Servlet实例

柔光的暖阳◎ 2022-06-06 02:08 126阅读 0赞

**DaoImpl**

package com.zhiyou100.crm.dao.impl;
    
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Timestamp;
    import java.util.ArrayList;
    import java.util.List;
    
    import com.zhiyou100.crm.dao.UserDao;
    import com.zhiyou100.crm.model.User;
    import com.zhiyou100.crm.util.DBUtil;
    
    public class UserDaoImpl implements UserDao { 
    
        @Override
        public boolean isUsername(String username) {
            // TODO Auto-generated method stub
            DBUtil db= new DBUtil();
            String sql="select * from user where username=?";
            Object[] obj={username};
            ResultSet rs=db.select(sql, obj);
            try {
                while(rs.next()){
                    return true;
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return false;
        }
    
        @Override
        public boolean isUsernamepassword(String username, String password) {
            // TODO Auto-generated method stub
            DBUtil db= new DBUtil();
            String sql="select * from user where username=? and password=?";
            Object[] obj={username,password};
            ResultSet rs=db.select(sql, obj);
            try {
                while(rs.next()){
                    return true;
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return false;
        }
    
        @Override
        public int isSuperAdmin(String username) {
            // TODO Auto-generated method stub
            DBUtil db= new DBUtil();
            String sql="select role_id from user where username=?";
            Object[] obj={username};
            ResultSet rs=db.select(sql, obj);
            try {
                int i=0;
                while(rs.next()){
                    i=rs.getInt("role_id");
                }
                return i;
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return 0;
        }
    
        @Override
        public List<User> list(int role_id) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="select * from user where role_id=?";
            Object[] obj={role_id};
            ResultSet rs=db.select(sql, obj);
            try {
    
                List<User> list=new ArrayList<User>();
                while(rs.next()){
                    int id=rs.getInt("user_id");
                    String username=rs.getString("username");
                    int dep_id=rs.getInt("department_id");
                    int roleid=rs.getInt("role_id");
                    String tel=rs.getString("mobile");
                    String email=rs.getString("email");
                    Timestamp tm=rs.getTimestamp("update_time");
                    User us=new User(id, username, dep_id, roleid, tel, email, tm);
                    list.add(us);
                }
                return list;
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return null;
        }
    
        @Override
        public boolean isNameExist(String username) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
    
            String sql="select * from user where username=?";
            Object[] obj={username};
            ResultSet rs=db.select(sql, obj);
            try {
                while(rs.next()){ 
                    return true;
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return false;
        }
    
        @Override
        public void add(User user) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
    
            String sql="insert into user(username,password,department_id,role_id,is_male,"
                    + "mobile,address,age,tel,id_num,email,qq,hobby,education,card_num,nation,marry,remark"
                    + ") values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ";
            Object[]obj={user.getUsername(),user.getPassword(),user.getDepartment_id(),
                    user.getRole_id(),user.getIs_male(),user.getMobile(),user.getAddress(),user.getAge(),
                    user.getTel(),user.getId_num(),user.getEmail(),user.getQq(),user.getHobby(),user.getEducation(),
                    user.getCard_num(),user.getNation(),user.getMarry(),user.getRemark()};
            db.update(sql, obj);
        }
    
        @Override
        public void delete(int user_id) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="delete from user where user_id=?";
            Object[] obj={user_id};
            db.update(sql, obj);
        }
    
        @Override
        public User selectOneById(int id) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="select * from user where user_id=?";
            Object[] obj={id};
            ResultSet rs=db.select(sql, obj);
            try {
                User us=null;
                while(rs.next()){
                    int user_id=rs.getInt(1);
                    String username=rs.getString(2);
                    String password=rs.getString(3);
                    int department_id=rs.getInt(6);
                    int is_male=rs.getInt(7);
                    int role_id=rs.getInt(8);
                    String mobile=rs.getString(9);
                    String address=rs.getString(10);
                    int age=rs.getInt(11);
                    String tel=rs.getString(12);
                    String id_num=rs.getString(13);
                    String email=rs.getString(14);
                    String qq=rs.getString(15);
                    String hobby=rs.getString(16);
                    int education=rs.getInt(17);
                    String card_num=rs.getString(18);
                    String nation=rs.getString(19);
                    int marry=rs.getInt(20);
                    String remark=rs.getString(22);
    
                    us=new User(user_id, username, password, department_id, role_id, is_male, 
                            mobile, address, age, tel, id_num, email, qq, hobby, education,
                            card_num, nation, marry, remark);
    
                }
                return us;
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return null;
        }
    
        @Override
        public void update(User user) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="update user set username=?, password=?,department_id=?,role_id=?,is_male=?"
                    + ",mobile=?,address=?,age=?,tel=?,id_num=?,email=?,qq=?,hobby=?,education=?,"
                    + "card_num=?,nation=?,marry=?,remark=? where user_id=?";
            Object[] obj={user.getUser_id(),user.getUsername(),user.getPassword(),user.getDepartment_id(),
                    user.getRole_id(),user.getIs_male(),user.getMobile(),user.getAddress(),user.getAge()
                    ,user.getTel(),user.getId_num(),user.getEmail(),user.getQq(),user.getHobby(),user.getEducation(),
                    user.getCard_num(),user.getNation(),user.getMarry(),user.getRemark()};
            db.update(sql, obj);
        }
    
        @Override
        public User getUser(String username) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="select * from user where username=?";
            Object[] obj={username};
            ResultSet rs=db.select(sql, obj);
            try {
                User user=null;
                while(rs.next()){
                    int user_id=rs.getInt(1);
                    String username2=rs.getString(2);
                    int department_id=rs.getInt(6);
                    int role_id=rs.getInt(8);
                    String mobile=rs.getString(9);
                    String email=rs.getString(14);
                    Timestamp create_time=rs.getTimestamp(23);
                    user=new User(user_id, username2, department_id, role_id, mobile, email, create_time);
                }
                return user;
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return null;
        }
    
        @Override
        public List<User> selectKeyword(String keyword, String searchFiled) {
            // TODO Auto-generated method stub
            DBUtil db=new DBUtil();
            String sql="select * from user where "+searchFiled+" like ?";
            Object[] obj={
       "%"+keyword+"%"};
            ResultSet rs=db.select(sql, obj);
            try {
    
                List<User> list=new ArrayList<User>();
                while(rs.next()){
                    int id=rs.getInt("user_id");
                    String username=rs.getString("username");
                    int dep_id=rs.getInt("department_id");
                    int roleid=rs.getInt("role_id");
                    String tel=rs.getString("mobile");
                    String email=rs.getString("email");
                    Timestamp tm=rs.getTimestamp("update_time");
                    User us=new User(id, username, dep_id, roleid, tel, email, tm);
                    list.add(us);
                }
                return list;
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            return null;
        }
    
    }

**serviceImpl**

package com.zhiyou100.crm.service.impl;
    
    
    import java.util.List;
    
    import com.zhiyou100.crm.dao.UserDao;
    import com.zhiyou100.crm.dao.impl.UserDaoImpl;
    import com.zhiyou100.crm.model.User;
    import com.zhiyou100.crm.service.UserService;
    
    public class UserServiceImpl implements UserService { 
    
        @Override
        public int user_login(String username, String password) {
            // TODO Auto-generated method stub
            /** * 1、判断帐号是否存在 * 2、判断帐号密码是否匹配 * 3、判断是否是超级管理员 * */
            UserDao ud=new UserDaoImpl();
            /*boolean b1= ud.isUsername(username); boolean b2= ud.isUsernamepassword(username,password); int i=ud.isSuperAdmin(username);*/
            if(ud.isUsername(username)){  //帐号存在
                if(ud.isUsernamepassword(username,password)){
                    int i=ud.isSuperAdmin(username);
                    if(i==1){
                        return 1;
                    }else{
                        return 2;
                    }
                }else{
       //帐号密码不匹配
                    return -1;
                }
    
            }else{ //帐号不存在
                return 0;
            }
        }
    
        @Override
        public List<User> list(int role_id) {
            // TODO Auto-generated method stub
            UserDao ud=new UserDaoImpl();
            List<User> list=ud.list(role_id);
            return list;
        }
    
        @Override
        public boolean add(User user) {
            // TODO Auto-generated method stub
            //判断 需要一个判断方法 根据username来判断
            UserDao ud=new UserDaoImpl();
            boolean flag=ud.isNameExist(user.getUsername());
            if(flag==true){ //帐号存在
                //添加失败，返回false
                return false;
    
            }else{
       //帐号不存在，执行添加操作并且返回true
                ud.add(user);
                return true;
            }
    
        }
    
        @Override
        public void removeById(int user_id) {
            // TODO Auto-generated method stub
            //业务逻辑层
            UserDao ud=new UserDaoImpl();
            ud.delete(user_id);
    
        }
    
        @Override
        public User selectOneById(int id) {
            // TODO Auto-generated method stub
            UserDao ud=new UserDaoImpl();
            User us=ud.selectOneById(id);
            return us;
        }
    
        @Override
        public void update(User user) {
            // TODO Auto-generated method stub
            UserDao ud=new UserDaoImpl();
            ud.update(user);
        }
    
        @Override
        public User getUser(String username) {
            // TODO Auto-generated method stub
            UserDao ud=new UserDaoImpl();
            User user=ud.getUser(username);
            return user;
        }
    
        @Override
        public List<User> selectKeyword(String keyword, String searchFiled) {
            // TODO Auto-generated method stub
            UserDao ud=new UserDaoImpl();
            List<User> list=ud.selectKeyword(keyword,searchFiled);
            return list;
        }
    
    }

ListServlet

/** * Servlet implementation class ListServlet */
     //主要是注意这里，一个name 一个url
    @WebServlet(name = "user/ListServlet", urlPatterns = { "/user/ListServlet" })
    public class ListServlet extends HttpServlet { 
        private static final long serialVersionUID = 1L;
    
        /** * @see HttpServlet#HttpServlet() */
        public ListServlet() {
            super();
            // TODO Auto-generated constructor stub
        }
    
        /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
        protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            // TODO Auto-generated method stub
            UserService us=new UserServiceImpl();
            List<User> list=us.list(2);
    
            request.setAttribute("list",list);
            request.getRequestDispatcher("/WEB-INF/view/user/list.jsp").forward(request, response);
        }
    
        /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */
        protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
            // TODO Auto-generated method stub
            doGet(request, response);
        }
    
    }