Mybatis

1.导入jar包

<!-- 导入mybatis 文件 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.2.1</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis-spring</artifactId>
        <version>1.1.1</version>
    </dependency>

2.配置文件

//标配，连接池
<bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:127.0.0.1:1521:orcl"/>
    <property name="username" value="scott"/>
    <property name="password" value="tiger"/>
</bean>

//mybatis独有配置sqlSessionFactory
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="datasource"/>
    //配置presistence对应的xml文件，代表presistence下的所有xml
    <property name="mapperLocations" value="classpath*:cn/hzy/presistence/**/*.xml"/>
</bean>

//mybatis独有配置mapper
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    //代表src下的presostence包开始下
    <property name="basePackage" value="cn.hzy.presistence"></property>
    //注意这里的值为sqlSessionFactory而不是ref
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>

//基本配置，配置事务
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="datasource"/>
</bean>

//基本配置
<tx:annotation-driven transaction-manager="transactionManager"/>

3.presistence层写法：

@Repository
public interface EmpPresistence {

    public List<Emp> queryAll();

    public void save(Emp emp);

    public void update(Emp emp);

    public void delete(Integer empno);
}

Mybatis这种配置方法无需写实现类

4.mapper.xml文件写法

<mapper namespace="cn.hzy.presistence.EmpPresistence">

    <resultMap type="cn.hzy.entity.Emp" id="emps">
        <id property="empno" column="empno" />
        <result property="ename" column="ename" />
        <result property="job" column="job" />
        <result property="mgr" column="mgr" />
        <result property="hiredate" column="hiredate" />
        <result property="sal" column="sal" />
        <result property="comm" column="comm" />
        <collection property="dept" column="deptno" select="cn.hzy.presistence.DeptPresistence.queryDeptByDeptno"></collection>
    </resultMap>

    <select id="queryAll" resultMap="emps">
        select * from emp order by empno
    </select>

    <insert id="save" parameterType="cn.hzy.entity.Emp">
        insert into emp values (e_sql.nextval,#{ename},#{job},#{mgr},#{hiredate},#{sal},#{comm},#{dept.deptno})
    </insert>

    <update id="update" parameterType="cn.hzy.entity.Emp">
        update emp set ename = #{ename},job=#{job},mgr=#{mgr},hiredate=#{hiredate},sal=#{sal},comm=#{comm},deptno=#{dept.deptno} where empno = #{empno}
    </update>

    <delete id="delete" parameterType="int">
        delete from emp where empno = #{empno}
    </delete>
</mapper>