mybatis使用注解开发
@Select 就是mapper里面的<select></select>
@Results 相当于<resultMap></resultMap>
@Result 相当于resultMap的字标签result 同时它的属性id是一个Boolean类型的值,如果为true,那么这个字段就是表的id,如果为false,那就是普通字段
@Select("select * from userinfo") @Results(id = "userMap",value = { @Result(id = true,property = "userId",column = "userId"), @Result(property = "username",column = "username"), @Result(property = "realName",column = "realName"), @Result(property = "sex",column = "sex"), @Result(property = "age",column = "age"), @Result(property = "accounts",column = "userId",many = @Many( select = "com.zh.dao.AccountMapper.findAccountById", fetchType = FetchType.LAZY )) }) List<User> findAll(); @Select("select * from userinfo where userId=#{userId}") User findById(Integer userId);