import java.sql.*;
import com.accp.demo2.model.UserBean;
public class ColDB {
private Connection con=null;
private PreparedStatement s=null;
private ResultSet rs=null;
DB db=new DB();
public UserBean isLogin(String username,String password){
UserBean bean=new UserBean();
con=db.getCon();
try {
String sql="select * from userinfo where userName=? and userPass=?";
s=con.prepareStatement(sql);
s.setString(1, username);
s.setString(2, password);
rs=s.executeQuery();
if(rs.next()){
bean.setUsername(rs.getString("userName"));
bean.setUserpass(rs.getString("userPass"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return bean;
}
}