java 调用mysql出错率高不高_java使用mysql出错，高手指教

packagejdbc;importjava.sql.*;publicclassTestDML{/***@paramargs*/publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstubtry{Class.forName("com.mysql.jdbc.Driver"...

package jdbc;

import java.sql.*;

public class TestDML {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

try{

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://127.0.0.1:3306/test";

Connection conn=DriverManager.getConnection(url,"root","mysql");

Statement stmt=conn.createStatement();

stmt.executeUpdate("insert into stu values('j001','zhangsan',18)");

stmt.executeUpdate("insert into stu values('j002','李四',20)");

stmt.executeUpdate("insert into stu values('j003','wangwu',19)");

stmt.executeUpdate("insert into stu values('j004','zhaoliu',21)");

ResultSet rs=stmt.executeQuery("select * from stu order by sid");//用于执行SELECT语句

while(rs.next()){

System.out.print("学号:"+rs.getString(1));

System.out.print("\t姓名:"+rs.getString(2));

System.out.println("\t年龄："+rs.getInt(3));

}

rs.close();

stmt.executeUpdate("update stu set age=age+10");

stmt.executeUpdate("delete from stu where sid='j002'");

System.out.println("-------更新数据后---------");

rs=stmt.executeQuery("select * from stu");

while(rs.next()){

System.out.print("学号"+rs.getString("sid"));

System.out.print("\t姓名"+rs.getString("name"));

System.out.println("\t年龄"+rs.getInt("age"));

}

rs.close();

stmt.close();

conn.close();

}catch(Exception e){

e.printStackTrace();

}

}

}java.sql.SQLException: Incorrect string value: '\xC0\xEE\xCB\xC4' for column 'name' at row 1

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1534)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1625)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)

at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1262)

at jdbc.TestDML.main(TestDML.java:16)

好像是字符集问题，但我不知怎么改，高手帮下忙，谢谢了

我用mysql的config配置字符默认为BGK，报的错是：

展开