SpringBoot整合MySQL

悠悠 2022-11-06 05:55 141阅读 0赞

本文演示SpringBoot整合MySQL。  
一、项目搭建  
新建一个SpringBoot项目，引入依赖：

<dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.4</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>8.0.22</scope>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.16.10</version>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
            </dependency>
        </dependencies>

二、配置文件  
配置项目端口号，添加数据库数据源配置信息：

server:
      port: 8989
    spring:
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://localhost:3306/mytest?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
        username: ****
        password: ****

三、库表准备  
使用MySQL,新建mytest数据库及student表，并插入记录：

DROP TABLE IF EXISTS `student`;
    CREATE TABLE `student`  (
      `id` bigint(20) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
      `age` int(10) NOT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    INSERT INTO `student` VALUES (1, '张三', 15);
    INSERT INTO `student` VALUES (2, '李四', 23);

四、编码实现  
①创建实体类Student如下：

@Data
    public class Student {
    
        private Long id;
        private String name;
        private Integer age;
    }

②编写Controller类及测试请求方法：

@RestController
    @RequestMapping("/")
    public class DemoController {
    
        @Autowired
        JdbcTemplate jdbcTemplate;
    
        @GetMapping("list")
        public List<Student> list(){
            String sql = "select id,name,age from student";
            List<Student> list = jdbcTemplate.query(sql, new RowMapper<Student>() {
                @Override
                public Student mapRow(ResultSet resultSet, int i) throws SQLException {
                    Student student=new Student();
                    student.setId(resultSet.getLong("id"));
                    student.setName(resultSet.getString("name"));
                    student.setAge(resultSet.getInt("age"));
                    return student;
                }
            });
            return list;
        }
    }

③启动类

@SpringBootApplication
    public class DemoApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(DemoApplication.class, args);
        }
    
    }

④测试请求及响应：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xkbGxvdmVneWg_size_16_color_FFFFFF_t_70][]

测试验证通过。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xkbGxvdmVneWg_size_16_color_FFFFFF_t_70]: /images/20221023/15c91ffa30cc446989b9cb375f5742b2.png