Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:cxmoracle", "scott", "scott");
//加入事务处理
conn.setAutoCommit(false);
Statement statement = conn.createStatement();
ResultSet result = statement.executeQuery("select * from (select viewa.*, rownum rn from (select * from emp) viewa) viewb where rn>=5 and rn<=10");
while(result.next())
{
System.out.println("name: " + result.getString(2));
}
//提交事务
conn.commit();
result.close();
statement.close();
conn.close();
} catch (Exception e) {
//回滚
// conn.rollback()
e.printStackTrace();
}
finally
{
}