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
);
|