java连接mysql

1.下载mysql版本对应的jar包
2.导入jar包

3.

package com.qcby.db;
import java.sql.*;
public class Db {
    public static void main(String [] args){
        select();
    }
    public static void select() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");//驱动
        String url="jdbc:mysql://localhost:3306/learn?serverTimezone=GMT%2B8";
        String user="root";
        String password="password";
        //建立好java 和mysql通路
 Connection connection =  DriverManager.getConnection(url,user,password);
 //在通路上建立一个车
   Statement statement= connection.createStatement();
 ResultSet resultSet=statement.executeQuery("select*from student");//执行结果存在resultSet
            while(resultSet.next()){
                String id=resultSet.getString(1);
                String userName=resultSet.getString(2);
                String passWord=resultSet.getString(3);
                System.out.print(id+"--");
                System.out.print(userName+"--");
                System.out.print(userName+"--");
                System.out.print(passWord);
                System.out.println();
            }

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
}