java sql in变量_Java中使用PreparedStatement 中占位符传递变量报错，变量传递不进sql语句中...

Scanner sc=new Scanner(System.in);

System.out.println("请输入用户名：");

String name=sc.nextLine();

System.out.println("请输入密码：：");

String psd=sc.nextLine();

String sql="SELECT * FROM users where sname=? AND spassword=?";

PreparedStatement pst=con.prepareStatement(sql);

//调用pst对象set方法，

pst.setString(1,name);

pst.setString(2,psd);

System.out.println(sql);

ResultSet rs=pst.executeQuery(sql);

输出台：

”

请输入用户名：

a

请输入密码：：

1

SELECT * FROM users where sname=? AND spassword=?

Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 spassword=?' at line 1