公文流转2

公文流转2

2、公文实体：

package com.me.domain;


public class Doc {
    private int id;
    private int status;
    private int deletestatus;
    private String title;
    private String current;
    private String owner;
    private String content;
    private String time;
    private String firstcheck;
    private String secondcheck;
    public String getFirstcheck() {
        return firstcheck;
    }
    public void setFirstcheck(String firstcheck) {
        this.firstcheck = firstcheck;
    }
    public String getSecondcheck() {
        return secondcheck;
    }
    public void setSecondcheck(String secondcheck) {
        this.secondcheck = secondcheck;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public int getStatus() {
        return status;
    }
    public void setStatus(int status) {
        this.status = status;
    }
    public int getDeletestatus() {
        return deletestatus;
    }
    public void setDeletestatus(int deletestatus) {
        this.deletestatus = deletestatus;
    }
    public String getTitle() {
        return title;
    }
    public void setTitle(String title) {
        this.title = title;
    }
    public String getCurrent() {
        return current;
    }
    public void setCurrent(String current) {
        this.current = current;
    }
    public String getOwner() {
        return owner;
    }
    public void setOwner(String owner) {
        this.owner = owner;
    }
    public String getContent() {
        return content;
    }
    public void setContent(String content) {
        this.content = content;
    }
    public String getTime() {
        return time;
    }
    public void setTime(String time) {
        this.time = time;
    }
    @Override
    public String toString() {
        return "Doc [id=" + id + ", status=" + status + ", deletestatus=" + deletestatus + ", title=" + title
                + ", current=" + current + ", owner=" + owner + ", content=" + content + ", time=" + time
                + ", firstcheck=" + firstcheck + ", secondcheck=" + secondcheck + "]";
    }
    
    
}

权限实体：

package com.me.domain;

public class Quan {
    private String quan; 
    private int id; 
    private String address;
    public String getQuan() {
        return quan;
    }
    public void setQuan(String quan) {
        this.quan = quan;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    @Override
    public String toString() {
        return "Quan [quan=" + quan + ", id=" + id + ", address=" + address + "]";
    } 
    
}

用户实体：

package com.me.domain;

public class User {
    private int id;
    private int uid;
    private int tid;
    private int statu;
    private String username;
    private String password;
    private String job;

    public int getUid() {
        return uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public int getTid() {
        return tid;
    }

    public void setTid(int tid) {
        this.tid = tid;
    }

    public int getStatu() {
        return statu;
    }

    public void setStatu(int statu) {
        this.statu = statu;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", tid=" + tid + ", statu=" + statu + ", username=" + username + ", password="
                + password + ", job=" + job + "]";
    }

}

公文servlet

package com.me.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.me.dao.DocDao;
import com.me.domain.Doc;
import com.me.domain.User;

@WebServlet("/docflow")
public class DocFlowServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    public DocFlowServlet() {
        super();
    }
    DocDao docdao =new DocDao();
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        String method = request.getParameter("method");
        System.out.println(method);
        if(method.equals("to_office")) {
            try {
                to_office(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("officelist")) {
            try {
                officelist(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("to_next")) {
            try {
                to_next(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("deletedoc")) {
            try {
                deletedoc(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("firstcheck")) {
            try {
                firstcheck(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("firstcheck2")) {
            try {
                firstcheck2(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("firstcheck3")) {
            try {
                firstcheck3(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("secondcheck")) {
            try {
                secondcheck(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("secondcheck2")) {
            try {
                secondcheck2(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("secondcheck3")) {
            try {
                secondcheck3(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("docinfo")) {
            try {
                docinfo(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("sent_to_down")) {
            try {
                sent_to_down(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("sign")) {
            try {
                sign(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("unsign")) {
            try {
                unsign(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("audit")) {
            try {
                audit(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("unaudit")) {
            try {
                unaudit(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("audit2")) {
            try {
                audit2(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else  if(method.equals("unaudit2")) {
            try {
                unaudit2(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    
    private void unaudit2(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.unaudit2();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }
    }

    private void audit2(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.audit2();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }
    }

    private void unaudit(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.unaudit();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }
    }

    private void audit(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.audit();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }
    }

    private void unsign(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        User user = (User) request.getSession().getAttribute("who");
        String job = user.getJob();
        List<Doc> doclist = docdao.unsign(job);
        request.setAttribute("doclist", doclist);
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("department.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("department.jsp").forward(request, response);
        }
    }
    private void sign(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        User user = (User) request.getSession().getAttribute("who");
        String job = user.getJob();
        List<Doc> doclist = docdao.sign(job);
        request.setAttribute("doclist", doclist);
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("department.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("department.jsp").forward(request, response);
        }
    }

    private void sent_to_down(HttpServletRequest request, HttpServletResponse response) throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        boolean f=docdao.sent_to_down(id);
        response.getWriter().write("{"f":"+f+"}");
    }

    private void docinfo(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        Doc doc=docdao.docinfo(id);
        request.setAttribute("doc", doc);
        if(doc!=null) {
            request.getRequestDispatcher("docinfo.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("docinfo.jsp").forward(request, response);
        }
    }

    private void secondcheck3(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        String secondcheck = request.getParameter("secondcheck");
        String check = request.getParameter("check");
        boolean f=false;
        if(check.equals("yes")) {
            f=docdao.secondcheck3(id,secondcheck);
        }else {
            f=docdao.secondcheck4(id,secondcheck);
        }
        //System.out.println(f+"123");
        response.getWriter().write("{"f":"+f+"}");
        
    }

    private void secondcheck2(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        Doc doc=docdao.secondcheck2(id);
        request.setAttribute("doc", doc);
        if(doc!=null) {
            request.getRequestDispatcher("secondcheck2.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("secondcheck2.jsp").forward(request, response);
        }
        
    }

    private void secondcheck(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.secondcheck();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("secondcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("secondcheck.jsp").forward(request, response);
        }
    }

    private void firstcheck3(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        System.out.println(123456);
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        String firstcheck = request.getParameter("firstcheck");
        String check = request.getParameter("check");
        boolean f=false;
        if(check.equals("yes")) {
            f=docdao.firstcheck3(id,firstcheck);
        }else {
            f=docdao.firstcheck4(id,firstcheck);
        }
        System.out.println(f+"123");
        response.getWriter().write("{"f":"+f+"}");
    }

    private void firstcheck2(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        Doc doc=docdao.firstcheck2(id);
        request.setAttribute("doc", doc);
        if(doc!=null) {
            request.getRequestDispatcher("firstcheck2.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck2.jsp").forward(request, response);
        }
    }

    private void firstcheck(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.firstchenk();
        request.setAttribute("doclist", doclist);
        System.out.println(doclist.isEmpty());
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("firstcheck.jsp").forward(request, response);
        }
    }

    private void deletedoc(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        boolean f=docdao.deletedoc(id);
        response.getWriter().write("{"f":"+f+"}");
    }

    private void to_next(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        String status_str = request.getParameter("status");
        int status= Integer.parseInt(status_str);
        int status_t=0;
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        String owner = request.getParameter("owner");
        String current="";
        switch (status) {
        case 1:
            if (owner.equals("销售部门")) {
                current="销售副厂长";
            } else if (owner.equals("财务部门")) {
                current="财务副厂长";
            } else {
                current="生产副厂长";
            }
            status_t=2;
            break;
        case 3:
            current="厂长";
            status_t=4;
            break;
        case 5:
            if (owner.equals("销售部门")) {
                current="销售副厂长";
            } else if (owner.equals("财务部门")) {
                current="财务副厂长";
            } else {
                current="生产副厂长";
            }
            status_t=10;
            break;
        case 11:
            current=owner;
            status_t=6;
            break;
        }
        boolean f= docdao.to_fu(id,current,status_t);
        response.getWriter().write("{"f":"+f+"}");

    }

    private void officelist(HttpServletRequest request, HttpServletResponse response)throws  SQLException, ServletException, IOException {
        List<Doc> doclist =docdao.officelist();
        request.setAttribute("doclist", doclist);
        if(!doclist.isEmpty()) {
            request.getRequestDispatcher("docflow_office.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("docflow_office.jsp").forward(request, response);
        }
    }

    private void to_office(HttpServletRequest request, HttpServletResponse response)throws  SQLException, IOException {
        Doc doc=new Doc();
        String current="办公室";
        User user = (User) request.getSession().getAttribute("who");
        String title = request.getParameter("title");
        String content = request.getParameter("content");
        Date date = new Date();
        SimpleDateFormat dateFormat= new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        String time=dateFormat.format(date).toString();
        doc.setContent(content);
        doc.setTitle(title);
        doc.setTime(time);
        doc.setCurrent(current);
        doc.setStatus(1);
        doc.setOwner(user.getJob());
        doc.setDeletestatus(0);
        boolean f = docdao.create(doc);
        response.getWriter().write("{"f":"+f+"}");
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        doGet(request, response);
    }

}

用户servlet

package com.me.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.me.dao.UserDao;
import com.me.domain.Quan;
import com.me.domain.User;

@WebServlet("/user")
public class UserServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    public UserServlet() {
        super();
    }
    UserDao userdao =new UserDao();
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        
        request.setCharacterEncoding("UTF-8");
        String method = request.getParameter("method");
        if(method.equals("login")) {
            try {
                login(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } else if(method.equals("function")) {
            try {
                function(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    private void function(HttpServletRequest request, HttpServletResponse response) throws  SQLException, ServletException, IOException{
        User user = (User) request.getSession().getAttribute("who");
        List<Quan> quan_list = userdao.function(user);
        request.setAttribute("quan_list", quan_list);
        if(!quan_list.isEmpty()) {
            System.out.println(quan_list.isEmpty());
            request.getRequestDispatcher("function.jsp").forward(request, response);;
        }else {
            request.getRequestDispatcher("function.jsp").forward(request, response);;
            
        }
    }

    private void login(HttpServletRequest request, HttpServletResponse response) throws IOException, SQLException, ServletException {
        User user= new User();
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        user.setUsername(username);
        user.setPassword(password);
        user=userdao.login(user);
        
        request.getSession().setAttribute("who", user);
        if(user!=null) {
            System.out.println(user.toString());
            request.getRequestDispatcher("user?method=function").forward(request, response);;
        }else {
            request.getRequestDispatcher("index.jsp").forward(request, response);;
        }
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}

管理servlet

package com.me.servlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import com.me.dao.UserDao;
import com.me.domain.Quan;
import com.me.domain.User;

@WebServlet("/manage")
public class ManageServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    public ManageServlet() {
        super();
    }
    UserDao userdao =new UserDao();
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");
        String method = request.getParameter("method");
        System.out.println(method);
        if(method.equals("userlist")) {
            try {
                userlist(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("query")) {
            try {
                query(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("add")) {
            try {
                add(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("stop")) {
            try {
                stop(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("start")) {
            try {
                start(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("delete")) {
            try {
                delete(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("change")) {
            try {
                change(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("change2")) {
            try {
                change2(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("changepassword")) {
            try {
                changepassword(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("juelist")) {
            try {
                juelist(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }else if(method.equals("bianji")) {
            try {
                bianji(request,response);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    private void bianji(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        int uid =Integer.parseInt(uid_str);
        User user = userdao.query(uid);
        List<Quan> quanlist = userdao.function(user);
        request.setAttribute("user", user);
        request.setAttribute("quanlist", quanlist);
        if(!quanlist.isEmpty()) {
            request.getRequestDispatcher("quan_bianji.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("index.jsp").forward(request, response);
        }
    }

    private void juelist(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        List<User> userlist=userdao.userlist();
        request.setAttribute("userlist", userlist);
        if(!userlist.isEmpty()) {
            request.getRequestDispatcher("juemanage.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("index.jsp").forward(request, response);
        }
    }

    private void changepassword(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        User user = (User) request.getSession().getAttribute("who");
        int uid = user.getUid();
        String before = request.getParameter("before");
        String password = request.getParameter("password");
        boolean f= userdao.changepassword(uid,before,password);
        if(f) {
            request.getRequestDispatcher("manage?method=userlist").forward(request, response);
        }else {
            request.getRequestDispatcher("manage?method=userlist").forward(request, response);
        }
    }


    private void change2(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        User user =new User();
        user.setUsername(request.getParameter("username"));
        user.setPassword(request.getParameter("password"));
        user.setJob(request.getParameter("job"));
        String statu_str = request.getParameter("statu");
        int statu=Integer.parseInt(statu_str);
        user.setStatu(statu);
        boolean f=userdao.change2(user);
        if(f) {
            request.getRequestDispatcher("manage?method=userlist").forward(request, response);
        }else {
            request.getRequestDispatcher("manage?method=userlist").forward(request, response);
        }
    }

    private void change(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        //System.out.println(uid_str);
        int uid =Integer.parseInt(uid_str);
        User user = userdao.query(uid);
        List<Quan> quanlist = userdao.function(user);
        request.setAttribute("user", user);
        request.setAttribute("quanlist", quanlist);
        if(!quanlist.isEmpty()) {
            request.getRequestDispatcher("change_user.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("change_user.jsp").forward(request, response);
        }
    }

    private void delete(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        int uid=Integer.parseInt(uid_str);
        boolean f=userdao.delete(uid);
        response.getWriter().write("{"f":"+f+"}");
    }

    private void start(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        int uid=Integer.parseInt(uid_str);
        boolean f=userdao.start(uid);
        response.getWriter().write("{"f":"+f+"}");
    }

    private void stop(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        int uid=Integer.parseInt(uid_str);
        boolean f=userdao.stop(uid);
        response.getWriter().write("{"f":"+f+"}");
    }

    private void add(HttpServletRequest request, HttpServletResponse response)throws SQLException, ServletException, IOException {
        User user =new User();
        user.setUsername(request.getParameter("username"));
        user.setPassword(request.getParameter("password"));
        user.setJob(request.getParameter("job"));
        String id_str = request.getParameter("id");
        int id=Integer.parseInt(id_str);
        String tid_str = request.getParameter("tid");
        int tid=Integer.parseInt(tid_str);
        user.setId(id);
        user.setTid(tid);
        boolean f=userdao.add(user);
        if(f) {
            request.getRequestDispatcher("create_user.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("create_user.jsp").forward(request, response);
        }
    }

    private void query(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        String uid_str = request.getParameter("uid");
        int uid =Integer.parseInt(uid_str);
        User user = userdao.query(uid);
        List<Quan> quanlist = userdao.function(user);
        request.setAttribute("user", user);
        request.setAttribute("quanlist", quanlist);
        if(!quanlist.isEmpty()) {
            request.getRequestDispatcher("userinfo.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("userinfo.jsp").forward(request, response);
        }
    }

    private void userlist(HttpServletRequest request, HttpServletResponse response) throws SQLException, ServletException, IOException {
        List<User> userlist=userdao.userlist();
        request.setAttribute("userlist", userlist);
        if(!userlist.isEmpty()) {
            request.getRequestDispatcher("usermanage.jsp").forward(request, response);
        }else {
            request.getRequestDispatcher("usermanage.jsp").forward(request, response);
        }
    }
    

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doGet(request, response);
    }

}

公文dao

package com.me.dao;

import java.sql.SQLException;
import java.util.List;


import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.me.domain.Doc;
import com.me.utils.DBUtils;

public class DocDao {

    public boolean create(Doc doc) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "insert into doc_list(title,owner,current,time,status,deletestatus,content) values(?,?,?,?,?,?,?)";
        int update = qr.update(sql,doc.getTitle(),doc.getOwner(),doc.getCurrent(),doc.getTime()
                ,doc.getStatus(),doc.getDeletestatus(),doc.getContent());
        if(update>0) {
            return true;
        }else {
            return false;
        }
    }

    public List<Doc> officelist() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where deletestatus = 0";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }

    public boolean to_fu(int id,String current,int status_t) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set status=?,current=?  where id=? ";
        int n = qr.update(sql, status_t , current, id);
        //System.out.println(n);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public boolean deletedoc(int id) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set deletestatus=1  where id=? ";
        int n = qr.update(sql, id);
        //System.out.println(n);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public List<Doc> firstchenk() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where ( status=2 or status = 10 ) and deletestatus = 0 ";
//        String sql = "select * from doc_list where ( status=2 or status = 10 ) and deletestatus = 0 and current = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }

    public Doc firstcheck2(int id) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status=2 and deletestatus = 0 and id = ?";
        Doc query = qr.query(sql, new BeanHandler<Doc>(Doc.class),id);
        return query;
    }

    public boolean firstcheck3(int id, String firstcheck) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set firstcheck=? , status= ? , current=? where id=? ";
        int n = qr.update(sql, firstcheck,3,"办公室",id);
        //System.out.println(n+"aa!");
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }
    
    public boolean firstcheck4(int id, String firstcheck) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set firstcheck=? ,status= 8 ,current='办公室' where id=? ";
        int n = qr.update(sql, firstcheck,id);
        //System.out.println(n);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public List<Doc> secondcheck() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status=4 and deletestatus = 0 ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }
    public Doc secondcheck2(int id) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status=4 and deletestatus = 0 and id = ?";
        Doc query = qr.query(sql, new BeanHandler<Doc>(Doc.class),id);
        return query;
    }
    public boolean secondcheck3(int id, String secondcheck) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set secondcheck=? , status= ? , current=? where id=? ";
        int n = qr.update(sql,secondcheck,5,"办公室",id);
        //System.out.println(n+"aa!");
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }
    
    public boolean secondcheck4(int id, String secondcheck) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set secondcheck=? ,status= 9 ,current='办公室' where id=? ";
        int n = qr.update(sql, secondcheck,id);
        //System.out.println(n);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public Doc docinfo(int id) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where deletestatus = 0 and id = ?";
        Doc query = qr.query(sql, new BeanHandler<Doc>(Doc.class),id);
        return query;
    }

    public boolean sent_to_down(int id) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update doc_list set status=?,current=?  where id=? ";
        int n = qr.update(sql, 11 , "办公室", id);
        //System.out.println(n);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public List<Doc> sign(String job) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status=7 and deletestatus = 0 and current = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),job);
        return list;
    }
    public List<Doc> unsign(String job) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status != 7 and deletestatus = 0 and owner = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),job);
        return list;
    }

    public List<Doc> unaudit() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where ( status=1 or  status=2 ) and deletestatus = 0 ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }
    public List<Doc> audit() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where  status !=1 and  status !=2  and deletestatus = 0 ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }
    public List<Doc> unaudit2() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status<5 and status =8 and deletestatus = 0 ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }
    public List<Doc> audit2() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status>4 and status !=8 and deletestatus = 0 ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }

    public List<Doc> lookall() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list ";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class));
        return list;
    }

    public List<Doc> querytime(String from, String to) throws SQLException {
        
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where time >= ? and time <= ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),from,to);
        return list;
    }

    public List<Doc> querybyowner(String tiaojian) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where owner = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),tiaojian);
        return list;
    }

    public List<Doc> querybycurrent(String tiaojian) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where current = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),tiaojian);
        return list;
    }

    public List<Doc> querybystatus(String tiaojian) throws SQLException {
        int status =Integer.parseInt(tiaojian);
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where status = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),status);
        return list;
    }

    public List<Doc> querybytitle(String tiaojian) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from doc_list where title = ?";
        List<Doc> list = qr.query(sql, new BeanListHandler<Doc>(Doc.class),tiaojian);
        return list;
    }


}

用户dao

package com.me.dao;

import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.me.domain.Quan;
import com.me.domain.User;
import com.me.utils.DBUtils;

public class UserDao {

    public User login(User user) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from user where username=? and password=? and statu = 1";
        User user01 = qr.query(sql, new BeanHandler<User>(User.class), user.getUsername(), user.getPassword());
        return user01;
    }

    public List<Quan> function(User user) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from quan01 where id=?";
        List<Quan> query = qr.query(sql, new BeanListHandler<Quan>(Quan.class), user.getId());
        return query;
    }

    public List<User> userlist() throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from user ";
        List<User> query = qr.query(sql, new BeanListHandler<User>(User.class));
        return query;
    }

    public User query(int uid ) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "select * from user where uid = ? ";
        User user01 = qr.query(sql, new BeanHandler<User>(User.class), uid);
        return user01;
    }

    public boolean add(User user) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "insert into user (id,password,username,tid,statu,job) values(?,?,?,?,?,?)";
        int update = qr.update(sql,user.getId(),user.getPassword(),user.getUsername(),user.getTid(),1,user.getJob());
        if(update>0) {
            return true;
        }else {
            return false;
        }
    }

    public boolean stop(int uid) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update user set statu = 0   where uid=? ";
        int n = qr.update(sql,uid);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }
    public boolean start(int uid) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update user set statu = 1   where uid=? ";
        int n = qr.update(sql,uid);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public boolean delete(int uid) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="delete from user  where uid=? ";
        int n = qr.update(sql,uid);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public boolean change2(User user) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update user set password = ? , job=? , statu=?   where username=? ";
        int n = qr.update(sql,user.getPassword(),user.getJob(),user.getStatu(),user.getUsername());
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

    public User changepassword(int uid) throws SQLException {
        QueryRunner qr = new QueryRunner(DBUtils.getDataSource());
        String sql = "update user set password = ? where uid = ? ";
        User user01 = qr.query(sql, new BeanHandler<User>(User.class), uid);
        return user01;
    }

    public boolean changepassword(int uid, String before, String password) throws SQLException {
        QueryRunner qr =new QueryRunner(DBUtils.getDataSource());
        String sql="update user set password = ? where uid=? and password=?";
        int n = qr.update(sql,password,before,uid);
        if (n > 0) {
            return true;
        } else {
            return false;
        }
    }

}