首先打开模块化设置
在这里添加相应的.jar包
然后会得到这样的一个结果
接着就可以进行测试了,在测试样例中我结合了配置文件一起使用的
配置文件.properties
DRIVER_HOME=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/chencj?characterEncoding=utf-8&serverTimezone=UTC
user=root
password=自己设置的密码
import java.sql.*;
import java.util.ResourceBundle;
public class selectSalgrade {
public static void main(String[] args) {
ResourceBundle bundle = ResourceBundle.getBundle("配置文件");
String DRIVER_HOME = bundle.getString("DRIVER_HOME");
// System.out.println(DRIVER_HOME);
String url = bundle.getString("url");
String user = bundle.getString("user");
String password = bundle.getString("password");
Connection conn = null;
Statement statement = null;
ResultSet rs = null;
try {
//1.加载驱动
Class.forName(DRIVER_HOME);
//2.创建连接
conn = DriverManager.getConnection(url,user,password);
//3.写SQL语句
String sql = "select * from salgrade";
//4.获取执行SQL的statement对象
statement = conn.createStatement();
//5.执行select返回结果
rs = statement.executeQuery(sql);
System.out.println("============================");
while(rs.next()){
System.out.print(rs.getInt(1) + ",");
System.out.print(rs.getString(2) + ",");
System.out.println(rs.getString(3));
}
System.out.println("============================");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException throwables) {
throwables.printStackTrace();
}finally {
//6.关闭连接
if(rs != null) {
try {
rs.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(statement != null) {
try {
statement.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
if(conn != null) {
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}
}
}
测试结果