springboot 原生jdbc进行MYSQL数据库的连接

1、pom

 		<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

2、main

public static void main(String[] args) throws ClassNotFoundException, SQLException {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url = "jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=GMT";
        Connection con = DriverManager.getConnection(url, "root", "123456");
        Statement statement = con.createStatement();
        ResultSet resultSet = statement.executeQuery("select * from gateway_route");
        while (resultSet.next()) {
            System.out.println("查询结果： "+resultSet.getString("service_id"));
        }

    }

3、结果