快捷導(dǎo)航

springboot如何集成mysql

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

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

springboot集成mysql

引入依賴

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

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

添加數(shù)據(jù)庫配置

在spring boot項(xiàng)目的配置文件 application.properties 中添加如下配置：

#集成mysql數(shù)據(jù)庫的配置
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

設(shè)計(jì)表和實(shí)體類

實(shí)體類對應(yīng)數(shù)據(jù)庫中的表結(jié)構(gòu)

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會幫我們實(shí)例化一個對象
    private JdbcTemplate jdbcTemplate;   // 一個通過JDBC連接數(shù)據(jù)庫的工具類，可以通過這個工具類對數(shù)據(jù)庫進(jìn)行增刪改查
    @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);
        }
    }

測試結(jié)果如下：

spring boot 連接 mysql結(jié)果

springboot集成mysql時報(bào)錯

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

首先，新版的mysql連接驅(qū)動要用：

com.mysql.cj.jdbc.Driver

啟動后并未報(bào)錯，但是訪問的時候報(bào)以下錯誤：

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ū)不對