public class Test {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:MySQL://127.0.0.1:3306/test";
String sql="insert into student values(?,?,?)";
Connection con=DriverManager.getConnection(url, "root", "root");
PreparedStatement ps=con.prepareStatement(sql);
ps.setInt(1, 103);
ps.setString(2, "b");
ps.setInt(3, 15);
int i=ps.executeUpdate();
System.out.println(i);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
错误信息:
java.sql.SQLException: Duplicate entry '103' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1584)
at com.mysql.jdbc.Connection.serverExecute(Connection.java:4742)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1251)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:993)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1930)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1855)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1693)
at a1.Test.main(Test.java:20) |
|