SpringBoot操作数据库------Mybatis

1.首先用idea 新建一个带web的SpringBoot应用

2.在maven的pom.xml中添加mybatis 的依赖，使用的数据库是mysql

	<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>
            <version>5.1.6</version>
        </dependency>
        

然后在application.properties文件中添加数据库的相关的属性

spring.datasource.driver-class-name= com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = ABC2345

表里面的数据如下：

3.新建一个Mapper接口

为了简化，直接使用注解来解决

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

import java.util.List;
import java.util.Map;

@Mapper
public interface TestMapper {

    @Select("select * from stu")
    List<Map<String,String>> getASAll()throws Exception;
}

4.新建一个controller，直接调用Mapper

import com.example.demo.mapper.TestMapper;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;

@RestController
public class MybatisTests {


    @Resource
    private TestMapper testMapper;

    @RequestMapping("/test")
    public String testMybatis(){

        try {
            List<Map<String,String>> result=testMapper.getASAll();
            
            for(Map item:result){
                System.out.println(item.get("userName")+","+item.get("password"));
            }


        } catch (Exception e) {
            e.printStackTrace();
        }

        return "ok";
    }
}

项目启动后打开浏览器访问127.0.0.1:8080/test

可以看到数据被成功的读取了