java - How to populate a CachedRowSet object without resultset?

Question

Usually, we populate a CachedRowSet in this way:

String queryString = "select * from ... where ...";
PreparedStatement pstm = con.prepareStatement(queryString);
ResultSet rs = pstm.executeQuery();
CachedRowSet crs = RowSetProvider.newFactory().createCachedRowSet();
crs.populate(rs);

Or, we used this way to avoid mapping:

String queryString = "select top 1 * from AccelData where 1=0";
pstm = con.prepareStatement(queryString);
rs = pstm.executeQuery();
crs = RowSetProvider.newFactory().createCachedRowSet();
crs.populate(rs);
for(......){
    crs.moveToInsertRow();
    crs.update....;
    crs.update....;
    crs.update....;
    crs.insertRow();
    crs.moveToCurrentRow();
}

My question is, is there another way to mapping the CachedRowSet without ResultSet manually? Because I want to use SqlServerBulkCopy, I wish I could eliminate every JDBC Connection part in my code.

question from:https://stackoverflow.com/questions/65838883/how-to-populate-a-cachedrowset-object-without-resultset

Answer 1

Waitting for answers