mysql 中文乱码问题。。。大家看看网上我查过了 但还是有问题!
我吧 MSYQL 全部设置为 utf-8
数据库 和 表格 也设置为 utf-8
myeclipse Resourse 也是 utf-8
public void getConnect() {
Connection conn = null;
Statement st = null;
try {
Class.forName("org.gjt.mm.mysql.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager
.getConnection(
"jdbc:mysql://localhost:3306/DBWorkCheck?useUnicode=true&characterEncoding=UTF-8",
"root", "1234");
st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from tbuser");
while (rs.next()) {
String s = rs.getString(3);
System.out.println(s);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (st != null)
st.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
我用 DEBUG 看过 是乱码
控制台输出也是乱码