Struts Tutorial Home

Struts Home

JSP Resources

Community

Site

 


Let us consider an example – a web based user registration application. Usually every web based application requires secure login to access its critical resources therefore a user management is part of every web application.



Our first Struts application is a web based user registration application. The application is capable of displaying the list of registered users and allowing the user to add a new user to the database. We’ll use a single table ‘users’ to store the user information. Select any database of your choice,and create a table "USERS" with following fields:










































Column Name



Data Type



Constraints


USER_ID TEXT PRIMARY KEY
FIRST_NAME TEXT NONE
LAST_NAME TEXT NONE
AGE NUMBER NONE
EMAIL TEXT NONE
PASSWORD TEXT NONE


We’ll use Microsoft Access database for this purpose. Use the following SQL to create table in Microsoft Access.


CREATE TABLE USERS(


       user_id text primary key,


       first_name text,


       last_name text,


       age number,


       email text,


       password text


);


 


 

                    

Copyright © 2013 VisualBuilder. All rights reserved