public class Result26 {
public static void main(String[] args) throws Exception {
Connection conn = ConnectionFactory.getInstance().getLocalConnection();
int money=0;
ResultSet rt=null;
Statement st=null;
String sql="select * from test_user order by uid asc";
st=conn.createStatement();
rt=st.executeQuery(sql);
while (rt.next()){
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
}
System.out.println("-------------------------");
while(rt.previous()){ //向上滚动
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
}
}
}
发现这是包括当前行的。
但是我们如果定位到某一行,则不会包括那一行:
public class Result26 {
public static void main(String[] args) throws Exception {
Connection conn = ConnectionFactory.getInstance().getLocalConnection();
int money=0;
ResultSet rt=null;
Statement st=null;
String sql="select * from test_user order by uid asc";
st=conn.createStatement();
rt=st.executeQuery(sql);
rt.absolute(3);//定位到某行
while (rt.next()){
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
}
rt.absolute(3);
System.out.println("-------------------------");
while(rt.previous()){ //向上
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
}
}
4 789
5 4890
-------------------------
2 450
1 50
关于可更新的结果集是有好处的。使用可更新的结果集和对数据敏感的结果集的表必须拥有主键:alter table test_user modify uid int primary key;
使用可更新的结果集是有好处的,比如一次性的修改很多的行的值。
public class Result26 {
public static void main(String[] args) throws Exception {
Connection conn = ConnectionFactory.getInstance().getLocalConnection();
int money=0;
ResultSet rt=null;
Statement st=null;
String sql="select * from test_user order by uid asc";
//所谓并发,就是对Result既能读,也能写。
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rt=st.executeQuery(sql);
while (rt.next()){
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
rt.updateInt("money", 24);
rt.updateRow();//不要忘了更新行,这个时候缓存值才被写入数据。
}
System.out.println("-------------------------");
while(rt.previous()){ //向上
System.out.print(rt.getInt("uid")+"\t");
System.out.print(rt.getInt("money")+"\t");
System.out.println("\n");
}
}
}
ResultSet.TYPE_SCROLL_SENSITIVE表示ResultSet对数据库更新是敏感的:比如在next中间,对数据库中的值进行了修改。那么在previous中就感知到这种变化,所以在previous中间,打印出的momey都是24.(next中间感受不到这些变化,它还没有这么神奇)
但实际上ResultSet.TYPE_SCROLL_INSENSITIVE,对于previous仍然可以感知到这个变化。也就是JDBC这个特性在mysql 的实现中并不是严格按照sun公司的标准。