1. springboot连接mysql数据库,不需要通过xml文件配置,xml文件配置是spring的事。
2. 添加maven依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.33</version>
</dependency><!-- 数据库驱动 -->
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.21.0.1</version>
</dependency> <!-- 数据库驱动 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.16</version>
</dependency> <!-- 连接池 -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>3.0.2</version> <!-- 持久层 -->
</dependency>
3. 配置文件 application.yaml
server:
port: 8080
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/dbone?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
4. DBMapper类实现,只需要定义接口文件,编译时@Mapper自动生成实体类。
package com.example.dbtest.mapper;
import com.example.dbtest.entity.Users;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface DBMapper {
@Select("SELECT id,username,password FROM users")
List<Users> select_users(String username);
@Select("SELECT password FROM users where username=#{username}")
String find_users(String username);
@Select("SELECT id,name,age,address FROM test")
List<Users> findAll();
@Select("select * from test where id=#{id}")
Users getById(int id);
@Insert("insert into test(id,name,age,address) values(#{id},#{name},#{age},#{address})")
int add(Users tab);
@Update("update test set name=#{name},age=#{age},address=#{address} where id=#{id}")
int update(Users tab);
@Delete("delete from test where id=#{id}")
int deleteById(int id);
}
5. 使用时调用:
@Resource
private DBMapper dbMapper;
String pwd = dbMapper.find_users(username);