计算机javaweb毕设项目基于Jsp+Servlet的汽车保险系统

淡淡的烟草味﹌ 2024-02-18 11:39 49阅读 0赞

**项目类型** ：JAVA WEB项目  
**项目名称：** 基于Jsp+Servlet的汽车保险系统  
**用户类型** ：3个角色（管理员+用户）  
**系统类型** ：前端网站+后台系统  
**设计模式** ：Jsp+Servlet  
**开发工具** ：Eclipse /IDEA都可以使用  
**数据库** ：Mysql+Navicat  
**数据库表** ：6张  
**适用** ：软件工程、计算机科学与技术等JAVA课程的学习和实验

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

**网站首页**

![90f3ecb665dbde2949f39b609293d310.png][]

**注册与登录**

![a25edbf63c34eeded2e7cfb80be57fd4.png][]

![530809b5d3858f78c038286a2b09fcdc.png][]

**用户办理汽车保险**

![790b5725c7cb2b848b825eacdc993c1f.png][]

**办理过的保险、理赔**

![fcc0e8bff9775e66ffcfd64d6a67bd09.png][]

**个人信息修改**

![10ef8a26a7c7c86dc4ac8adb65c9b778.png][]

## **业务员端功能介绍** ##

**保险处理 对于用的的理赔进行受理**

![68b35203b05c08941ca64a6247380789.png][]

**客户理赔记录**

![cc4cac7274fd70ad119bdf2e2f11cea6.png][]

**个人信息管理**

![3c6e3b75cb5dd384fd8b0797a39f33d7.png][]

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

**客户管理**

![bfe843ebf99879a3f73b9628a85e5f10.png][]

**保险管理**

![21622d5dd1d1d38c11fbe4a9cc76447b.png][]

**业务员管理**

![2843fde631bf77c567e04ba43dc232d3.png][]

## **数据库表** ##

![0541ca5b3fea54ee8e0852ce98ab58d6.png][]

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

![ba0f1f0341e39e3b2d0f3af1b17f15df.png][]

## 多用户登录代码实战 ##

### **用户登录表单** ###

登录                      
                        ${message}
    
                          请选择角色
                            管理员 
                            用户
                            业务员
                        登录

## 数据库建表 ##

