2、spring+mybatis注解+idea+maven

1、在idea中配置database 连接数据库，用来在idea中编写sql脚本操作数据库

 2、sql详细脚本如下：

 1 --1.创建部门表
 2 create table dept
 3  (
 4    deptno int(2) unsigned primary key,
 5    dname varchar(14),
 6    loc varchar(13)
 7  );
 8 
 9 --2.添加部门数据
10 insert into dept(deptno,dname,loc) values
11 (10,"ACCOUNTING","NEW YORK"),
12 (20,"RESEARCH","DALLAS"),
13 (30,"SALES","CHICAGO"),
14 (40,"OPERATIONS","BOSTON");
15 
16 --3.创建员工表
17 create table emp
18 (
19    empno int(4) unsigned primary key,
20    ename varchar(10),
21    job varchar(9),
22    mgr int(4),
23    hiredate date,
24    sal double(7,2),
25    comm double(7,2),
26    deptno int(2) references dept(deptno)
27 );
28 
29 --4.插入数据员工数据
30 insert into emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) values
31 (7369,"SMITH","CLERK",7902,"1980-12-17",800,null,20),
32 (7499,"ALLEN","SALESMAN",7698,"1981-02-20",1600,300,30),
33 (7521,"WARD","SALESMAN",7698,"1981-02-22",1250,500,30),
34 (7566,"JONES","MANAGER",7839,"1981-04-02",2975,null,20),
35 (7654,"MARTIN","SALESMAN",7698,"1981-09-28",1250,1400,30),
36 (7698,"BLAKE","MANAGER",7839,"1981-05-01",2850,null,30),
37 (7782,"BLAKE","MANAGER",7839,"1981-06-09",2450,null,10),
38 (7788,"SCOTT","ANALYST",7566,"1987-04-19",3000,null,20),
39 (7839,"KING","PRESIDENT",null,"1981-11-17",5000,null,10),
40 (7844,"TURNER","SALESMAN",7698,"1981-09-08",1500,0,30),
41 (7876,"ADAMS","CLERK",7788,"1987-05-23",1100,null,20),
42 (7900,"JAMES","CLERK",7698,"1981-12-03",950,null,30),
43 (7902,"FORD","ANALYST",7566,"1981-12-03",3000,null,20),
44 (7934,"MILLER","CLERK",7782,"1982-01-23",1300,null,10);
45 
46 
47 --3.员工福利表
48 create table bonus
49 (
50   ename varchar(10),
51   job varchar(9),
52   sal double(7,2),
53   comm double(7,2)
54 );
55 
56 --4.工资等级表
57 create table salgrade
58 (
59    grade int(10),
60    losal double(7,2),
61    hisal double(7,2)
62 );
63 
64 --5.插入工资等级信息
65 insert into salgrade(grade,losal,hisal) values
66 (1,700,1200),
67 (2,1201,1400),
68 (3,1401,2000),
69 (4,2001,3000),
70 (5,3001,9999);