1. 引入所需依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.2.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.30</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.15</version>
</dependency>
(1)mybatis集成包
(2)mysql连接池
(3)阿里数据库连接池
2. application.properties添加数据库配置源
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/database?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false&serverTimezone=UTC
spring.datasource.username=username
spring.datasource.password=password
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
为了myBatis和domain的实体字段对应,需要加上下述配置(下划线转驼峰)
mybatis.configuration.map-underscore-to-camel-case=true
3. 测试一下
新建实体类
@Getter
@Setter
@ToString
public class SmUser {
/**用户id*/
private String id;
/**登录名*/
private String loginName;
/**密码*/
private String password;
/**用户名*/
private String userName;
/**用户状态*/
private String userStatus;
}
新建接口Dao——注意需要在接口上加上@Mapper注解,或者在启动类App上加上@MapperScan注解,扫描Dao层的包路径即可
@Mapper
public interface SmUserDao {
@Select("select * from sm_user where login_name=#{loginName}")
List<SmUser> getByLoginName(String loginName);
}
新增Controller方法
@Controller
public class TestController {
@Autowired
private SmUserDao userDao;
@RequestMapping("/user")
@ResponseBody
public List<SmUser> user() {
return userDao.getByLoginName("zhangsan");
}
}
结果: