JDBC连接mysql数据库

1.点击File->Project Structure->Modules

新版本 ：Class.forName(“com.mysql.cj.jdbc.Driver”);
有的老版本是 Class.forName(“com.mysql.jdbc.Driver”);

package jdbc;

import java.sql.*;
import java.util.Date;
import java.util.Scanner;
public class Main {
    public static void main(String[] args) {
        try {
            //加载驱动
            Class.forName("com.mysql.cj.jdbc.Driver");
            //获取连接
            String url = "jdbc:mysql://localhost:3306/db_food?useJDBCCompliantTimezoneShift=true&serverTimezone=UTC";
            String user = "root";
            String password = "010318";
            // 创建Java与MySQL的连接通道
            Connection connection = DriverManager.getConnection(url,user,password);
            System.out.println("连接成功");
            //创建sql语句
            String sql="select * from goods";
            String msql;
            Scanner s = new Scanner(System.in);
            msql = s.nextLine();
            //创建传输数据的载体
            Statement statement = connection.createStatement();
            //将数据sql语句传递
            ResultSet resultSet=statement.executeQuery(msql);
            System.out.println("id  商品名称 价格 描述");
            while(resultSet.next()){
                int id = resultSet.getInt("id");
                String goodsName = resultSet.getString("goodsName");
                int price = resultSet.getInt("price");
                String goodsDesc = resultSet.getString("goodsDesc");
                String imageLink = resultSet.getString("imageLink");
                System.out.println(id+" "+goodsName+" "+price+" "+goodsDesc+" "+imageLink);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e){
            e.printStackTrace();
        }
    }
}