Servlet实例

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

}