DAO层用于底层数据库的连接
userdao接口层用于定义业务层需要使用的数据库的方法,例如
public void QueryLogin(User user);//根据实体类用户对象在数据库中查到对应的用户对象,用于用户登录时,校验是否是注册用户
public List<User>getallUsers();//查询所有用户的信息,保存在Lis集合中
public int addadmin(User user);//添加一个用户信息
public int deleteUser(int id);//根据id删除一条用户
public User getUserByid(int id);//根据id查询用户对象
userdaoImpl层用于实现userdao层定义的相关接口方法
class userdaoimpl extends dao implements userdao{
Connection connection=nul;
PreparedStatement preparedStatement=null;
Resultset resultset=null;
int count =0;
public int getCount() {
return count;
}
public void setCount(int count) {
this.count = count;
}
//查询数据表中的管理员,进行登录数时的验证
public void QueryLogin(User user){
String sql="select * from user where username='"+user.getUserName+" ' and password='"+user.getPassword+" '; ";
try{
connection=this.getConnection();
preparedStatement=connection.prepareStatement(sql);
resultset=preparedStatement.executeQuser();
while(resultset.next()){
count=resultSet.getint(1);
}
}
}
}
UserLoginaction
String username=request.getParameter("username");
String password=request.getParameter("password");
user=new User
user.setusername(username);
user.setpassword(password);
userdao=new UserDaoImpl();
userdao.queryLogin(user);