plz help in solving erroris showing invalid character used in sql query..so plz help

[sanya]

try
{
String url="jdbc:mysql://localhost/"+"userpwsd";
Connection con=DriverManager.getConnection(url,"root","");
Statement sn=con.createStatement();
String s;
s=SELECT 'username','password' FROM "userpwsd" WHERE username="+s1"' and password='"+s2+"'";
out.println(s);
ResultSet rs= sn.executeQuery("s=SELECT 'username','password' FROM 'userpwsd' WHERE username="+s1"' and password='"+s2"'";);

[rajujrk]

Hi

Try the below and let me know (UnTested)

try
    {
    String url="jdbc:mysql://localhost/userpwsd";
    Connection con=DriverManager.getConnection(url,"root","");
    Statement sn=con.createStatement();
    String s;
    s="SELECT username,password FROM userpwsd WHERE username='"+ s1 +"' and password='" + s2 + "'";
    out.println(s);
    ResultSet rs= sn.executeQuery(s);
 

Thanks
Raju

[chaarmann]

Just repl. double quot. mrks w single around 2nd userpwsd.
Tx.

Check, "userpwsd" misspelled - reverse "ws" --> "userpswd".
Tx.