【大二学习笔记之java Web】基于 servlet 开发的学生管理系统

最新推荐文章于 2021-12-29 22:57:00 发布

Zhang_Dream

最新推荐文章于 2021-12-29 22:57:00 发布

阅读量958

点赞数 1

分类专栏：学习笔记 java 文章标签： web 数据库

本文链接：https://blog.csdn.net/qq_45621392/article/details/110284701

版权

学习笔记同时被 2 个专栏收录

21 篇文章 1 订阅

订阅专栏

java

13 篇文章 0 订阅

订阅专栏

此次项目做得不是很完整，在大二上学期边学习java边了解java web知识，最终在2020.4.6-2020.6.30完成基于servlet学生管理系统，在此期间遇见很多困难，但自己也没有因此退缩而是百度和参考别人博客以及在老师的帮助下完成的，目前是2020.11.25日大三快接近实习了，写一写博客温故而知新
基于经典mvc开发的，代码中有很多大白话注释，不喜勿喷

也行这个系统还存在一些bug,我就暂时不修改了，最近忙着学习新的知识如：springboot、spring 、mybatis、springmvc、shrio、RabbitMQ（消息队列），和找工作

项目结构

在这里插入图片描述

运行截图

在这里插入图片描述

登录页

在这里插入图片描述

注册页

在这里插入图片描述

管理员登录成功

在这里插入图片描述

学生登录成功

在这里插入图片描述

添加信息、删除等等

在这里插入图片描述

项目目的：

灵活应用所学Java基础知识，加粗样式独立完成需求分析、系统设计和编码等系统设计全过程的综合实践能力。巩固、深化学生的理论知识，提高实践工程应用水平，并在此过程中培养了严谨的科学态度和良好的工作作风。

项目描述：

学生可以查看自己的信息，管理员可以修改学生信息以及注册自己的信息、
前 HTMl+css+javascipt,框架是 Bootstrap4.0,Jquery3.2 表单验证，异步请求、
数据库 Mysql 以及 Druid 连接池、服务器使用 Tomact8.5,开发工具 Idea2018、
结构上分为表现层、业务层和数据访问层，层次间的依赖关系自下到上
责任描述：从前端美工到后台都在老师的帮助下努力完成
项目总结：从项目中学会用 bootstrap 框架对前端页面进行快速搭建，熟悉了 mvc 开发流程，掌握了 JAVAEE 模式开发

运行环境：

**

jdk8以上+tomcat8以上+mysql5.6+IDEA2018

需要下载jar包如下

在这里插入图片描述

数据库连接

package cn.itzxj.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

/**
 * Jdbc工具类 使用Durid连接池
 */
public class JDBCUtils {
    /**声明  DataSource可以看作数据源，它封装了数据库参数，
     连接数据库，程序中操作DataSource对象即可对数据库进行增删改查操作
     */
    private  static DataSource ds;
    //加载Durid文件
    static{

        try {
            //1.加载配置文件
            Properties pro = new Properties();
            //使用ClassLoader加载配置文件，获取字节输入流
            InputStream is = JDBCUtils.class.getClassLoader().getResourceAsStream("druid.properties");
            pro.load(is);
            //初始化连接池对象
           ds = DruidDataSourceFactory.createDataSource(pro);

        } catch (IOException e) {
            e.printStackTrace();
        }   catch (Exception e) {
            e.printStackTrace();
        }
    }
    /**
     * 获取连接池对象
     */
    public static DataSource getDataSource(){
        return ds;
    }
    /**
     * 获取连接Connection对象
     */
    public static Connection getConnnection() throws SQLException {
        //有异常需要抛出
        return  ds.getConnection();
    }
}

druid.properties配置

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///day17login
username=root
password=1234
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大等待时间
maxWait=3000

dao层

接口UserDao.java

package cn.itzxj.dao;


import cn.itzxj.domain.Tescher;
import cn.itzxj.domain.User;

import java.util.List;
import java.util.Map;

/**
 * 用户操作的Dao
 */
public interface UserDao {
    /**
     * 列表查询
     * @return
     */
    public List<User> findAll();

    /**
     * 通过用学号和密码查找用户
     * @param sno
     * @param password
     * @return
     */
    public  User findUserBySnoAndPassword(String sno, String password);

    /**
     * 添加联系人
     * @param user
     */
   public void add(User user);

    /**
     * 根据id删除联系人
     * @param id
     */

  public   void delete(int id);

    /***
     * 根据id查询信息
     * @return
     * @param id
     */

   public  User findById(int id);

    /**
     * 根据id修改信息
     * @param user
     */

    void update(User user);

    /*
    *//**
     * 查询总记录数
     * @return
     *//*
    int findTotalCount();

    *//**
     * 分页查询每页记录条数
     * @param start
     * @param rows
     * @return
     *//*

    List<User> findByPage(int start, int rows);*/

    /**
     * 按条件查询总记录数
     * @param condition
     * @return
     */

    int findTotalCount(Map<String, String[]> condition);

    /**
     * 按条件分页查询每页及记录条数
     * @param start
     * @param rows
     * @param condition
     * @return
     */

    List<User> findByPage(int start, int rows, Map<String, String[]> condition);

    /**
     * 学生登录方法
     * @param loginuser
     * @return
     */
    User login(User loginuser);

