目录
2.添加druid和springboot的整合依赖和lombok的整合依赖
1.项目搭建
新建一个module,勾选以下三个
创建好后需要额外修改一下pom文件
1.修改pom中log4j的配置
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<exclusions><!--spring自带的日志框架-->
<exclusion>
<artifactId>spring-boot-starter-logging</artifactId>
<groupId>org.springframework.boot</groupId>
</exclusion>
</exclusions>
</dependency>
<!--引入log4j2-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-log4j2</artifactId>
</dependency>
2.添加druid和springboot的整合依赖和lombok的整合依赖
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.18</version>
</dependency>
3.完整pom如下
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.7.14</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<packaging>pom</packaging>
<groupId>com.jhy</groupId>
<artifactId>springboot</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>springboot</name>
<description>springboot</description>
<properties>
<java.version>11</java.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<exclusions><!--spring自带的日志框架-->
<exclusion>
<artifactId>spring-boot-starter-logging</artifactId>
<groupId>org.springframework.boot</groupId>
</exclusion>
</exclusions>
</dependency>
<!--引入log4j2-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-log4j2</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.3.1</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.2.18</version>
</dependency>
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<scope>runtime</scope>
</dependency>
<!--lombok相关注解-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
注意:这里的pom是个父pom,整合代码为一个单独的模块
2.创建对应的文件
1.创建实体类
@Data
public class User {
private Integer id;
private String userName;
private Integer age;
}
2.创建对应的mapper接口
@Repository
public interface UserMapper {
List<User> getUser();
User getUserById();
}
3.创建对应的mapper.xml文件
在resource目录下面创建对应的mapper接口路径的文件
注意:在getUserById中如果resultType不是resultMap时,在配置文件中需要开启驼峰命名
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jhy.mapper.UserMapper">
<resultMap id="user" type="com.jhy.pojo.User">
<result property="id" column="id"/>
<result property="userName" column="user_name"/>
<result property="age" column="age"/>
</resultMap>
<select id="getUser" resultMap="user">
select * from user
</select>
<select id="getUserById" resultType="com.jhy.pojo.User">
select * from user where id = 1
</select>
</mapper>
4.创建service
public interface UserService {
public void getUser();
}
@Slf4j
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public void getUser() {
List<User> user = userMapper.getUser();
log.info("查询出来的用户数据List:{}",user.toString());
User userById = userMapper.getUserById();
log.info("查询出来的用户数据ById:{}",userById.toString());
}
}
5.创建对应controller
@Slf4j
@RestController
public class UserController {
@Autowired
private UserService userService;
@RequestMapping("/user")
public void getUser(){
userService.getUser();
}
}
6.yml配置文件
# 配置相关信息
# 第一种配置方法:通过spring.datasource.type配置druid
#spring:
# datasource:
# driver-class-name: com.mysql.cj.jdbc.Driver # mysql 驱动
# url: jdbc:mysql://10.0.0.0:3306/test?useSSL=false&serverTimezone=UTC # 连接数据库
# username: root # 数据库账户
# password: root # 数据库密码
# type: com.alibaba.druid.pool.DruidDataSource
# 第二种配置方法:druid 专用配置(推荐)
spring:
datasource:
druid:
driver-class-name: com.mysql.cj.jdbc.Driver # mysql 驱动
url: jdbc:mysql://10.0.0.0:3306/test?useSSL=false&serverTimezone=UTC # 连接数据库
username: root # 数据库账户
password: root # 数据库密码
logging:
level:
com.jhy.mapper: debug # 控制台输出sql语句
mybatis:
mapper-locations: classpath:mapper/*.xml
type-aliases-package: com.jhy.pojo
configuration:
map-underscore-to-camel-case: true #开启驼峰式命名
3.修改启动类
@SpringBootApplication
@MapperScan("com.jhy.mapper")
public class SpringbootDruidApplication {
public static void main(String[] args) {
SpringApplication.run(SpringbootDruidApplication.class, args);
}
}