用jdbc连db2时,我创建了一数据库test,连接一直没建立成功,却老报这么个错
com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!
at com.ibm.db2.jcc.a.ab.b(ab.java:1618)
at com.ibm.db2.jcc.a.bb.ac(bb.java:4454)
at com.ibm.db2.jcc.a.bb.a(bb.java:4392)
at com.ibm.db2.jcc.a.b.a(b.java:702)
at com.ibm.db2.jcc.a.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
不知道是为什么编码有问题了,代码如下package src;import java.sql.*;
public class JDBC
{
private static Connection con; public static void main(String[] args) throws SQLException
{
try{
String url="jdbc:db2://127.0.0.1:50000/test";
Class.forName("com.ibm.db2.jcc.DB2Driver");
con = DriverManager.getConnection(url,"db2admin","280117191");
Statement stat = con.createStatement();
ResultSet rs = null;
String sqlstr = "select * from fun";
rs = stat.executeQuery(sqlstr);
while(rs.next())
System.out.println("********************"+"\n"+
"name:"+"\t"+rs.getString("NAME")+"\n"+
"stuNum:"+"\t"+rs.getString("STUNUM"));
}
catch(Exception e){
e.printStackTrace();
}
finally{
con.close();
}
}}
com.ibm.db2.jcc.b.DisconnectException: encoding not supported!!
at com.ibm.db2.jcc.a.ab.b(ab.java:1618)
at com.ibm.db2.jcc.a.bb.ac(bb.java:4454)
at com.ibm.db2.jcc.a.bb.a(bb.java:4392)
at com.ibm.db2.jcc.a.b.a(b.java:702)
at com.ibm.db2.jcc.a.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:162)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
不知道是为什么编码有问题了,代码如下package src;import java.sql.*;
public class JDBC
{
private static Connection con; public static void main(String[] args) throws SQLException
{
try{
String url="jdbc:db2://127.0.0.1:50000/test";
Class.forName("com.ibm.db2.jcc.DB2Driver");
con = DriverManager.getConnection(url,"db2admin","280117191");
Statement stat = con.createStatement();
ResultSet rs = null;
String sqlstr = "select * from fun";
rs = stat.executeQuery(sqlstr);
while(rs.next())
System.out.println("********************"+"\n"+
"name:"+"\t"+rs.getString("NAME")+"\n"+
"stuNum:"+"\t"+rs.getString("STUNUM"));
}
catch(Exception e){
e.printStackTrace();
}
finally{
con.close();
}
}}
解决方案 »
- poi 导出excel 如何生成树状生成结构图(用矩形文本框和画线来做出来)
- equals()方法 达人进
- 我问一下,在Double.parseDouble("25.001")时,输出的结果时25.000999999999,这样应该如何处理!
- 小问题啊!!兄弟门帮忙!!!撒分
- 请问怎么让JLabel中的图片可以随着JLabel的变大边小?
- javadoc如何生成说明文档的问题
- 程序有点问题,求帮忙。
- 怎样解决这个中文问题?(关于URL)??????????????????????
- java 与Access怎么连接?
- 大神们 sleep()只能用于线程吗
- 大家帮看看这段代码哪里有错...
- 如何在java程序中得到当前的jvm heap dump的信息
String url="jdbc:db2://localhost:5000/sample";
//sample为你的数据库名
String user="admin";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);