public static void main(String[] args) throws SQLException, UnsupportedEncodingException {
// TODO Auto-generated method stub
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}java.sql.Connection conn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/movie?useUnicode=true&characterEncoding=gb2312", "root", "root");
java.sql.Statement stmt = conn.createStatement();String sql;
sql = "insert into movie_5th(num, week_begin, week_end, name, firstchk, secondchk) values ('111', '2011-04-07', '2011-04-12', '卧虎藏龙', '审核员1', '审核员2')";
stmt.executeUpdate(sql);
java.sql.ResultSet rs = stmt.executeQuery("select * from movie_5th");while(rs.next()){
//System.out.println(rs.getInt(1));
System.out.print(rs.getString("num") + " ");
System.out.print(rs.getString("week_begin") + " ");
System.out.print(rs.getString("week_end") + " ");
System.out.print(rs.getString("name") + " ");
System.out.print(rs.getString("firstchk") + " ");
System.out.println(rs.getString("secondchk"));}
rs.close();
stmt.close();
conn.close();}
已设置表的字符集,GB2312。
在MyEclipse上运行,提示的错误信息如下:
Exception in thread "main" java.sql.SQLException: Incorrect string value: '\xCE\xD4\xBB\xA2\xB2\xD8...' for column 'name' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1564)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1485)
at mysql.MySQL.main(MySQL.java:26)
请大虾帮忙看看!
解决方案 »
- 在linux下安装mysql5.5.8,不知道看文档哪一章节呢?是2.9. Installing MySQL from tar.gz Packages on O
- mysql 一输密码就自动关闭,昨天已经重装过了,但今天又出错了
- mysql的主从问题 从服务器对数据库修改不会影响主的数据库么?
- mysql服务不定时自动停止
- 这样的SQL语句改如何组合
- 请问用户自定义函数的问题。
- 在我的phpadmin中总有这句"使用链接表的额外特性尚未激活。要查出原因,请单击此处。"是什么意思呢?
- mysql中int类型检测为空的条件?
- mysql存储过程中select COUNT(*) INTO 问题求助
- 求高手列出一个数据库更新同步与替换的代码!
- MySql客户端一闪就关了这是为什么?
- 急!!!mysql中如何用limit删除第n行后的记录
(1)修改 my.ini(MySQL Server Instance Configuration 文件)# CLIENT SECTION[client]port=3306[mysql]default-character-set=gbk
# SERVER SECTION[mysqld]default-character-set=gbk
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码