70 lines
2.4 KiB
Java
70 lines
2.4 KiB
Java
import java.sql.*;
|
|
|
|
public class Question10 {
|
|
|
|
// MySQL 8.0 以上版本 - JDBC 驱动名及数据库 URL
|
|
static final String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
|
|
static final String DB_URL = "jdbc:mysql://公网IP:3306/user000db?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC";
|
|
|
|
|
|
// 数据库的用户名与密码，需要根据自己的设置
|
|
static final String USER = "DB_USER000";
|
|
static final String PASS = "DB_USER000@123";
|
|
|
|
public static void main(String[] args) {
|
|
Connection conn = null;
|
|
Statement stmt = null;
|
|
try{
|
|
// 注册 JDBC 驱动
|
|
Class.forName(JDBC_DRIVER);
|
|
|
|
// 打开链接
|
|
System.out.println("连接数据库...");
|
|
conn = DriverManager.getConnection(DB_URL,USER,PASS);
|
|
|
|
// 执行查询
|
|
System.out.println("实例化Statement对象...");
|
|
stmt = conn.createStatement();
|
|
String sql;
|
|
sql = "SELECT ID, name, dept_name, salary from instructor where salary > 70000 order by dept_name";
|
|
ResultSet rs = stmt.executeQuery(sql);
|
|
|
|
// 展开结果集数据库
|
|
while(rs.next()){
|
|
// 通过字段检索
|
|
String id = rs.getString("ID");
|
|
String name = rs.getString("name");
|
|
String dept_name = rs.getString("dept_name");
|
|
Double salary = rs.getDouble("salary");
|
|
|
|
// 输出数据
|
|
System.out.print(id);
|
|
System.out.print("|" + name + "|" + dept_name + "|" + salary);
|
|
System.out.print("\n");
|
|
}
|
|
// 完成后关闭
|
|
rs.close();
|
|
stmt.close();
|
|
conn.close();
|
|
}catch(SQLException se){
|
|
// 处理 JDBC 错误
|
|
se.printStackTrace();
|
|
}catch(Exception e){
|
|
// 处理 Class.forName 错误
|
|
e.printStackTrace();
|
|
}finally{
|
|
// 关闭资源
|
|
try{
|
|
if(stmt!=null) stmt.close();
|
|
}catch(SQLException se2){
|
|
}// 什么都不做
|
|
try{
|
|
if(conn!=null) conn.close();
|
|
}catch(SQLException se){
|
|
se.printStackTrace();
|
|
}
|
|
}
|
|
System.out.println("Goodbye!");
|
|
}
|
|
}
|