Designing Database

Database designing is considered as crucial stage in the development lifecycle of the web application. The database is finally responsible for storing the data in the database for retrieval in future. So, the database design should be done in such a way that it full fill all your business requirements.

In this application we are only concern with take the new user information and saving in the database for authenticating the user in the future.

We are using MySQL database for this application. MySQL one of the open source, free and widely used relational database for applications.

Creating the database:

I am assuming that you have already installed MySQL on your machine and have access to the database server. Login to your MySQL Server and create a database "strutshibernatespring".

Creating tables:

Then connect to the database "strutshibernatespring" and create table "login". Here is the script to create login table:

CREATE TABLE `login` (
`id` int(11) NOT NULL default '0',
`loginid` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`email` varchar(30) default NULL,
`address` varchar(60) default NULL,
`phno` int(11) default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `loginid` (`loginid`)
) TYPE=MyISAM;

The login table will used to store the user information and then authenticating the user at login time.