MyBatis学习 之 一、MyBatis简介与配置MyBatis+Spring+MySql
/* 建立数据库 */CREATE DATABASE STUDENT_MANAGER;USE STUDENT_MANAGER;/***** 建立student表 *****/CREATE TABLE STUDENT_TBL( STUDENT_ID VARCHAR(255) PRIMARY KEY, STUDENT_NAME VARCHAR(10) NOT NULL, STUDENT_SEX VARCHAR(10), STUDENT_BIRTHDAY DATE, CLASS_ID VARCHAR(255));/*插入学生数据*/INSERT INTO STUDENT_TBL (STUDENT_ID, STUDENT_NAME, STUDENT_SEX, STUDENT_BIRTHDAY, CLASS_ID) VALUES (123456, '某某某', '女', '1980-08-01', 121546 )
创建连接MySql使用的配置文件mysql.properties。
jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/student_manager?user=root&password=limingnihao&useUnicode=true&characterEncoding=UTF-8
顺序随便，现在的顺序是因为可以尽量的少的修改写好的文件。
public class StudentEntity implements Serializable {private static final long serialVersionUID = 3096154202413606831L;private ClassEntity classEntity;private Date studentBirthday;private String studentID;private String studentName;private String studentSex;public ClassEntity getClassEntity() {return classEntity;}public Date getStudentBirthday() {return studentBirthday;}public String getStudentID() {return studentID;}public String getStudentName() {return studentName;}public String getStudentSex() {return studentSex;}public void setClassEntity(ClassEntity classEntity) {this.classEntity = classEntity;}public void setStudentBirthday(Date studentBirthday) {this.studentBirthday = studentBirthday;}public void setStudentID(String studentID) {this.studentID = studentID;}public void setStudentName(String studentName) {this.studentName = studentName;}public void setStudentSex(String studentSex) {this.studentSex = studentSex;}}
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);}
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 STWHERE ST.STUDENT_ID = #{studentID} ]]> </select><!-- 查询学生列表 --><select id="getStudentAll" resultType="com.manager.data.model.StudentEntity" resultMap="studentResultMap"><![CDATA[SELECT * from STUDENT_TBL]]> </select></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>
主要是添加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>
也可以不定义mapper的bean，使用注解：
将StudentMapper加入注解
@Repository@Transactionalpublic interface StudentMapper {}
对应的需要在dispatcher-servlet.xml中加入扫描：
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="annotationClass" value="org.springframework.stereotype.Repository"/> <property name="basePackage" value="com.liming.manager"/> <property name="sqlSessionFactory" ref="sqlSessionFactory"/> </bean>
1.2.4测试StudentMapper
使用SpringMVC测试，创建一个TestController，配置tomcat，访问index.do页面进行测试：
@Controllerpublic class TestController {@Autowiredprivate StudentMapper studentMapper;@RequestMapping(value = "index.do")public void indexPage() {StudentEntity entity = studentMapper.getStudent("10000013");System.out.println("name：" + entity.getStudentName());}}
使用Junit测试：
使用Junit测试：Java代码@RunWith(value = SpringJUnit4ClassRunner.class)@ContextConfiguration(value = "test-servlet.xml")public class StudentMapperTest {@Autowiredprivate ClassMapper classMapper;@Autowiredprivate StudentMapper studentMapper;@Transactionalpublic void getStudentTest(){StudentEntity entity = studentMapper.getStudent("10000013");System.out.println("" + entity.getStudentID() + entity.getStudentName());List<StudentEntity> studentList = studentMapper.getStudentAll();for( StudentEntity entityTemp : studentList){System.out.println(entityTemp.getStudentName());}}}
MyBatis学习 之 一、MyBatis简介与配置MyBatis+Spring+MySql
MyBatis学习 之 二、SQL语句映射文件(1)resultMap
MyBatis学习 之 二、SQL语句映射文件(2)增删改查、参数、缓存
MyBatis学习 之 三、动态SQL语句
MyBatis学习 之 四、MyBatis配置文件