mybatis学习（一）

来源：互联网发布：淘宝旺旺客服电话编辑：程序博客网时间：2024/05/19 04:29

创建数据访问接口

Student类对应的dao接口：StudentMapper。

public interface StudentMapper {          public StudentEntity getStudent(String studentID);          public StudentEntity getStudentAndClass(String studentID);          public List<StudentEntity> getStudentAll();          public void insertStudent(StudentEntity entity);          public void deleteStudent(StudentEntity entity);          public void updateStudent(StudentEntity entity); }

创建SQL映射语句文件

Student类的sql语句文件StudentMapper.xml
resultMap标签：表字段与属性的映射。

Select标签：查询sql。

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.manager.data.StudentMapper">      <resultMap type="StudentEntity" id="studentResultMap">         <id property="studentID" column="STUDENT_ID"/>         <result property="studentName" column="STUDENT_NAME"/>         <result property="studentSex" column="STUDENT_SEX"/>         <result property="studentBirthday" column="STUDENT_BIRTHDAY"/>     </resultMap>          <!-- 查询学生，根据id -->     <select id="getStudent" parameterType="String" resultType="StudentEntity" resultMap="studentResultMap">         <![CDATA[            SELECT * from STUDENT_TBL ST                WHERE ST.STUDENT_ID = #{studentID}         ]]>      </select>          <!-- 查询学生列表 -->     <select id="getStudentAll"  resultType="com.manager.data.model.StudentEntity" resultMap="studentResultMap">         <![CDATA[            SELECT * from STUDENT_TBL        ]]>      </select>      </mapper>

创建MyBatis的mapper配置文件
在src/main/resource中创建MyBatis配置文件：mybatis-config.xml。
typeAliases标签：给类起一个别名。com.manager.data.model.StudentEntity类，可以使用StudentEntity代替。
Mappers标签：加载MyBatis中实体类的SQL映射语句文件。

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration>     <typeAliases>         <typeAlias alias="StudentEntity" type="com.manager.data.model.StudentEntity"/>     </typeAliases>     <mappers>         <mapper resource="com/manager/data/maps/StudentMapper.xml" />     </mappers> </configuration>

修改Spring 的配置文件
主要是添加SqlSession的制作工厂类的bean：SqlSessionFactoryBean，（在mybatis.spring包中）。需要指定配置文件位置和dataSource。
和数据访问接口对应的实现bean。通过MapperFactoryBean创建出来。需要执行接口类全称和SqlSession工厂bean的引用。

<!-- 导入属性配置文件 --> <context:property-placeholder location="classpath:mysql.properties" />  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">     <property name="driverClassName" value="${jdbc.driverClassName}" />     <property name="url" value="${jdbc.url}" /> </bean>  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">     <property name="dataSource" ref="dataSource" /> </bean>  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">     <property name="configLocation" value="classpath:mybatis-config.xml" />     <property name="dataSource" ref="dataSource" /> </bean>  <!— mapper bean --> <bean id="studentMapper" class="org.mybatis.spring.MapperFactoryBean">     <property name="mapperInterface" value="com.manager.data.StudentMapper" />     <property name="sqlSessionFactory" ref="sqlSessionFactory" /> </bean>

0 0