很好用的CachedRowSet

最新推荐文章于 2022-11-17 13:32:32 发布

原创最新推荐文章于 2022-11-17 13:32:32 发布 · 887 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#integer #file #string #class #null

java开发专栏收录该内容

17 篇文章

订阅专栏

public class RowSetTest {

    public static void test() {
        CachedRowSet csr = null;
        try {
            csr = new CachedRowSetImpl();
            RowSetMetaData rsmd = new RowSetMetaDataImpl();
            rsmd.setColumnCount(2);
            rsmd.setColumnName(1, "col001");
            rsmd.setColumnType(1, java.sql.Types.INTEGER);
            rsmd.setColumnName(2, "col002");
            rsmd.setColumnType(2, java.sql.Types.INTEGER);
            csr.setMetaData(rsmd);

            csr.moveToInsertRow();
            csr.updateObject(1, new Integer(12));
            csr.updateObject(2, new Integer(1254));
            csr.insertRow();

            csr.moveToInsertRow();
            csr.updateObject(1, new Integer(12));
            csr.updateObject(2, new Integer(1254));
            csr.insertRow();

            csr.moveToCurrentRow();
            csr.first();
            do {
                int i1 = csr.getInt(1);
                int i2 = csr.getInt(2);
                System.out.println(i1 + ", " + i2);
            } while( csr.next());
        } catch (SQLException e) {
            e.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
        }
    }

    public static void main(String[] args) {
        test();
    }
}