1、bean.xml配置文件
<!--mapper配置 创建数据映射器,数据映射器必须为接口 --> <bean id="mybatisMapper" class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="mybatis.mybatisAndSpring.dao.mybatisMapper"/> <property name="sqlSessionFactory" ref="sqlSessionFactory"/> </bean>
2、接口类:
package mybatis.mybatisAndSpring.dao; import mybatis.mybatisAndSpring.pojo.Person; /** * Created by yp-tc-m-2935 on 18/4/2. */ public interface mybatisMapper { public Person findPersonById(int id) throws Exception; }
3、mybatis配置文件
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD iBatis Mapper 3.0 //EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd"> <mapper namespace="Liujin"> <select id="findPersonById" parameterType="int" resultType="Person"> SELECT * FROM DB2INST.TBL_P WHERE ID = #{id} </select> </mapper>