Using servlet+jopo+jsp to build a Micro Java Web project (two-stage preparation)

This is one of the most basic Web project exercises, is a template is a project, which contains a table of additions and deletions function, a little change and supplement can be applied in similar Model II development of the application.

Pre-Preparation:

My development environment is MyEclipse 10.6+oracle 10g+tomcat 6.0+ie 8+win XP.

Note: 1. The compiler aspect of Eclipse or myeclipse any version can be done without too much trouble.

2. For example, I use the Oracle 10g database, in fact, the use of SQL Server and my SQL even H2, mainly in the database load driver and port number slightly different, just a few changes.

It is important to note that the SQL Server database has a downward incompatibility problem when separating and attaching. A database using SQL Server 2008 cannot be used on SQL Server 2005, but vice versa.

Also, remember to open the port (service) of the database when the database is in use. (Start and run the->cmd Input Netstat-an command.) 1433 is the port number of SQL Server. 1521 is Oracle's

Port number).

3.Tomcat 6.0 and 7.0 are all available.

4. Browsers suggest using IE 8 or chrome.

Database tables unilaterally

　　　　

Select *  fromUser_info TCreate TableUser_info (IDvarchar2( -)Primary Key, usernamevarchar2( -), Passwordvarchar2( -), Sexvarchar2( -), collegevarchar2( -)       )

(Do not mind for everything is varchar2 (20), I just figure easy convenient =)

Note: The Oarcle database is case insensitive.

Using servlet+jopo+jsp to build a Micro Java Web project (two-stage preparation)