Mybatis学习之CRUD操作

1、创建数据表

CREATE TABLE `dept` (
  `deptno` int(11) NOT NULL COMMENT '部门编号',
  `dname` varchar(30) NOT NULL COMMENT '部门名称',
  `loc` varchar(50) NOT NULL COMMENT '部门地址',
  PRIMARY KEY (`deptno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

2、定义pojo

public class Dept {
	private int deptno;
	private String dname;
	private String loc;
	public Dept(String dname, String loc) {
		super();	
		this.dname = dname;
		this.loc = loc;
	}
	public Dept() {
		super();
	}
	public int getDeptno() {
		return deptno;
	}
	public void setDeptno(int deptno) {
		this.deptno = deptno;
	}
	public String getDname() {
		return dname;
	}
	public void setDname(String dname) {
		this.dname = dname;
	}
	public String getLoc() {
		return loc;
	}
	public void setLoc(String loc) {
		this.loc = loc;
	}
	@Override
	public String toString() {
		return "Dept [deptno=" + deptno + ", dname=" + dname + ", loc=" + loc
				+ "]";
	}
}

3、在resource目录中创建DeptMapper.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.chenchao.mapper.DeptMapper">
	<!-- 查询所有 -->
	<select id="findAll" resultType="dept">
		select * from dept
	</select>
	
	<!-- 通过id查询 -->
	<select id="findById" parameterType="int" resultType="dept">
		select * from dept where deptno=#{deptno}
	</select>
	
	<!-- 增加，使用selectKey方式，必须在数据库中设置主键自增 
	<insert id="add1" >
		<selectKey keyProperty="deptno" resultType="int" order="BEFORE">
			select LAST_INSERT_ID()
		</selectKey>
		insert into dept(deptno,dname,loc)value(#{deptno},#{dname},#{loc})
	</insert>
	-->
	<!-- 增加，使用useGeneratedKeys，这种方式也必须在数据库中设置主键自增
	<insert id="add1" useGeneratedKeys="true" keyProperty="deptno" parameterType="dept">
		insert into dept(dname,loc)value(#{dname},#{loc})
	</insert>
	 -->
	 <!-- 增加 -->
	 <insert id="add" parameterType="dept">
	 	insert into dept(deptno,dname,loc)value(#{deptno},#{dname},#{loc})
	 </insert>
	 
	 <!-- 删除 -->
	 <delete id="deleteById" parameterType="int">
	 	delete from dept where deptno = #{deptno}
	 </delete>
</mapper>