Java tutorial
package com.yitong.app.service.judicial.dxzpjymx; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.List; import java.util.Map; import java.util.zip.ZipEntry; import java.util.zip.ZipOutputStream; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRichTextString; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.DataValidation; import com.yitong.commons.model.IListPage; import com.yitong.commons.service.BaseService; public class JymxService extends BaseService { // @SuppressWarnings("unchecked") public IListPage pageQueryJyTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQuery", "jymx.pageCount", params, pageNo); } @SuppressWarnings("unchecked") public Map load(String params) { logger.info("jymx.loadById........."); return (Map) load("jymx.loadById", params); } //?? @SuppressWarnings("unchecked") public Map ckload(String params) { logger.info("jymx.loadByCkId........."); return (Map) load("jymx.loadByCkId", params); } @SuppressWarnings("unchecked") public IListPage pageQueryCkTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryCkTask", "jymx.pageCountCkTask", params, pageNo); } // @SuppressWarnings("unchecked") public Map qzhload(String params) { logger.info("jymx.loadByQzhId........."); return (Map) load("jymx.loadByQzhId", params); } @SuppressWarnings("unchecked") public IListPage pageQueryQzhTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryQzhTask", "jymx.pageCountQzhTask", params, pageNo); } //?? @SuppressWarnings("unchecked") public IListPage pageQueryFkTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryFkTask", "jymx.pageCountFkTask", params, pageNo); } @SuppressWarnings("unchecked") public Map fkload(String params) { logger.info("jymx.loadByFkId........."); return (Map) load("jymx.loadByFkId", params); } //?? @SuppressWarnings("unchecked") public IListPage pageQueryCxmxTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryCxmxTask", "jymx.pageCountCxmxTask", params, pageNo); } @SuppressWarnings("unchecked") public Map cxmxload(Map params) { logger.info("jymx.loadByCxmxId........."); return (Map) load("jymx.loadByCxmxId", params); } // @SuppressWarnings("unchecked") public IListPage pageQueryCkfkTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryCkfkTask", "jymx.pageCountCkfkTask", params, pageNo); } @SuppressWarnings("unchecked") public Map ckfkload(String params) { logger.info("jymx.loadByCkfkId........."); return (Map) load("jymx.loadByCkfkId", params); } //? @SuppressWarnings("unchecked") public IListPage pageQueryZhTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryZhTask", "jymx.pageCountZhTask", params, pageNo); } @SuppressWarnings("unchecked") public Map zhload(Map params) { logger.info("jymx.loadByZhId........."); return (Map) load("jymx.loadByZhId", params); } //? @SuppressWarnings("unchecked") public IListPage pageQueryDjTask(Map params, int pageNo) { return this.pageQuery("jymx.pageQueryDjTask", "jymx.pageCountDjTask", params, pageNo); } //?? @SuppressWarnings("unchecked") public List<Map> findZhjyqqList(Map params) { return this.findList("jymx.findZhjyqqList", params); } //?? @SuppressWarnings("unchecked") public List<Map> findZhxxList(Map params) { return this.findList("jymx.findZhxxList", params); } //?? @SuppressWarnings("unchecked") public List<Map> findJymxList(Map params) { return this.findList("jymx.findJymxList", params); } //???? @SuppressWarnings("unchecked") public List<Map> findCkztqqList(Map params) { return this.findList("jymx.findCkztqqList", params); } //???? @SuppressWarnings("unchecked") public List<Map> findCkztjgList(Map params) { return this.findList("jymx.findCkztjgList", params); } //?? @SuppressWarnings("unchecked") public List<Map> findQzhqqList(Map params) { return this.findList("jymx.findQzhqqList", params); } //??? @SuppressWarnings("unchecked") public List<Map> findQzhzhxxList(Map params) { return this.findList("jymx.findQzhzhxxList", params); } //?? @SuppressWarnings("unchecked") public List<Map> findQzhdjxxList(Map params) { return this.findList("jymx.findQzhdjxxList", params); } //?Excel public File makeZhjyqqExcel(List<Map> zhjyqqList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet = wk.createSheet("zhjyqq"); // HSSFRow firstRow = sheet.createRow(0); int totalColNum = 27; //? HSSFCell[] firstCell = new HSSFCell[totalColNum]; //??string String[] colNames = new String[totalColNum]; colNames[0] = "?"; colNames[1] = "?"; colNames[2] = "???"; colNames[3] = "??"; colNames[4] = "?"; colNames[5] = ""; colNames[6] = ""; colNames[7] = ""; colNames[8] = "?"; colNames[9] = "??"; colNames[10] = "??"; colNames[11] = "?/?"; colNames[12] = ""; colNames[13] = "?"; colNames[14] = "?"; colNames[15] = ""; colNames[16] = ""; colNames[17] = ""; colNames[18] = "?"; colNames[19] = "??"; colNames[20] = "??"; colNames[21] = "???"; colNames[22] = "???"; colNames[23] = "??"; colNames[24] = "???"; colNames[25] = "????"; colNames[26] = "????"; //?? for (int i = 0; i < totalColNum; i++) { //? firstCell[i] = firstRow.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell[i].setCellValue(new HSSFRichTextString(colNames[i])); } //???excel //j1 ?rs int j = 1; //? DataValidation data_validation = null; for (Map m : zhjyqqList) { // HSSFRow row = sheet.createRow(j); for (int i = 0; i < totalColNum; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m.get("MESSAGEFROM"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASENUMBER"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASETYPE"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString( "02".equals(((String) m.get("EMERGENCYLEVEL"))) ? "" : "")); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m.get("SUBJECTTYPE"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKNAME"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTNAME"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m.get("CARDNUMBER"))); } if (i == 12) { String str = (String) m.get("INQUIRYMODE"); String INQUIRYMODE = ""; if ("01".equals(str)) { INQUIRYMODE = "?"; } else if ("02".equals(str)) { INQUIRYMODE = ""; } else if ("03".equals(str)) { INQUIRYMODE = "?+"; } else { INQUIRYMODE = ""; } cell.setCellValue(new HSSFRichTextString(INQUIRYMODE)); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m.get("INQUIRYPERIODSTART"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m.get("INQUIRYPERIODEND"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m.get("REASON"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME"))); } if (i == 20) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDTYPE"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDNUMBER"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORNAME"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORPHONENUMBER"))); } if (i == 24) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDTYPE"))); } if (i == 25) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDNUMBER"))); } if (i == 26) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORNAME"))); } } // j++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //?Excel public File makeZhjyjgExcel(List<Map> zhxxList, List<Map> jymxList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet1 = wk.createSheet("zhxx"); HSSFSheet sheet2 = wk.createSheet("jymx"); // HSSFRow firstRow1 = sheet1.createRow(0); HSSFRow firstRow2 = sheet2.createRow(0); int totalColNum1 = 40; int totalColNum2 = 31; //? HSSFCell[] firstCell1 = new HSSFCell[totalColNum1]; HSSFCell[] firstCell2 = new HSSFCell[totalColNum2]; //??string String[] colNames1 = new String[totalColNum1]; colNames1[0] = "?"; colNames1[1] = "ID"; colNames1[2] = "?"; colNames1[3] = "??"; colNames1[4] = "??"; colNames1[5] = ""; colNames1[6] = ""; colNames1[7] = "?"; colNames1[8] = ""; colNames1[9] = ""; colNames1[10] = ""; colNames1[11] = ""; colNames1[12] = "??"; colNames1[13] = "(?)??"; colNames1[14] = "(?)"; colNames1[15] = "?"; colNames1[16] = "??"; colNames1[17] = ""; colNames1[18] = "?"; colNames1[19] = "??"; colNames1[20] = "?"; colNames1[21] = "??"; colNames1[22] = "???"; colNames1[23] = "??"; colNames1[24] = "?"; colNames1[25] = "?/???"; colNames1[26] = "?/??"; colNames1[27] = "?/????"; colNames1[28] = "??"; colNames1[29] = "??"; colNames1[30] = "??"; colNames1[31] = "???"; colNames1[32] = "???"; colNames1[33] = "?"; colNames1[34] = ""; colNames1[35] = "?"; colNames1[36] = "???"; colNames1[37] = "??"; colNames1[38] = "?"; colNames1[39] = "?"; String[] colNames2 = new String[totalColNum2]; colNames2[0] = "?"; colNames2[1] = ""; colNames2[2] = "??"; colNames2[3] = ""; colNames2[4] = ""; colNames2[5] = "?"; colNames2[6] = "??"; colNames2[7] = ""; colNames2[8] = "?"; colNames2[9] = "??"; colNames2[10] = "??"; colNames2[11] = "???"; colNames2[12] = "??"; colNames2[13] = "?"; colNames2[14] = "?"; colNames2[15] = "?"; colNames2[16] = "??"; colNames2[17] = "?"; colNames2[18] = "?"; colNames2[19] = "??"; colNames2[20] = "??"; colNames2[21] = "?"; colNames2[22] = ""; colNames2[23] = "?"; colNames2[24] = "??"; colNames2[25] = "?"; colNames2[26] = "??"; colNames2[27] = "MAC?"; colNames2[28] = "IP?"; colNames2[29] = ""; colNames2[30] = "?"; //?? for (int i = 0; i < totalColNum1; i++) { //? firstCell1[i] = firstRow1.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell1[i].setCellValue(new HSSFRichTextString(colNames1[i])); } //?? for (int i = 0; i < totalColNum2; i++) { //? firstCell2[i] = firstRow2.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell2[i].setCellValue(new HSSFRichTextString(colNames2[i])); } //???excel //j1 ?rs int j = 1; for (Map m1 : zhxxList) { // HSSFRow row = sheet1.createRow(j); for (int i = 0; i < totalColNum1; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m1.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m1.get("JSJG"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m1.get("TXCODE"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m1.get("TRANSSERIALNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNAME"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDNUMBER"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCH"))); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCHCODE"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTOPENTIME"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONTIME"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONBRANCH"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m1.get("REMARK"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNUMBER"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSERIAL"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTTYPE"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSTATUS"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CURRENCY"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CASHREMIT"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTBALANCE"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m1.get("AVAILABLEBALANCE"))); } if (i == 20) { cell.setCellValue(new HSSFRichTextString((String) m1.get("LASTTRANSACTIONTIME"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCREDENTIALTYPE"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCREDENTIALNUMBER"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSUBJECTNAME"))); } if (i == 24) { cell.setCellValue(new HSSFRichTextString((String) m1.get("TELNUMBER"))); } if (i == 25) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORNAME"))); } if (i == 26) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORCREDENTIALTYPE"))); } if (i == 27) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDOPERATORCREDENTIALNUMBER"))); } if (i == 28) { cell.setCellValue(new HSSFRichTextString((String) m1.get("RESIDENTADDRESS"))); } if (i == 29) { cell.setCellValue(new HSSFRichTextString((String) m1.get("RESIDENTTELNUMBER"))); } if (i == 30) { cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKCOMPANYNAME"))); } if (i == 31) { cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKADDRESS"))); } if (i == 32) { cell.setCellValue(new HSSFRichTextString((String) m1.get("WORKTELNUMBER"))); } if (i == 33) { cell.setCellValue(new HSSFRichTextString((String) m1.get("EMAILADDRESS"))); } if (i == 34) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREP"))); } if (i == 35) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREPCREDENTIALTYPE"))); } if (i == 36) { cell.setCellValue( new HSSFRichTextString((String) m1.get("ARTIFICIALPERSONREPCREDENTIALNUMBER"))); } if (i == 37) { cell.setCellValue(new HSSFRichTextString((String) m1.get("BUSINESSLICENSENUMBER"))); } if (i == 38) { cell.setCellValue(new HSSFRichTextString((String) m1.get("STATETAXSERIAL"))); } if (i == 39) { cell.setCellValue(new HSSFRichTextString((String) m1.get("LOCALTAXSERIAL"))); } } // j++; } int k = 1; for (Map m2 : jymxList) { // HSSFRow row = sheet2.createRow(k); for (int i = 0; i < totalColNum2; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m2.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m2.get("CARDNUMBER"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSSERIALNUMBER"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m2.get("BORROWINGSIGNS"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONTYPE"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONAMOUNT"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString((String) m2.get("CURRENCY"))); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONTIME"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m2.get("ACCOUNTBALANCE"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTNAME"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONSERIAL"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTCREDENTIALNUMBER"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTACCOUNTNUMBER"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONREMARK"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m2.get("OPPONENTDEPOSITBANKID"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONBRANCHCODE"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONBRANCHNAME"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m2.get("SUMMONSNUMBER"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m2.get("LOGNUMBER"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m2.get("VOUCHERCODE"))); } if (i == 20) { cell.setCellValue(new HSSFRichTextString((String) m2.get("VOUCHERTYPE"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TERMINALNUMBER"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m2.get("CASHMARK"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONADDRESS"))); } if (i == 24) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TRANSACTIONSTATUS"))); } if (i == 25) { cell.setCellValue(new HSSFRichTextString((String) m2.get("MERCHANTCODE"))); } if (i == 26) { cell.setCellValue(new HSSFRichTextString((String) m2.get("MERCHANTNAME"))); } if (i == 27) { cell.setCellValue(new HSSFRichTextString((String) m2.get("MAC"))); } if (i == 28) { cell.setCellValue(new HSSFRichTextString((String) m2.get("IPADDRESS"))); } if (i == 29) { cell.setCellValue(new HSSFRichTextString((String) m2.get("REMARK"))); } if (i == 30) { cell.setCellValue(new HSSFRichTextString((String) m2.get("TELLERCODE"))); } } // k++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //???Excel public File makeCkztqqExcel(List<Map> ckztqqList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet = wk.createSheet("ckztqq"); // HSSFRow firstRow = sheet.createRow(0); int totalColNum = 24; //? HSSFCell[] firstCell = new HSSFCell[totalColNum]; //??string String[] colNames = new String[totalColNum]; colNames[0] = "?"; colNames[1] = "?"; colNames[2] = "???"; colNames[3] = "??"; colNames[4] = "?"; colNames[5] = ""; colNames[6] = ""; colNames[7] = ""; colNames[8] = "?"; colNames[9] = "??"; colNames[10] = "??"; colNames[11] = "?/?"; colNames[12] = ""; colNames[13] = ""; colNames[14] = ""; colNames[15] = "?"; colNames[16] = "??"; colNames[17] = "??"; colNames[18] = "???"; colNames[19] = "???"; colNames[20] = "??"; colNames[21] = "???"; colNames[22] = "????"; colNames[23] = "????"; //?? for (int i = 0; i < totalColNum; i++) { //? firstCell[i] = firstRow.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell[i].setCellValue(new HSSFRichTextString(colNames[i])); } //???excel //j1 ?rs int j = 1; for (Map m : ckztqqList) { // HSSFRow row = sheet.createRow(j); for (int i = 0; i < totalColNum; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m.get("MESSAGEFROM"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASENUMBER"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASETYPE"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString( "02".equals(((String) m.get("EMERGENCYLEVEL"))) ? "" : "")); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m.get("SUBJECTTYPE"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKNAME"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTNAME"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m.get("CARDNUMBER"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m.get("REASON"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDTYPE"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDNUMBER"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORNAME"))); } if (i == 20) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORPHONENUMBER"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDTYPE"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDNUMBER"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORNAME"))); } } // j++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //???Excel public File makeCkztjgExcel(List<Map> ckztjgList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet = wk.createSheet("ckztjg"); // HSSFRow firstRow = sheet.createRow(0); int totalColNum = 24; //? HSSFCell[] firstCell = new HSSFCell[totalColNum]; //??string String[] colNames = new String[totalColNum]; colNames[0] = "??"; colNames[1] = "????"; colNames[2] = "ID"; colNames[3] = "?"; colNames[4] = "???"; colNames[5] = "?"; colNames[6] = "?"; colNames[7] = "??"; colNames[8] = "?/??"; colNames[9] = "??"; colNames[10] = "??"; colNames[11] = "?/???"; colNames[12] = "??"; colNames[13] = "?/????"; colNames[14] = "???"; colNames[15] = "??"; colNames[16] = "?"; colNames[17] = "???"; colNames[18] = ""; colNames[19] = "?"; colNames[20] = "???"; colNames[21] = "??"; colNames[22] = "?"; colNames[23] = "?"; //?? for (int i = 0; i < totalColNum; i++) { //? firstCell[i] = firstRow.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell[i].setCellValue(new HSSFRichTextString(colNames[i])); } //???excel //j1 ?rs int j = 1; for (Map m : ckztjgList) { // HSSFRow row = sheet.createRow(j); for (int i = 0; i < totalColNum; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m.get("NEWTRANSSERIALNUMBER"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m.get("JSJG"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALNUMBER"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString((String) m.get("TELNUMBER"))); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALTYPE"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORCREDENTIALTYPE"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTSUBJECTNAME"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m.get("RESIDENTADDRESS"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORNAME"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m.get("WORKCOMPANYNAME"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m.get("CARDOPERATORCREDENTIALNUMBER"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m.get("WORKTELNUMBER"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m.get("RESIDENTTELNUMBER"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m.get("EMAILADDRESS"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m.get("WORKADDRESS"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREP"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREPCREDENTIALTYPE"))); } if (i == 20) { cell.setCellValue( new HSSFRichTextString((String) m.get("ARTIFICIALPERSONREPCREDENTIALNUMBER"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m.get("BUSINESSLICENSENUMBER"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m.get("STATETAXSERIAL"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m.get("LOCALTAXSERIAL"))); } } // j++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //???Excel public File makeQzhqqExcel(List<Map> qzhqqList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet = wk.createSheet("qzhqq"); // HSSFRow firstRow = sheet.createRow(0); int totalColNum = 27; //? HSSFCell[] firstCell = new HSSFCell[totalColNum]; //??string String[] colNames = new String[totalColNum]; colNames[0] = "?"; colNames[1] = "?"; colNames[2] = "???"; colNames[3] = "??"; colNames[4] = "?"; colNames[5] = ""; colNames[6] = ""; colNames[7] = "??"; colNames[8] = "?"; colNames[9] = ""; colNames[10] = "??"; colNames[11] = "???"; colNames[12] = "??"; colNames[13] = ""; colNames[14] = ""; colNames[15] = ""; colNames[16] = ""; colNames[17] = "?"; colNames[18] = "??"; colNames[19] = "??"; colNames[20] = "???"; colNames[21] = "???"; colNames[22] = "??"; colNames[23] = "???"; colNames[24] = "????"; colNames[25] = "????"; //?? for (int i = 0; i < totalColNum; i++) { //? firstCell[i] = firstRow.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell[i].setCellValue(new HSSFRichTextString(colNames[i])); } //???excel //j1 ?rs int j = 1; for (Map m : qzhqqList) { // HSSFRow row = sheet.createRow(j); for (int i = 0; i < totalColNum; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m.get("TXCODE"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m.get("MESSAGEFROM"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m.get("TRANSSERIALNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASENUMBER"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m.get("CASETYPE"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString( "02".equals(((String) m.get("EMERGENCYLEVEL"))) ? "" : "")); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKNAME"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m.get("BANKID"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString( "2".equals(((String) m.get("SUBJECTTYPE"))) ? "" : "")); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALTYPE"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTCREDENTIALNUMBER"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m.get("ACCOUNTSUBJECTNAME"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString( "02".equals(((String) m.get("INQUIRYMODE"))) ? "?" : "?")); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m.get("REASON"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m.get("REMARK"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONTIME"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGID"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m.get("APPLICATIONORGNAME"))); } if (i == 19) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDTYPE"))); } if (i == 20) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORIDNUMBER"))); } if (i == 21) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORNAME"))); } if (i == 22) { cell.setCellValue(new HSSFRichTextString((String) m.get("OPERATORPHONENUMBER"))); } if (i == 23) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDTYPE"))); } if (i == 24) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORNAME"))); } if (i == 25) { cell.setCellValue(new HSSFRichTextString((String) m.get("INVESTIGATORIDNUMBER"))); } } // j++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //?Excel public File makeQzhjgExcel(List<Map> qzhzhxxList, List<Map> qzhdjList, String filePath) throws IOException { HSSFWorkbook wk = new HSSFWorkbook(); HSSFSheet sheet1 = wk.createSheet("zhxx"); HSSFSheet sheet2 = wk.createSheet("djxx"); // HSSFRow firstRow1 = sheet1.createRow(0); HSSFRow firstRow2 = sheet2.createRow(0); int totalColNum1 = 40; int totalColNum2 = 31; //? HSSFCell[] firstCell1 = new HSSFCell[totalColNum1]; HSSFCell[] firstCell2 = new HSSFCell[totalColNum2]; //??string String[] colNames1 = new String[totalColNum1]; colNames1[0] = "??"; colNames1[1] = "????"; colNames1[2] = "??"; colNames1[3] = ""; colNames1[4] = ""; colNames1[5] = "?"; colNames1[6] = ""; colNames1[7] = ""; colNames1[8] = ""; colNames1[9] = ""; colNames1[10] = "??"; colNames1[11] = "(?)??"; colNames1[12] = "(?)"; colNames1[13] = "?"; colNames1[14] = "??"; colNames1[15] = ""; colNames1[16] = "?"; colNames1[17] = "??"; colNames1[18] = "?"; String[] colNames2 = new String[totalColNum2]; colNames2[0] = "?"; colNames2[1] = "???? "; colNames2[2] = "??"; colNames2[3] = "?"; colNames2[4] = "??"; colNames2[5] = ""; colNames2[6] = ""; colNames2[7] = "??"; colNames2[8] = "??"; colNames2[9] = "?"; colNames2[10] = ""; //?? for (int i = 0; i < totalColNum1; i++) { //? firstCell1[i] = firstRow1.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell1[i].setCellValue(new HSSFRichTextString(colNames1[i])); } //?? for (int i = 0; i < totalColNum2; i++) { //? firstCell2[i] = firstRow2.createCell(i); //? ?? new HSSFRichTextString(colNames[i]) ? firstCell2[i].setCellValue(new HSSFRichTextString(colNames2[i])); } //???excel //j1 ?rs int j = 1; for (Map m1 : qzhzhxxList) { // HSSFRow row = sheet1.createRow(j); for (int i = 0; i < totalColNum1; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m1.get("TRANSSERIALNUMBER"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m1.get("NEWTRANSSERIALNUMBER"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNAME"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CARDNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCH"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m1.get("DEPOSITBANKBRANCHCODE"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTOPENTIME"))); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONTIME"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTCANCELLATIONBRANCH"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m1.get("REMARK"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTNUMBER"))); } if (i == 11) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSERIAL"))); } if (i == 12) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTTYPE"))); } if (i == 13) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTSTATUS"))); } if (i == 14) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CURRENCY"))); } if (i == 15) { cell.setCellValue(new HSSFRichTextString((String) m1.get("CASHREMIT"))); } if (i == 16) { cell.setCellValue(new HSSFRichTextString((String) m1.get("ACCOUNTBALANCE"))); } if (i == 17) { cell.setCellValue(new HSSFRichTextString((String) m1.get("AVAILABLEBALANCE"))); } if (i == 18) { cell.setCellValue(new HSSFRichTextString((String) m1.get("LASTTRANSACTIONTIME"))); } } // j++; } int k = 1; for (Map m2 : qzhdjList) { // HSSFRow row = sheet2.createRow(k); for (int i = 0; i < totalColNum2; i++) { //?? HSSFCell cell = row.createCell(i); //? ?new HSSFRichTextString()?? //rs.getString(i+1)1?? if (i == 0) { cell.setCellValue(new HSSFRichTextString((String) m2.get("APPLICATIONID"))); } if (i == 1) { cell.setCellValue(new HSSFRichTextString((String) m2.get("NEWTRANSSERIALNUMBER"))); } if (i == 2) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZESERIAL"))); } if (i == 3) { cell.setCellValue(new HSSFRichTextString((String) m2.get("ACCOUNTNUMBER"))); } if (i == 4) { cell.setCellValue(new HSSFRichTextString((String) m2.get("CARDNUMBER"))); } if (i == 5) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZESTARTTIME"))); } if (i == 6) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEENDTIME"))); } if (i == 7) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEDEPTNAME"))); } if (i == 8) { cell.setCellValue(new HSSFRichTextString((String) m2.get("CURRENCY"))); } if (i == 9) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZEBALANCE"))); } if (i == 10) { cell.setCellValue(new HSSFRichTextString((String) m2.get("FREEZETYPE"))); } } // k++; } //? OutputStream out = new FileOutputStream(filePath); //?excel? wk.write(out); //? out.close(); return new File(filePath); } //? public File compressFileListToZip(List<File> fileList, String strZipFilePath) throws IOException { byte[] buffer = new byte[1024]; ZipOutputStream out = new ZipOutputStream(new FileOutputStream(strZipFilePath)); for (int i = 0; i < fileList.size(); i++) { FileInputStream fis = new FileInputStream(fileList.get(i)); out.putNextEntry(new ZipEntry(fileList.get(i).getName())); int len; //?zip while ((len = fis.read(buffer)) > 0) { out.write(buffer, 0, len); } out.closeEntry(); fis.close(); } out.close(); return new File(strZipFilePath); } }