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

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 VALUES (9, ‘菜单导航’, ‘modNavTop.jsp’, 1);

INSERT INTO funs VALUES (10, ‘菜单条’, ‘splitor.jsp’, 1);

INSERT INTO funs VALUES (11, ‘操作失败提示页面’, ‘error.jsp’, 1);

INSERT INTO funs VALUES (12, ‘系统崩溃提示页面’, ‘appError.jsp’, 1);

INSERT INTO funs VALUES (13, ‘成功页面’, ‘ok.jsp’, 1);

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

INSERT INTO funs VALUES (50, ‘添加用户角色查询动作n’, ‘AddUserAction.do’, 3);

INSERT INTO funs VALUES (51, ‘添加用户页面’, ‘addUser.jsp’, 3);

INSERT INTO funs VALUES (52, ‘添加用户动作’, ‘AddUser.do’, 3);

INSERT INTO funs VALUES (53, ‘查询用户角色查询动作n’, ‘FindUserAction.do’, 4);

INSERT INTO funs VALUES (54, ‘查询用户页面’, ‘findUser.jsp’, 4);

INSERT INTO funs VALUES (55, ‘显示查询用户结果页面n’, ‘viewUser.jsp’, 4);

INSERT INTO funs VALUES (56, ‘查询用户动作’, ‘FindUser.do’, 4);

INSERT INTO funs VALUES (57, ‘预更新查询用户动作’, ‘PreUpdateUser.do’, 4);

INSERT INTO funs VALUES (58, ‘显示更新用户页面’, ‘updateUser.jsp’, 4);

INSERT INTO funs VALUES (59, ‘更新用户动作’, ‘UpdateUser.do’, 4);

INSERT INTO funs VALUES (60, ‘删除用户动作’, ‘DeleteUser.do’, 4);

INSERT INTO funs VALUES (61, ‘预修改用户密码’, ‘PreChangeUserPwd.do’, 4);

INSERT INTO funs VALUES (62, ‘修改用户密码页面’, ‘chengeUserPwd.jsp’, 4);

INSERT INTO funs VALUES (63, ‘修改用户密码动作’, ‘ChangeUserPwd.do’, 4);

INSERT INTO funs VALUES (100, ‘添加客户页面’, ‘addCustomers.jsp’, 6);

INSERT INTO funs VALUES (101, ‘添加客户动作n’, ‘AddCustomersAction.do’, 6);

INSERT INTO funs VALUES (102, ‘查询客户页面’, ‘findCustomers.jsp’, 7);

INSERT INTO funs VALUES (103, ‘查询客户信息动作n’, ‘FindCustomersAction.do’, 7);

INSERT INTO funs VALUES (104, ‘显示查询客户结果页面’, ‘viewCustomers.jsp’, 7);

INSERT INTO funs VALUES (105, ‘预更新客户查询动作’, ‘PreCustomers.do’, 7);

INSERT INTO funs VALUES (106, ‘显示更新客户页面’, ‘updateCustomers.jsp’, 7);

INSERT INTO funs VALUES (107, ‘更新客户动作’, ‘UpdateCustomers.do’, 7);

INSERT INTO funs VALUES (108, ‘删除客户动作’, ‘DeleteCustomers.do’, 7);

INSERT INTO funs VALUES (109, ‘预修改客户密码’, ‘PreChangeCustomerPwd.do’, 7);

INSERT INTO funs VALUES (110, ‘修改客户密码页面’, ‘chengeCustomersPwd.jsp’, 7);

INSERT INTO funs VALUES (111, ‘修改用户密码动作’, ‘ChangeCustomersPwd.do’, 7);

INSERT INTO funs VALUES (200, ‘添加汽车页面’, ‘addCar.jsp’, 9);

INSERT INTO funs VALUES (201, ‘添加汽车动作n’, ‘AddCarAction.do’, 9);

INSERT INTO funs VALUES (202, ‘查询汽车页面’, ‘findCar.jsp’, 10);

INSERT INTO funs VALUES (203, ‘显示查询汽车结果页面’, ‘viewCars.jsp’, 10);

INSERT INTO funs VALUES (204, ‘查询汽车信息动作n’, ‘FindCarAction.do’, 10);

INSERT INTO funs VALUES (205, ‘预更新查询汽车动作’, ‘PreUpdateCar.do’, 10);

INSERT INTO funs VALUES (206, ‘显示更新汽车结果页面’, ‘updateCar.jsp’, 10);

INSERT INTO funs VALUES (207, ‘更新汽车动作’, ‘UpdateCar.do’, 10);

INSERT INTO funs VALUES (209, ‘删除汽车动作’, ‘DeleteCar.do’, 10);

---

– Table structure for menus

---

DROP TABLE IF EXISTS menus;

CREATE TABLE menus (

menuid decimal(8, 0) NOT NULL,

menuname varchar(40) CHARACTER SET utf8 COLLATE utf8_general