SQL语句原因之一:
SQL语句中的?也是有中英文区别的,报错SQL语句如下,根据报错提示:只有6个“?”,而下面却设置了7条赋值语句,冲突。即发现错误在第7个问号处。该处?没有用英文格式的?。
public void updateStudents(Connection conn, Student student) {
String sql = "update student set sname=?,age=?,gender=?,address=?,phone=?,remark=? where id=?";
PreparedStatement sta = null;
try {
sta = conn.prepareStatement(sql);
sta.setString(1, student.getSname());
sta.setInt(2, student.getAge());
sta.setString(3, student.getGender());
sta.setString(4, student.getAddress());
sta.setString(5, student.getPhone());
sta.setString(6, student.getRemark());
sta.setInt(7,student.getId());
sta.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
JDBCUtils.close(null, sta, null);
}
}