mybatis学习（一）

创建数据访问接口

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>