    /**
     * 老师登录方法
     * @param techerlogin
     * @return
     */
    Tescher loginTea(Tescher techerlogin);

    /**
     * 管理员注册
     * @param teacher
     * @return
     */

    int addteacher(Tescher teacher);

    /**
     * 根据id显示信息
     * @param id
     */

    User finstu(String sno);
}

实现类：userdaoimpl.java

package cn.itzxj.dao.impl;

import cn.itzxj.dao.UserDao;
import cn.itzxj.domain.Tescher;
import cn.itzxj.domain.User;
import cn.itzxj.util.JDBCUtils;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;
import java.util.Set;

public class UserDaoImpl implements UserDao {
    /***
     * JdbcTemplate是Spring JDBC的核心类，封装了常见的JDBC的用法，
     * JdbcTemplate可以执行查询、更新等操作、初始化对ResultSets的遍历
     * 操作以及捕获JDBC异常并将其转换成在org.springframework.dao包下定义的更常规更有用的异常类。
     * 通过实现回调接口，可以自定义这些回调函数的具体操作。其中，PreparedStatementSetter和RowMapper是两个最常用的回调接口。
     */
    private JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());

    /**
     * 查询所有用户
     *
     * @return
     */
    @Override
    public List<User> findAll() {

        //使用jdbc操作数据库
        //1.定义sql
        String sql = "select * from user";
        List<User> users = template.query(sql, new BeanPropertyRowMapper<User>(User.class));
        return users;
    }

    /**
     * 登录方法
     *
     * @param sno      学号
     * @param password 密码
     * @return
     */
    @Override
    public User findUserBySnoAndPassword(String sno, String password) {
        //1.定义mysql
        try {
            String sql = "select * from user where sno = ? and password = ?";

            System.out.println("sno" + sno + "======  pass" + password);

            User user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), sno, password);

            System.out.println(user.toString());
            return user;
        } catch (DataAccessException e) {
            e.printStackTrace();
            //失败返回null
            return null;
        }
    }


    @Override
    public void add(User user) {
        try {
            //1.定义sql
            String sql = "insert into user values(null ,?,?,?,?,?,?,?,?,?,?,?)";
            System.out.println("对象：" + user);
            System.out.println("编号1-----------" + user.getId());
            //2.执行sql
            template.update(sql, user.getName(), user.getGender(), user.getAge(),
                    user.getAddress(), user.getDepart(), user.getClazz()
                    , user.getMajor(), user.getQq(), user.getEmail(),
                    user.getSno(), user.getPassword());
        } catch (DataAccessException e) {
            e.printStackTrace();
        }
    }

    /**
     * 根据id删除信息user
     *
     * @param id
     */
    @Override
    public void delete(int id) {
        //定义sql
        String sql = "delete from user where id = ?";
        //2.执行sql
        template.update(sql, id);
    }

    /**
     * 根据id查询信息
     *
     * @param id
     * @return
     */
    @Override
    public User findById(int id) {
        //定义sql
        String sql = "select * from user where id = ?";
        return template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), id);
    }

    /**
     * 根据id修改信息
     *
     * @param user
     */
    @Override
    public void update(User user) {
        try {
            //1.定义sql
            String sql = "update user set name = ?,gender = ?,age = ?,address = ?,depart = ?,clazz = ?,major = ? ,qq = ? ,email = ? ,sno = ?,password = ? where id = ?";
            System.out.println("对象" + user);
            template.update(sql, user.getName(), user.getGender(), user.getAge(),
                    user.getAddress(), user.getDepart(), user.getClazz()
                    , user.getMajor(), user.getQq(), user.getEmail(),
                    user.getSno(), user.getPassword(), user.getId());
            System.out.println("add" + user.getAddress());
        } catch (DataAccessException e) {
            e.printStackTrace();
        }
    }



    /*  *//**
     * 查询总记录数
     * @return
     *//*
    @Override
    public int findTotalCount() {
        //1.定义sql
        String sql = "select count(*) from user";
        return template.queryForObject(sql,Integer.class);
    }

    *//**
     * 分页查询总记录数
     * @param start
     * @param rows
     * @return
     *//*
    @Override
    public List<User> findByPage(int start, int rows) {
        //1.定义sql
        String sql = "select * from user limit ? , ?";
        return template.query(sql,new BeanPropertyRowMapper<User>(User.class),start,rows);
    }*/

    /**
     * 按条件查询总记录数
     *
     * @param condition
     * @return
     */
    @Override
    public int findTotalCount(Map<String, String[]> condition) {
        //动态sql的编写
        //1.定义模板初始化sql
        /* 1 = 1:表示恒等式，对sql不影响 为了后面拼接sql做铺垫 */
        String sql = "select count(*) from user  where  1 = 1 ";
        StringBuilder sb = new StringBuilder(sql);
        //2.遍历map
        Set<String> keySet = condition.keySet();
        //定义参数的集合
        List<Object> params = new ArrayList<Object>();

        for (String key : keySet) {
            //排除分页条件查询参数
            if ("currentPage".equals(key) || "rows".equals(key)) {
                continue;
            }
            //获取value
            String value = condition.get(key)[0];
            //判断value是否有值
            if (value != null && !"".equals(value)) {
                //有值
                sb.append(" and " + key + " like ? ");
                params.add("%" + value + "%"); //传入？条件的值
            }
        }
        //赋值
        sql = sb.toString();
        //打印
        System.out.println("sql:" + sql);
        System.out.println("parms:" + params);
        return template.queryForObject(sql, Integer.class, params.toArray());
    }

    /**
     * 按条件分页查询记录条数
     *
     * @param start
     * @param rows
     * @param condition
     * @return
     */
    @Override
    public List<User> findByPage(int start, int rows, Map<String, String[]> condition) {
        //动态sql的编写
        //1.定义模板初始化sql
        //    1 = 1:表示恒等式，对sql不影响 为了后面拼接sql做铺垫
        String sql = "select * from user  where  1 = 1 ";

        StringBuilder sb = new StringBuilder(sql);
        //2.遍历map
        Set<String> keySet = condition.keySet();
        //定义参数的集合
        List<Object> params = new ArrayList<Object>();

        for (String key : keySet) {
            //排除分页条件查询参数
            if ("currentPage".equals(key) || "rows".equals(key)) {
                continue;
            }
            //获取value
            String value = condition.get(key)[0];
            //判断value是否有值
            if (value != null && !"".equals(value)) {
                //有值
                sb.append(" and " + key + " like ? ");
                params.add("%" + value + "%"); //传入？条件的值
            }
        }
        //添加分页查询
        sb.append(" limit ?,? ");
        //添加分页查询参数值
        params.add(start);
        params.add(rows);
        //赋值
        sql = sb.toString();
        //打印两个
        System.out.println("sql:" + sql);
        System.out.println("params:" + params);
        return template.query(sql, new BeanPropertyRowMapper<User>(User.class), params.toArray());
        //1.定义sql
        /*String sql = "select * from user limit ? , ?";
        return template.query(sql,new BeanPropertyRowMapper<User>(User.class),start,rows);*/
    }

    /**
     * 学生登录
     *
     * @param loginuser
     * @return
     */
    @Override
    public User login(User loginuser) {
        User user = null;
        //1.定义mysql
        try {
            String sql = "select * from user where sno = ? and password = ?";

            user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class),
                    loginuser.getSno(),
                    loginuser.getPassword());
            System.out.println(user.toString());
        } catch (DataAccessException e) {
            e.printStackTrace();
        }
        return user;
    }

    /**
     * 老师登录
     *
     * @param teacherlogin
     * @return
     */
    @Override
    public Tescher loginTea(Tescher teacherlogin) {
        Tescher teacher = null;
        try {
            String sql = "select * from teacher where tid = ? and password = ?";
            //2.调用query方法
            teacher = template.queryForObject(sql,
                    new BeanPropertyRowMapper<Tescher>(Tescher.class),
                    teacherlogin.getTid(),
                    teacherlogin.getPassword());
            System.out.println("教师：" + teacher);
        } catch (DataAccessException e) {
            e.printStackTrace();   //记录日志
        }
        return teacher;
    }

    /**
     * 管理员注册
     * @param teacher
     * @return
     */
    @Override
    public int addteacher(Tescher teacher) {
        int update = 0;
        try {
            //1.定义sql
            String sql = "insert into teacher values(?,?,?,?,?)";
            System.out.println("teacher:" + teacher);
            //2.执行sql
            update = template.update(sql, teacher.getTid(), teacher.getTname(),
                    teacher.getTsex(), teacher.getTdepart(), teacher.getPassword());

        } catch (DataAccessException e) {
            e.printStackTrace();
        }
        return update;
    }

    /**
     * 根据id显示自己的信息
     * @param sno
     * @return
     */
    @Override
    public User finstu(String sno) {
        User user = null;
        try {
            //定义sql
            String sql = "select * from user where sno = ?";
             user = template.queryForObject(sql, new BeanPropertyRowMapper<User>(User.class), sno);

        } catch (DataAccessException e) {
            e.printStackTrace();
        }
        return user;
    }
}

