回滚操作

最新推荐文章于 2022-11-28 19:56:04 发布

javaindex

最新推荐文章于 2022-11-28 19:56:04 发布

阅读量540

点赞数

分类专栏：数据库文章标签： string scroll jdbc import oracle url

本文链接：https://blog.csdn.net/javaindex/article/details/2990291

版权

数据库专栏收录该内容

15 篇文章 0 订阅

订阅专栏

import java.sql.*;

public class TestScroll {
public static void main(String args[]) {

  try {
   new oracle.jdbc.driver.OracleDriver();
   String url = "jdbc:oracle:thin:@192.168.0.1:1521:SXT";
   Connection conn = DriverManager
     .getConnection(url, "scott", "tiger");
   Statement stmt = conn.createStatement(
     ResultSet.TYPE_SCROLL_INSENSITIVE,
     ResultSet.CONCUR_READ_ONLY);
   ResultSet rs = stmt
     .executeQuery("select * from emp order by sal");
   rs.next();
   System.out.println(rs.getInt(1));
   rs.last();
   System.out.println(rs.getString(1));
   System.out.println(rs.isLast());
   System.out.println(rs.isAfterLast());
   System.out.println(rs.getRow());
   rs.previous();
   System.out.println(rs.getString(1));
   rs.absolute(6);
   System.out.println(rs.getString(1));
   rs.close();
   stmt.close();
   conn.close();
  } catch (SQLException e) {
   e.printStackTrace();
  }
}
}