"SELECT uname,upwd FROM fu_white_user WHERE uname=? AND upwd=?";查询用户名 密码那么当传过来的 参数 查不到时出现 nullpointerException 这时我咋处理public Login queryNamePwd(String name,String pwd){
Connection con = null;
PreparedStatement pre = null;
ResultSet rs = null;
Login lo = null;
String sqlStr = "SELECT uname,upwd FROM fu_white_user WHERE uname=? AND upwd=?";
try {
con=DriverManager.getConnection("proxool.ivr");
System.out.println(con+"=========================");
pre = con.prepareStatement(sqlStr);
pre.setString(1, name);
pre.setString(2, pwd);
rs = pre.executeQuery();
while(rs.next()){
lo = new Login();
String uname = rs.getString("uname");
String upwd = rs.getString("upwd");
System.out.println(uname);
lo.setUname(uname);
lo.setUpwd(upwd);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try{
rs.close();
pre.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return lo;
Connection con = null;
PreparedStatement pre = null;
ResultSet rs = null;
Login lo = null;
String sqlStr = "SELECT uname,upwd FROM fu_white_user WHERE uname=? AND upwd=?";
try {
con=DriverManager.getConnection("proxool.ivr");
System.out.println(con+"=========================");
pre = con.prepareStatement(sqlStr);
pre.setString(1, name);
pre.setString(2, pwd);
rs = pre.executeQuery();
while(rs.next()){
lo = new Login();
String uname = rs.getString("uname");
String upwd = rs.getString("upwd");
System.out.println(uname);
lo.setUname(uname);
lo.setUpwd(upwd);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try{
rs.close();
pre.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return lo;
我是无语了 最近总能遇见这个事 靠 坑死我了 谢谢你们的解答