我的mysql数据库里面数据都显示正常,还有dos下,查询都显示正常,在eclipse平台下读取时怎么都显示乱码,如果把那个文件导出为一个sql文件,里面的汉字全变成了二进制的编码,搞不懂了,求解?????????
我已经把数据库平台所有都改成了gbk,代码如下:
import java.sql.*;public class DBconnect {
public static Connection getConnection() throws SQLException,java.lang.ClassNotFoundException{
String url="jdbc:mysql://localhost:3306/sss?useUnicode=true&characterEncoding=gbk";
Class.forName("com.mysql.jdbc.Driver");
String username="root";
String password="gaofei";
Connection con=DriverManager.getConnection(url, username, password);
return con;
}
public static void main(String[] args) throws Exception
{
Connection con=DBconnect.getConnection();
Statement st=con.createStatement();
String sql="select * from category";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getInt("cat_id")+" "+rs.getString("cat_title"));
break;
}
}}运行显示乱码,实在是头疼,恳求各位帮忙?
我已经把数据库平台所有都改成了gbk,代码如下:
import java.sql.*;public class DBconnect {
public static Connection getConnection() throws SQLException,java.lang.ClassNotFoundException{
String url="jdbc:mysql://localhost:3306/sss?useUnicode=true&characterEncoding=gbk";
Class.forName("com.mysql.jdbc.Driver");
String username="root";
String password="gaofei";
Connection con=DriverManager.getConnection(url, username, password);
return con;
}
public static void main(String[] args) throws Exception
{
Connection con=DBconnect.getConnection();
Statement st=con.createStatement();
String sql="select * from category";
ResultSet rs=st.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getInt("cat_id")+" "+rs.getString("cat_title"));
break;
}
}}运行显示乱码,实在是头疼,恳求各位帮忙?
String sql="select * from category";
ResultSet rs=st.executeQuery(sql);
mysql> status; //看看你的数据库编码
mysql> set names 'gbk'; //把所有编码都设成gbk
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
楼主运行一下这个,看一下你的数据库是不是所有的都是gbk了……
http://download.csdn.net/detail/rememberthemilk/3635418
都统一