IDEA+Java+JSP+Mysql+Tomcat实现Web教师信息管理系统_java教室管理系统(2)_教师信息管理系统java

最后

我还为大家准备了一套体系化的架构师学习资料包以及BAT面试资料，供大家参考及学习

已经将知识体系整理好（源码，笔记，PPT，学习视频）

本文已被CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】收录

需要这份系统化的资料的朋友，可以点击这里获取

Java+JSP系统系列实现

Java+Servlet系统系列实现

Java+SSM系统系列实现

Java+SSH系统系列实现

Java+Springboot系统系列实现

2.源码下载

3.运行项目

4.备注

5.支持博主

---

一、系统介绍

1.开发环境

开发工具：IDEA2018

JDK版本：Jdk1.8

Mysql版本：8.0.13

2.技术选型

Java+Jsp+Mysql

3.系统功能

1.管理员登录系统；

2.管理员查询教师信息；

3.管理员新增教师信息；

4.管理员修改教师信息；

5.管理员删除教师信息；

4.数据库文件

/*
 Navicat Premium Data Transfer

 Source Server         : MYSQL
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost:3306
 Source Schema         : jsp_teacher_management

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 14/01/2022 15:36:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('admin', 'admin');

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `salary` double NULL DEFAULT NULL,
  `workTime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1004 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (1001, '王老师', '男', '语文', 30000, '2022-01-01');
INSERT INTO `teacher` VALUES (1002, '张老师', '女', '英语', 30000, '2022-01-01');
INSERT INTO `teacher` VALUES (1003, '黄老师', '男', '数学', 30000, '2022-01-14');
INSERT INTO `teacher` VALUES (1004, '杨老师', '女', '英语', 30000, '2022-01-14');
INSERT INTO `teacher` VALUES (1005, '吴老师', '女', '音乐', 30000, '2022-01-14');

SET FOREIGN_KEY_CHECKS = 1;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58

5.工程截图

二、系统展示

1.登录系统

2.查询教师信息

3.添加教师信息

4.修改教师信息

三、部分代码

AdminDaoImpl

package com.sjsq.dao.impl;

import com.sjsq.dao.AdminDao;
import com.sjsq.utils.DBUtil;
import com.sjsq.vo.Admin;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author: shuijianshiqing
 * @date: 2021-12-31
 * @description: 登录系统实现
 */
public class AdminDaoImpl implements AdminDao {

    /**
     * 登录系统
     * @param admin
     * @return
     */
    @Override
    public Admin login(Admin admin) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            // 1.获取数据库连接
            con = DBUtil.getConnection();
            // 2.写sql
            String sql = "select * from admin where username = ? and password = ?";
            // 3.预编译
            ps = con.prepareStatement(sql);
            // 4.设置值
            ps.setObject(1, admin.getUsername());
            ps.setObject(2, admin.getPassword());
            rs = ps.executeQuery();
            Admin adminLogin = null;
            if (rs.next()) {
                adminLogin = new Admin();
                // 从数据库中获取值到实体类的setter方法中
                adminLogin.setUsername(rs.getString("username"));
                adminLogin.setPassword(rs.getString("password"));

                // 返回的是你查询出来的完整的对象
                return adminLogin;

            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            // 关闭资源，避免出现异常
            DBUtil.close(con, ps, rs);
        }
        return null;
    }

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

TeacherDaoImpl

package com.sjsq.dao.impl;

import com.sjsq.dao.TeacherDao;
import com.sjsq.utils.DBUtil;
import com.sjsq.vo.Teacher;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

/**
 * @author: shuijianshiqing
 * @date: 2021-12-31
 * @description:
 */
public class TeacherDaoImpl implements TeacherDao {

    /**
     * 查询教师信息
     * @param sql
     * @param arr
     * @return
     */
    @Override
    public List<Teacher> selectAll(String sql, Object[] arr) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;

