Ex1.java
import java.sql.*;
public class Ex1 {
public static void main(String[] args) {
Connection con = null;
Statement sql = null;
ResultSet rs = null;
con = GetDBConnection.connectDB("tsglxt", "root", "0218hu");
//if(con == null) return;
String sqlStr = "SELECT * FROM student";
try {
sql= con.createStatement();
rs = sql.executeQuery(sqlStr);
while( rs.next() ) {
String id = rs.getString(1);
String name = rs.getString(2);
String sex = rs.getString(3);
Date birthday = rs.getDate(4);
String result = rs.getString(5);
System.out.printf("%s\t",id);
System.out.printf("%s\t",name);
System.out.printf("%s\t",sex);
System.out.printf("%s\t",birthday);
System.out.printf("%s\n",result);
}
con.close();
}
catch(SQLException e) {
System.out.println(e);
}
}
}
GetDBConnection.java
import java.sql.*;
public class GetDBConnection {
public static Connection connectDB(String DBName,String id,String p) {
Connection con = null;
String uri = "jdbc:mysql://localhost:3306/"+DBName+"?useSSL=true&&characterEncoding=utf-8";
try {
Class.forName("com.mysql.cj.jdbc.Driver");
}
catch(Exception e) {}
try {
con = DriverManager.getConnection(uri, id, p);
}
catch(SQLException e) {}
return con;
}
}
