jdbc 关于添加数据的问题

[s14791577605]

public static Users register(String name,String pwd){
Users users = null;
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:MySql:///register","root","0012");
PreparedStatement ps = conn.prepareStatement("insert users(name,pwd) values ('?','?')");
ps.setString(1, name);
ps.setString(2, pwd);
ResultSet rs = ps.executeQuery();
int count = 0;
if (rs.next()) {
count++;
System.out.println("用户名重复");
}else{
users = new Users(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getInt(4));
}

} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return users;
}

这里有问题：PreparedStatement ps = conn.prepareStatement("insert users(name,pwd) values ('?','?')");
ps.setString(1, name);
ps.setString(2, pwd);

错误： Parameter index out of range (1 > number of parameters, which is 0).

谁能告诉我要怎么办 - - 我改不出来

[晴天_ccc]

PreparedStatement ps = conn.prepareStatement("insert users(name,pwd) values ('?','?')"); insert 后面加上 into , 把？两旁的单引号去掉应该就可以了。

[尼古拉斯-全蛋]

恩，去掉单引号试试

[webnonono]

对啊.问号的话就不能加引号了