Connection可以设置字符集吗? to kypfos(今天,我革谁的命?) :我听说用jdbc建连接的时候可以在url后边加上字符集,但我试着在weblogic的url处加上字符集后,总是报错,可能是写的格式不正确,还是有别的什么区别,您能说在再详细些吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public static void main(String[] args) { String uri = "jdbc:postgresql://192.168.2.63/myutf8db?useUnicode=true&characterEncoding=UTF-8"; String sql = "SELECT * FROM mytable"; String sql1 = "select * from pg_database"; DataSource dataSource = setupDataSource(uri); Connection conn = null; Statement stmt = null; ResultSet rset = null; try { conn = dataSource.getConnection(); stmt = conn.createStatement(); rset = stmt.executeQuery(sql1); int numcols = rset.getMetaData().getColumnCount(); // column names for (int i = 1; i <= numcols; i++) { System.out.print("\t"+rset.getMetaData().getColumnName(i)); } System.out.println("\n------------------------------------"); while(rset.next()) { for(int i=1;i<=numcols;i++) { System.out.print("\t" + rset.getString(i)); } System.out.println(""); } } catch(SQLException e) { e.printStackTrace(); } finally { try { rset.close(); } catch(Exception e) { } try { stmt.close(); } catch(Exception e) { } try { conn.close(); } catch(Exception e) { } } } useUnicode和characterEncoding都是关键字吗?我如果想用GBK的字符集,可以这么来设置吗:useUnicode=true&characterEncoding=GBK SWING的1个小问题! 关于弹出窗口的问题,恳请大家帮助 请教高手用java如何获取系统硬件信息? 提取pdf中的文字 新手问题 ...谢谢帮忙啊.... JAVA Beans到底是什么? 上溯造型 这个问题谁有答案!!!!!!!! 想学JAVA,大家给我介绍几本好书行不行? java中异常类与监听类作用有什么区别 等米下锅!!! 请问不在windows里设ODBC数据源怎样连接数据库?
String uri = "jdbc:postgresql://192.168.2.63/myutf8db?useUnicode=true&characterEncoding=UTF-8";
String sql = "SELECT * FROM mytable";
String sql1 = "select * from pg_database";
DataSource dataSource = setupDataSource(uri); Connection conn = null;
Statement stmt = null;
ResultSet rset = null; try {
conn = dataSource.getConnection();
stmt = conn.createStatement();
rset = stmt.executeQuery(sql1);
int numcols = rset.getMetaData().getColumnCount();
// column names
for (int i = 1; i <= numcols; i++) {
System.out.print("\t"+rset.getMetaData().getColumnName(i));
}
System.out.println("\n------------------------------------"); while(rset.next()) {
for(int i=1;i<=numcols;i++) {
System.out.print("\t" + rset.getString(i));
}
System.out.println("");
}
} catch(SQLException e) {
e.printStackTrace();
} finally {
try { rset.close(); } catch(Exception e) { }
try { stmt.close(); } catch(Exception e) { }
try { conn.close(); } catch(Exception e) { }
}
}