【springboot学习】集成mybatis

导入依赖

	<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.1.1</version>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>

修改配置文件

spring.datasource.url=jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driverClassName=com.mysql.jdbc.Driver

mybatis.mapper-locations=classpath:mybatis/*.xml
mybatis.type-aliases-package=com.study.FirstSpringBoot.dto

新建实体类

public class School {

	private String name;
	private String telephone;
	private String grade;
	private String sex;

	public String getName() {
		return name;
	}

	public void setName(final String name) {
		this.name = name;
	}

	public String getTelephone() {
		return telephone;
	}

	public void setTelephone(final String telephone) {
		this.telephone = telephone;
	}

	public String getGrade() {
		return grade;
	}

	public void setGrade(final String grade) {
		this.grade = grade;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(final String sex) {
		this.sex = sex;
	}

}

新建SchoolMapper和对应的xml文件。

@Mapper
public interface SchoolMapper {

	void insert(School school);
}

<?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.study.FirstSpringBoot.dao.SchoolMapper">

  <insert id="insert" parameterType="com.study.FirstSpringBoot.dto.School">
  	insert into student(name,telephone,grade,sex) values(
  		#{name},#{telephone},#{grade},#{sex}
  	)
  </insert>
</mapper>

实现sevice层

@Service
public class SchoolService {

	@Autowired
	SchoolMapper mapper;

	public void insert() {
		School school = new School();
		school.setGrade("1");
		school.setName("lis");
		school.setSex("n");
		school.setTelephone("1111111111");
		mapper.insert(school);
	}
}

测试schoolService

@SpringBootTest
@RunWith(SpringJUnit4ClassRunner.class)
public class SchoolServiceTest {

	@Autowired
	SchoolService schoolService;

	@Test
	public void testInsert() {
		schoolService.insert();
	}

}

ok,成功了