springboot整合mybatis

1.导入依赖

<parent>

          <groupId>org.springframework.boot</groupId>

          <artifactId>spring-boot-starter-parent</artifactId>

          <version>1.3.2.RELEASE</version>

          <relativePath /> <!-- lookup parent from repository -->

     </parent>

     <dependencies>

          <dependency>

               <groupId>org.springframework.boot</groupId>

               <artifactId>spring-boot-starter</artifactId>

          </dependency>

          <!-- 单元测试 -->

          <dependency>

               <groupId>org.springframework.boot</groupId>

               <artifactId>spring-boot-starter-test</artifactId>

               <scope>test</scope>

          </dependency>

          <!-- mybaties -->

          <dependency>

               <groupId>org.mybatis.spring.boot</groupId>

               <artifactId>mybatis-spring-boot-starter</artifactId>

               <version>1.1.1</version>

          </dependency>

          <!-- mysql驱动 -->

          <dependency>

               <groupId>mysql</groupId>

               <artifactId>mysql-connector-java</artifactId>

          </dependency>

          <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId>

               </dependency>

     </dependencies>

 

2.数据库配置文件

接口加注解形式：

3.写Mapper

接口加Mapper.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.zsk.mapper.UserMapper" >     <insert id="save">         insert into t_user (username,password) VALUES(#{0},#{1})     </insert>     <select id="findByUsername" resultType="com.zsk.model.User" parameterType="string">       select * from t_user where username = #{username,jdbcType=VARCHAR}     </select> </mapper>

注意：如果是配置xml文件，则需要在pom中添加一下代码，这样编译的时候classpath路径下才会有这个xml文件 <build>   <resources>     <resource>       <directory>src/main/java</directory>       <includes>         <include>**/*.xml</include>       </includes>     </resource>   </resources> </build>   4.一层层调用方法，从dao层到web层这里就不演示了 5.在App应用启动类中配置 三个注解: @ComponentScan(basePackages={"com.abc.controller"})    //扫描控制器 @MapperScan(basePackages={"com.abc.mapper"})      //扫描mapper接口 @EnableAutoConfiguration                                                     //自动配置spring文件 6.最后在应用类中启动一下就行了