SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?java.sql.SQLException: Can not issue executeUpdate() for SELECTsat com.mysql.
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/28 06:55:39
![SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?java.sql.SQLException: Can not issue executeUpdate() for SELECTsat com.mysql.](/uploads/image/z/4641383-47-3.jpg?t=SQL+%3Eselect+count%28%2A%29+from+Teacher+where+teacherCode%3D%3F+and+teacherPassword%3D%3F+java.sql.SQLException%3ASQL+%3Eselect+count%28%2A%29+from+Teacher+where+teacherCode%3D%3F+and+teacherPassword%3D%3Fjava.sql.SQLException%3A+Can+not+issue+executeUpdate%28%29+for+SELECTsat+com.mysql.)
SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?java.sql.SQLException: Can not issue executeUpdate() for SELECTsat com.mysql.
SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:
SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?
java.sql.SQLException: Can not issue executeUpdate() for SELECTs
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
public int execOther(final String strSQL, final Object[] params){
this.fetchFreeConnection();
try {
this.pstmt = this.conn.prepareStatement(strSQL);
System.out.println(new Date()+"\nSQL >"+strSQL);
for (int i = 0; i < params.length; i++) {
this.pstmt.setObject(i+1, params[i]);
}
int count = this.pstmt.executeUpdate();
return count;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return -1;
}
}
SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=? java.sql.SQLException:SQL >select count(*) from Teacher where teacherCode=? and teacherPassword=?java.sql.SQLException: Can not issue executeUpdate() for SELECTsat com.mysql.
int count = this.pstmt.executeUpdate();
改为
int count = this.pstmt.executequery();
你执行的是select语句,调用的确实update方法.查询语句要是用查询的方法.