JBuilder2005 Real-field JSP CREATE database table

1. In Oracle's SQL Plus tool, log on to the database as a user with DBA authority.

system/manger@to_128

The to_128 of the @ is the connection string name of the database, which needs to be changed according to the circumstances, and the @ and the connection string can be omitted if the database is local.

2. Create the Jbuser user and specify the password as ABC.

Sql> create user Jbuser identified by ABC;

3. Assign Connect and resource role permissions to Jbuser users.

Sql> Grant Connect, resource to Jbuser;

4. Log on to the database with Jbuser

Sql> Connect jbuser/abc@to_128;

5. Create user tables and sequences, and run the following SQL code in the sql> command.

Code Listing 1 Creating the code for tables and sequences

1.--Create a user table
2. CREATE TABLE T_user (
3. user_id CHAR (6) NOT NULL,
4. User_name VARCHAR2 (60),
5. PASSWORD VARCHAR2 (20),
6. Constraint Pk_t_user primary KEY (USER_ID)
7.);
8.--Create Login log table
9. CREATE TABLE T_login_log (
ID CHAR (a) is not NULL,
USER_ID CHAR (6) NOT NULL,
Dt_login CHAR (not null),
Dt_lonout CHAR (14),
Constraint Pk_t_login_log primary KEY (ID)
15.);
16.
17.--Create an index to generate a primary key for the T_login_log table
Create sequence seq_login_log_id
Increment by 1
MaxValue 999999999999
MinValue 100000000000;
6. Insert 3 historical Figures in the T_user user table as the initial user, run the following SQL code in the sql> command.

Code Listing 2 inserts 3 records into the T_user table

1. Insert into T_user (User_id,user_name,password) VALUES (' 100000 ', ' Jiang teeth ', ' 123456 ');
2. Insert into T_user (User_id,user_name,password) VALUES (' 100001 ', ' Baoshu tooth ', ' 123456 ');
3. Insert into T_user (User_id,user_name,password) VALUES (' 100002 ', ' vertical teeth ', ' 123456 ');
4. Commit;

Create Engineering and Web modules

After you create the database, open JBuilder and create the engineering and Web modules.

1. File->new Project ... Create a project called bookstore.

2. File->new...->web-> Double-click the Web Module (WAR) icon to create a web model with the name Webmodule. Choose Tomcat 5.0 as the Web application server.

Write Get database Connection class

You have to access the database through a data connection, and you need to get a database connection in multiple parts of the module, so we write a class that gets the data connection to increase the reuse rate of the code.

When writing a class to obtain a data connection, you must first add the Oracle JDBC Drive class bundle Classes12.jar to the Engineering Extensions Class library (Classes12.jar is located in the directory of the <oracle installation directory >/jdbc/lib). We put the Classes12.jar in the < Engineering catalogue >/orajdbclib. Use the following steps to introduce Classes12.jar in the engineering Extension class library:
Project->properties...->paths Settings page-> switch to required libraries-> Click Add...-> in the pop-up add to Project Classpath dialog box to switch to Archives tab, select the Engineering directory under the < Engineering directory >/orajdbclib/classes12.jar.

After introducing Oracle's JDBC Drive class pack Classes12.jar into the Engineering Extensions class library, create the DbConnection class in the project, and the code looks like this:

Code Listing 3 Dbconnection.java

1. Package bookstore;
2.
3. Import java.sql.*;
4. Import java.util.Properties;
5.
6. public class DbConnection {
7.//Get Database connection class
8. public static Connection getconnection () throws SQLException {
9. try {
Class.forName ("Oracle.jdbc.driver.OracleDriver");
One.} catch (ClassNotFoundException ex) {
Ex.printstacktrace ();
return null;
14.}
Properties Sysprops = new properties ();
Sysprops.put ("User", "Jbuser");
Sysprops.put ("Password", "abc");
Return Drivermanager.getconnection (
"Jdbc:oracle:thin:@192.168.0.128:1521:ora9i", sysprops);
20.}
21.}

This class provides only a static method Getconnection (), with JBUSER/ABC to obtain a data connection located in 192.168.0.128,sid for ora9i.

There are two key points to getting a database connection:

1. Specify Database Drive class

As the 10th line of code shows, Oracle's JDBC Drive class name is: Oracle.jdbc.driver.OracleDriver, different databases have their own JDBC database drives, if you use other databases, please check the relevant information.

2, the specified database URL connection string

In line 19th, we specify a database URL connection string, different database URL connection string format is not the same, for Oracle database, database URL connection string contains 4 parts:

Jdbc:oracle:thin: Specifies the type of JDBC drive, where thin client drives are specified and are most commonly used without installing additional components on the connection client.

@192.168.0.128: The IP of the machine where the database is located, or the machine name can be used.

• 1521: The port where the database listener is located, typically Oracle defaults to port 1521.

ora9i: Database sid name.