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;
}
}
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;
}
}