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>