为什么这样连接不到DB2???关于用JDBC连接DB2,在建立结果集的时候报错
import java.sql.*;
public class db2
{
public static void main(String args[])
{
Connection conn = null;
String url = "jdbc:db2:sample";
String user = "db2admin";
String pwd = "leipang";
try
{
System.out.println("\n Loading JDBC Driver ");
DriverManager.registerDriver(new COM.ibm.db2.jdbc.app.DB2Driver());
//Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
System.out.println(" OK !");
}catch (Exception e)
{
System.out.println(" Failed !");
}
try
{
System.out.println("\n Connect to DB2 ");
conn = DriverManager.getConnection(url,user,pwd);
System.out.println(" OK!");
try
{
System.out.println("\n Create Statement ");
Statement stmt = conn.createStatement();
System.out.println(" OK !");
String sql = "select * from org";
try
{
System.out.println("\n Create ResultSet ");
ResultSet res = stmt.executeQuery("select * from org");
System.out.println(" OK !");
while (res.next())
{
System.out.println("\n" + res.getString(2));
}
}catch (Exception exce)
{
System.out.println(" Failed \n " + exce);
}
}catch (Exception exc)
{
System.out.println(" Failed !\n " + exc);
}
}catch (Exception ex)
{
System.out.println(" Failed !\n " + ex);
}
}
};
public class db2
{
public static void main(String args[])
{
Connection conn = null;
String url = "jdbc:db2:sample";
String user = "db2admin";
String pwd = "leipang";
try
{
System.out.println("\n Loading JDBC Driver ");
DriverManager.registerDriver(new COM.ibm.db2.jdbc.app.DB2Driver());
//Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
System.out.println(" OK !");
}catch (Exception e)
{
System.out.println(" Failed !");
}
try
{
System.out.println("\n Connect to DB2 ");
conn = DriverManager.getConnection(url,user,pwd);
System.out.println(" OK!");
try
{
System.out.println("\n Create Statement ");
Statement stmt = conn.createStatement();
System.out.println(" OK !");
String sql = "select * from org";
try
{
System.out.println("\n Create ResultSet ");
ResultSet res = stmt.executeQuery("select * from org");
System.out.println(" OK !");
while (res.next())
{
System.out.println("\n" + res.getString(2));
}
}catch (Exception exce)
{
System.out.println(" Failed \n " + exce);
}
}catch (Exception exc)
{
System.out.println(" Failed !\n " + exc);
}
}catch (Exception ex)
{
System.out.println(" Failed !\n " + ex);
}
}
};
...全文
相关推荐
通过JDBC通过java连接DB2数据库
本文档为作者在实践过程中的总结,大神可以绕道,如果是初学者可以阅读,非常详细。
JDBC连接db2驱动包,包含db2jcc_license_cu.jar,db2jcc4.jar
包括JDBC用来连接db2的db2jcc_license_cu.jar,db2jcc4.jar
JDBC连接DB2数据库需要的jar包
JDBC连接DB2数据库需要的jar包 JDBC连接DB2数据库需要的jar包 JDBC连接DB2数据库需要的jar包
JDBC连接DB2驱动包(公司授权正版驱动)
这个是购买的IBM正版DB2数据库中的驱动包,无限制连接,希望能对大家有帮助,其中包括: db2jcc.jar db2jcc_license_cu
DB2的JDBC驱动包
链接DB2数据库的时候采用的JDBC驱动包


Web 开发
