JAVA操作字符集
来源:互联网 发布:淘宝开店认证 上半身 编辑:程序博客网 时间:2024/06/04 22:11
mysql4.1.2的默认字符集是latin1,latin1属于ISO8859-1的子集(或者是一回事?),写入时需要为iso8859-1的编码,读出时要转换成gbk编码,就不会是乱码。 Class.forName("org.gjt.mm.mysql.Driver"); String url ="jdbc:mysql://localhost/mysql"; Connection conn=DriverManager.getConnection(url,"root","root"); Statement stmt=conn.createStatement(); String a="老哈斯蒂芬"; a=new String(a.getBytes("GBK"),"iso8859-1"); stmt.executeUpdate("insert into zquan (name) value ('"+a+"')"); ResultSet rs=stmt.executeQuery("select name from zquan"); while(rs.next()){ String aaa=rs.getString(1); System.out.println(new String(aaa.getBytes("iso8859-1"),"GB2312")); }