</pre>正常的想法是和MySQL插入语句一样的:<pre name="code" class="java">String sql="insert into student(‘no’,‘name’,‘score’,‘password’) values(?,?,?,?)"
但其实如果这样写就会爆出:Parameter index out of range (1 > number of parameters, which is 0).
如果改成如下语句就不会报错
<pre name="code" class="java">String sql="insert into student(no,name,score,password) values(?,?,?,?)" ;
也就是SQL语句中不能出现‘’。
public static int insertStudent(Student student) {
Connection conn=DB.getConn();
String sql="insert into student(no,name,score,password) values(?,?,?,?)" ;
PreparedStatement pstmt=DB.prepare(conn,sql);
try {
pstmt.setString(1, student.no);
pstmt.setString(2, student.name);
pstmt.setInt(3, student.score);
pstmt.setString(4, student.password);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
DB.close(pstmt);
DB.close(conn);
}
return 1;
}