本文共 1866 字,大约阅读时间需要 6 分钟。
目录
数据库:MySQL 5.x
三张表:employee(员工表)、department(部门表)、job(职位表)
employee
-- ------------------------------ Table structure for employee-- ----------------------------DROP TABLE IF EXISTS `employee`;CREATE TABLE `employee` ( `employee_id` int(10) NOT NULL AUTO_INCREMENT, `first_name` varchar(20) DEFAULT NULL, `last_name` varchar(25) DEFAULT NULL, `email` varchar(25) DEFAULT NULL, `phone_number` varchar(20) DEFAULT NULL, `hire_date` date DEFAULT NULL, `job_id` varchar(10) DEFAULT NULL, `salary` decimal(10,2) DEFAULT NULL COMMENT '工资', `manager_id` int(10) DEFAULT NULL, `department_id` int(10) DEFAULT NULL, PRIMARY KEY (`employee_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
department
-- ------------------------------ Table structure for department-- ----------------------------DROP TABLE IF EXISTS `department`;CREATE TABLE `department` ( `department_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '部门id', `department_name` varchar(30) DEFAULT NULL COMMENT '部门名称', `manager_id` int(10) DEFAULT NULL, `location_id` int(10) DEFAULT NULL, PRIMARY KEY (`department_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
job
-- ------------------------------ Table structure for job-- ----------------------------DROP TABLE IF EXISTS `job`;CREATE TABLE `job` ( `job_id` varchar(10) NOT NULL, `job_title` varchar(35) DEFAULT NULL, `min_salary` decimal(6,0) DEFAULT NULL, `max_salary` decimal(6,0) DEFAULT NULL, PRIMARY KEY (`job_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;
artifactId:SSM
groupId:com.starfall.ssm
(1)src/main/java:
com.starfall.ssm.controller:SpringMVC控制器
com.starfall.ssm.dao:MyBatis接口层
com.starfall.ssm.service:业务服务层
com.starfall.ssm.entity:数据库对应实体类
com.starfall.ssm.model:其他模型实体(例如分页页码、枚举对象。。。)
(2)src/main/resources:
mapper:Mybatis对应的mapper文件
其他:Spring、SpringMVC、MyBatis、日志等配置文件
(3)src/main/webapp:
前端的资源
转载地址:http://cplci.baihongyu.com/