java程序连接mysql 5.6.37 读取值为'1'或者'x'这种一位的值时 返回的是'' 但是用控制台查询就能查到该值 请问是什么问题呢 谢谢大家啦 在线等
解决方案 »
- [菜鸟在线等]
- 怎么在linux下进入mysql命令行?
- MYSQL存储过程的输出参数可以是游标吗?
- mysql5.1 触发器 label 语句问题?
- 这个sql语句应该怎么写啊?
- mysql在安装到最后时apply security setting报错
- Postgresql的低级问题?脸红!!
- MySQL client run out of memory是怎样产生的?
- 50份请问:EMS MySQL Manager 1.9.2.2 的注册码和汉化文件!谢谢!
- Mysql 行转列 求助 40
- mysql空间数据库怎样将一个字段的所有空间数据添加进GeometryCollection
- mysql触发器问题
Connection conn = null;
Statement stmt= null;
ResultSet rs= null;
String sql;
String url = "jdbc:mysql://localhost:3306/mas?user=root&password=root&useUnicode=true&characterEncoding=gbk";
try {
Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
sql = "select black, white,worker from phone_switch";
rs = stmt.executeQuery(sql);
while (rs.next()) {
String param1 = rs.getString(1);
String param2 = rs.getString(2);
String param3 = rs.getString(3);
System.out.println("JDBC=param1="+param1);
System.out.println("JDBC=param2="+param2);
System.out.println("JDBC=param3="+param3);
}
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
rs.close();
stmt.close();
conn.close();
}
}
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
+--------------------------+--------+