谁知道jdbc for db27.1 的驱动程序哪有下载?谢谢!高分!jsp+tomcat怎么连他?非常谢谢!

[yuxiadong]

谁知道jdbc for db27.1 的驱动程序哪有下载?谢谢!高分!jsp+tomcat怎么连他?非常谢谢!

[lly9900]

<%@page language="java" contentType="text/html;charset=gb2312"
import = "java.sql.*"
%>
<%
//变量申明
java.sql.Connection sqlCon; //数据库连接对象
java.sql.Statement sqlStmt; //SQL语句对象
java.sql.ResultSet sqlRst; //结果集合对象
java.lang.String strCon; //数据库连接字符串
java.lang.String strSQL; //SQL语句
int intRowCount;

///*
//装载jdbc
try {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
//Class.forName("COM.ibm.db2.jdbc.net.DB2Driver").newInstance();
}
catch ( ClassNotFoundException cnfe) {
String err = cnfe.toString();
out.print("类错误"+err);
}


//设置数据库连接字符串
//strCon = "jdbc:db2://172.31.10.199:50002/iassys";
strCon = "jdbc:db2:iassys";
//*/

/*
//装载jdbc_odbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//设置数据库连接字符串
strCon = "jdbc:odbc:iassun";
*/

//连接数据库
//try {

//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
/*
Connection conn =
DriverManager.getConnection ("jdbc:oracle:thin:@dlsun511:1721:dbms733",
"scott", "tiger");
*/

sqlCon = java.sql.DriverManager.getConnection(strCon,"db2inst1","db2");

//创建SQL语句对象
sqlStmt = sqlCon.createStatement();


//获取记录总数
strSQL = "select count(1) from tbuser";

//执行SQL语句并取得结果集合
sqlRst = sqlStmt.executeQuery(strSQL);

//记录集刚打开时，指针位于第一条记录之前
sqlRst.next();

intRowCount = sqlRst.getInt(1);

//关闭结果集合
sqlRst.close();
........

1. 安装db2 client后， D:\SQLLIB\java\db2java.zip 就是jdbc driver.
2.autoexec.bat中:
CLASSPATH=.;D:\jb5\jdk1.3\lib\tools.jar;D:\jb5\lib\servlet.jar;D:\jb5\tomcat32\lib;d:\jb5\lib\classes111.zip;d:\jb5\lib\db2java.zip
3.配置odbc