Just use mybatis-spring-boot-starter. Simply put, mybatis saw that spring boot is so popular, so I came up with the mybatis-spring-boot-starter solution to better integrate with springboot.
See details
http://www.mybatis.org/spring/zh/index.html
Introduce mybatis-spring-boot-starter pom file
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency>
application.properties Add related configuration
spring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/city?useUnicode=true&characterEncoding=utf-8spring.datasource.username = rootspring.datasource.password = mysql
Springboot will automatically load the relevant configuration of spring.datasource.*, and the data source will be automatically injected into the sqlSessionFactory. The sqlSessionFactory will be automatically injected into the mapper. By the way, you don’t have to worry about everything, just pick it up and use it.
mybatis.type-aliases-package=com.test.demo.model
This configuration is used to specify which package the bean is in, so as to avoid the bean not being found when the class with the same name exists
Add @MapperScan to the startup class to specify the location of dao or mapper package. You can specify multiple packages in the form of {"","}
@SpringBootApplication@MapperScan("com.test.demo.dao")public class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); }}Or you can also specify mapper by adding annotation to the Mapper class. It is recommended to use the above. It is very troublesome to add annotation to each mapper. If it is a dao package, you should still use @MapperScan to specify the location.
Next, you can use the annotation mode to develop mapper, or use the xml mode to develop
Annotation mode
@Mapperpublic interface CityMapper { @Select("select * from city where state = #{state}") City findByState(@Param("state") String state);}@Select is an annotation of the query class. All queries use this @Result to modify the result set returned, and the associated entity class attributes and database fields correspond one by one. If the entity class attributes and database attribute names are consistent, this attribute is not needed to modify. @Insert is inserted into the database for use. Directly passing into the entity class will automatically parse the attribute to the corresponding value @Update is responsible for modifying it, or you can directly pass into the object @delete is responsible for deleting it for more annotations. Refer to here
http://www.mybatis.org/mybatis-3/zh/java-api.html
xml mode
The xml pattern maintains the old tradition of mapping files, and application.properties needs to be added
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
Specify the mapping xml file location of mybatis. In addition, you can also specify the configuration file of mybatis. If you need to add some basic configuration of mybatis, you can add the following configuration.
mybatis.config-locations=classpath:mybatis/mybatis-config.xml
Specify the mybatis basic configuration file
mybatis-config.xml can add some basic configurations of mybatis, for example
<configuration> <typeAliases> <typeAlias alias="Integer" type="java.lang.Integer" /> <typeAlias alias="Long" type="java.lang.Long" /> <typeAlias alias="HashMap" type="java.util.HashMap" /> <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" /> <typeAlias alias="ArrayList" type="java.util.ArrayList" /> <typeAlias alias="LinkedList" type="java.util.LinkedList" /> </typeAliases></configuration>
Writing Dao layer code
public interface CityDao { public City selectCityByState(String State);}The corresponding xml mapping file
<!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.test.demo.dao.CityDao"> <select id="selectCityByState" parameterType="String" resultType="City"> select * from city where state = #{state} </select></mapper> Summarize
The above is the method of using mybatis under springboot introduced to you. I hope it will be helpful to everyone!