1. Search for db2java.zip and rename it db2java. JSR to the common/lib directory of Tomcat installation.
(2) create a database test in DB2. Table users (3) run the JSP code. // Testdb. jsp<
% @ PageImport = "Java. SQL .*"
Import = "Java. util .*"
Import = "Java. Io .*"
Contenttype = "text/html; charset = gb2312"
%>
<HTML>
<Head>
<Title> use a DB2 database </title>
<Meta name = "generator" content = "Microsoft FrontPage 4.0">
<Meta name = "progid" content = "FrontPage. Editor. Document">
</Head>
<Body>
<P align = "center"> <u> <font size = "5" face = "文 "> use JSP to connect to the DB2 database </font> </u> </P>
<%!
String host = "127.0.0.1"; // Database Host
String database = "test"; // Database Name
String user = "admin"; // User Name
String pass = "qq456"; // Password
%> <% Java. SQL. Connection sqlConn; // database Connection object
Java. SQL. Statement sqlStmt; // Statement object
Java. SQL. ResultSet sqlRst; // result set object
Try {
// Register the JDBC driver object
// The second method below can be used
// DriverManager. registerDriver (new COM.ibm.db2.jdbc.net. DB2Driver (); // db2
Class. forName ("COM.ibm.db2.jdbc.net. DB2Driver"). newInstance (); // db2
}
Catch (ClassNotFoundException e)
{Out. print (e );
}
// Connect to the database
SqlConn = java. SQL. DriverManager. getConnection ("jdbc: db2: //" + host + "/" + database, user, pass); // create a statement object
Out. print ("connected to the database! ");
%>
</Body>
<%
// Close the result set object
// SqlRst. close ();
// Close the statement object
// SqlStmt. close ();
// Close the database connection
SqlConn. close ();
} Catch (SQLException e)
{ Out. print ("failed to connect to the database! ");
Out. print (e );
}
%>
