Question

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

private int check(String user_name, String user_code) throws SQLException {
// TODO Auto-generated method stub
PreparedStatement stmt = null;
String sql ="select * from log where name='?' and code='?';";
stmt = Server.con.prepareStatement(sql);
stmt.setString(1,user_name);
stmt.setString(2, user_code);
if(stmt.executeQuery(sql)==null){
return 0;
}
return 1;
}
大神求救啊！！！！！！！！！！！！！

Answer 1

String sql ="select * from log where name='?' and code='?';";改成
String sql ="select * from log where name=? and code=?“;

追问

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? and code=?' at line 1

追答

String sql ="select * from log where name=? and code=?";