conn = JdbcUtils.getConnection();
conn.setAutoCommit(true);
ps = conn.prepareStatement(sql);
ps.clearBatch();
for (int i = rowBegin; i < rowEnd; i++) {
HisTrans trans = eService.getRow(result, i);
ps.setString(1, trans.getSettle_date());
ps.setString(2, trans.getPan());
ps.setFloat(3, trans.getAcc_type());
ps.setString(4, trans.getTxn_name());
ps.setFloat(5, trans.getTxn_amt());
ps.setFloat(6, trans.getFee_amt());
ps.setString(7, trans.getCname());
ps.setString(8, trans.getTid());
ps.setString(9, trans.getSp_mid());
ps.setString(10, trans.getSp_tid());
ps.setString(11, trans.getTrace1());
ps.setString(12, trans.getRrn());
ps.setString(13, trans.getTxn_date());
ps.setString(14, trans.getArea());
ps.addBatch();
}
ps.executeBatch();
conn.commit();
} catch (SQLException e) {