mybatis中常用注解标签

常用注解标签：

注解	标签	说明
@Insert	insert	添加操作
@Select	select	查询操作
@Update	update	更新操作
@Delete	delete	删除操作
@Param		入参，eg：Admin find(@Param("column") String column);
@Results	resultMap	封装结果集，与@Result一起使用，@Results({@Result()，@Result()})或@Results(@Result())
@Result	result	结果集中表字段与类属性映射
@One	association	一个结果，@Result属性one的赋值，@Result(one=@One(select=“查询方法的全路径”))
@Many	collection	多个结果，@Result属性many的赋值，@Result(many=@Many(select=“查询方法的全路径”))

使用案例

查询所有信息

@Select("select * from t_emp")
@Results(id = "empMap",
         value = {@Result(column = "emp_id",property = "empId",id = true), 
                  @Result(column = "emp_name",property = "empName"), 
                  @Result(column = "emp_tel",property = "empTel"), 
                  @Result(column = "emp_education",property = "empEducation"),                             @Result(column = "emp_birthday",property = "empBirthday")})
List<Employee> getAll()

查询单个信息

@Select("select num,name from student where id = #{id}")
Student findStudent(int id);

删除信息

@Delete("delete from student where id = #{id}")
void deleteStudent(int id);

更新信息

@Update("update student set num = 1003 where id = #{id}")
void updateState(int id);

插入信息

@Insert("insert into t_emp (emp_id,emp_name,emp_tel,"+"emp_education,emp_birthday, fk_dept_id"+")"
       values (#{empId},#{empName},#{empTel},"+"#{empEducation},#{empBirthday},#   {fkDeptId}"+")")
int insert(Employee record)