db2连接很奇怪的问题,高手请进

Question

http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=438

Answer 1

test.jsp<%@ page language="java" import="java.io.*,java.sql.*,javax.sql.* ,javax.naming.*"%>
<%@ page contentType="text/html;charset=gb2312" %> 
<% 
String sDBDriver = "COM.ibm.db2.jdbc.net.DB2Driver"; 
String sConnStr = "jdbc:db2://169.254.1.201/database"; Connection conn = null; 
ResultSet rs = null; 
Statement stmt = null; 
try 
{ 
Class.forName(sDBDriver); 
conn = DriverManager.getConnection(sConnStr,"jincheng","781126"); 
stmt = conn.createStatement(); 
//stmt.executeQuery("create table aaa(aaa int)");
//stmt.executeUpdate("insert into bbb values(456)"); rs = stmt.executeQuery("select aaa from bbb"); 
while (rs.next()){ 
out.println("" + rs.getInt(1) + ""); 
out.println(":"+"<br>"); 
//out.println(" + rs.getString('answers') + "); 
} 
rs.close(); } 
catch(Exception e) 
{ 
out.println(e); 
} 
%> 

Answer 2

本地需要COM.db2.jdbc.app.DB2Driver
数据库端口可以通过db2jstrt 端口号进行设定