Mybatis源码分析(七) - 注解方式配置

@Results(id="jobInfo",value={
            @Result(property="id",column="id",id = true),
            @Result(property="userId",column="user_id"),
            @Result(property="compName",column="comp_name"),
            @Result(property="years",column="years"),
            @Result(property="title",column="title")
    })
    @Select("select id, user_id, comp_name, years, title from t_job_history"
            + " where user_id = #{userId}")
    List selectByUserId(int userId);
    
    @ResultMap("jobInfo")
    @Select("select id, user_id, comp_name, years, title from t_job_history")
    List selectAll();
    
    @Insert("insert into t_job_history (id, user_id, comp_name, years, title)"
            + " values (#{id,jdbcType=INTEGER}, #{userId,jdbcType=INTEGER},"
            + "#{compName,jdbcType=VARCHAR},"
            + "#{years,jdbcType=INTEGER}, #{title,jdbcType=VARCHAR})")
    @Options(useGeneratedKeys=true,keyProperty="id")
    int insert(TJobHistory record);

@Test
  // 注解测试
  public void testAnno() {
    // 2.获取sqlSession
    SqlSession sqlSession = sqlSessionFactory.openSession();
    // 3.获取对应mapper
    TJobHistoryAnnoMapper mapper = sqlSession.getMapper(TJobHistoryAnnoMapper.class);
    
    List list = mapper.selectByUserId(1);
    System.out.println(list.size());
    
    List listAll = mapper.selectAll();
    System.out.println(listAll.size());
    
    TJobHistory job = new TJobHistory();
    job.setTitle("产品经理");
    job.setUserId(1);
    job.setCompName("美团");
    job.setYears(3);
    
    mapper.insert(job);
    System.out.println(job.getId());
  }