/*
     Navicat Premium Data Transfer
    
     Source Server         : project
     Source Server Type    : MySQL
     Source Server Version : 50715
     Source Host           : localhost:3306
     Source Schema         : db_qcbx
    
     Target Server Type    : MySQL
     Target Server Version : 50715
     File Encoding         : 65001
    
     Date: 01/04/2021 16:21:47
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
      `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
      `nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of admin
    -- ----------------------------
    INSERT INTO `admin` VALUES (1, 'admin', '123456', '管理员');
    
    -- ----------------------------
    -- Table structure for bx
    -- ----------------------------
    DROP TABLE IF EXISTS `bx`;
    CREATE TABLE `bx`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
      `bname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险名称',
      `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险内容',
      `fxrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发行日期',
      `s_id` int(11) NULL DEFAULT NULL COMMENT '业务员，关联saler表的id',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of bx
    -- ----------------------------
    INSERT INTO `bx` VALUES (1, '第三者责任险', '这个是赔付第三方人和物的，一般是建议购买50万，如果经济允许我是建议你购买100万的，因为有人员伤亡的时候50万是不够赔付的。', '2021-03-29 14:39', 1);
    INSERT INTO `bx` VALUES (3, '车损险', '你是新车新手的话我是建议你购买的，买了车损险，发生出险事故时候修自己的车是有保险公司赔付的。', '2021-03-29 14:48', 1);
    INSERT INTO `bx` VALUES (4, '交强险', '交强险 这个是必须买的，这个是没什么疑问，这个是国家规定的，不买是不能上路，上牌年检的。', '2021-03-29 14:52', 3);
    
    -- ----------------------------
    -- Table structure for jl
    -- ----------------------------
    DROP TABLE IF EXISTS `jl`;
    CREATE TABLE `jl`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
      `bname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险名称',
      `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险内容',
      `blrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理日期',
      `blsc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险办理时长',
      `blr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '办理人姓名',
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆名称',
      `cph` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车号牌',
      `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆类型',
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of jl
    -- ----------------------------
    INSERT INTO `jl` VALUES (1, '第三者责任险', '这个是赔付第三方人和物的，一般是建议购买50万，如果经济允许我是建议你购买100万的，因为有人员伤亡的时候50万是不够赔付的。', '2021-03-30 10:44', '2年', '张三', '宝马530', '苏M99999', '小轿车', '/img/4f21ad35-4db9-4e36-9b47-52c86a8b1a40.jpg', 1, 1);
    INSERT INTO `jl` VALUES (2, '交强险', '交强险 这个是必须买的，这个是没什么疑问，这个是国家规定的，不买是不能上路，上牌年检的。', '2021-03-30 14:19', '1年', '张三', '宝马530', '苏M99999', '小轿车', '/img/4f21ad35-4db9-4e36-9b47-52c86a8b1a40.jpg', 1, 4);
    
    -- ----------------------------
    -- Table structure for lpsh
    -- ----------------------------
    DROP TABLE IF EXISTS `lpsh`;
    CREATE TABLE `lpsh`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键、自增',
      `bname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险名称',
      `detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险内容',
      `blrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理日期',
      `blr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '办理人',
      `blsc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险办理时长',
      `bz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
      `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0表示拒绝理赔，1表示审核中，2表示理赔成功',
      `s_id` int(11) NULL DEFAULT NULL COMMENT '业务员，关联saler表的id',
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆名称',
      `cph` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号',
      `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆类型',
      `imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆图片',
      `j_id` int(10) NULL DEFAULT NULL COMMENT '办理保险记录表id',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of lpsh
    -- ----------------------------
    INSERT INTO `lpsh` VALUES (1, '第三者责任险', '这个是赔付第三方人和物的，一般是建议购买50万，如果经济允许我是建议你购买100万的，因为有人员伤亡的时候50万是不够赔付的。', '2021-03-30 10:44', '张三', '2年', '保险质量太差了，申请理赔', '2', 1, '宝马530', '苏M99999', '小轿车', '/img/4f21ad35-4db9-4e36-9b47-52c86a8b1a40.jpg', 1);
    
    -- ----------------------------
    -- Table structure for saler
    -- ----------------------------
    DROP TABLE IF EXISTS `saler`;
    CREATE TABLE `saler`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
      `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
      `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家庭住址',
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of saler
    -- ----------------------------
    INSERT INTO `saler` VALUES (1, '小明', '男', '123456', '13622221111', 'xiaoming@qq.com', '江苏省南京市');
    INSERT INTO `saler` VALUES (3, '小红', '女', '123456', '13622223333', 'xiaohong@qq.com', '江苏省南京市');
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
      `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录密码',
      `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
      `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
      `cno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆名称',
      `cph` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车牌号',
    
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES (1, '张三', '男', '123456', '15365129999', 'zhangsan@qq.com', '321283199805059999', '宝马530', '苏M99999', '小轿车', '/img/4f21ad35-4db9-4e36-9b47-52c86a8b1a40.jpg', '江苏省南京市雨花台区1');
    INSERT INTO `user` VALUES (2, '李四', '男', '123456', '13912345678', 'lisi@qq.com', '321283199823239999', '奥迪A6L', '苏M89893', '小轿车', '/img/6d189381-a25f-4aa6-aff5-7d886e5f1589.jpg', '江苏省泰州市泰兴市鼓楼路');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 项目获取: ##

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

[90f3ecb665dbde2949f39b609293d310.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/cb7199811c8b40dbadbe76c42123c9d2.png
[a25edbf63c34eeded2e7cfb80be57fd4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/50510bf112804781a18b56c3134a6a50.png
[530809b5d3858f78c038286a2b09fcdc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/5d7f08e9477e48a388f27278e2b93c4d.png
[790b5725c7cb2b848b825eacdc993c1f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/69637e703f5340549382990ca843aac8.png
[fcc0e8bff9775e66ffcfd64d6a67bd09.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/61b0dd05f64d40d4a8c0f23385d74641.png
[10ef8a26a7c7c86dc4ac8adb65c9b778.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/95fe3ecef7664aa989f6236d3f780de0.png
[68b35203b05c08941ca64a6247380789.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d25e2cddea57487db1ce7d8326bff17e.png
[cc4cac7274fd70ad119bdf2e2f11cea6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/b3b2fccee65e46a79693ecae8bc3c568.png
[3c6e3b75cb5dd384fd8b0797a39f33d7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/8a49d504bc774ef78cea29ee13053d8f.png
[bfe843ebf99879a3f73b9628a85e5f10.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/c9f27b22b4884b5d8c14cb866608022f.png
[21622d5dd1d1d38c11fbe4a9cc76447b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/81afd2810ca04f19b12a50c001f84f7d.png
[2843fde631bf77c567e04ba43dc232d3.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/fb51209403674bf2845282b23ad6f1e9.png
[0541ca5b3fea54ee8e0852ce98ab58d6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/c8c05829d8bb440386884f9ac5093c32.png
[ba0f1f0341e39e3b2d0f3af1b17f15df.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/18/d31c41ad8d4b4f41ad26192f71c10dfd.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master