IDEA+Java+Servlet+JSP+Mysql实现学生信息管理系统

后端使用Java+Servlet进行开发，前端为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_servlet_studentinfo

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 16/07/2021 21:24:47

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for account

---

DROP TABLE IF EXISTS account;

CREATE TABLE account (

username varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

password varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,

nickname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

---

– Records of account

---

INSERT INTO account VALUES (‘admin’, ‘admin’, ‘管理员’);

---

– Table structure for stuinfo

---

DROP TABLE IF EXISTS stuinfo;

CREATE TABLE stuinfo (

Id varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

Name varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

Age int(5) NOT NULL,

Dep varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

Sex varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

Phone varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

Email varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

PRIMARY KEY (Id) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of stuinfo

---

INSERT INTO stuinfo VALUES (‘105001’, ‘黄晋江’, 35, ‘数计院’, ‘男’, ‘18050193364’, ‘48577342@qq.com’);

INSERT INTO stuinfo VALUES (‘105002’, ‘叶小白’, 21, ‘数计院’, ‘男’, ‘18056789321’, ‘4793247@qq.com’);

INSERT INTO stuinfo VALUES (‘105003’, ‘林幼玲’, 19, ‘医学院’, ‘女’, ‘15745492821’, ‘4488742@qq.com’);

INSERT INTO stuinfo VALUES (‘105004’, ‘白凌琳’, 20, ‘文学院’, ‘女’, ‘180437289678’, ‘75834538@qq.com’);

INSER