JDBC连接mysql数据库

package com.dgd.test;

import java.sql.*;

/**

• @author LZF

• @create 2020-12-14

• 测试数据库
  */
  public class Test {
  public static void main(String[] args) throws Exception{
  //加载数据库驱动程序
  try{
  Class.forName(“com.mysql.cj.jdbc.Driver”);
  }catch (ClassNotFoundException cne){
  cne.printStackTrace();
  }
  String dburl = “jdbc:mysql://localhost:3306/webstore?&useSSL=false&serverTimezone=UTC”; //webstore代表数据库名称
  String sql = “SELECT * FROM products where id < 104”;
  try( Connection conn = DriverManager.getConnection(dburl,“root”,“lzfzyl586”);
  Statement stmt = conn.createStatement();
  ResultSet rst = stmt.executeQuery(sql))

   {
       while (rst.next()){
           System.out.println(rst.getInt(1)+"\t"+
                   rst.getString(2)+"\t"+rst.getString(3)+
                   "\t"+rst.getFloat(4) + "\t" + rst.getInt(5)
           );
       }
  
   }catch (SQLException se){
       se.printStackTrace();
   }
  

  }
  }