Select语句在java文件中的应用

import entity.User;

public class UserDao {

private Connection conn = null;

private PreparedStatement pstmt = null;
private Statement stmt = null;

private ResultSet  rs = null;

public int selectIfHaveUser(User user){
int count=0;
try {
conn = Connsql.getConn();
String sql = "SELECT * FROM users WHERE name = ? AND password = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, user.getLogname());
pstmt.setString(2, user.getPassword());

rs=pstmt.executeQuery();//select语句对应的方法
if(rs.next()){
count=1;
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
Connsql.closeAll(pstmt, conn);
}
return count;
}

}