向資料庫插入一條資料,
//輸入學生
public void add_student(String id,String name,String gender,
String age,String grade,String class_bj,String performance){
// System.out.println(mf.getId_field().getText());
try{
// stem = con.createStatement();
String s = “insert into tb_stu values(?,?,?,?,?,?,?)”;
statement = con.prepareStatement(s);
statement.setString(1, id);
statement.setString(2, name);
statement.setString(3, gender);
statement.setString(4, age);
statement.setString(5, grade);
statement.setString(6, class_bj);
statement.setString(7, performance);
statement.executeUpdate();
// String s = “insert into tb_stu values(”+id+","+name+","+gender+","+age+","
// +grade+","+class_bj+","+performance+")";
// stem.execute(s);
}catch(SQLException e){
e.printStackTrace();
}
}
為啥用注釋的方法插入會出現下列錯誤,未注釋的預處理方法可以成功。
[錯誤資訊]
