StringBoot 整合Mybatis
1.SpringBoot 简介
1.1 Spring Team在现有Spring框架的基础上发布了一个创新的框架：Spring Boot。
1.2 Spring Boot的开发团队是：PivotalSpring Boot的主要作用是：简化开发，减少配置（简化配置和部署spring应用程序的过程）。
1.3 Spring Boot框架提倡：一键部署、习惯优于配置Spring Boot还是一个微框架，它与目1.4 前流行的微服务紧密联系，可以开发微应用。
2.引入依赖
<!-- 引入Mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- 引入Mysql依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.44</version>
</dependency>
<!-- 导入数据源C3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.1</version>
</dependency>
<!-- spring Mybatis 整合包 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
3.配置数据源，和加载Mybatis配置
3.1.在application.properties中配置数据源
#配置数据源
spring.datasource.url=jdbc:mysql://localhost:3306/llmjsh
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root
# 加载mybatis 配置
mybatis.mapper-locations=classpath:mapper/*.xml
mybatis.config-location=classpath:mybatis/mybatis-config.xml
比如这样！！！
4.在 src/main/resources 下创建 mybatis 文件夹，并在 mybatis 文件夹中创建 “mybatis-config.xml” 配置文件，内容如下：
<?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>
<settings>
<!-- 获取数据库自增主键值 -->
<setting name="useGeneratedKeys" value="true"/>
<!-- 使用列别名替换列名，默认为 true -->
<setting name="useColumnLabel" value="true"/>
<!-- 开启驼峰命名转换：Table(create_time) => Entity(createTime) -->
<setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
</configuration>
5.创建数据库
5.创建实体类
此处省略get，set
public class Student implements Serializable {
private int uid;
private String name;
private String sex;
private String age;
private String address;
}
6.创建dao接口
public interface Studentdao {
Student studentAll();
}
7.创建Service
public interface StudentService { Student studentAll();
}
8.创建ServiceImpl 实现类
@Service("studentService")
public class StudentServiceImpl implements StudentService{
@Resource
private Studentdao studentdao;
@Override
public Student studentAll() {
return studentdao.studentAll();
}
}
7.创建StudentMapper.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.llmjsh.springboot1.dao.Studentdao">
<select id="studentAll" resultType="com.llmjsh.springboot1.pojo.Student">
select * from tb_Student
</select>
</mapper>
8.在controller中调用
@Controller
public class StudentController {
@Resource
private StudentServiceImpl studentService;
@RequestMapping(value = "/hello",produces="text/html;charset=UTF-8")
@ResponseBody
public Student Test(){
Student students = studentService.studentAll();
System.out.println(students);
return students;
}
}