domain层

JavaBean

1.PageBean.java

package cn.itzxj.domain;

import java.util.List;

/**
 * 分页对象
 * PageBean<T>：在后面可以实现通用性，到时候直接初始化T就可以了
 * @param <T>
 */
public class PageBean<T> {
    private int totalCount;//总记录数
    private int totalPage; //总页码
    private List<T> list;   //每页的数据
    private  int currentPage;  //当前页码
    private int rows;       //每页显示的条数

    /***
     * 提供公共访问方式
     * @return
     */
    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public List<T> getList() {
        return list;
    }

    public void setList(List<T> list) {
        this.list = list;
    }

    public int getCurrentPage() {
        return currentPage;
    }

    public void setCurrentPage(int currentPage) {
        this.currentPage = currentPage;
    }

    public int getRows() {
        return rows;
    }

    public void setRows(int rows) {
        this.rows = rows;
    }
    /**
     * 重新tostring()
     *
     */
    @Override
    public String toString() {
        return "PageBean{" +
                "总记录数=" + totalCount +
                ", 总页码=" + totalPage +
                ", 每页的数据=" + list +
                ", 当前页码=" + currentPage +
                ", 每页显示的记录数=" + rows +
                '}';
    }
}

2.Tescher.java

package cn.itzxj.domain;

public class Tescher {
    private String tid;
    private String tname;
    private  String tsex;
    private  String tdepart;
    private  String password;

