项目类型:JAVA WEB项目
项目名称:基于Jsp+Servlet的汽车保险系统
用户类型:3个角色(管理员+用户)
系统类型:前端网站+后台系统
设计模式:Jsp+Servlet
开发工具:Eclipse /IDEA都可以使用
数据库:Mysql+Navicat
数据库表:6张
适用:软件工程、计算机科学与技术等JAVA课程的学习和实验
视频演示在下方
原创项目,开发不易,感谢支持!!
项目来源:公众号“学长源码”咨询
网站首页
注册与登录
用户办理汽车保险
办理过的保险、理赔
个人信息修改
保险处理 对于用的的理赔进行受理
客户理赔记录
个人信息管理
客户管理
保险管理
业务员管理
毕设源码项目——基于Jsp+Servlet的汽车保险系统
<form action="LoginServlet?action=login" method="post" id="loginForm" name="loginForm"> <legend>登录</legend> <div class="layui-form-item" style="margin-bottom: 4px;"> <div class="layui-inline veri-code"> <div class="layui-input-inline"> <input type="text" name="userName" id="userName" lay-verify="required" placeholder="请输入用户名或者手机号" autocomplete="off" class="layui-input"> <span id="msg3" style="color:red">${message}</span> </div> </div> <div class="layui-inline veri-code"> <div class="layui-input-inline"> <input id="password" type="password" name="password" lay-verify="required" placeholder="请输入密码" autocomplete="off" class="layui-input"> </div> </div> <div class="layui-inline veri-code"> <div class="layui-input-inline"> <select name="type" id="type" style="height: 35px;width: 100%;"> <option value="">请选择角色</option> <option value="1">管理员</option> <option value="2">用户</option> <option value="3">业务员</option> </select> </div> </div> </div> <div class="layui-form-item login-btn"> <div class="layui-input-block"> <button class="layui-btn" lay-submit="" id="login" lay-filter="demo1" >登录</button> </div> </div> </form>
package com.qcbx.servlet; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.qcbx.entity.Admin; import com.qcbx.entity.Saler; import com.qcbx.entity.User; import com.qcbx.service.LoginService; import com.qcbx.service.impl.LoginServiceImpl; public class LoginServlet extends HttpServlet{ private LoginService ls = new LoginServiceImpl(); @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String action=request.getParameter("action");//接受请求的参数 // check(request,response,action); if(action != null && action.equals("toLogin")) {//去登录页面 toLogin(request, response); }else if(action != null && action.equals("login")) {//登录 login(request, response); }else if(action != null && action.equals("LoginOutAct")) {//退出 LoginOutAct(request, response); }else if(action != null && action.equals("welcome")) {//默认页面 welcome(request, response); }else if(action != null && action.equals("toRegsite")) {//去注册 toRegsite(request, response); }else if(action != null && action.equals("registe")) {//注册 registe(request, response); } } /** * 注册 * @param request * @param response */ private void registe(HttpServletRequest request, HttpServletResponse response) { } /** * 去注册页面 * @param request * @param response */ private void toRegsite(HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher("/client/register.jsp").forward(request, response); } catch (Exception e) { e.printStackTrace(); } } private void check(HttpServletRequest request, HttpServletResponse response, String action) { if(request.getSession().getAttribute("user") == null && request.getSession().getAttribute("saler") == null && request.getSession().getAttribute("admin") == null && !action.equals("login") && !action.equals("toRegsite") && !action.equals("registe")){ toLogin(request, response); } } /** * 退出 * @param request * @param response */ private void LoginOutAct(HttpServletRequest request, HttpServletResponse response) { try { request.getSession().removeAttribute("admin"); request.getSession().removeAttribute("saler"); request.getSession().removeAttribute("user"); request.getSession().removeAttribute("flag"); //response.sendRedirect(request.getContextPath()+"/LoginServlet?action=toLogin"); response.sendRedirect(request.getContextPath()+"/BxServlet?action=bxUserList"); } catch (Exception e) { e.printStackTrace(); } } /** * 登录 * @param request * @param response */ private void login(HttpServletRequest request, HttpServletResponse response) { removeAll(request,response); String userName = request.getParameter("userName"); String password = request.getParameter("password"); String type = request.getParameter("type"); if(type != null && type.equals("1")){ Admin admin = new Admin(); admin.setUserName(userName); admin.setPwd(password); Admin admin1 = ls.selectAdmin(admin); try { if (admin1 == null){ request.setAttribute("message", "管理员用户不存在或者密码错误"); request.getRequestDispatcher("/client/login.jsp").forward(request, response); }else { request.getSession().setAttribute("admin",admin1); request.getSession().setAttribute("flag",1); request.getRequestDispatcher("/WEB-INF/view/main.jsp").forward(request, response); } } catch (Exception e) { e.printStackTrace(); } }else if(type != null && type.equals("2")){ User user =new User(); user.setPhone(userName); user.setPwd(password); User user1 = ls.selectUser(user); try{ if(user1 == null){ request.setAttribute("message", "用户手机号不存在或者密码错误"); request.getRequestDispatcher("/client/login.jsp").forward(request, response); }else{ request.getSession().setAttribute("user",user1); request.getSession().setAttribute("flag",2); //request.getRequestDispatcher("/client/shouye.jsp").forward(request, response); response.sendRedirect(request.getContextPath()+"/BxServlet?action=bxUserList"); } }catch(Exception e){ e.printStackTrace(); } }else if(type != null && type.equals("3")){ Saler saler = new Saler(); saler.setPhone(userName); saler.setPwd(password); Saler saler1 = ls.selectSaler(saler); try{ if(saler1 == null){ request.setAttribute("message", "业务员手机号不存在或者密码错误"); request.getRequestDispatcher("/client/login.jsp").forward(request, response); }else{ request.getSession().setAttribute("saler",saler1); request.getSession().setAttribute("flag",3); request.getRequestDispatcher("/WEB-INF/view/main.jsp").forward(request, response); } }catch(Exception e){ e.printStackTrace(); } }else{ try{ request.setAttribute("message", "请选择角色"); request.getRequestDispatcher("/client/login.jsp").forward(request, response); }catch(Exception e){ e.printStackTrace(); } } } /** * 去登陆页面 * @param request * @param response */ private void toLogin(HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher("/client/login.jsp").forward(request, response); }catch(Exception e){ e.printStackTrace(); } return; } private void removeAll(HttpServletRequest request, HttpServletResponse response) { request.removeAttribute("admin"); request.removeAttribute("saler"); request.removeAttribute("user"); request.removeAttribute("flag"); } private void welcome(HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher("/WEB-INF/view/console.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } }
package com.qcbx.service; import com.qcbx.entity.Admin; import com.qcbx.entity.Saler; import com.qcbx.entity.User; public interface LoginService { Admin selectAdmin(Admin admin); User selectUser(User user); Saler selectSaler(Saler saler); }
package com.qcbx.service.impl; import com.qcbx.dao.LoginDao; import com.qcbx.dao.impl.LoginDaoImpl; import com.qcbx.entity.Admin; import com.qcbx.entity.Saler; import com.qcbx.entity.User; import com.qcbx.service.LoginService; public class LoginServiceImpl implements LoginService{ private LoginDao ld = new LoginDaoImpl(); @Override public Admin selectAdmin(Admin admin) { return ld.selectAdmin(admin); } @Override public User selectUser(User user) { return ld.selectUser(user); } @Override public Saler selectSaler(Saler saler) { return ld.selectSaler(saler); } }
package com.qcbx.dao; import com.qcbx.entity.Admin; import com.qcbx.entity.Saler; import com.qcbx.entity.User; public interface LoginDao { Admin selectAdmin(Admin admin); User selectUser(User user); Saler selectSaler(Saler saler); }
package com.qcbx.dao.impl; import java.sql.SQLException; import org.apache.commons.dbutils.QueryRunner; import org.apache.commons.dbutils.handlers.BeanHandler; import com.qcbx.dao.LoginDao; import com.qcbx.entity.Admin; import com.qcbx.entity.Saler; import com.qcbx.entity.User; import com.qcbx.utils.C3p0Utils; public class LoginDaoImpl implements LoginDao{ private QueryRunner runner=new QueryRunner(C3p0Utils.getDs()); @Override public Admin selectAdmin(Admin admin) { try {//返回查询的信息 return runner.query("select * from admin where userName=? and pwd=?", new BeanHandler<Admin>(Admin.class),admin.getUserName(),admin.getPwd()); } catch (SQLException e) { throw new RuntimeException("管理员登录异常!",e);//抛出运行异常 } } @Override public User selectUser(User user) { try {//返回查询的信息 return runner.query("select * from user where phone=? and pwd=?", new BeanHandler<User>(User.class),user.getPhone(),user.getPwd()); } catch (SQLException e) { throw new RuntimeException("用户登录异常!",e);//抛出运行异常 } } @Override public Saler selectSaler(Saler saler) { try {//返回查询的信息 return runner.query("select * from saler where phone=? and pwd=?", new BeanHandler<Saler>(Saler.class),saler.getPhone(),saler.getPwd()); } catch (SQLException e) { throw new RuntimeException("业务员登录异常!",e);//抛出运行异常 } } }
package com.qcbx.servlet; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.util.List; import java.util.UUID; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.beanutils.BeanUtils; import org.apache.commons.fileupload.FileItem; import org.apache.commons.fileupload.disk.DiskFileItemFactory; import org.apache.commons.fileupload.servlet.ServletFileUpload; import com.qcbx.entity.User; import com.qcbx.service.UserService; import com.qcbx.service.impl.UserServiceImpl; public class UserServlet extends HttpServlet{ private UserService us = new UserServiceImpl(); @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String action=request.getParameter("action");//接受请求的参数 if(action != null && action.equals("userListLike")) {//模糊查询用户列表 userListLike(request, response); }else if(action != null && action.equals("userList")){//分页查询用户列表 userList(request, response); }else if(action != null && action.equals("toAddUser")){//去新增用户页面 toAddUser(request, response); }else if(action != null && action.equals("addUser")){//新增用户 addUser(request, response); }else if(action != null && action.equals("toUpdateUser")){//去用户修改页面 toUpdateUser(request, response); }else if(action != null && action.equals("updateUser")){//用户修改 updateUser(request, response); }else if(action != null && action.equals("deleteUser")){//用户删除 deleteUser(request, response); }else if(action != null && action.equals("wdxx")){//页面首页我的信息 wdxx(request, response); } } /** * 我的信息 * @param request * @param response */ private void wdxx(HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher("/client/wdxx.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } } /** * 删除用户 * @param request * @param response */ private void deleteUser(HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("id"); try { us.deleteUser(id); response.sendRedirect(request.getContextPath()+"/UserServlet?action=userList"); } catch (Exception e) { e.printStackTrace(); } } /** * 修改用户 * @param request * @param response */ private void updateUser(HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("userId"); String name = request.getParameter("name"); String pwd = request.getParameter("pwd"); String phone = request.getParameter("phone"); String email = request.getParameter("email"); String cno = request.getParameter("cno"); String cname = request.getParameter("cname"); String cph = request.getParameter("cph"); String address = request.getParameter("address"); User user = new User(); user.setAddress(address); user.setCname(cname); user.setCno(cno); user.setCph(cph); user.setEmail(email); user.setId(Integer.parseInt(id)); user.setName(name); user.setPhone(phone); user.setPwd(pwd); us.updateUser(user); Object flag = request.getSession().getAttribute("flag"); if(flag != null && flag.toString().equals("1")){ try { response.sendRedirect(request.getContextPath()+"/UserServlet?action=userList"); } catch (Exception e) { e.printStackTrace(); } }else{ User user1 = us.selectUserById(id); request.getSession().setAttribute("user", user1); try { request.getRequestDispatcher("/client/wdxx.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } } } /** * 去用户修改页面 * @param request * @param response */ private void toUpdateUser(HttpServletRequest request, HttpServletResponse response) { Object flag = request.getSession().getAttribute("flag"); if(flag != null && flag.toString().equals("1")){ String id = request.getParameter("id"); User user = us.selectUserById(id); request.getSession().setAttribute("user", user); try { request.getRequestDispatcher("/WEB-INF/view/user/updateUser.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } }else{ try { request.getRequestDispatcher("/WEB-INF/view/user/updateUser.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } } } /** * 新增用户 * @param request * @param response */ private void addUser(HttpServletRequest request, HttpServletResponse response) { String temp = request.getParameter("temp"); User user = fileUpload(request); us.addUser(user); if(temp != null && temp.equals("1")){ try { response.sendRedirect(request.getContextPath()+"/LoginServlet?action=toLogin"); } catch (IOException e) { e.printStackTrace(); } }else{ try { response.sendRedirect(request.getContextPath()+"/UserServlet?action=userList"); } catch (IOException e) { e.printStackTrace(); } } } /** * 新增用户车辆图片上传 * @param request * @return */ private User fileUpload(HttpServletRequest request) { User user=new User(); try { DiskFileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); List<FileItem> list = upload.parseRequest(request); for(FileItem item : list){ if(item.isFormField()){ String name = item.getFieldName(); String value = item.getString("UTF-8"); BeanUtils.setProperty(user, name, value); }else{ String filename = item.getName(); String savefilename = makeFileName(filename); String savepath="C:\\WorkspaceForZGN\\qcbx\\WebContent\\img\\"; InputStream in = item.getInputStream(); FileOutputStream out = new FileOutputStream(savepath + "\\" + savefilename); int len = 0; byte buffer[] = new byte[1024]; while((len = in.read(buffer)) > 0){ out.write(buffer, 0, len); } in.close(); out.close(); item.delete(); user.setImgUrl("/img/"+savefilename); System.out.println(user.getImgUrl()); } } return user; } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } } private String makeFileName(String filename) { String ext = filename.substring(filename.lastIndexOf(".") + 1); return UUID.randomUUID().toString() + "." + ext; } /** * 去新增用户页面 * @param request * @param response */ private void toAddUser(HttpServletRequest request, HttpServletResponse response) { try { request.getRequestDispatcher("/WEB-INF/view/user/addUser.jsp").forward(request,response); } catch (Exception e) { e.printStackTrace(); } } /** * 分页查询用户列表 * @param request * @param response */ private void userList(HttpServletRequest request, HttpServletResponse response) { String p=request.getParameter("p");//接收页码 int pageSize=4;//每页显示5条 int pageNum=1; //默认第一页 if(p!=null){ pageNum= Integer.parseInt(p); } //调用分页查询 List<User> list=us.getUserListPage(pageNum,pageSize); //携带参数到页面 // request.setAttribute("userList",bList); //绑定参数 int nums=us.queryUserCount(); //查询总数 //计算总页数 int totalPage=(nums%pageSize==0)? (nums/pageSize):(nums/pageSize+1); request.setAttribute("cp",pageNum); //当前页 request.setAttribute("tp",totalPage); //总页数 try { request.removeAttribute("msg"); request.setAttribute("list" ,list); request.getRequestDispatcher("/WEB-INF/view/user/userList.jsp").forward(request, response); } catch (Exception e) { e.printStackTrace(); } } /** * 模糊查询用户列表 * @param request * @param response */ private void userListLike(HttpServletRequest request, HttpServletResponse response) { try { String name = request.getParameter("name"); List<User> list=us.selectUserList(name); request.removeAttribute("msg"); request.setAttribute("list" ,list); request.getRequestDispatcher("/WEB-INF/view/user/userList.jsp").forward(request, response); } catch (Exception e) { e.printStackTrace(); } } @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } }
/* 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 '车辆类型', `imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '车辆图片', `u_id` int(10) NULL DEFAULT NULL COMMENT '办理人id', `b_id` int(10) NULL DEFAULT NULL COMMENT '保险id', PRIMARY KEY (`id`) USING BTREE ) 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 '车牌号', `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 '车辆图片', `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 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;