Question

JAVA操作MSSQL的小问题

public ResultSet select(String sql) {
try {
rst = st.executeQuery(sql);
return rst;
} catch (SQLException ex) {
close();
System.out.println("查询失败");
}
close();
return null;
}
main{
String passwordText=new String(password.getPassword());
String sql="select * from table_1 where id like'"+ID.getText()+"'"+"and password like'"+passwordText+"'";
select(sql);
}
数据库已连接好，怎样在table_1中获取id=ID.getText(),password=passwordText的用户的name?//table_1中有name的这列
上面这样哪里错了？

Answer 1

1.sql注意空格:
String sql = "select * from table_1 where id like '"+ID.getText()+"' and password like '"+passwordText+"'";
2.返回的对象为ResultSet，你可以用getString("name")获取到这个用户的name
比如:
ResultSet rs = seletc(sql);
String name = rs.next()?rs.getString("name"):null;

Answer 2

like'"+ID.getText()+"'"+"and password like'"+你的双引号有点问题

Answer 3

sql 中用到双引号 要加\ 转意符