SpringBoot

1.SprigBoot集成Mybatis

1 添加Mybatis的起步依赖

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

2.在application.properties中添加数据库的连接信息

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test? useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root

3. 编写Mapper

@Mapper 
public interface UserMapper { 
	public List<User> queryUserList(); 
}

4.配置Mapper映射文件
在src\main\resources\mapper路径下加入UserMapper.xml配置文件"

<?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.itheima.mapper.UserMapper"> 
	<select id="queryUserList" resultType="user"> 
		select * from user 
	</select> 
</mapper>

5.在application.properties中添加mybatis的信息

#spring集成Mybatis环境 
#pojo别名扫描包 
mybatis.type-aliases-package=com.itheima.domain 
#加载Mybatis映射文件 
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

6.编写测试Controller

@Controller 
public class MapperController { 
	@Autowired 
	private UserMapper userMapper; 
	@RequestMapping("/queryUser") 
	@ResponseBody 
	public List<User> queryUser(){ 
		List<User> users = userMapper.queryUserList(); 
		return users; 
	} 
}