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

朱雀 2022-05-12 15:22 226阅读 0赞

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

表里面的数据如下：

![在这里插入图片描述][70]

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

![在这里插入图片描述][70 1]

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

[70]: /images/20220504/891b86d447f842a2ab1693005c82a535.png
[70 1]: /images/20220504/304e5a3a55234866945b0225f683071d.png