public class JDBC {
public static void main(String[] args) {
//1.注册驱动器
Class.forName(oracle.jdbc.driver.OracleDriver);
//2.得到Connection
Connection conn = DriverManager.getConnection();
try {
//3.创建Statement
Statement stmt = conn.createStatement();
//4.得到结果集
ResultSet rs = stmt.executeQuery("Select * from t_student");
//5.对结果集进行处理(例如遍历t_student表中的sname字段)
while(rs.next()) {
System.out.println(rs.getString("sname"));
}
catch(SQLException e) {
e.printStackTrace();
}
//6.资源释放
if(rs != null) {
try {
rs.close();
rs = null;
} catch(SQLException e) {
e.printStackTrace();
}
}
if(stmt != null) {
try {
stmt.close();
stmt = null;
} catch(SQLException e) {
e.printStackTrace();
}
}
if(conn != null) {
try {
conn.close();
conn = null;
} catch(SQLException e) {
e.printStackTrace();
}
}
}
}
JDBC链接Oracle数据库的6个步骤
最新推荐文章于 2024-07-19 20:18:03 发布