public class ResultSetMoveTest {$ `: o# T9 Y1 e7 Z9 v3 d; F
// TODO自动生成体例存根# P" \0 z3 x& k5 `: s# ^( G
try {( g+ q0 F* {$ F$ n
String sql = "select * from login order by id";
% P8 m4 @, H! k // 获得2.1节中的(3)供给的毗连;Connection con = DBUtil.getConn();
! Z- ^) ]/ s% j& S4 Q //获得可以前后滚动的类型: k, a; B! }* Y. k
Statement stmt = con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);3 K: k) ~# A& ]. {% J6 ?7 U
//经由过程Statement获得结不美观集
5 O( N: A8 l6 M1 u ResultSet rs = stmt.executeQuery(sql);1 x2 t, Q* }* _8 f
public static void main(String[] args) {) Y& P% E3 G7 C$ H/ e/ J, b
int i = 0;
9 y( k+ x1 X& S1 H, ] System.out.println("===起头测试获得的所有记实===\n"); System.out.println("游标下移2条/n"); rs.absolute(2); System.out.println("此刻共在第:" + rs.getRow() + " 行。"); rs.last(); System.out.println("此刻共有:" + rs.getRow() + " 标识表记标帜录。"); rs.moveToInsertRow(); System.out.println("插入一标识表记标帜录。"); rs.insertRow(); System.out.println("插入一标识表记标帜录。"); rs.insertRow(); rs.last(); System.out.println("此刻共有:" + rs.getRow() + " 标识表记标帜录。"); rs.deleteRow(); rs.last(); System.out.println("此刻共有:" + rs.getRow() + " 标识表记标帜录。");
) Y n, T4 N* z1 b9 c- f // rs.deleteRow();
0 W- U C/ s6 G8 m" Y System.out.println("===测试获得的所有记实成功===\n");
0 s# K7 Z; u4 v( f* ^ //写一个最通俗的发芽语句# n$ X5 A: H$ J. H/ ~' ?5 A- c
} catch (Exception e) {" H' s0 N) d, _$ U* o |* ^+ b9 i
e.printStackTrace();
/ f1 W! t3 N, O* f: _2 o }+ y6 }2 \3 l* D; l9 ^4 r" Q4 W
}
. Y. b* Q' [# }% M2 z! q } |