增：

1.insert into table1(field1,field2) values(value1,value2)
2.insert into table1 values(value1,value2)
一般用上一个，如果用下一个的话需要插入的元组要在表的所有属性列上都有指定值。属性列的次序要与其相同。
mybatis：
insert into department(id,department_name) values(#{id},#{departmentName})

删：

delete from table1 where 范围
mybatis：
delete from department where id=#{id}

改：

1.update table1 set field1=value1 where 范围
mybatis：update department set department_name=#{departmentName} where id=#{id}

查：

1.select * from department where 范围
mybatis：
select * from department where id=#{id}

2.select * from table1 where field1 like ’%value1%’ (模糊查询)
mybatis：
select * from department where department_name like#{departmentName}
执行

System.out.println(departmentMapper.getDeptLikeName("A_"));

结果：Department [id=1, departmentName=AA]