SpringBoot整合Mybatis

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/sms?serverTimezone=UTC
    username: root
    password: 123123

数据库配置

mapper(注解的方式)

package com.cuit.springbootmybatis.mapper;

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

@Mapper  //指定这是一个操作数据库的mapper
public interface Departmentmapper {
    @Select("select name from jduser where id=#{id}")
    public String getNameById(Integer id);


}

controller:

@Controller
public class mybatiscontroller {

    @Autowired
    Departmentmapper departmentmapper;
    @ResponseBody
    @RequestMapping("/getname")
    public String getname(@RequestParam("id") Integer id) {
        return departmentmapper.getNameById(id);
    }
}

 

直接是写一个mapper的接口然后  在controller中自动注入这个接口  然后在相关的方法中调用这个接口中的方法就是了

 

 

下划线命名转驼峰命名

@Configuration
public class configura {
    @Bean
    public ConfigurationCustomizer configurationCustomizer() {
        return new ConfigurationCustomizer() {
            @Override
            public void customize(org.apache.ibatis.session.Configuration configuration) {
                configuration.setMapUnderscoreToCamelCase(true);
            }
        };
    }
}

配置文件版本

核心就是要在springboot的配置文件中有这个