代码如下:
boolean isConnect = false;
try {
//用了第二种连接方式!!!!!!!!!
String DriverName = "com.ibm.db2.jcc.DB2Driver";
String Url = "jdbc:db2:USERINFO";
String UserName = "db2admin";
String Password = "123456";
Class.forName(DriverName).newInstance();
Connection con = DriverManager.getConnection(Url, UserName, Password);
if (con != null) {
isConnect = true;
}
System.out.println("iscon:"+isConnect);
String sql = "select * from USERS";
Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
System.out.println("创建statement成功");
ResultSet rs = stm.executeQuery(sql);
System.out.println("查询到结果");
try {
while (rs.next()) {
System.out.println("查询到结果");
}
rs.close();
} catch (SQLException e) {
System.out.println(e);
}
rs.close();
stm.close();
con.close();
} catch (Exception e) {
System.out.println("操作失败!-----------");
e.printStackTrace();
}
代码说明:数据库名为USERINFO,数据表名为USERS;
报错为:
iscon:true
创建statement成功
操作失败!-----------
com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DB2ADMIN.USERS, DRIVER=3.62.56
at com.ibm.db2.jcc.am.fd.a(fd.java:676)
.......