4.21 ͨJSPDB2ݿʵJSPҳвǷͨJDBCɹDB2ݿ⡣
<%@page import="java.sql.*" contentType="text/html; charset=gb2312" 
%> 
<html> 
<head> 
<title>ʹDB2ݿ</title> 
</head> 
<body> 
<p align="center"><u><font size="5" face="κ">ʹJSPӵDb2ݿ
</font>
</u>
</p> 
<%! 
String database="ebusines"; //ݿ
String user="db2admin"; //û
String pass="mydb2"; //
%><% java.sql.Connection sqlConn; //ݿӶ
java.sql.Statement sqlStmt; //
java.sql.ResultSet sqlRst; //
try{ 

try{ 
//ǼJDBC 
//Ķз 
//DriverManager.registerDriver (new COM.ibm.db2.jdbc.app.DB2Driver()); //db2
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance(); //db2 
} 
catch (ClassNotFoundException e) 
{ out.print (e); 
} 
//ݿ 
sqlConn= java.sql.DriverManager.getConnection ("jdbc:db2:"+database,user,pass);
// 
out.print ("ݿɹ"); 
%> 
</body> 
<% 
//رս 
//sqlRst.close(); 
//ر 
//sqlStmt.close (); 
//رݿ 
sqlConn.close(); 
}catch (SQLException e) 
{ out.print ("ݿʧ!"); 
out.print (e); 
} 
%>



4.24 JSPҳԴ룬ͨODBCԴʵ4.21DB2ݿӲ
<%@page import="java.sql.*" 
import ="java.util.*" 
import ="java.io.*" 
contentType="text/html; charset=gb2312" 
%> 
<html> 
<head> 
<title>ʹDB2ݿ</title> 
</head> 
<body> 
<p align="center"><u><font size="5" face="κ">ʹJSPӵDb2ݿ
</font>
</u>
</p> 
<% 
String database="EBUSINES"; //ݿ
String user="db2admin"; //û
String pass="mydb2"; //
%><% java.sql.Connection sqlConn; //ݿӶ
java.sql.Statement sqlStmt; //
java.sql.ResultSet sqlRst; //
try{ 

try{ 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} 
catch (ClassNotFoundException e) 
{ out.print (e); 
} 
//ݿ 
sqlConn= DriverManager.getConnection("jdbc:odbc:"+database,user,pass);// 
out.print ("ݿɹ"); 
%> 
</body> 
<% 
//رս 
//sqlRst.close(); 
//ر 
//sqlStmt.close (); 
//رݿ 
sqlConn.close(); 
}catch (SQLException e) 
{ out.print ("ݿʧ!"); 
out.print (e); 
} 
%>
