提示: 大佬可以自动略过哦
/**
* @create 2020-10-05 16:22
*/
public class JDBCUseJdbcUtils {
public static void main(String[] args) throws SQLException {
test01();
}
private static void test01() {
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
try {
//调用jdbcUtils中getConnection()
connection = JDBCUtils.getConnection();
String sql = "select * from account";
//创建执行sql语句的对象
statement = connection.createStatement();
//执行sql语句
rs = statement.executeQuery(sql);
while (rs.next()) {
//获取table表中的字段
int id = rs.getInt(1);
String name = rs.getString("name");
double balance = rs.getDouble(3);
System.out.println("我是" + name + "我的工号id是 " + id + "我的工资是:" + balance + "元");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
//释放资源
JDBCUtils.close(statement,connection,rs);
}
}
}