int colBegin = 0, rowBegin = 0;
int colEnd, rowEnd;
int index = 0;
String filename = "E:/���ж��˵�/2012/3.xls";
ExcelService eService = new ExcelService();
Sheet rs = eService.getSheet(filename, index);
rowEnd = rs.getRows();
// rowEnd = 10000;
colEnd = rs.getColumns();
Map<Point, String> result = eService.readExcel(rs, rowBegin, rowEnd, colBegin, colEnd);
String sql = "insert into data_to_import "
+ "(SETTLE_DATE, PAN, ACC_TYPE, TXN_NAME, TXN_AMT, FEE_AMT, CNAME, TID, SP_MID, SP_TID, TRACE1, RRN, TXN_DATE, TRANS_ID, AERA ) "
+ " values (?,?,?,?,?,?,?,?,?,?,?,?,?,SEQ_DATA_TO_IMPORT.NEXTVAL,?)";
Connection conn = null;
PreparedStatement ps = null;
try {
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());