Question

用java连Oracle数据库,在Java中写了一条查询语句,怎么样才能在java中得查询语句的结果集啊

Answer 1

try{
Class.forName("oracle.jdbc.driver.OracleDriver);
String url="jdbc:oracle:oci8:@数据库名";
Connection con = DriverManager.getConnection(url,用户名,密码);
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select * from 表名");
while(rst.next())
{
//
rst.getString("表字段")
}
}catch(Exception e){
} finally{
//关闭连接、释放资源
rst.close();
stmt.close();
con.close();
}