        try {
            // 1.连接数据库
            con = DBUtil.getConnection();
            // 2.预编译
            ps = con.prepareStatement(sql);
            if (arr != null) {
                for (int i = 0; i < arr.length; i++) {
                    // 传入sql的参数,向上转型,某个栏位的查询
                    ps.setObject(i + 1, arr[i]);
                }
            }
            // 3.执行sql
            rs = ps.executeQuery();
            // 4.保存查询出来的数据到list
            List<Teacher> list = new ArrayList<>();
            while (rs.next()) {

                Teacher teacher = new Teacher();

                teacher.setId(rs.getInt("id"));
                teacher.setName(rs.getString("name"));
                teacher.setSex(rs.getString("sex"));
                teacher.setSubject(rs.getString("subject"));
                teacher.setSalary(rs.getDouble("salary"));
                teacher.setWorkTime(rs.getString("workTime"));

                list.add(teacher);
            }
            return list;

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            // 关闭链接，避免数据库连接过多
            DBUtil.close(con, ps, rs);
        }
        return null;
    }

    /**
     * 根据教职工号查询教师信息
     * @param id
     * @return
     */
    @Override
    public Teacher selectTeacher(Integer id) {
        Connection con = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            // 1.连接数据库
            con = DBUtil.getConnection();
            // 2.预编译
            String sql = "select * from Teacher where id = ?";
            ps = con.prepareStatement(sql);
            ps.setInt(1,id);
            // 3.执行sql
            rs = ps.executeQuery();
            while (rs.next()){
                Teacher teacher = new Teacher();

                teacher.setId(rs.getInt("id"));
                teacher.setName(rs.getString("name"));
                teacher.setSex(rs.getString("sex"));
                teacher.setSubject(rs.getString("subject"));
                teacher.setSalary(rs.getDouble("salary"));
                teacher.setWorkTime(rs.getString("workTime"));

                return teacher;
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            // 关闭资源，避免出现异常
            DBUtil.close(con,ps,rs);
        }
        return null;
    }

    /**
     * 新增教师信息
     * @param teacher
     * @return
     */
    @Override
    public boolean addTeacher(Teacher teacher) {
        String sql = "insert into teacher values (?,?,?,?,?,?)";
        List<Object> list = new ArrayList<Object>();

        list.add(teacher.getId());
        list.add(teacher.getName());
        list.add(teacher.getSex());
        list.add(teacher.getSubject());
        list.add(teacher.getSalary());
        list.add(teacher.getWorkTime());

        boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());
        if(flag){
            return true;
        }else {
            return false;
        }
    }

    /**
     * 更新教师信息
     * @param teacher
     * @return
     */
    @Override
    public boolean updateTeacher(Teacher teacher) {
        String sql = "update teacher set name=?,sex=?,subject=?,salary=?,workTime=? where id=?";
        List<Object> list = new ArrayList<Object>();


        list.add(teacher.getName());
        list.add(teacher.getSex());
        list.add(teacher.getSubject());
        list.add(teacher.getSalary());
        list.add(teacher.getWorkTime());
        // 注意id在最后面
        list.add(teacher.getId());

        boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());
        if(flag){
            return true;
        }else {
            return false;
        }
    }


    /**
     * 删除教师信息
     * @param id
     * @return
     */
    @Override
    public boolean deleteTeacher(Integer id) {
        String sql = "delete from teacher where id=?";
        List<Object> list = new ArrayList<Object>();

        list.add(id);

        boolean flag = DBUtil.addUpdateDelete(sql,list.toArray());
        if(flag){
            return true;
        }else {
            return false;
        }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187

main.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8" %>
<%@ page import="com.sjsq.service.TeacherService" %>
<%@ page import="com.sjsq.service.impl.TeacherServiceImpl" %>
<%@ page import="com.sjsq.vo.Teacher" %>
<%@ page import="java.util.List" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>查看教师</title>
    <link rel="stylesheet" type="text/css" href="css/common.css">
    <link rel="stylesheet" type="text/css" href="css/main.css">
    <style type="text/css">


    </style>
</head>
<body>
<%-- 头部 --%>
<jsp:include page="top.jsp"/>
<%
    // 设置获取注册时的编码为UTF-8
    request.setCharacterEncoding("UTF-8");

    TeacherService studentService = new TeacherServiceImpl();
    // 定义一个学生类
    Teacher teacher = new Teacher();

    // 获取上一个页面传过来的值
    if (request.getParameter("id") != null && request.getParameter("id") != "") {
        Integer id = Integer.parseInt(request.getParameter("id"));
        teacher.setId(id);
    }

    // 获取所有教师
    List<Teacher> list = studentService.selectAll(teacher);
%>
<h1>教师列表</h1>
<hr/>
<div id="before">
    <form action="main.jsp" method="post">
        请输入教职工号：<input type="text" name="id" placeholder="输入教职工号搜索">
        <input type="submit" value="查询"/>
    </form>
</div>
<br>
<table align="center" border="1" cellspacing="0">
    <tr bgcolor="#6495ed";>
        <th>教职工号</th>
        <th>教师姓名</th>
        <th>教师性别</th>
        <th>教学科目</th>
        <th>教师工资</th>
        <th>入职时间</th>
        <th colspan="2">操作</th>
    </tr>
    <%
        for (int i = 0; i < list.size(); i++) {
            Teacher t = list.get(i);
    %>
    <tr id="content">
        <td><%=t.getId()%>
        </td>
        <td><%=t.getName()%>
        </td>
        <td><%=t.getSex()%>
        </td>
        <td><%=t.getSubject()%>
        </td>
        <td><%=t.getSalary()%>
        </td>
        <td><%=t.getWorkTime()%>
        </td>
        <td>
            <a href="teacher-update.jsp?id=<%=t.getId()%>">修改</a>
            <a href="teacher-delete.jsp?id=<%=t.getId()%>">删除</a>
        </td>
    </tr>
    <%
        }
    %>
</table>

<br>
<table align="center">
    <tr>
        <td><a href="teacher-add.jsp">新增教师</a></td>
    </tr>
</table>

</body>
<%-- 底部 --%>
<jsp:include page="bottom.jsp"/>
</html>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95

teacher-add.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>新增教师</title>
    <link rel="stylesheet" type="text/css" href="css/common.css">
</head>
<body>
<%-- 头部 --%>
<jsp:include page="top.jsp"/>

<h1>新增教师</h1>
<hr/>

<div id="before">
    <a href="javascript: window.history.go(-1)">返回上一级</a>
</div>
</br>

<form action="teacher-add-do.jsp" method="post" name="addForm">
    <div>
        <tr>
            <label>教职工号：</label>
            <input type="text" name="id" id="id" placeholder="请输入教职工号">
        </tr>
    </div>
    <div>
        <tr>
            <label>教师姓名：</label>
            <input type="text" name="name" id="name" placeholder="请输入教师姓名">
        </tr>
    </div>
    <div>
        <tr>
            <label>教师性别：</label>
            <input type="text" name="sex" id="sex" placeholder="请输入教师性别">
        </tr>
    </div>
    <div>
        <tr>
            <label>教学科目：</label>
            <input type="text" name="subject" id="subject" placeholder="请输入教学科目">
        </tr>
    </div>
    <div>
        <tr>
            <label>教师工资：</label>
            <input type="text" name="salary" id="salary" placeholder="请输入教师工资">
        </tr>

    </div>
    <div>
        <tr>
            <label>工作时间：</label>
            <input type="text" name="workTime" id="workTime" placeholder="请输入工作时间">
        </tr>

    </div>

    <br>
    <div id="submit">


### 最后

**由于篇幅限制，小编在此截出几张知识讲解的图解**

![P8级大佬整理在Github上45K+star手册，吃透消化，面试跳槽不心慌](https://img-blog.csdnimg.cn/img_convert/999661288e9c1184ba59d4e0ab2a053f.webp?x-oss-process=image/format,png)

![P8级大佬整理在Github上45K+star手册，吃透消化，面试跳槽不心慌](https://img-blog.csdnimg.cn/img_convert/26a8bd4fb11a11525a5f5d1e0394678a.webp?x-oss-process=image/format,png)

![P8级大佬整理在Github上45K+star手册，吃透消化，面试跳槽不心慌](https://img-blog.csdnimg.cn/img_convert/447766f196a98e49c141e2edf9ffbf42.webp?x-oss-process=image/format,png)

![P8级大佬整理在Github上45K+star手册，吃透消化，面试跳槽不心慌](https://img-blog.csdnimg.cn/img_convert/d1082af1d7c5e707f9d4844c9d2b6187.webp?x-oss-process=image/format,png)

![P8级大佬整理在Github上45K+star手册，吃透消化，面试跳槽不心慌](https://img-blog.csdnimg.cn/img_convert/bda212afafe74131db318a074682e0b2.webp?x-oss-process=image/format,png)



> **本文已被[CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**

**[需要这份系统化的资料的朋友，可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**

      <label>工作时间：</label>
            <input type="text" name="workTime" id="workTime" placeholder="请输入工作时间">
        </tr>

    </div>

    <br>
    <div id="submit">


### 最后

**由于篇幅限制，小编在此截出几张知识讲解的图解**

[外链图片转存中...(img-PtxrJ5yJ-1715284989320)]

[外链图片转存中...(img-SAoxJRNJ-1715284989320)]

[外链图片转存中...(img-O9wLH4TK-1715284989321)]

[外链图片转存中...(img-pzXXtM71-1715284989321)]

[外链图片转存中...(img-q0lRzOFV-1715284989322)]



> **本文已被[CODING开源项目：【一线大厂Java面试题解析+核心总结学习笔记+最新讲解视频+实战项目源码】](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)收录**

**[需要这份系统化的资料的朋友，可以点击这里获取](https://bbs.csdn.net/forums/4f45ff00ff254613a03fab5e56a57acb)**

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114