springboot如何集成mysql

更新時間：2023年08月14日 15:02:01 作者：貪吃小明

這篇文章主要介紹了springboot如何集成mysql問題,具有很好的參考價值,希望對大家有所幫助,如有錯誤或未考慮完全的地方,望不吝賜教

springboot集成mysql

引入依賴

在pom文件中加入如下依賴：

 <!--集成mysql數據庫-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

添加數據庫配置

在spring boot項目的配置文件 application.properties 中添加如下配置：

#集成mysql數據庫的配置
spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/studentscon?useSSL=false&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root

設計表和實體類

實體類對應數據庫中的表結構

package com.test.springbootstudy.entity;
public class Student {
    private int id;
    private String name;
    private String password;
    private String sex;
    private int age;
    public Student() {
    }
    public Student(int id, String name, String password, String sex, int age) {
        this.id = id;
        this.name = name;
        this.password = password;
        this.sex = sex;
        this.age = age;
    }
    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                ", sex='" + sex + '\'' +
                ", age=" + age +
                '}';
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
}

測試

 	@Resource    // 自動注入，spring boot會幫我們實例化一個對象
    private JdbcTemplate jdbcTemplate;   // 一個通過JDBC連接數據庫的工具類，可以通過這個工具類對數據庫進行增刪改查
    @Test
    public void mySqlTest(){
        String sql = "select id,name,password,sex,age from students";
        List<Student> students = jdbcTemplate.query(sql, new RowMapper<Student>() {
            @Override
            public Student mapRow(ResultSet resultSet, int i) throws SQLException {
                Student student = new Student();
                student.setId(resultSet.getInt("id"));
                student.setName(resultSet.getString("name"));
                student.setPassword(resultSet.getString("password"));
                student.setSex(resultSet.getString("sex"));
                student.setAge(resultSet.getInt("age"));
                return student;
            }
        });
        System.out.println("查詢成功");
        for(Student s : students){
            System.out.println(s);
        }
    }

測試結果如下：

spring boot 連接 mysql結果

springboot集成mysql時報錯

在使用springboot默認的mysql和mybatis時踩了一個坑，特此記錄

首先，新版的mysql連接驅動要用：

com.mysql.cj.jdbc.Driver

啟動后并未報錯，但是訪問的時候報以下錯誤：

java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

查詢原因，是由于安裝mysql的時候安裝時區(qū)不對