Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Struts Hibernate-spring Designing Database

Related Tutorials


 
 

Share on Google+Share on Google+

Designing Database

Advertisement
Database designing is considered as crucial stage in the development lifecycle of the web application

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.

 

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: May 24, 2009

Related Tutorials

Discuss: Designing Database   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com