Spring Boot整合使用mybatis

Spring Boot整合使用mybatis

pom文件引入

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.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
    </dependencies>

配置文件引入

spring.datasource.url=jdbc:mysql://localhost:3306/springboot
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

User实体类

package com.cc.springboot.entity;

public class UserEntity {

    private int id;
    private String username;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }


}

Mapper代码

package com.cc.springboot.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.cc.springboot.entity.UserEntity;

public interface UserMapper {
    @Select("SELECT * FROM USERS WHERE USERNAME = #{name}")
    UserEntity findByName(@Param("name") String name);
}

Controller类

package com.cc.springboot.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.cc.springboot.entity.UserEntity;
import com.cc.springboot.mapper.UserMapper;

@Controller
public class IndexController {

    @Autowired
    private UserMapper userMapper;

    @ResponseBody
    @RequestMapping("/getUserName")
    public UserEntity getUserName(String name) {
        return userMapper.findByName(name);

    }
}

app类

package com.cc.springboot.app;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.ComponentScan;

@ComponentScan(basePackages = "com.cc.springboot.controller")
@MapperScan(basePackages = "com.cc.springboot.mapper")
@EnableAutoConfiguration
public class App{

    public static void main(String[] args) {
        SpringApplication.run(App.class, args);
    }

}

运行访问：