advertisement
javaboutique
Search Tips
Articles  |   Tutorials  |   Reviews  |   Tools  |   by Category  |   by Date  |   by Name  |   Submit  |   Source  |   Forums  |  
javaboutique
Browse DevX


Partners & Affiliates











advertisement

Reviews :

Building a sample Web App with STRUTS Part 2 :

By Harshal Deo & Keerti Pai

Adding database access to the sample web app.

Pre-requisite:

Before starting this you should have completely read part 1: Building a sample Web App with STRUTS For easy reference, the complete code for this article is available at The Open Stack website look for the Part 2 ZIP file.

Quick Overview:

In this article we will demonstrate database access from the STRUTS Action class. We will use the 'iterate' tag from the STRUTS tag library to display the contents of a table on the web page. Finally, we will add a simple error handling to the application.

In part one, we developed two screens (JSPs) and the Action class. The TestForm had a simple form to take an input String and pass it to the Action class. The Action class constructed a Welcome message and displayed it back on the TestResult page.

In this article we will modify that application to "search" for employees from a database, based on the input search String. The database will store employee records and our app will allow a simple search on the short name "abbreviation". Our assumption is this short name "abbreviation" is sort of like a user ID used for system accounts and email addresses etc. The search will return the first name , last name along with the short name abbreviation from the records that match the search criteria.

NOTE: This is just an attempt to demonstrate the database access from STRUTS, not necessarily a "Best Practice". For a simple web application that does not have much transactional/persistence requirements this surely is a quick and easy way. As next steps, one could separate the Database access code from the Action class and/or use JDO or a similar product like Castor. Please look at The Open Stack Project for further details on these approaches.

Preparation:

For the database access part, you need to have a test database ready along with the JDBC driver to access this. For completeness of the article, we will demonstrate using a MySQL database and the corresponding JDBC (2.0) driver. If you are using a different database/driver, then please ignore the parts related to MySQL.

Optional: MySQL database setup

Download and install MySQL from here. Once you have installed the server (you can follow all the default steps in graphical install tool for easy setup), start the server. It could be as easy as going to the 'bin' directory under the MySQL install directory and executing the server executable such as 'mysqld-nt.exe'.

How to Add Java Applets to Your Site

New on the Java Boutique:

New Review:

Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling API boasts simplicity, ease-of-integration, a well-rounded feature set, and it's free!

New Applet:

Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA sequences into three useful formats.

Elsewhere on internet.com:

WebDeveloper Java
Lots of Java information on webdeveloper.com

WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.

ScriptSearch Java
Hundreds of free Java code files to download.

jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.

 Microsoft Visual Studio 2010 Showcase
 Avaya Developer Showcase
 MSDN Spotlight
 PHP for Windows Showcase
XML error: undefined entity at line 39
advertisement
Receive Articles via our XML/RSS feed
Receive Articles via our XML/RSS feed

JavaBytes
Internet Cyclone
This powerful, easy-to-use, internet optimizer is for Windows 95, 98, ME, NT, 2000 and XP. It's designed to automatically optimize your Windows settings, boosting your Internet connection up to 200%.

Windows 7: From Beta to Final Code in One Year
Google Shows Off Chrome OS, Releases Source
Microsoft Shows Off Silverlight 4, IE9 Plans
Metasploit Expands Vulnerability Test Framework
HyperCard Reborn?
Fedora 12 Takes Aim at Linux Networking
Top Supercomputer Nearly Doubles in Speed
Fedora 12 Linux Tackles Virtualization
Apple Gives iPhone Developers App Status Tracker
Novell Sets OpenSUSE 11.2 Free

Creating Custom Export Filters for StarOffice with XSLT
WPF Wonders: Using DataTemplates
Crystal Reports Family Offers Options for Developers
Avaya Aura Session Manager video
Avaya Aura Overview video
Exploring HTML 5's Audio/Video Multimedia Support
Overriding Virtual Functions? Use C++0x Attributes to Avoid Bugs.
Understanding the Cloud Computing Security Vulnerabilities
Cisco and IBM Target a Greener World
Upgrade to Visual Studio 2010 with the Ultimate Offer

Advertising Info  |   Member Services  |   Contact Us  |   Help  |   Feedback  |   Site Map  |   Network Map  |   About

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs