springboot整合mybatis超详细教程

教程"/>

springboot整合mybatis超详细教程

开头一个坑~

关于properties乱码问题，解决办法。。都设置成utf-8

1.准备工作：创建springboot项目或者导入依赖包

这四个是要勾选的或者直接导入依赖包，放到pom.xml下面哦

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

2.创建javabean必须和数据库表对应哦

3.创建mapper

4.创建mapper映射，分别创建mybatis-config.xml和pojo对应的xml

这个是pojo对应的xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapperPUBLIC "-//mybatis//DTD Mapper 3.0//EN"".dtd">
<mapper namespace="com.yto.mapper.EmployeeMapper"><select id="getEmps" resultType="com.yto.entities.Employee">SELECT * FROM employees ;</select><insert id="saveEmp" >INSERT  into employees(lastName,email,gender,department,birth) values (#{lastName},#{email},#{gender},#{department},#{birth})</insert><delete id="delEmp">DELETE from employees where  id=#{id}</delete><select id="findByEmp" resultType="com.yto.entities.Employee">SELECT * FROM employees where id=#{id}</select><update id="updateEmp">UPDATE  employees SET lastName=#{lastName},email=#{email},gender=#{gender},department=#{department},birth=#{birth} where  id=#{id}</update>
</mapper>

这个是mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configurationPUBLIC "-//mybatis//DTD Config 3.0//EN"".dtd">
<configuration><settings><setting name="mapUnderscoreToCamelCase" value="true"/></settings>
</configuration>

5.在application.properties下关联配置属性

mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
mybatis.config-location=classpath:mybatis/mybatis-config.xml

6.在主程序添加扫描

@MapperScan("comcco.mapper")

7.在application.yml配置数据库连接

spring:datasource:
#   数据源基本配置username: rootpassword: 80616059driver-class-name: com.mysql.jdbc.Driverurl: jdbc:mysql://localhost:3306/springboot

8.在这里提供一个完整的pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns=".0.0" xmlns:xsi=""xsi:schemaLocation=".0.0 .0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.atguigu</groupId><artifactId>spring-boot-04-web-restfulcrud</artifactId><version>0.0.1-SNAPSHOT</version><packaging>jar</packaging><name>spring-boot-04-web-restfulcrud</name><description>Demo project for Spring Boot</description><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>1.5.10.RELEASE</version><relativePath/> <!-- lookup parent from repository --></parent><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><java.version>1.8</java.version><thymeleaf.version>3.0.9.RELEASE</thymeleaf.version><!-- 布局功能的支持程序  thymeleaf3主程序  layout2以上版本 --><!-- thymeleaf2   layout1--><thymeleaf-layout-dialect.version>2.2.2</thymeleaf-layout-dialect.version></properties><dependencies><!-- 引入web模块 --><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><!--引入其他的Servlet容器--><!--<dependency><artifactId>spring-boot-starter-undertow</artifactId><groupId>org.springframework.boot</groupId></dependency>--><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-thymeleaf</artifactId></dependency><!--引入jquery-webjar--><dependency><groupId>org.webjars</groupId><artifactId>jquery</artifactId><version>3.3.1</version></dependency><!--引入bootstrap--><dependency><groupId>org.webjars</groupId><artifactId>bootstrap</artifactId><version>4.0.0</version></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-jdbc</artifactId></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>1.3.1</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.1.8</version></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId></plugin></plugins></build></project>