SpringBoot整合Mybatis,简单明了

SpringBoot整合Mybatis --->Maven

1.在pom.xml里面加入配置导入Mybatis mysql的jar

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

2.启动类

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;


/**
 * Hello world!
 *
 */
@RestController
@SpringBootApplication
@MapperScan("com.demo.dao")//扫描dao层即为mapper层
@ComponentScan({ //ComponentScan 扫描其他注解类
"com.demo.controller",
"com.demo.exceptionhandler", 
"com.demo.service"})


public class App 
{
    public static void main( String[] args )
    {
        System.out.println( "Hello World!" );
        SpringApplication.run(App.class, args);
    }
    @RequestMapping("/hello")
    public String Hello(){
return "Hello Word"; 
    }
}

2.Dao层

import java.util.List;     
import com.demo.entity.User;  
public interface UserDao { 
   public List<User> getUser();
}

3.Service层

import java.util.List; 
import com.demo.entity.User; 
public interface UserService {
  List<User>  getuser();
}

4.Service层的实现

import java.util.List;  
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;  
import com.demo.dao.UserDao; 
import com.demo.entity.User;
import com.demo.service.UserService;
@Service("userService")
public class UserServiceImp implements UserService{
    @Autowired
    private UserDao userDao;
public List<User> getuser() { 
return userDao.getUser();
}
   
}

5.实体类 User

public class User {
   private String id;
   private String name;
   private String username;
   private String password;
   private String createtime;
   private String updatetime;
   private String nickname;
   private String description;
   private String email;

  get set省略...............

}

6.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.demo.dao.UserDao"> 
   <resultMap id="UserMap" type="com.demo.entity.User" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="username" property="username" jdbcType="VARCHAR" />
    <result column="password" property="password" jdbcType="VARCHAR" />
    <result column="createtime" property="createtime" jdbcType="VARCHAR" />
    <result column="updatetime" property="updatetime" jdbcType="VARCHAR" />
    <result column="nickname" property="nickname" jdbcType="VARCHAR" />
    <result column="description" property="description" jdbcType="VARCHAR" />
    <result column="email" property="email" jdbcType="VARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
     name, username, password,  createtime, updatetime, nickname, description, email
  </sql>
  <select id="getUser" resultMap="UserMap">
     select id,
     <include refid="Base_Column_List" />
      from User
  </select>
</mapper>

7.application.yml 文件的配置

server:
   port: 8090
   context-path: /demo1
spring:
   datasource:
        name: com.mysql.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/test
        username: root
        password: 123456
mybatis: 
   mapper-locations: classpath:mapper/UserMapper.xml 

目录结构:

如果你按照上面的未能完成简单的整合

下载地址:http://download.csdn.net/download/qq_38425662/10200452

下载地址里面的Demo，亲测可用

访问的时候:可以看到最下面输出了User数据表里面的两条数据