sm(spring+mybatis)注释版的整合

1.导入所需的包 
2.mybatis配置文档与spring整合 
（1）数据源的配置：

<!-- <properties resource="db.properties">
    </properties> -->
<!-- <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />

            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driverClassName}" />
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}" />
                <property name="password" value="${jdbc.password}" />
            </dataSource>
        </environment>
    </environments> -->
<!-- 将包名下的映射文件下所有xml导入 ， 也可以单个添加 -->
    <!-- <mappers>
        <package name="mybatis.mapper"/>
    </mappers> -->

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18

变成：

@Configuration  //beans
@ComponentScan("mybatis")  //component
@EnableTransactionManagement  //事务  
@PropertySource("db.properties")  //引入properties文件
@MapperScan("mybatis.mapper")   //扫描具体xml UserMapper.xml
//工厂配置
@Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setConfigLocation(new ClassPathResource("mybatis-config.xml"));
        factoryBean.setDataSource(dataSource);
        return factoryBean;
    }
    //数据源
    @Bean                       // 依赖Environment
    public DataSource dataSource(Environment env) {
        DriverManagerDataSource ds = new DriverManagerDataSource();
        // env.getProperty("someKey") 获得属性值
        ds.setDriverClassName(env.getProperty("jdbc.driverClassName"));
        ds.setUrl(env.getProperty("jdbc.url"));
        ds.setUsername(env.getProperty("jdbc.username"));
        ds.setPassword(env.getProperty("jdbc.password"));
        return ds;
    }

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24

3.具体配置文件：

<mapper namespace="mybatis.mapper.BlogMapper">

    <!-- one2one -->
    <select id="findByID" resultMap="blogid">
        select b.id blog_id,a.id author_id,b.title blog_title,a.name author_name 
        from author a inner join blog b 
        on a.id = b.id 
        where b.id = #{id}
    </select>

    <resultMap type="Blog" id="blogid">
        <id property="id" column="blog_id"/>
        <result property="title" column="blog_title"/>
        <!-- 链接另外一张表（一对一） -->
        <association property="author" javaType="Author">
            <id property="id" column="author_id"/>
            <result property="name" column="author_name"/>
        </association>
    </resultMap>

    <!-- one2many -->

    <select id="findByID2" resultMap="blogid2">
        select b.id blog_id,b.title blog_title,
          a.id author_id,a.name author_name ,
          p.subject post_subject,p.id post_id
        from author a inner join blog b 
        on b.id = a.blog_id 
        left join post p
        on b.id = p.blog_id
        where b.id = #{id}
    </select>

    <resultMap type="Blog" id="blogid2">
        <id property="id" column="blog_id"/>
        <result property="title" column="blog_title"/>
        <association property="author" javaType="Author">
            <id property="id" column="author_id"/>
            <result property="name" column="author_name"/>
        </association>
        <!-- collection（ofType）一对多  类型也不同余association（javaType） -->
        <collection property="postlist" ofType="Post">
            <id property="id" column="post_id"/>
            <result property="subject" column="post_subject"/>
        </collection>
    </resultMap>


    <select id="findByID3" resultMap="blogid3">
        select b.id blog_id,b.title blog_title,
          a.id author_id,a.name author_name ,
          p.subject post_subject,p.id post_id,
          c.id comment_id,c.content comment_content
        from author a inner join blog b 
        on b.id = a.blog_id 
        left join post p
        on b.id = p.blog_id
        left join comment c
        on c.post_id = p.id
        where b.id = #{id}
    </select>

    <resultMap type="Blog" id="blogid3">
        <id property="id" column="blog_id"/>
        <result property="title" column="blog_title"/>
        <!-- <association property="author" javaType="Author">
            <id property="id" column="author_id"/>
            <result property="name" column="author_name"/>
        </association> -->
        <association property="author" resultMap="authorResult"></association>

        <collection property="postlist" ofType="Post">
            <id property="id" column="post_id"/>
            <result property="subject" column="post_subject"/>

            <collection property="commentlist" ofType="Comment">
            <id property="id" column="comment_id"/>
            <result property="content" column="comment_content"/>
            </collection>

        </collection>

    </resultMap>

    <!-- 对于相同的链接另外一张表  可进行抽取， 但是限制了别名格式  列如：column="author_id"  column="author_name" -->
    <resultMap type="Author" id="authorResult">
        <id property="id" column="author_id" />     
        <result property="name" column="author_name"/>  
    </resultMap>
</mapper>

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• 51
• 52
• 53
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• 71
• 72
• 73
• 74
• 75
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• 86
• 87
• 88
• 89
• 90
• 91

4.BlogMapper —>dao 没有具体的实现类，只有接口，具体实现都写在BlogMapper.xml中的具体sql语句了，执行方法被Mybatis封装了

public interface BlogMapper {
    //one2one
    Blog findByID(Long id);
    //one2many
    Blog findByID2(Long id);
    Blog findByID3(Long id);
}

• 1
• 2
• 3
• 4
• 5
• 6
• 7

5.关于带参数的crud，mybatis只接受一个参数，基本类型一个，类类型，map类型。当多个参数时，应该用代码封装成集合，或者注释@Param

相比于xml整合的简单很多。还是推荐xml,熟悉了解各个部分的作用，注释来的简单，容易忘记