计算机javaweb毕设项目基于Jsp+Servlet的户籍管理系统

Love The Way You Lie 2024-02-18 11:39 30阅读 0赞

**项目类型** ：JAVA WEB项目  
**项目名称：** 基于Jsp+Servlet的户籍管理系统

**用户类型** ：2个角色（管理员+用户）  
**系统类型** ：后台管理系统  
**设计模式** ：jsp+Servlet+MVC  
**开发工具** ：Eclipse  
**数据库** ：Mysql+Navicat  
**数据库表** ：5张  
**适用** ：软件工程、计算机科学与技术等JAVA课程的学习和实验

## **管理员端功能介绍** ##

### **登录界面** ###

![aadd824af77d62de00fa857aa554acb7.png][]

### **管理员与子管理员** ###

![717eb48a6aaa86321d5165296d11d379.png][]

### **用户户籍信息管理（增删改查以外，可以讲用户的户籍迁入和迁出）** ###

![88feee5ef8c7adda8527b187e431b4b1.png][]

### **户籍信息修改** ###

![48bfa5ec212562ec0be7486f8ba12068.png][]

### **户籍迁入迁出** ###

![d092fc3c124a6944437ad92dd101c0b4.png][]

### **意见反馈管理** ###

![911289b135ebc242d777169985373b0a.png][]

### **公告管理** ###

![30503f60f6d89146abb7df8d9bea5812.png][]

### **用户端功能介绍** ###

### **用户查看自己的信息** ###

![164ffa772ec900b9b8728440d4c5c3cb.png][]

### **在线反馈，也可以通过反馈信息，来提交自己的户籍迁入迁出申请** ###

![2aa6007a579cd51918b5fe72a458678d.png][]

### **户籍地迁入迁出记录（每一次管理员修改自己的户籍地址，就会留下一条记录）** ###

![6fb08f1c237f7eb23cc242630edb8de7.png][]

### **查看公告** ###

![955af91c6ba4bbefa6b22823a9c8cf72.png][]

## **数据库设计** ##

![67c4329c932cfd5c95b1a114afc4fc3e.png][]

-- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of admin
    -- ----------------------------
    INSERT INTO `admin` VALUES (1, 'admin', '管理员', '123456');
    INSERT INTO `admin` VALUES (2, 'admin123', '管理员123', '123456');
    
    -- ----------------------------
    -- Table structure for board
    -- ----------------------------
    DROP TABLE IF EXISTS `board`;
    CREATE TABLE `board`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `fbsj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of board
    -- ----------------------------
    INSERT INTO `board` VALUES (2, '关于系统升级通知', '下周系统维护！！！！', '2021-04-13 22:46');
    
    -- ----------------------------
    -- Table structure for fk
    -- ----------------------------
    DROP TABLE IF EXISTS `fk`;
    CREATE TABLE `fk`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `userId` int(11) NULL DEFAULT NULL,
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of fk
    -- ----------------------------
    INSERT INTO `fk` VALUES (5, '111', '2021-04-13 22:35', '22222', 1, '管理员');
    INSERT INTO `fk` VALUES (6, '222222', '2021-04-14 09:33', '2222222', 1, '张三');
    INSERT INTO `fk` VALUES (7, '4444444', '2021-04-14 10:28', '44444444', 2, '管理员123');
    
    -- ----------------------------
    -- Table structure for record
    -- ----------------------------
    DROP TABLE IF EXISTS `record`;
    CREATE TABLE `record`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `userId` int(11) NULL DEFAULT NULL,
      `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `yhj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `ydz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `xhj` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `xdz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

## **项目结构** ##

### Jsp+Servlet+MVC开发 ###

![5affc11005cae52fb5a6349fc2f635ba.png][]

## 项目获取: ##

[https://gitee.com/sinonfin/L-javaWebSha/tree/master][https_gitee.com_sinonfin_L-javaWebSha_tree_master]

[aadd824af77d62de00fa857aa554acb7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/103810e4be4c456da4c7bdea29d10de7.png
[717eb48a6aaa86321d5165296d11d379.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/af0e1be23b63451f87b9c3d356a44827.png
[88feee5ef8c7adda8527b187e431b4b1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/a311f3a738674982b96a76292677981c.png
[48bfa5ec212562ec0be7486f8ba12068.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/0ab42fb2df49425e8c8bf92c25ee811e.png
[d092fc3c124a6944437ad92dd101c0b4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d1f0f4622bbe4b28a0b88c054315287b.png
[911289b135ebc242d777169985373b0a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/f5a4f86a848c4c728204bb10350aca0e.png
[30503f60f6d89146abb7df8d9bea5812.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/98fb7cd96f224aba9cc352814f99d684.png
[164ffa772ec900b9b8728440d4c5c3cb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d034bcf7481c4e329d63c409429815af.png
[2aa6007a579cd51918b5fe72a458678d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/481738c13a064aef94652b264130678b.png
[6fb08f1c237f7eb23cc242630edb8de7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/78d6267bb6bb49f8b2fe09ffd0b242cc.png
[955af91c6ba4bbefa6b22823a9c8cf72.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d250127732f6486cbebc28184ea7821f.png
[67c4329c932cfd5c95b1a114afc4fc3e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/9ff4f619976247b39ff25a6f521dcb70.png
[5affc11005cae52fb5a6349fc2f635ba.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/c4c2e6baaf1048a0a5e1d2815f86e76b.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master