JDBC如何设置可滚动的结果集及动态更新

ResultSet对象默认情况下是不可生成可更新的结果集,因此需要手动设置为可跟新,可滚动的结果集Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);ResultSet.TYPE_SCROLL_INSENSITIVE用于设置结果集是可以滚动的,ResultSet.CONCUR_UPDATABLE表示是否可以对某个跟定的对象进行跟新.,以下是一个可跟新:

import java.sql.*;
import com.UtilTool.*;
public class TestUpdateResultSet {
	public static void main(String args[]){
		Connection con=null;
		Statement stm=null;
		ResultSet rs=null;
		
		try{
			con=ConnectTool.getConnection();
			con.setAutoCommit(false);
			stm=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			String sql="select empno,Ename from emp order by sal";
			rs=stm.executeQuery(sql);
			rs.next();
			rs.absolute(5);
			rs.updateString(2, "jj");
			System.out.println(rs.getInt(1)+"===="+rs.getString(2));
			rs.absolute(3);
			rs.updateString(2, "jj");
			System.out.println(rs.getInt(1)+"===="+rs.getString(2));
			rs.updateRow();
			con.commit();
		}catch(Exception e){
			e.printStackTrace();
			try {
				con.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
		}finally{
			ConnectTool.releasersc(rs, stm, con);
		}
	}

}

评论

1 楼 luzl 2009-02-24  

学的这么认真呀！