<% @ Page import = "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 = "192.1.1.127"; // Database host
String database = "myweb"; // database Name
String user = "db2admin"; // user Name
String pass = "db2admin"; // Password
%> <% Java. SQL. Connection sqlConn; // database Connection object
Java. SQL. Statement sqlStmt; // Statement object
Java. SQL. ResultSet sqlRst; // result set object
Try {
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 );
}
%>