Java+SSM+Jsp+Mysql实现Web汽车信息管理系统

4.数据库文件

---

/*

Navicat Premium Data Transfer

Source Server : MYSQL

Source Server Type : MySQL

Source Server Version : 80013

Source Host : localhost:3306

Source Schema : ssm_car_rent

Target Server Type : MySQL

Target Server Version : 80013

File Encoding : 65001

Date: 14/03/2022 11:43:21

*/

SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for cars

---

DROP TABLE IF EXISTS cars;

CREATE TABLE cars (

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

cartype varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

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

rentprice decimal(10, 2) NOT NULL,

deposit decimal(10, 2) NOT NULL,

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

cardesc varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

carimg varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,

seat int(5) NOT NULL,

PRIMARY KEY (carnumber) USING BTREE

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

---

– Records of cars

---

INSERT INTO cars VALUES (‘京A-10001’, ‘宝马X6’, ‘蓝色’, 1000.00, 100000.00, ‘未出租’, ‘现代车’, ‘京A-10001.jpg’, 4);

INSERT INTO cars VALUES (‘京A-10002’, ‘宝马X6’, ‘红色’, 1000.00, 100000.00, ‘未出租’, ‘现代车’, ‘京A-10002.jpg’, 4);

INSERT INTO cars VALUES (‘京A-10003’, ‘桑塔纳X1’, ‘红色’, 500.00, 100000.00, ‘未出租’, ‘复古车’, ‘京A-10003.jpg’, 4);

INSERT INTO cars VALUES (‘京A-10004’, ‘奔驰X9’, ‘棕色’, 1000.00, 100000.00, ‘未出租’, ‘现代车’, ‘京A-10004.jpg’, 4);

---

– Table structure for customers

---

DROP TABLE IF EXISTS customers;

CREATE TABLE customers (

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

custname varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

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

address varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

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

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

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

PRIMARY KEY (identity) USING BTREE,

INDEX custname(custname) USING BTREE

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

---

– Records of customers

---

INSERT INTO customers VALUES (‘100001’, ‘赵克’, ‘男’, ‘北京’, ‘13345676544’, ‘开发’, ‘123456’);

INSERT INTO customers VALUES (‘100002’, ‘黄山’, ‘男’, ‘广东’, ‘13456540987’, ‘运营’, ‘wwwwww’);

INSERT INTO customers VALUES (‘100003’, ‘李丽’, ‘女’, ‘深圳’, ‘13346787654’, ‘采购’, ‘123456’);

INSERT INTO customers VALUES (‘100004’, ‘张红’, ‘女’, ‘北京’, ‘13478765643’, ‘人力’, ‘123456’);

INSERT INTO customers VALUES (‘100005’, ‘张刚’, ‘男’, ‘武汉’, ‘13456988765’, ‘品质’, ‘123456’);

INSERT INTO customers VALUES (‘100006’, ‘张燕’, ‘女’, ‘长沙’, ‘13450987863’, ‘运维’, ‘123456’);

---

– Table structure for funs

---

DROP TABLE IF EXISTS funs;

CREATE TABLE funs (

funid decimal(8, 0) NOT NULL,

funname varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

funurl varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,

menuid decimal(8, 0) NOT NULL,

PRIMARY KEY (funid) USING BTREE,

INDEX FUNS_FK(menuid) USING BTREE,

CONSTRAINT FUNS_FK FOREIGN KEY (menuid) REFERENCES menus (menuid) ON DELETE CASCADE ON UPDATE CASCADE

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

---

– Records of funs

---

INSERT INTO funs VALUES (1, ‘主页面’, ‘index.jsp’, 1);

INSERT INTO funs VALUES (2, ‘头页面’, ‘head.jsp’, 1);

INSERT INTO funs VALUES (3, ‘菜单页面’, ‘menu.jsp’, 1);

INSERT INTO funs VALUES (4, ‘脚页面’, ‘foot.jsp’, 1);

INSERT INTO funs VALUES (5, ‘操作页面’, ‘welcome.jsp’, 1);

INSERT INTO funs VALUES (6, ‘权限提示页面’, ‘norole.jsp’, 1);

INSERT INTO funs VALUES (8, ‘退出系统动作n’, ‘ExitSystemAction.do’, 1);

INSERT INTO funs