//-----------------------------//
public void DbConn() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, "cooc123", "19867200");
st = conn.createStatement();
System.out.println("连接");
String sql = "select * from tdb_posts where tid = '3307'";
rs = st.executeQuery(sql);
if(rs.next()){
System.out.println(rs.getString("subject"));
}else{
System.out.println("no");
}
} catch (Exception e) {
e.printStackTrace();
}
} //-----------------------------//输出结果连接
(GRAPHIS)°×?B¤?¤?¤é[150p]说明下,我是用到SWING里,不是JSP
public void DbConn() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, "cooc123", "19867200");
st = conn.createStatement();
System.out.println("连接");
String sql = "select * from tdb_posts where tid = '3307'";
rs = st.executeQuery(sql);
if(rs.next()){
System.out.println(rs.getString("subject"));
}else{
System.out.println("no");
}
} catch (Exception e) {
e.printStackTrace();
}
} //-----------------------------//输出结果连接
(GRAPHIS)°×?B¤?¤?¤é[150p]说明下,我是用到SWING里,不是JSP
// 或者
System.out.println(new String(rs.getString("subject").getBytes("ISO-8859-1"),"GBK"));
看看
日本?o修正「Tora Tora Platinum Vol.20~上村??子(TRP-020)」DVD/4340MB
日本?o修正「Japanese Peach Girl Vol.42~草風?~加納瑞穗(PB-091)」DVD/4260MB
日本無修正「Tora Tora Platinum Vol.20~上村優子(TRP-020)」DVD/4340MB其中有繁体
// 或者
System.out.println(new String(rs.getString("subject").getBytes("ISO-8859-1"),"BIG5"));
换繁体中文看看
+ Title
+ "','"
+ DownUrl
+ "','"
+ BegTime
+ "','0','"
+ name + "')";
db.st.executeUpdate(sql);
就可以了
names = new String(name.getBytes("UTF8"),"UTF8");
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
}一样没用
加上(或者更改)default-character-set=utf-8,[mysql]和[mysqld]一个
是指客户端编码(连接MySQL的编码),一个指服务端编码(建库的编码)(具体
哪一个对应哪一个我忘掉了),设好后重启MySQL服务,这样JDBC连接字符串就不
要加?useUnicode=true&characterEncoding=utf-8这些了。