mybatis注解

基本的增删改

@Insert("insert into t_user values(null,#{username},#{password},#{account})")

@Delete(“delete from t_user where pk_id = #{id}”)

@Update(“update t_user set f_username=#{param1} where pk_id=#{param2}”)

简单查询

@Select(“select * from t_user where pk_id=#{id}”)

@Select(“select *from t_user”)

结果集：

@Results(
    value={     @Result(id=true,column=“pk_id”,property=“id”),
    @Result(property=“name”,column=“f_name”)
    }
)

在XML中定义结果集resultMap
@ResultMap(“结果集名字”)

关系映射

• 一对一

  @Result(property=“myHome”,column=“lock_id”,one=@One(select=“com.lovo.mapper.HomeMapper.getHomeByLock”))
  

• 一对多

@Result(property=“keyLst”,column=“lock_id”,many=@Mnay(select=“com.lovo.mapper.KeyMapper.getKeyByLock”))

• 多对多

@Result(property=“courceList”,column=“student_id”,many=@Mnay(select=“com.lovo.mapper.CourceMapper.getCourceByStudent”))