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.

 Avaya Developer Showcase
 MSDN Spotlight
 PHP for Windows Showcase
XML error: undefined entity at line 34
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%.

IBM Brings Developers Into the Cloud
Apache at 10: You Can't Buy Us
Microsoft's CodePlex Foundation Moving Forward
Apple Claims 100,000 Apps, Google Analyzes Them
Nokia Latest to Play Opera Mobile 10 Browser
PayPal Opens Up Payment Platform to Devs
Ubuntu Linux 9.10 'Karmic Koala' Starts Its Climb
IBM Links Rational Developer Tools, Tivoli Apps
Libraries Give Vista Apps a Windows 7 Look
Ubuntu: The 'Default Alternative' to Windows?

Delivering Web-based Embedded Fonts in CSS 3
Adobe Helps PHP Developers Create Rich Internet Applications
Java Developers Finding a Home at Adobe Flex
Virtualization Delivers a Dynamic Infrastructure
Consuming XML Web Services in iPhone Applications
Build a More Agile Business with IBM
POJO-Based Solutions for LDAP Access: One Good, One Better
IBM Offers Enhanced Measurement and Management for Energy Usage
IBM Helps Transformation to an Information-Based Enterprise
Top Five Touch UI-Related Design Guidelines

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, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs