基于javaweb和mysql的jsp+servlet校园疫情防控管理信息系统疫情播报系统(java+servlet+jsp+bootstrap+mysql+css)

基于javaweb和mysql的jsp+servlet校园疫情防控管理信息系统疫情播报系统(java+servlet+jsp+bootstrap+mysql+css)

私信源码获取及调试交流

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的JSP+Servlet校园疫情防控管理信息系统疫情播报系统(java+servlet+jsp+bootstrap+mysql+css)

管理员：

admin 123456

学生：

student1 123456

student2 123456

教师：

teacher1 123456

teacher2 123456

校园疫情防控管理信息系统

项目简介：

校园疫情防控管理信息系统分为前台部分和后台部分，面向学校的学生和老师，旨在为学校提供一个有效防控校园出现疫情的综合性平台。

本管理系统将通过健康打卡的功能实现后台管理系统对师生身体状况数据的收集。

有了此系统，大大方便了学校疫情的防控工作，加大了学校疫情防控的力度，提高学校疫情防控的效率，尽最大地可能避免学校出现新冠肺炎疫情。

借助此系统学校能更好地做好疫情防控措施。

采用技术 ：

前端：HTML + CSS + JavaScript + Bootstrap + Jquery + Ajax

后端：Spring Boot + Jpa + Maven + Schedule定时任务 + Redis + Security + POI

开发环境 ：

工具：IDEA、Navicat、Git

环境：JDK 1.8、Tomcat 7.0、Mysql 8.0

项目管理：Maven

代码托管平台：GitHub

开发流程：

1、数据库设计

2、Model：模型定义，与数据库相匹配

3、Dao层：数据操作

4、Service:服务包装

5、Controller：业务入口，数据交互

6、Util：工具类封装

7、Config：配置类封装

8、单元测试

功能模块：

前台部分，主要分为以下几个模块：

个人信息管理

学生和老师登录

学生和老师修改密码

数据显示

学校疫情各情况数据的统计显示

疫情各情况饼状图占比分析

学生和教师各情况统计柱形图显示

各学院学生的各情况统计表格显示

各学院教师的各情况统计表格显示

打卡操作

学生每天打卡

教师每天打卡

疫情新闻显示

最新疫情新闻播报浏览

查看疫情新闻详情

后台部分，主要分为以下几个模块：

学生管理

查询学生

添加学生

修改学生

删除学生

教师管理

查询教师

添加教师

修改教师

删除教师

打卡信息管理

查询打卡信息

添加打卡信息

修改打卡信息

删除打卡信息

分析打卡信息

统计打卡信息

新闻管理

查询新闻

发布新闻

删除新闻

@WebServlet("/SchoQueryStuPunchByIdServlet1")
public class SchoQueryStuPunchByIdServlet1 extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String sno = req.getParameter("sno");
        String spunchdate = req.getParameter("spunchdate");

        //获取登录时的session会话对象
        HttpSession session = req.getSession();
//        String userName = (String) session.getAttribute("userName");
//        String sno = (String) session.getAttribute("sno");
        String belong = (String) session.getAttribute("belong");

        System.out.println(belong);

        String sql = null;
        Object[] objects = {sno, spunchdate};

        //查询是否存在此人
        sql = "select count(*) as num from student s,stupunchin sp where s.sno = sp.sno and s.sno = ? and sp.spunchdate = ?";
        int count = DeptAdminDao.findTotalCount(sql, objects);

        if (count > 0){ //有则继续操作
            sql = "select s.sname,sp.* from student s,stupunchin sp where s.sno = sp.sno and sp.sno = ? and sp.spunchdate = ?";
            ResultSet resultSet = DeptAdminDao.qureyInfo(sql, objects);
            StuPunch stuPunch = new StuPunch();

            try {
                while (resultSet.next()){
                    stuPunch.setSno(resultSet.getString("sno"));
                    stuPunch.setSname(resultSet.getString("sname"));
                    stuPunch.setSispunch(resultSet.getString("sispunch"));
                    stuPunch.setSpunchdate(resultSet.getDate("spunchdate"));
                    stuPunch.setSpunchtime(resultSet.getString("spunchtime"));

@WebServlet("/SchoQueryTeaPunchByPageServlet")
public class SchoQueryTeaPunchByPageServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String tno = req.getParameter("tno");
        String tname = req.getParameter("tname");
        String tdept = req.getParameter("tdept");
        String tpunchdate = req.getParameter("tpunchdate");

        System.out.println(tno);
        System.out.println(tname);
        System.out.println(tdept);
        System.out.println(tpunchdate);

        //如果传入的参数为null，则置为空字符串
        if (tno == null){
            tno = "";
        }
        if (tname == null){
            tname = "";
        }
        if (tdept == null){
            tdept = "";
        }
        if (tpunchdate == null){
            tpunchdate = "";
        }

            Object[] objects = {userName, psw};
                ResultSet resultSet = StuDao.login(sql, objects);
            String sno = null;
            try {
                if (resultSet.next()){
                    flag = true;
                    sno = resultSet.getString("sno");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JdbcUtils.close(resultSet);
            }
            if (flag){
                System.out.println("登录成功!");
                //创建会话，处理请求要用
                HttpSession session = req.getSession();
                session.setAttribute("userName", userName);
                // 创建请求属性对象，处理请求要用
                session.setAttribute("sno", sno);
                System.out.println(sno);

                req.setAttribute("httpUrl","/view/stu/stumainview.jsp");
                req.setAttribute("info", "登录成功!即将跳转至后台首页!");
                req.setAttribute("title","登录成功");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
//                resp.sendRedirect(req.getContextPath() + "/view/stu/stumainview.jsp");
            }else {
                System.out.println("用户名或密码错误!请重新登录!");
                //返回登录成功的信息
                req.setAttribute("httpUrl","/view/login/login.jsp");
                req.setAttribute("info", "登录失败!用户名或密码错误!即将跳转至登录页面!");
                req.setAttribute("title","登录失败");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
            }
        }else
            if (identity.equals("教师")){//教师身份
            boolean flag = false;
            String sql = "select * from teacher where tname = ? and tpsw = ?";
            Object[] objects = {userName, psw};
            ResultSet resultSet = TeaDao.login(sql, objects);
            String tno = null;
            try {
                if (resultSet.next()){
                    flag = true;
                    tno = resultSet.getString("tno");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JdbcUtils.close(resultSet);

        if (identity.equals("学生")){//学生身份
            boolean flag = false;
            String sql = "select * from student where sname = ? and spsw = ?";
            Object[] objects = {userName, psw};
                ResultSet resultSet = StuDao.login(sql, objects);
            String sno = null;
            try {
                if (resultSet.next()){
                    flag = true;
                    sno = resultSet.getString("sno");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JdbcUtils.close(resultSet);
            }
            if (flag){
                System.out.println("登录成功!");
                //创建会话，处理请求要用
                HttpSession session = req.getSession();
                session.setAttribute("userName", userName);
                // 创建请求属性对象，处理请求要用
                session.setAttribute("sno", sno);
                System.out.println(sno);

                req.setAttribute("httpUrl","/view/stu/stumainview.jsp");
                req.setAttribute("info", "登录成功!即将跳转至后台首页!");
                req.setAttribute("title","登录成功");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
//                resp.sendRedirect(req.getContextPath() + "/view/stu/stumainview.jsp");
            }else {
                System.out.println("用户名或密码错误!请重新登录!");
                //返回登录成功的信息
                req.setAttribute("httpUrl","/view/login/login.jsp");
                req.setAttribute("info", "登录失败!用户名或密码错误!即将跳转至登录页面!");
                req.setAttribute("title","登录失败");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
            }
        }else
            if (identity.equals("教师")){//教师身份
            boolean flag = false;
            String sql = "select * from teacher where tname = ? and tpsw = ?";
            Object[] objects = {userName, psw};
            ResultSet resultSet = TeaDao.login(sql, objects);
            String tno = null;
            try {
                if (resultSet.next()){
                    flag = true;
                    tno = resultSet.getString("tno");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JdbcUtils.close(resultSet);

            String dept = depts[i];
            webTea.setTdept(dept);
            sql = "select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tdept= ? and tp.tishot = ?";
            Object[] obj2 = {dept, "是"};
            int tbTeaHotNum = FrontWebDao.findTotalCount(sql, obj2);
            webTea.setTishotNum(tbTeaHotNum);
            sql = "select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tdept= ? and tp.tiscough = ?";
            int tbTeaCoughNum = FrontWebDao.findTotalCount(sql, obj2);
            webTea.setTiscoughNum(tbTeaCoughNum);
            sql = "select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tdept= ? and tp.tisseem = ?";
            int tbTeaSeemNum = FrontWebDao.findTotalCount(sql, obj2);
            webTea.setTisseemNum(tbTeaSeemNum);
            sql = "select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tdept= ? and tp.tisdiagnose = ?";
            int tbTeaDiagNum = FrontWebDao.findTotalCount(sql, obj2);
            webTea.setTisdiagnoseNum(tbTeaDiagNum);
            sql = "select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tdept= ? and tp.tstatus = ?";
            Object[] obj3 = {dept, "异常"};
            int tbTeaStatusNum = FrontWebDao.findTotalCount(sql, obj3);
            webTea.setTstatusNum(tbTeaStatusNum);
            webTeaArrayList.add(webTea);
        }
        System.out.println(webTeaArrayList);
        req.setAttribute("webTeaArrayList", webTeaArrayList);

        //实时播报
        sql = "select * from news order by nid desc limit 7";
        Object[] objects2 = {};
        ArrayList<News> newsArrayList = new ArrayList<News>();

        ResultSet resultSet = FrontWebDao.qureyInfo(sql, objects2);
        try {
            while (resultSet.next()){
                News news = new News();
                news.setTitle(resultSet.getString("title"));
                news.setUrl(resultSet.getString("url"));
                news.setPubdate(resultSet.getDate("pubdate"));
                newsArrayList.add(news);
                System.out.println(news);
            }
        } catch (Exception e) {

        System.out.println(totalCount);
        pageBean.setTotalCount(totalCount);

        if (totalCount > 0){
            //计算总页码，并设置
            int totalPage = (totalCount % rows1) == 0 ? totalCount/rows1 : (totalCount/rows1 + 1);
            pageBean.setTotalPage(totalPage);

            //如果当前页数大于总页数
            if (currentPage1 > pageBean.getTotalPage()){
                currentPage1 = pageBean.getTotalPage();
                //重新设置当前页码
                pageBean.setCurrentPage(currentPage1);
            }

            //计算开始的记录和list对象集合，并设置
            int start = (currentPage1 - 1) * rows1;
            sql = "select * from teacher where tno like ? and tname like ? and tdept like ? limit ?, ?";
            Object[] objects1 = {tno1, tname1, tdept1, start, rows1};

            ResultSet resultSet = StuDao.QureyInfoByPage(sql, objects1);
            ArrayList teaArrayList = new ArrayList();

            try {
                while (resultSet.next()){
                    Teacher teacher = new Teacher();
                    teacher.setTno(resultSet.getString("tno"));
                    teacher.setTname(resultSet.getString("tname"));
                    teacher.setTsex(resultSet.getString("tsex"));
                    teacher.setTage(resultSet.getInt("tage"));
                    teacher.setTdept(resultSet.getString("tdept"));
                    teacher.setTphone(resultSet.getString("tphone"));
                    teacher.setTpsw(resultSet.getString("tpsw"));
                    teaArrayList.add(teacher);
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JDBCUtils.close(resultSet);
            }
            pageBean.setArrayList(teaArrayList);

            System.out.println(teaArrayList);
            System.out.println(pageBean);

            req.setAttribute("pageBean", pageBean);

            req.getRequestDispatcher("/view/schoadmin/teainfolist.jsp").forward(req, resp);
        }else {

        if (currentPage == null || "".equals(currentPage)){
            currentPage = "1";
        }

        //如果没有设置rows的请求参数，此处自动设置
        if (rows == null || "".equals(rows)){
            rows = "7";
        }

        //获取条件查询的参数
        int currentPage1 = Integer.parseInt(currentPage);
        int rows1 = Integer.parseInt(rows);

        //如果当前页数小于1，则设置当前页数为1
        if (currentPage1 <= 0){
            currentPage1 = 1;
        }

        //设置StuPunch类的对象类型
        PageBean<StuPunch> pageBean = new PageBean<StuPunch>();

        //设置当前页码
        pageBean.setCurrentPage(currentPage1);

        //设置每页的记录数
        pageBean.setRows(rows1);

        sql = " select count(*) as num from student s, stupunchin sp where s.sno = sp.sno and s.sname like ? and s.sclass like ? and sp.spunchdate like ? and s.sdept = ?";
        Object[] objects = {sname1, sclass1, spunchdate1,belong};

        //计算总记录数，并设置
        int totalCount = DeptAdminDao.findTotalCount(sql, objects);
        System.out.println(totalCount);
        pageBean.setTotalCount(totalCount);

        if (totalCount > 0){
            //计算总页码，并设置
            int totalPage = (totalCount % rows1) == 0 ? totalCount/rows1 : (totalCount/rows1 + 1);
            pageBean.setTotalPage(totalPage);

            //如果当前页数大于总页数
            if (currentPage1 > pageBean.getTotalPage()){
                currentPage1 = pageBean.getTotalPage();
                //重新设置当前页码
                pageBean.setCurrentPage(currentPage1);
            }

        //如果传入的参数为null，则置为空字符串
        if (sname == null){
            sname = "";
        }
        if (sclass == null){
            sclass = "";
        }
        if (sdept == null){
            sdept = "";
        }

        //变为like查询所需的字符串参数
        String sname1 = "%" + sname + "%";
        String sclass1 = "%" + sclass + "%";
        String sdept1 = "%" + sdept + "%";

        //设置请求的属性参数，后面需要用
        req.setAttribute("sname",sname);
        req.setAttribute("sclass", sclass);
        req.setAttribute("sdept",sdept);

        System.out.println(sname1);
        System.out.println(sclass1);
        System.out.println(sdept1);

        //获取登录时的session会话对象
        HttpSession session = req.getSession();
//        String userName = (String) session.getAttribute("userName");
//        String sno = (String) session.getAttribute("sno");
        String belong = (String) session.getAttribute("belong");

        String sql = null;

//        System.out.println(userName);
//        System.out.println(sno);
        System.out.println(belong);
        System.out.println("hdghghjg");

        String currentPage = req.getParameter("currentPage");//从请求对象中获取当前页码
        String rows = req.getParameter("rows");//从请求获取对象中每页显示的行数

        //如果未设请求参数，此处自动设置参数为第一页
        if (currentPage == null || "".equals(currentPage)){
            currentPage = "1";

        HashMap<String, Object> hashMap = new HashMap<String, Object>();

        HttpSession session = req.getSession();

        String str = "是";
        Object[] objects = {str};
        //计算学生已经打卡
        sql = "select count(*) as num from stupunchin where sispunch = ?";
        int stuPunNum = FrontWebDao.findTotalCount(sql, objects);
        System.out.println(stuPunNum);
        //计算教师已经打卡
        sql = "select count(*) as num from teapunchin where tispunch = ?";
        int teaPunNum = FrontWebDao.findTotalCount(sql, objects);
        System.out.println(teaPunNum);
        //总打卡数
        int allPunNum = teaPunNum + stuPunNum;
        System.out.println(allPunNum);
        //设置请求的变量属性
        req.setAttribute("allPunNum", allPunNum);

        //计算学生发烧
        sql = "select count(*) as num from stupunchin where sishot = ?";
        int stuHotNum = FrontWebDao.findTotalCount(sql, objects);
        System.out.println(stuHotNum);
        //计算教师发烧
        sql = "select count(*) as num from teapunchin where tishot = ?";
        int teaHotNum = FrontWebDao.findTotalCount(sql, objects);
        System.out.println(teaHotNum);
        //总发烧
        int allHotNum = teaHotNum + stuHotNum;
        System.out.println(allHotNum);
        hashMap.put("发烧", allHotNum);
        //设置请求的变量属性
        req.setAttribute("allHotNum", allHotNum);

        //计算学生咳嗽
        sql = "select count(*) as num from stupunchin where siscough = ?";
        int stuCoughNum = FrontWebDao.findTotalCount(sql, objects);
        System.out.println(stuCoughNum);
        //计算教师咳嗽
        sql = "select count(*) as num from teapunchin where tiscough = ?";

        if (identity.equals("学生")){//学生身份
            boolean flag = false;
            String sql = "select * from student where sname = ? and spsw = ?";
            Object[] objects = {userName, psw};
                ResultSet resultSet = StuDao.login(sql, objects);
            String sno = null;
            try {
                if (resultSet.next()){
                    flag = true;
                    sno = resultSet.getString("sno");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }finally {
                JdbcUtils.close(resultSet);
            }
            if (flag){
                System.out.println("登录成功!");
                //创建会话，处理请求要用
                HttpSession session = req.getSession();
                session.setAttribute("userName", userName);
                // 创建请求属性对象，处理请求要用
                session.setAttribute("sno", sno);
                System.out.println(sno);

                req.setAttribute("httpUrl","/view/stu/stumainview.jsp");
                req.setAttribute("info", "登录成功!即将跳转至后台首页!");
                req.setAttribute("title","登录成功");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
//                resp.sendRedirect(req.getContextPath() + "/view/stu/stumainview.jsp");
            }else {
                System.out.println("用户名或密码错误!请重新登录!");
                //返回登录成功的信息
                req.setAttribute("httpUrl","/view/login/login.jsp");
                req.setAttribute("info", "登录失败!用户名或密码错误!即将跳转至登录页面!");
                req.setAttribute("title","登录失败");
                req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
            }
        }else
            if (identity.equals("教师")){//教师身份
            boolean flag = false;
            String sql = "select * from teacher where tname = ? and tpsw = ?";

        }

        //如果没有设置rows的请求参数，此处自动设置
        if (rows == null || "".equals(rows)){
            rows = "7";
        }

        //获取条件查询的参数
        int currentPage1 = Integer.parseInt(currentPage);
        int rows1 = Integer.parseInt(rows);

        //如果当前页数小于1，则设置当前页数为1
        if (currentPage1 <= 0){
            currentPage1 = 1;
        }

        //设置StuPunch类的对象类型
        PageBean<TeaPunch> pageBean = new PageBean<TeaPunch>();

        //设置当前页码
        pageBean.setCurrentPage(currentPage1);

        //设置每页的记录数
        pageBean.setRows(rows1);

        sql = " select count(*) as num from teacher t, teapunchin tp where t.tno = tp.tno and t.tno like ? and t.tname like ? and t.tdept like ? and tp.tpunchdate like ?";
        Object[] objects = {tno1, tname1, tdept1, tpunchdate1};

        //计算总记录数，并设置
        int totalCount = DeptAdminDao.findTotalCount(sql, objects);
        System.out.println(totalCount);
        pageBean.setTotalCount(totalCount);

        if (totalCount > 0){
            //计算总页码，并设置
            int totalPage = (totalCount % rows1) == 0 ? totalCount/rows1 : (totalCount/rows1 + 1);
            pageBean.setTotalPage(totalPage);

            //如果当前页数大于总页数
            if (currentPage1 > pageBean.getTotalPage()){
                currentPage1 = pageBean.getTotalPage();

                ResultSet resultSet = SchoAdminDao.login(sql, objects);
//                String belong = null;
                try {
                    if (resultSet.next()){
                        flag = true;
//                        belong = resultSet.getString("belong");
                    }
                } catch (Exception e) {
                    e.printStackTrace();
                }finally {
                    JdbcUtils.close(resultSet);
                }

                if (flag){

                    if (identity.equals("学校")){//学校管理员
                        System.out.println("登录成功!");
                        HttpSession session = req.getSession();
                        // 创建会话属性对象，处理请求要用
                        session.setAttribute("belong", identity);
                        System.out.println(identity);
//                        session.setAttribute("belong", belong);
//                        System.out.println(belong);

                        req.setAttribute("httpUrl","/view/schoadmin/schomainview.jsp");
                        req.setAttribute("info", "登录成功!即将跳转至后台首页!");
                        req.setAttribute("title","登录成功");
                        req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
                    }else {//二级学院管理员
                        System.out.println("登录成功!");
                        //创建会话，处理请求要用
                        HttpSession session = req.getSession();
                        // 创建请求属性对象，处理请求要用
                        session.setAttribute("belong", identity);
                        System.out.println(identity);

                        req.setAttribute("httpUrl","/view/deptadmin/deptmainview.jsp");
                        req.setAttribute("info", "登录成功!即将跳转至后台首页!");
                        req.setAttribute("title","登录成功");
                        req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
//                resp.sendRedirect(req.getContextPath() + "/view/guide/mainview_guide.jsp");
                    }

                }else {
                    System.out.println("用户名或密码错误!请重新登录!");
                    //返回登录成功的信息
                    req.setAttribute("httpUrl","/view/login/login.jsp");
                    req.setAttribute("info", "登录失败!用户名或密码错误!即将跳转至登录页面!");
                    req.setAttribute("title","登录失败");
                    req.getRequestDispatcher("/view/alluse/info.jsp").forward(req, resp);
                }
        }

                e.printStackTrace();
            }finally {
                JDBCUtils.close(resultSet);
            }
            pageBean.setArrayList(stuPunchArrayList);

            System.out.println(stuPunchArrayList);
            System.out.println(pageBean);

            req.setAttribute("pageBean", pageBean);

            req.getRequestDispatcher("/view/deptadmin/stupunchlist.jsp").forward(req, resp);
        }else {
            req.getRequestDispatcher("/view/alluse/nodata.jsp").forward(req, resp);
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

@WebServlet("/DeptQueryStuByPageServlet")
public class DeptQueryStuByPageServlet extends HttpServlet {

    @Override

        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取查找的参数
        String tpunchdate = req.getParameter("tpunchdate");

        if (tpunchdate == null){
            tpunchdate = "";
        }

        String tpunchdate1 = "%" + tpunchdate + "%";
        System.out.println(tpunchdate1);

        req.setAttribute("tpunchdate", tpunchdate);

        //获取登录时的session会话对象
        HttpSession session = req.getSession();
        String userName = (String) session.getAttribute("userName");
        String tno = (String) session.getAttribute("tno");

        String sql = null;

        System.out.println(userName);
        System.out.println(tno);
        System.out.println("hdghghjg");

        String currentPage = req.getParameter("currentPage");//从请求对象中获取当前页码
        String rows = req.getParameter("rows");//从请求获取对象中每页显示的行数

        //如果未设请求参数，此处自动设置参数为第一页
        if (currentPage == null || "".equals(currentPage)){
            currentPage = "1";
        }

        //如果没有设置rows的请求参数，此处自动设置
        if (rows == null || "".equals(rows)){
            rows = "8";
        }

        //获取条件查询的参数
        int currentPage1 = Integer.parseInt(currentPage);
        int rows1 = Integer.parseInt(rows);

        //如果当前页数小于1，则设置当前页数为1
        if (currentPage1 <= 0){
            currentPage1 = 1;
        }

        //设置StuPunch类的对象类型
        PageBean<StuPunch> pageBean = new PageBean<StuPunch>();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String sname = req.getParameter("sname");
        String sclass = req.getParameter("sclass");
        String sdept = req.getParameter("sdept");

        //如果传入的参数为null，则置为空字符串
        if (sname == null){
            sname = "";
        }
        if (sclass == null){
            sclass = "";
        }
        if (sdept == null){
            sdept = "";
        }

        //变为like查询所需的字符串参数
        String sname1 = "%" + sname + "%";
        String sclass1 = "%" + sclass + "%";
        String sdept1 = "%" + sdept + "%";

        //设置请求的属性参数，后面需要用
        req.setAttribute("sname",sname);
        req.setAttribute("sclass", sclass);
        req.setAttribute("sdept",sdept);

        System.out.println(sname1);
        System.out.println(sclass1);
        System.out.println(sdept1);

        //获取登录时的session会话对象
        HttpSession session = req.getSession();
//        String userName = (String) session.getAttribute("userName");

            System.out.println(num);

        }else {//已打卡
        }
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

@WebServlet("/DeptQueryTeaPunchByIdServlet")
public class DeptQueryTeaPunchByIdServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String tno = req.getParameter("tno");
        String tpunchdate = req.getParameter("tpunchdate");

        String sql = null;
        Object[] objects = {tno, tpunchdate};

@WebServlet("/DeptQueryStuPunchByPageServlet")
public class DeptQueryStuPunchByPageServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String sname = req.getParameter("sname");
        String sclass = req.getParameter("sclass");
        String spunchdate = req.getParameter("spunchdate");

        System.out.println(sname);
        System.out.println(sclass);
        System.out.println(spunchdate);

        //如果传入的参数为null，则置为空字符串
        if (sname == null){
            sname = "";
        }
        if (sclass == null){
            sclass = "";
        }
        if (spunchdate == null){
            spunchdate = "";
        }

        //变为like查询所需的字符串参数
        String sname1 = "%" + sname + "%";
        String sclass1 = "%" + sclass + "%";
        String spunchdate1 = "%" + spunchdate + "%";

@WebServlet("/SchoQueryTeaPunchByPageServlet")
public class SchoQueryTeaPunchByPageServlet extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        resp.setCharacterEncoding("utf-8");
        resp.setContentType("text/html;charset=utf-8");

        //获取请求参数
        String tno = req.getParameter("tno");
        String tname = req.getParameter("tname");
        String tdept = req.getParameter("tdept");
        String tpunchdate = req.getParameter("tpunchdate");

        System.out.println(tno);
        System.out.println(tname);
        System.out.println(tdept);
        System.out.println(tpunchdate);

        //如果传入的参数为null，则置为空字符串
        if (tno == null){
            tno = "";
        }
        if (tname == null){
            tname = "";
        }
        if (tdept == null){
            tdept = "";
        }
        if (tpunchdate == null){
            tpunchdate = "";
        }

        //变为like查询所需的字符串参数
        String tno1 = "%" + tno + "%";
        String tname1 = "%" + tname + "%";
        String tdept1 = "%" + tdept + "%";
        String tpunchdate1 = "%" + tpunchdate + "%";

        //设置请求的属性参数，后面需要用