    public Tescher() {
    }

    public Tescher(String tid, String tname, String tsex, String tdepart, String password) {
        this.tid = tid;
        this.tname = tname;
        this.tsex = tsex;
        this.tdepart = tdepart;
        this.password = password;
    }

    public String getTid() {
        return tid;
    }

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

    public String getTname() {
        return tname;
    }

    public void setTname(String tname) {
        this.tname = tname;
    }

    public String getTsex() {
        return tsex;
    }

    public void setTsex(String tsex) {
        this.tsex = tsex;
    }

    public String getTdepart() {
        return tdepart;
    }

    public void setTdepart(String tdepart) {
        this.tdepart = tdepart;
    }

    public String getPassword() {
        return password;
    }

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



    @Override
    public String toString() {
        return "Tescher{" +
                "tid='" + tid + '\'' +
                ", tname='" + tname + '\'' +
                ", tsex='" + tsex + '\'' +
                ", tdepart='" + tdepart + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

3.user.java

package cn.itzxj.domain;

/**
 * 数据库实体类
 *
 */
public class User {
    /**
     * 成员变量
     */
    private int id;
    private String sno;
    private String name;
    private String gender;
    private  int age;
    private  String address;
    private  String depart;
    private  String clazz;
    private  String major;
    private  String qq;
    private  String email;
    private String password;
    public User() {
    }

    public User(int id, String sno,
                String name, String gender, int age, String address,
                String depart, String clazz, String major, String qq, String email,
                String password) {
        this.id = id;
        this.sno = sno;
        this.name = name;
        this.gender = gender;
        this.age = age;
        this.address = address;
        this.depart = depart;
        this.clazz = clazz;
        this.major = major;
        this.qq = qq;
        this.email = email;
        this.password = password;
    }
    /**
     * 提供公共访问方式
     */
    public int getId() {
        return id;
    }

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

    public String getSno() {
        return sno;
    }

    public void setSno(String sno) {
        this.sno = sno;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getDepart() {
        return depart;
    }

    public void setDepart(String depart) {
        this.depart = depart;
    }

    public String getClazz() {
        return clazz;
    }

    public void setClazz(String clazz) {
        this.clazz = clazz;
    }

    public String getMajor() {
        return major;
    }

    public void setMajor(String major) {
        this.major = major;
    }

    public String getQq() {
        return qq;
    }

    public void setQq(String qq) {
        this.qq = qq;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
    /***
     * 重写tostring()方法
     *
     */
    @Override
    public String toString() {
        return "User{" +
                "编号=" + id +
                ", 学号='" + sno + '\'' +
                ", 姓名='" + name + '\'' +
                ", 性别='" + gender + '\'' +
                ", 年龄=" + age +
                ", 地址='" + address + '\'' +
                ", 院系='" + depart + '\'' +
                ", 班级='" + clazz + '\'' +
                ", 专业='" + major + '\'' +
                ", qq='" + qq + '\'' +
                ", 邮箱='" + email + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

service层

接口

package cn.itzxj.service;

import cn.itzxj.domain.PageBean;
import cn.itzxj.domain.Tescher;
import cn.itzxj.domain.User;

import java.util.List;
import java.util.Map;

/**
 * 用户管理的业务接口
 */
public interface UserService {
    /**
     * 查询所有用户信息
     *
     * @return
     */
    public List<User> findAll();
    /**
     * 登录方法
     */
    public User login(User user);

    /**
     * 添加联系人方法
     *
     * @param user
     */
  public   void adduser(User user);

    /**
     * 根据id删除user信息
    * @param id
     */
    public  void deleteUser(String id);

    /**
     * 根据id查询信息
     * @param id
     * @return
     */

   public  User findUserById(String id);

    /**
     * 根据id修改信息
     * @param user
     */

    void updateUser(User user);

    /**
     * 根据id批量删除信息
     * @param uid
     */

    void delSelectedUser(String[] uid);



    /* *//**
     * 分页查询
     * @param currentPage
     * @param rows
     * @return
     *//*

    PageBean<User> findUserByPage(String currentPage, String rows);*/

    /**
     * 按照条件使用分页查询
     * @param currentPage
     * @param rows
     * @param condition
     * @return
     */
    PageBean<User> findUserByPage(String currentPage, String rows, Map<String, String[]> condition);

    /**
     * 管理员注册
     * @param teacher
     * @return
     */

    int addTeacher(Tescher teacher);

    /**
     * 根据id展示自己的信息
     * @param sno
     */

    User findstudent(String sno);
}

接口实现类

package cn.itzxj.service.impl;

import cn.itzxj.dao.UserDao;
import cn.itzxj.dao.impl.UserDaoImpl;
import cn.itzxj.domain.PageBean;
import cn.itzxj.domain.Tescher;
import cn.itzxj.domain.User;
import cn.itzxj.service.UserService;

import java.util.List;
import java.util.Map;

public class UserServiceImpl implements UserService {
    //申明一个实现类
    private UserDao dao = new UserDaoImpl();

    /**
     * 查询所有
     *
     * @return
     */
    @Override
    public List<User> findAll() {
        return dao.findAll();
    }

    /**
     * 登录方法
     *
     * @param user
     * @return
     */
    @Override
    public User login(User user) {
        return dao.findUserBySnoAndPassword(user.getSno(), user.getPassword());
    }

    /**
     * 保存user对象
     *
     * @param user
     */
    @Override
    public void adduser(User user) {
       dao.add(user);
    }

    /**
     *根据id删除不想要的信息
     * @param id
     */
    @Override
    public void deleteUser(String id) {
        //因为传过来的id是String类型的要进行强制转换Integer.parseInt(id)

        dao.delete(Integer.parseInt(id));
    }

    /**
     * 根据id查询信息
     * @param id
     * @return
     */
    @Override
    public User findUserById(String id) {
        //id获取过来是字符串，因为数据库是int所有要进行强制转换
        return  dao.findById(Integer.parseInt(id));
    }

    /**
     * 根据id修改信息
     * @param user
     */
    @Override
    public void updateUser(User user) {
        dao.update(user);
    }

    /**
     * 根据id批量删除信息
     * @param uid
     */
    @Override
    public void delSelectedUser(String[] uid) {
        //判断是为了防止空指针异常
        if(uid!=null&&uid.length>0){
            //遍历id数组
            for (String id : uid) {
                //调用以前的根据id 删除---delete()删除方法
                //获取过来的id是字符串类型，要强制转换int
                dao.delete(Integer.parseInt(id));
            }
        }

    }


   /* @Override
    public PageBean<User> findUserByPage(String _currentPage, String _rows) {
        //获取过来的参数是字符串要强制转换int
            //当前页码
            int currentPage = Integer.parseInt(_currentPage);
            //每页显示的条数
            int rows = Integer.parseInt(_rows);
            //判断一下当用户再第一页时再点击前一页就不能点击了，还是再第一页
           if(currentPage <=0){
               currentPage = 1;
           }

        //1.创建空的PageBean对象
            PageBean<User> pb =  new PageBean<User>();
        //2. 设置参数
            pb.setCurrentPage(currentPage);
            pb.setRows(rows);

         //3.调用dao查询总记录数
            int totalCount = dao.findTotalCount();
            pb.setTotalCount(totalCount);
        //4.调用到查询List集合
            //计算开始的记录索引
            int start = (currentPage-1) * rows;
            List<User> list = dao.findByPage(start,rows);
            pb.setList(list);
        //5.计算总页码数
             int totalPage = (totalCount % rows) == 0 ? totalCount / rows :(totalCount / rows)+1;
             pb.setTotalPage(totalPage);
         //6.直接返回pb 对象
        return pb;
    }*/

    /**
     * 按条件完成分页查询
     * @param _currentPage
     * @param _rows
     * @param condition
     * @return
     */
   @Override
   public PageBean<User> findUserByPage(String _currentPage, String _rows, Map<String, String[]> condition) {
       //获取过来的参数是字符串要强制转换int
       //当前页码
       int currentPage = Integer.parseInt(_currentPage);
       //每页显示的条数
       int rows = Integer.parseInt(_rows);
       //判断一下当用户再第一页时再点击前一页就不能点击了，还是再第一页
       if(currentPage <=0){
           currentPage = 1;
       }

       //1.创建空的PageBean对象
       PageBean<User> pb =  new PageBean<User>();
       //2. 设置参数
       pb.setCurrentPage(currentPage);
       pb.setRows(rows);

       //3.调用dao查询总记录数
       int totalCount = dao.findTotalCount(condition);
       pb.setTotalCount(totalCount);
       //4.调用到查询List集合
       //计算开始的记录索引
       int start = (currentPage-1) * rows;
       List<User> list = dao.findByPage(start,rows,condition);
       pb.setList(list);
       //5.计算总页码数
       int totalPage = (totalCount % rows) == 0 ? totalCount / rows :(totalCount / rows)+1;
       pb.setTotalPage(totalPage);
       //6.直接返回pb 对象
       return pb;
   }

    /**
     * 教师注册
     * @param teacher
     * @return
     */
    @Override
    public int addTeacher(Tescher teacher) {
       return dao.addteacher(teacher);
    }

    /**
     * 根据id展示自己的信息
     * @param sno
     */
    @Override
    public User findstudent(String sno) {
            return  dao.finstu(sno);
    }

}

数据库设计

user表
在这里插入图片描述
techer表

过滤器设置页面统一编码

finanyFilter.java

package cn.itzxj.web.filter;

import javax.servlet.*;
import javax.servlet.annotation.WebFilter;
import java.io.IOException;

/**
 *
 *设置编码格式
 */
@WebFilter(filterName = "finanyFilter",urlPatterns = "/*")
public class finanyFilter implements Filter {
    public void destroy() {
    }

    public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws ServletException, IOException {
        //设置reauest字符编码
        req.setCharacterEncoding("utf-8");
        //设置response字符编码
        resp.setContentType("utf-8");
        chain.doFilter(req, resp);
    }

    public void init(FilterConfig config) throws ServletException {

    }

}

登录页

页面login.jsp

<%--
  Created by IntelliJ IDEA.
  User: 张旭军
  Date: 2020/5/5
  Time: 9:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" errorPage="500.jsp" language="java" %>
<html>
<head>
    <title>用户登录界面</title>
    <link rel="stylesheet" type="text/css" href="css/base.css">
    <link rel="stylesheet" type="text/css" href="css/login.css">
    <script type="text/javascript" src="js/checkcode.js"></script>
    <style>
        .form-group {
            width: 100%;
            height: 205px;
            padding-top: 635px;
            padding-left: 958px;
        }
        .buttons {
            background-color: #88bab9; /* Green */
            text-decoration: none;
            display: inline-block;
            cursor: pointer;
            transition-duration: 0.4s;
        }


        button{
            position: relative;
            height: 44px;
            width: 121px;
            border-radius: 29px;
            background: blue;
            color: #fff;
            font-size: 20px;
            letter-spacing: 2px;
            cursor: pointer
        }

        button:first-child:hover{
            background: linear-gradient(90deg, #03a9f4, #f441a5, #ffeb3b, #03a9f4);
            background-size: 400%;
        }


        button:last-child:hover{
            background: linear-gradient(90deg, #fa7199, #f5ce62, #e43603, #fa7199);
            background-size: 400%;
        }

        button:first-child:before,
        button:last-child:before{
            content: '';
            position: absolute;
            background: inherit;
            top: -5px;
            right:-5px;
            bottom: -5px;
            left: -5px;
            border-radius: 50px;
            filter: blur(20px);
            opacity: 0;
            transition: opacity 0.5s;
        }

        button:first-child:hover:before,
        button:last-child:hover:before{
            opacity: 1;
            z-index: -1;
        }

        button:hover{
            z-index: 1;
            animation: glow 8s linear infinite;
        }

        @keyframes glow {
            0%{
                background-position: 0%;
            }
            100%{
                background-position: 400%;
            }
        }

    </style>
</head>
<body>
<div class="hh">
    <form action="${pageContext.request.contextPath}/loginStudentTeacherServlet" method="post" class="form1">
        <div class="table1">
            <div style="width:500px;height: 30px">
                <div style="float:left;">

                </div>
                <div style="float:right;font-size: 18px">
                    管理员还没有账号<a href="res1.jsp">马上注册</a>
                </div>
            </div>
            <div style="margin-top: 5px ;width: 500px;height: 30px">
                <div style="font-size: 18px ;float: left" >账&nbsp;&nbsp;号：</div>
                <div><input
                        type="text"
                        name="sno"
                        id="userName"
                        value=""
                        style="height: 30px;border-radius: 5px ;float: left"
                        placeholder="请输入账号"
                        onblur="checkreg()"
                /></div>
            </div>
            <div style="margin-top: 10px;width: 500px;height: 30px">
                <div style="font-size: 18px ;float:left;">密&nbsp;&nbsp;码：</div>
                <div><input type="password" name="password"  style="height: 30px;border-radius: 5px;float:left;" id="password" value=""
                            placeholder="请输入账号"
                            onblur="checkreg()" /></div>
            </div>
            <div style="margin-top: 10px;width: 500px;height: 30px">
                <div align="left" style="font-size: 18px ;float: left;">用&nbsp;&nbsp;户：</div>
                <div align="left">
                    <input
                            type="radio"
                            name="lei"
                            value="teacher"
                            style="float:left;"
                            checked="checked"
                    />
                    教师
                    <input type="radio" name="lei" value="student" />
                    学生 </div>
            </div>
            <div style="margin-top: 10px;width: 500px;height: 30px">
                <div  style="font-size: 18px ;float: left">验证码：</div>
                <div><input
                        type="text"
                        name="checkcode"
                        style="height: 30px;border-radius: 5px;float:left;"
                        id=""
                /><img id="checkCode" src="${pageContext.request.contextPath}/checkCodeServlet" />

                    <a id="change" href="">换一张</a></div>
            </div>
            <div style="margin-top: 10px;width: 500px;height: 30px">
                <div   style="font-size: 18px;float: left "><input
                        type="checkbox"
                        name="remember"
                        id="remember"
                        value="on"
                />
                    记住密码 </div>
                <div style="font-size: 18px;float: right;padding-right:184px ">
                    <a href="#"> 忘记密码？</a>
                </div>
            </div>
            <div align="center" style="width: 500px;height: 30px;">
                <div style="color: #c81623">${cc_error}</div>
                <div style="color:#c81623;">${login_error}</div>
            </div>
        </div>
        <div class="form-group">
            <button class="buttons" type="submit">登录</button >
            <button class="buttons" type="reset">取消</button>
        </div>
          </form>
</div>
</body>
</html>

web层（LoginStudentTeacherServlet.java）

package cn.itzxj.web.servlert;
import cn.itzxj.dao.UserDao;
import cn.itzxj.dao.impl.UserDaoImpl;
import cn.itzxj.domain.Tescher;
import cn.itzxj.domain.User;

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 javax.servlet.http.HttpSession;
import java.io.IOException;

/**
 * 老师和学生登录逻辑
 */
@WebServlet("/loginStudentTeacherServlet")
public class LoginStudentTeacherServlet extends HttpServlet {
    Tescher tescher = null;
    User user = null;

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

        //1.设置编码
        request.setCharacterEncoding("utf-8");
        //    response.setContentType("text/html;charset= utf-8");
        //2.用map获取参数
        /**
         * 使用map集合需要导入xommons-beanutils-1.8.0.jar
         */
        String checkcode = request.getParameter("checkcode");
        HttpSession session = request.getSession();
        //获取验证码servlet里面存储的checkCode_session
        String checkcode_server = (String) session.getAttribute("CHECKCODE_SERVER");
        //删除session中存储的验证码
        session.removeAttribute("CHECKCODE_SERVER");//确保验证码一次性

        //判断验证码是否正确
        if (checkcode_server == null || !checkcode_server.equalsIgnoreCase(checkcode)) {
            //验证码不一致
            //存储提示信息到request
            request.setAttribute("cc_error", "验证码错误");
            //转发到登录页面
            request.getRequestDispatcher("/login.jsp").forward(request, response);
            return;
        }
        String sid = request.getParameter("sno");
        String password = request.getParameter("password");
        String lei = request.getParameter("lei");
        System.out.println(lei);

        if (lei.equals("student")) {
            //3.创建user对象
            User loginuser = new User(0,sid,null,null,0,null,null,null,null,null,null,password);
           UserDao dao = new UserDaoImpl();
            user = dao.login(loginuser);
            user(user, request, response, session);
        } else {
            Tescher tescherlogin = new Tescher(sid, null, null, null, password);
            UserDao dao = new UserDaoImpl();
            tescher = dao.loginTea(tescherlogin);

            user(tescher, request, response, session);

        }
    }

    public void user(Object user, HttpServletRequest request, HttpServletResponse response, HttpSession session) throws IOException, ServletException {
        if (user != null) {
            session.setAttribute("tescher", tescher);
            if (user == tescher) {

                //跳转页面
                response.sendRedirect(request.getContextPath() + "/TeacherRoot.jsp");
                System.out.println("teacher:"+tescher);
            } else {
                //跳转页面
               request.getRequestDispatcher("/studentListServlet").forward(request,response);
                System.out.println("student:"+user);
            }
        } else {
            //登录失败
            //提示信息
            request.setAttribute("login_error", "用户名或密码错误！");
            //跳转登录页面
            request.getRequestDispatcher("/login.jsp").forward(request, response);
        }
    }

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

学生信息管理页面

list.jsp

<%@ page contentType="text/html;charset=UTF-8" errorPage="500.jsp" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<!DOCTYPE html>
<!-- 网页使用的语言 -->
<html lang="zh-CN">
<head>
    <!-- 指定字符集 -->
    <meta charset="utf-8">
    <!-- 使用Edge最新的浏览器的渲染方式 -->
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- viewport视口：网页可以根据设置的宽度自动进行适配，在浏览器的内部虚拟一个容器，容器的宽度与设备的宽度相同。
    width: 默认宽度与设备的宽度相同
    initial-scale: 初始的缩放比，为1:1 -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ -->
    <title>用户信息管理系统</title>

    <!-- 1. 导入CSS的全局样式 -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <!-- 2. jQuery导入，建议使用1.9以上的版本 -->
    <script src="js/jquery-2.1.0.min.js"></script>
    <!-- 3. 导入bootstrap的js文件 -->
    <script src="js/bootstrap.min.js"></script>
    <style type="text/css">
        td, th {
            text-align: center;
        }
    </style>
    <script>
       function delateUser(id) {
           if (confirm("您确定要删除吗？")){
               location.href="${pageContext.request.contextPath}/delUserServlet?id="+id;
           }
       }
       function findUser(id) {
           if (confirm("您确定要修改吗？")){
               location.href="${pageContext.request.contextPath}/findUserServlet?id="+id;
           }
       }
    /*   window.onload 表示等页面加载完成再执行*/
       //删除事件
       window.onload=function(){
             //给删除选中添加单击事件
           document.getElementById("delSelected").onclick = function () {

               if(confirm("您确定要删除所选中的信息吗")){
                   //定义一个标记变量
                   var flag = false;
                   //判断是否有选中的信息
                   var cbs = document.getElementsByName("uid");
                   for (var i = 0; i < cbs.length; i++) {
                       if(cbs[i].checked){
                           //表示有一个选着中了
                        flag = true;
                        //然后停止遍历
                        break
                       }
                   }
                   if(flag){   //表示有条目选中了，在提交数据
                       //获取form表单的id然后提交数据
                       //form表单有一个属性sumbit直接提交数据
                       document.getElementById("form").submit();
                   }
               }
       }
           //获取第一个cb,也就是第一个选着框
           document.getElementById("firstCb").onclick=function () {
               //2.获取下边列表中所有的cb
               var cbs=document.getElementsByName("uid");
               //3.遍历
               for (var i = 0; i < cbs.length; i++) {
                   //4.设置这些cbs[i]的checked的状态，也就是看是否选着=firstC的checked
                   cbs[i].checked = this.checked;
               }
           }
       }
    </script>
</head>
<body>
<div class="container">
    <h3 style="text-align: center">用户信息列表</h3>
    <div style="float:left; margin: 3px">
        <form class="form-inline" action="${pageContext.request.contextPath}/findUserByPageServlet" method="post">
            <div class="form-group">
                <label for="exampleInputName2">学号</label>
                <input type="text" class="form-control" name="sno" value="${condition.sno[0]}"  id="exampleInputName2" placeholder="请输入学号">
            </div>
            <div class="form-group">
                <label for="exampleInputName3">姓名</label>
                <input type="text" class="form-control" name="name"  value="${condition.name[0]}" id="exampleInputName3" placeholder="请输入姓名">
            </div>
            <div class="form-group">
                <label for="exampleInputName4">籍贯</label>
                <input type="text" class="form-control"  name="address" value="${condition.address[0]}"  id="exampleInputName4" placeholder="请输入地址">
            </div>
            <div class="form-group">
                <label for="exampleInputEmail2">邮箱</label>
                <input type="text" class="form-control" name="email" value="${condition.email[0]}"  id="exampleInputEmail2" placeholder="输入邮箱@email.com">
            </div>
            <button type="submit" class="btn btn-default">查询</button>
        </form>

    </div>
    <div style="float: right; margin: 5px">
        <a class="btn btn-primary" href="add.jsp">添加联系人</a>
        <%--需要绑定一个单击事件   再加上一个id属性--%>
        <a class="btn btn-primary" href="javascript:void(0);" id="delSelected">删除所选人</a>
    </div>
    <%--  删除所选中id的信息，先用form表单把table嵌套起来，在把id提交过去 再给  <th><input type="checkbox" name="uid" value="${user.id}"></th>
         添加一个name属性name="uid" 和value值 value="${user.id}--%>
    <form  id="form" action="${pageContext.request.contextPath}/delSelectedServlet" method="post">
        <table border="1" class="table table-bordered table-hover">
        <tr class="success">
            <th><input type="checkbox" id="firstCb"></th>
            <th>编号</th>
            <th>学号</th>
            <th>姓名</th>
            <th>性别</th>
            <th>年龄</th>
            <th>籍贯</th>
            <th>院系</th>
            <th>班级</th>
            <th>专业</th>
            <th>QQ</th>
            <th>邮箱</th>
            <th>操作</th>
        </tr>
        <%--使用foreach标签完成遍历--%>
        <c:forEach items="${pb.list}" var="user" varStatus="s">
            <tr>
                <th><input type="checkbox" name="uid" value="${user.id}"></th>
                <td>${s.count}</td>
                <td>${user.sno}</td>
                <td>${user.name}</td>
                <td>${user.gender}</td>
                <td>${user.age}</td>
                <td>${user.address}</td>
                <td>${user.depart}</td>
                <td>${user.clazz}</td>
                <td>${user.major}</td>
                <td>${user.qq}</td>
                <td>${user.email}</td>
                <td><a class="btn btn-default btn-sm" href="javascript:findUser(${user.id})">修改</a>&nbsp;
                    <a class="btn btn-default btn-sm" href="javascript:delateUser(${user.id})">删除</a></td>
            </tr>
        </c:forEach>
    </table>
    </form>
    <div>
        <nav aria-label="Page navigation">
            <ul class="pagination">
               <%--    <c:if test="${pb.currentPage == 1}">那就给li加一个样式disabled,在否则就相反  --%>
                    <c:if test="${pb.currentPage == 1}">
                        <li class="disabled">
                            <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${pb.currentPage - 1}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Previous">
                            <span aria-hidden="true">&laquo;</span>
                            </a>
                        </li>
                    </c:if>
                   <c:if test="${pb.currentPage != 1}">
                       <li>
                           <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${pb.currentPage - 1}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Previous">
                               <span aria-hidden="true">&laquo;</span>
                           </a>
                       </li>
                   </c:if>
                    <c:forEach begin="1" end="${pb.totalPage}" var="i">
                        <%--   <c:if test="${pb.currentPage == i}">:判断一下给当前页加一个css样式   --%>
                        <c:if test="${pb.currentPage == i}">
                            <li class="active">  <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}">${i}</a></li>
                        </c:if>
                        <c:if test="${pb.currentPage != i}">
                            <li >  <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}">${i}</a></li>
                        </c:if>
                    </c:forEach>
               <c:if test="${pb.currentPage >= i}">
                   <li class="disabled">
                           <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${i}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Next">
                               <span aria-hidden="true">&raquo;</span>
                           </a>
                   </li>
               </c:if>
                <c:if test="${pb.currentPage != i}">
                       <li >
                           <a href="${pageContext.request.contextPath}/findUserByPageServlet?currentPage=${pb.currentPage + 1}&rows=5&sno=${condition.sno[0]}&name=${condition.name[0]}&address=${condition.address[0]}&email=${condition.email[0]}" aria-label="Next">
                           <span aria-hidden="true">&raquo;</span>
                           </a>
                       </li>
                </c:if>
                <span style="font-size: 25px; margin-left: 5px">共${pb.totalCount}条记录，共${pb.totalPage}页</span>
            </ul>
        </nav>
    </div>
</body>
</html>

UserListServlet.java

package cn.itzxj.web.servlert;

import cn.itzxj.domain.User;
import cn.itzxj.service.UserService;
import cn.itzxj.service.impl.UserServiceImpl;

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 java.io.IOException;
import java.util.List;

/**
 * 用户列表显示
 */
@WebServlet("/userListServlet")
public class UserListServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       //调用UserService完成查询
        UserService service = new UserServiceImpl();
        List<User> users = service.findAll();
        //将list存入request域中
        request.setAttribute("users",users);
        //3.转发到list.jsp中 并且下面的转发不不需要加上虚拟目录
        request.getRequestDispatcher("/list.jsp").forward(request,response);

    }

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