在使用mysql数据库插入数据时,假如我们的主键自增,在后台编写代码时需要注意下面的情况:
先看下面一段代码:
try{
Class.forName(driverName);
}catch (ClassNotFoundException e){
e.printStackTrace();
}
java.sql.Connection conn = null;
PreparedStatement pstmt =null;
try{
String sql = "insert into MsgText values(?,?,?,?,?,?,?,?,?)";
conn = DriverManager.getConnection(dbURL, user, password);
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, textMessage.getToUserName());
pstmt.setString(2, ToUserID);
pstmt.setString(3, textMessage.getFromUserName());
pstmt.setString(4, FromUserID);
pstmt.setString(5, textMessage.getCreateTime());
pstmt.setString(6, textMessage.getMsgType());
pstmt.setString(7, textMessage.getContent());
pstmt.setLong(8, textMessage.getMsgId());
pstmt.setInt(9, textMessage.getAgentID());
pstmt.executeU