Question

MySQL select count(*) from user where = ？ 执行ParPreparedStatement ps.executeQuery() 报错？

java.sql.SQLException: Can not issue data manipulation statements with executeQuery().

Answer 1

语句写多了、~~~~~~~~~~~~

追问

String sqlQuery = "select count(*) from user where username = ?";
PreparedStatement pstmt = conn.prepareStatement(sqlQuery);
pstmt.setString(1, u.getUsername());
ResultSet rs = pstmt.executeQuery();
int count=0;
if(rs.next()){
count = rs.getInt(1);
System.out.println(count);
}
那儿多了啊！不解！