注意导入Jar包 mysql-connector-java-8.0.15.jar
package edu.qdu.dsse.function;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class JDBC {public static void main(String[] args) {getConnection();}public static void getConnection(){try {Class.forName("com.mysql.cj.jdbc.Driver"); String url = "jdbc:mysql://localhost:3306/student?serverTimezone=GMT";String user = "root";String password = "123qwe";Connection con = DriverManager.getConnection(url,user,password);Statement stmt = con.createStatement();ResultSet rs = stmt.executeQuery("select * from stuinfo");while(rs.next()){System.out.print(rs.getString(1));System.out.print(rs.getString(2));}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}
}