Java tutorial
package com.synct.report; import java.io.*; import java.util.*; import java.sql.*; import java.lang.*; import org.apache.poi.poifs.filesystem.*; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.*; import org.apache.poi.hssf.util.CellReference; import com.synct.util.*; import com.codecharge.*; import com.codecharge.components.*; import com.codecharge.util.*; import com.codecharge.events.*; import com.codecharge.db.*; import com.codecharge.validation.*; public class bm10101_1 extends Ole2Adapter { private int onepage_detail = 20000; //@XCdetail private int dtl_start_row = 3; //detailqpageXC}l private int dtl_cols = 2; //detailX private String execlfilename = "bm10101_1.xls"; //excelW public bm10101_1() { page_rows = 20000; //@XC } //e private String separator; private String path; public void setReset(String emptyString) { this.path = ""; this.path = ""; } public void setPath(String path) { this.path = path; } public String getPath() { return this.path; } public POIFSFileSystem fs; public HSSFWorkbook wb; public HSSFSheet sheet, sheet1, sheet2, sheet3; public HSSFPrintSetup ps; HSSFCellStyle[][] header_style; //headerstyle HSSFCellStyle[][] body_style; //bodystyle String[] data; String[] data_other; String[][] header_value; //headerW, String[][] body_value; //bodyW, Region[] region; //Xxs}C //eqwo public String[] getDataValue(String[] wherestring) throws Exception { String ls_sql = ""; ls_sql += " SELECT GETBUILDLICS('" + wherestring[0].trim() + "') INFO FROM DUAL "; JDBCConnection conn = JDBCConnectionFactory.getJDBCConnection("SynctConn"); System.err.println(ls_sql); // Enumeration rows1 = null; int i = 0; rows1 = conn.getRows(ls_sql); conn.closeConnection(); String[] rds = new String[40]; String ldata = null; while (rows1 != null && rows1.hasMoreElements()) { DbRow row2 = (DbRow) rows1.nextElement(); ldata = Utils.convertToString(row2.get("INFO")); } rds = ldata.split(";"); System.out.println("*****data rds ***********:" + rds); System.err.println("*****data rds ***********:" + rds); return rds; } //eqwo u@ public String[] getData(String[] wherestring) throws Exception { String KEY = wherestring[0]; long l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_P01", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); int i_cnt = (int) l_cnt; System.out.println("#######bm10101_1 i_cnt: " + i_cnt); JDBCConnection conn = JDBCConnectionFactory.getJDBCConnection("SynctConn"); String[] ds = new String[300]; String[] p01 = new String[6]; // Enumeration rows1 = null; DbRow CurrentRecord; String ls_sql = " ", temp = " "; ds[0] = "_yHlhG"; int x = 0; for (int n = 1; n <= i_cnt; n++) { ls_sql = " select GETP01S('" + KEY + "'," + Integer.toString(n).trim() + ") info from dual "; // System.out.println("#######bm10101_1 ls_sql: " + ls_sql); rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } p01 = temp.split(";"); System.out.println("#######bm10101_1 p01[0]: " + p01[0]); System.out.println("#######bm10101_1 p01[1]: " + p01[1]); ds[2 * n - 1] = p01[0]; ds[2 * n] = p01[1]; System.out.println("#######bm10101_1 ds[2*n-1]: " + ds[2 * n - 1]); System.out.println("#######bm10101_1 ds[2*n]: " + ds[2 * n]); } x = 2 * i_cnt; l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_LAN", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); i_cnt = (int) l_cnt / 3; x++; ds[x] = "aG"; for (int n = 1; n <= i_cnt; n++) { ls_sql = " select GETLANS('" + KEY + "'," + Integer.toString(n).trim() + ") info from dual "; // System.out.println("#######bm10101_1 ls_sql: " + ls_sql); rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } ds[x + n] = temp; } x += i_cnt; x++; ds[x] = "vnG"; l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_STAIR", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); i_cnt = (int) l_cnt; for (int n = 1; n <= i_cnt; n++) { ls_sql = " select GETSTAIRS('" + KEY + "'," + Integer.toString(n).trim() + ") info from dual "; // System.out.println("#######bm10101_1 ls_sql: " + ls_sql); rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } ds[x + n] = temp; } x += i_cnt; x++; ds[x] = " ]mO QO /~ aW/U n(T) "; l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_PARK", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); i_cnt = (int) l_cnt; for (int n = 1; n <= i_cnt; n++) { ls_sql = " select GETPARKS('" + KEY + "'," + Integer.toString(n).trim() + ") info from dual "; // rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } ds[x + n] = temp; } x += i_cnt; x++; ds[x] = "[: "; x++; ds[x] = "iAkOnj"; l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_PARK", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); i_cnt = (int) l_cnt; ls_sql = " select GETLAWS('" + KEY + "') info from dual "; // rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } p01 = temp.split(";"); if (!StringUtils.isEmpty(p01[0])) { x++; ds[x] = p01[0]; } if (!StringUtils.isEmpty(p01[1])) { x++; ds[x] = p01[1]; } if (!StringUtils.isEmpty(p01[2])) { x++; ds[x] = p01[2]; } l_cnt = Utils .convertToLong(DBTools.dLookUp("COUNT(*) ", "BM_MEMO", " INDEX_KEY ='" + KEY + "' ", "SynctConn")); i_cnt = (int) l_cnt; for (int n = 1; n <= i_cnt; n++) { ls_sql = " select GETMEMOS('" + KEY + "'," + Integer.toString(n).trim() + ") info from dual "; // System.out.println("#######bm10101_1 ls_sql: " + ls_sql); rows1 = conn.getRows(ls_sql); while (rows1 != null && rows1.hasMoreElements()) { CurrentRecord = (DbRow) rows1.nextElement(); temp = Utils.convertToString(CurrentRecord.get("info")); } p01 = temp.split(";"); System.out.println("#######bm10101_1 p01[0]: " + p01[0]); for (String token : p01) { x++; ds[x] = token; } } conn.closeConnection(); return ds; } /** *<br>GX *<br>G L *<br>^Gboolean */ public synchronized boolean outXLS(String userid, String[] wherestring) throws Exception { try { separator = System.getProperty("file.separator"); fs = new POIFSFileSystem(new FileInputStream(getPath() + "template" + separator + execlfilename)); wb = new HSSFWorkbook(fs); sheet = wb.getSheetAt(0); sheet1 = wb.getSheetAt(1); sheet2 = wb.getSheetAt(2); sheet3 = wb.getSheetAt(3); ps = sheet.getPrintSetup(); sheet.setAutobreaks(false); sheet1.setAutobreaks(false); sheet2.setAutobreaks(false); sheet3.setAutobreaks(false); execOut(userid, wherestring); } catch (Exception e) { throw new Exception(e); //System.err.println("outXLS error is "+e); //return false; } return true; } //Excel public void execOut(String userid, String[] wherestring) throws Exception { FileOutputStream fileOut = null; try { //iwd System.err.println("bm10101_1.java: before getDataValue."); data = getDataValue(wherestring); data_other = getData(wherestring); System.err.println("bm10101_1.java: end getDataValue."); //s body_style = copyPageBodyStyleBlock(sheet, 0, 0, 34, 35); // (int row, int start col, int cols) //sxs body_value = copyPageBodyValueBlock(sheet, 0, 0, 34, 35); //s@Xxs region = copyMergedRegion(sheet); //System.err.println("1"); //pX`,jwCBz@,]iH`h]j pastePageBodyStyleBlock(sheet, body_style, 0, 0); pastePageBodyValueBlock(sheet, body_value, 0, 0); // //gJdetail printPageBody(0, data, 0); //sG body_style = copyPageBodyStyleBlock(sheet1, 0, 0, 35, 55); // (int row, int start col, int cols) //sxs body_value = copyPageBodyValueBlock(sheet1, 0, 0, 35, 55); //sGXxs //region = copyMergedRegion(sheet1); // pasteMergedRegion(sheet1, region, 0, 0); pastePageBodyStyleBlock(sheet1, body_style, 0, 0); pastePageBodyValueBlock(sheet1, body_value, 0, 0); //l printPageBody1(0, data, 0); //sT body_style = copyPageBodyStyleBlock(sheet2, 0, 0, 35, 47); // (int row, int start col, int cols) //sxs body_value = copyPageBodyValueBlock(sheet2, 0, 0, 35, 47); //sTXxs //region = copyMergedRegion(sheet2); // pasteMergedRegion(sheet, region, 0, 0); pastePageBodyStyleBlock(sheet2, body_style, 0, 0); pastePageBodyValueBlock(sheet2, body_value, 0, 0); //l printPageBody2(0, data, 0); //s| body_style = copyPageBodyStyleBlock(sheet3, 0, 0, 35, 54); // (int row, int start col, int cols) //sxs body_value = copyPageBodyValueBlock(sheet3, 0, 0, 35, 54); //s|Xxs //region = copyMergedRegion(sheet3); // pasteMergedRegion(sheet3, region, 0, 0); pastePageBodyStyleBlock(sheet3, body_style, 0, 0); pastePageBodyValueBlock(sheet3, body_value, 0, 0); //l printPageBody3(0, data, 0); // //printFoot("" + (page + 1) + "A@" + (total_page) + ""); // // setPageBreak(ps); //XExcel fileOut = new FileOutputStream(getPath() + "output" + separator + userid + execlfilename); wb.write(fileOut); } catch (Exception e) { System.err.println("bm10101_1:execOut error is " + e.toString()); throw new Exception(e.getMessage()); } finally { fileOut.close(); } } public static void main(String[] args) { System.out.println("I am here"); } public void printPageBody(int k, String[] data1, int rowno) throws IOException { try { //[J CellReference cellReference = new CellReference("J13"); HSSFRow row = sheet.getRow(0); HSSFCell cell1 = row.getCell((short) (20)); setBig5CellValue(data1[0], cell1); //U1 LICENSE_DESC row = sheet.getRow(1); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[1], cell1); //G2 P01_NAME row = sheet.getRow(2); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[2], cell1); //G3 ADDR row = sheet.getRow(3); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[3], cell1); //G4 P02_NAME row = sheet.getRow(3); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[4], cell1); //X4 OFFICE_NAME row = sheet.getRow(4); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[5], cell1); //G5 LANNO row = sheet.getRow(5); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[6], cell1); //G6 ADDR row = sheet.getRow(6); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[7], cell1); //G7 USE_CATEGORY_CODE_DESC row = sheet.getRow(7); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[8], cell1); //J8 AREA_ARC row = sheet.getRow(7); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[9], cell1); //X8 AREA_OTHER row = sheet.getRow(8); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[10], cell1); //J9 AREA_SHRINK row = sheet.getRow(8); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[11], cell1); //X9 AREA_TOTAL //***************************************************************************** /* 0 1 2 3 4 5 6 7 8 910111213141516171819202122232425 6 7 8 930 1 2 3 4 5 A B C D E F G H I J K L M N O P Q R S T U V W X Y ZAAABACADAEAFAGAHAIAJ */ row = sheet.getRow(9); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[12], cell1); //G10 USAGE_CODE_DESC row = sheet.getRow(10); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[13], cell1); //G11 BUILDING_CATEGORY row = sheet.getRow(10); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[14], cell1); //X11 CHWANG DONG row = sheet.getRow(10); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[15], cell1); //AF11 BUILD_HIHIGHT row = sheet.getRow(11); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[15], cell1); //G12 BUILDING_KIND_DESC row = sheet.getRow(11); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[16], cell1); //X12 BUILDING_HEIGHT row = sheet.getRow(11); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[17], cell1); //AF12 BUILD_HIHIGHT row = sheet.getRow(12); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[19], cell1); //X13 LAW_COVER_RATE row = sheet.getRow(12); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[18], cell1); //AF13 SPACE_RATE row = sheet.getRow(12); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[20], cell1); //G13 BASE_AREA_TOTAL // row = sheet.getRow(12); // cell1 =row.getCell((short)(23)); // setBig5CellValue(data1[20],cell1); //X13 BUILD_COVER_RATE row = sheet.getRow(13); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[21], cell1); //J14 TOTAL_CONSTRU_AREA row = sheet.getRow(14); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[22], cell1); //J15 STATUTORY_OPEN_SPACE row = sheet.getRow(13); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[23], cell1); //AA14 AIRRAID_U_AREA row = sheet.getRow(14); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[24], cell1); //AA15 AIRRAID_D_AREA row = sheet.getRow(16); cell1 = row.getCell((short) (2)); setBig5CellValue(data1[25], cell1); //C17 PARK_SUM1 row = sheet.getRow(16); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[26], cell1); //J17 PARK_SUM3 row = sheet.getRow(16); cell1 = row.getCell((short) (16)); setBig5CellValue(data1[27], cell1); //Q17 PARK_SUM2 row = sheet.getRow(16); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[28], cell1); //X17 PARK_SUM row = sheet.getRow(16); cell1 = row.getCell((short) (29)); setBig5CellValue(data1[29], cell1); //AD17 PARK_ row = sheet.getRow(17); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[30], cell1); //G18 OTHERS_NAME row = sheet.getRow(18); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[31], cell1); //G19 PRICE row = sheet.getRow(19); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[32], cell1); //Y20 VALID_MONTH row = sheet.getRow(20); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[33], cell1); //G21 APPROVE_LICE_DATE row = sheet.getRow(20); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[34], cell1); //Y21 RECEIVE_LICE_DATE row = sheet.getRow(36); cell1 = row.getCell((short) (1)); setBig5CellValue("W " + data1[1], cell1); //B37 P01_NAME row = sheet.getRow(40); cell1 = row.getCell((short) (15)); setBig5CellValue(data1[35], cell1); //P41 IDENTIFY_LICE_DATE row = sheet.getRow(21); cell1 = row.getCell((short) (0)); setBig5CellValue(data1[36], cell1); //A22 PUBLIC_CODE row = sheet.getRow(21); cell1 = row.getCell((short) (19)); setBig5CellValue(data1[37], cell1); //T22 BASE_AREA_PURPOSE } catch (Exception e) { System.err.println("bm10101_1:printPageBody error is " + e); } } public void printPageBody1(int k, String[] data1, int rowno) throws IOException { try { HSSFRow row = sheet1.getRow(1); HSSFCell cell1 = row.getCell((short) (0)); setBig5CellValue("_yHlhG", cell1); //A2 row = sheet1.getRow(0); cell1 = row.getCell((short) (21)); setBig5CellValue(data1[0], cell1); //V1 // System.out.println("bm10101_1:data_other.length " + data_other.length); // System.out.println("bm10101_1:data_other[0] " + data_other[0]); // System.out.println("bm10101_1:data_other[1] " + data_other[1]); int j = 0; for (int i = 1; i <= data_other.length; i++) { //A3 A4 A5 A6 A7 row = sheet1.getRow(1 + i); cell1 = row.getCell((short) (0)); setBig5CellValue(data_other[i], cell1); j = i; System.out.println("bm10101_1:data_other[i] " + data_other[i]); if (StringUtils.isEmpty(data_other[i])) break; } row = sheet1.getRow(3 + j); cell1 = row.getCell((short) (0)); setBig5CellValue("HU", cell1); // } catch (Exception e) { System.err.println("bm10101_1:printPageBody error is " + e); } } public void printPageBody2(int k, String[] data1, int rowno) throws IOException { try { //[J HSSFRow row = sheet2.getRow(0); HSSFCell cell1 = row.getCell((short) (20)); setBig5CellValue(data1[0], cell1); //U1 LICENSE_DESC row = sheet2.getRow(1); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[1], cell1); //G2 P01_NAME row = sheet2.getRow(2); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[2], cell1); //G3 ADDR row = sheet2.getRow(3); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[3], cell1); //G4 P02_NAME row = sheet2.getRow(3); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[4], cell1); //X4 OFFICE_NAME row = sheet2.getRow(4); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[5], cell1); //G5 LANNO row = sheet2.getRow(5); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[6], cell1); //G6 ADDR row = sheet2.getRow(6); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[7], cell1); //G7 USE_CATEGORY_CODE_DESC row = sheet2.getRow(7); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[8], cell1); //J8 AREA_ARC row = sheet2.getRow(7); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[9], cell1); //X8 AREA_OTHER row = sheet2.getRow(8); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[10], cell1); //J9 AREA_SHRINK row = sheet2.getRow(8); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[11], cell1); //X9 AREA_TOTAL //***************************************************************************** /* 0 1 2 3 4 5 6 7 8 910111213141516171819202122232425 6 7 8 930 1 2 3 4 5 A B C D E F G H I J K L M N O P Q R S T U V W X Y ZAAABACADAEAFAGAHAIAJ */ row = sheet2.getRow(9); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[12], cell1); //G10 USAGE_CODE_DESC row = sheet2.getRow(10); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[13], cell1); //G11 BUILDING_CATEGORY row = sheet2.getRow(10); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[14], cell1); //X11 CHWANG DONG row = sheet2.getRow(10); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[15], cell1); //AF11 BUILD_HIHIGHT row = sheet2.getRow(11); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[15], cell1); //G12 BUILDING_KIND_DESC row = sheet2.getRow(11); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[16], cell1); //X12 BUILDING_HEIGHT row = sheet2.getRow(11); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[17], cell1); //AF12 BUILD_HIHIGHT row = sheet2.getRow(12); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[19], cell1); //X13 LAW_COVER_RATE row = sheet2.getRow(12); cell1 = row.getCell((short) (31)); setBig5CellValue(data1[18], cell1); //AF13 SPACE_RATE row = sheet2.getRow(12); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[20], cell1); //G13 BASE_AREA_TOTAL // row = sheet2.getRow(12); // cell1 =row.getCell((short)(23)); // setBig5CellValue(data1[20],cell1); //X13 BUILD_COVER_RATE row = sheet2.getRow(13); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[21], cell1); //J14 TOTAL_CONSTRU_AREA row = sheet2.getRow(14); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[22], cell1); //J15 STATUTORY_OPEN_SPACE row = sheet2.getRow(13); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[23], cell1); //AA14 AIRRAID_U_AREA row = sheet2.getRow(14); cell1 = row.getCell((short) (26)); setBig5CellValue(data1[24], cell1); //AA15 AIRRAID_D_AREA row = sheet2.getRow(16); cell1 = row.getCell((short) (2)); setBig5CellValue(data1[25], cell1); //C17 PARK_SUM1 row = sheet2.getRow(16); cell1 = row.getCell((short) (9)); setBig5CellValue(data1[26], cell1); //J17 PARK_SUM3 row = sheet2.getRow(16); cell1 = row.getCell((short) (16)); setBig5CellValue(data1[27], cell1); //Q17 PARK_SUM2 row = sheet2.getRow(16); cell1 = row.getCell((short) (23)); setBig5CellValue(data1[28], cell1); //X17 PARK_SUM row = sheet2.getRow(16); cell1 = row.getCell((short) (29)); setBig5CellValue(data1[29], cell1); //AD17 PARK_ row = sheet2.getRow(17); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[30], cell1); //G18 OTHERS_NAME row = sheet2.getRow(18); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[31], cell1); //G19 PRICE row = sheet2.getRow(19); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[32], cell1); //Y20 VALID_MONTH row = sheet2.getRow(20); cell1 = row.getCell((short) (6)); setBig5CellValue(data1[33], cell1); //G21 APPROVE_LICE_DATE row = sheet2.getRow(20); cell1 = row.getCell((short) (24)); setBig5CellValue(data1[34], cell1); //Y21 RECEIVE_LICE_DATE row = sheet2.getRow(36); cell1 = row.getCell((short) (1)); setBig5CellValue("W " + data1[1], cell1); //B37 P01_NAME row = sheet2.getRow(40); cell1 = row.getCell((short) (15)); setBig5CellValue(data1[35], cell1); //P41 IDENTIFY_LICE_DATE row = sheet2.getRow(21); cell1 = row.getCell((short) (0)); setBig5CellValue(data1[36], cell1); //A22 PUBLIC_CODE row = sheet2.getRow(21); cell1 = row.getCell((short) (19)); setBig5CellValue(data1[37], cell1); //T22 BASE_AREA_PURPOSE } catch (Exception e) { System.err.println("bm10101_1 sheet2:printPageBody error is " + e); } } public void printPageBody3(int k, String[] data1, int rowno) throws IOException { try { HSSFRow row = sheet3.getRow(1); HSSFCell cell1 = row.getCell((short) (0)); setBig5CellValue("_yHlhG", cell1); //A2 row = sheet3.getRow(0); cell1 = row.getCell((short) (21)); setBig5CellValue(data1[0], cell1); //V1 // System.out.println("bm10101_1:data_other.length " + data_other.length); // System.out.println("bm10101_1:data_other[0] " + data_other[0]); // System.out.println("bm10101_1:data_other[1] " + data_other[1]); int j = 0; for (int i = 1; i <= data_other.length; i++) { //A3 A4 A5 A6 A7 row = sheet3.getRow(1 + i); cell1 = row.getCell((short) (0)); setBig5CellValue(data_other[i], cell1); j = i; System.out.println("bm10101_1:data_other[i] " + data_other[i]); if (StringUtils.isEmpty(data_other[i])) break; } row = sheet3.getRow(3 + j); cell1 = row.getCell((short) (0)); setBig5CellValue("HU", cell1); // } catch (Exception e) { System.err.println("bm10101_1:printPageBody error is " + e); } } } //[J /* 0 1 2 3 4 5 6 7 8 910111213141516171819202122232425 6 7 8 930 1 2 3 4 5 A B C D E F G H I J K L M N O P Q R S T U V W X Y ZAAABACADAEAFAGAHAIAJ rds[i][0] = StringUtils.isEmpty(AREA_ARC) ? "null": AREA_ARC; rds[i][1] = StringUtils.isEmpty(AREA_SHRINK) ? "null": AREA_SHRINK; rds[i][2] = StringUtils.isEmpty(AREA_OTHER) ? "null": AREA_OTHER; rds[i][3] = StringUtils.isEmpty(AREA_TOTAL) ? "null": AREA_TOTAL; rds[i][4] = StringUtils.isEmpty(PRICE) ? "null": PRICE; rds[i][5] = StringUtils.isEmpty(COMMENCE_DATE) ? "null": COMMENCE_DATE; rds[i][6] = StringUtils.isEmpty(VALID_MONTH) ? "null": VALID_MONTH; rds[i][7] = StringUtils.isEmpty(APPROVE_LICE_DATE) ? "null": APPROVE_LICE_DATE; rds[i][8] = StringUtils.isEmpty(RECEIVE_LICE_DATE) ? "null": RECEIVE_LICE_DATE; rds[i][9] = StringUtils.isEmpty(USE_CATEGORY_CODE_DESC) ? "null": USE_CATEGORY_CODE_DESC; rds[i][10] = StringUtils.isEmpty(LANNO) ? "null": LANNO; rds[i][11] = StringUtils.isEmpty(P01_NAME) ? "null": P01_NAME; rds[i][12] = StringUtils.isEmpty(ADDR) ? "null": ADDR; rds[i][13] = StringUtils.isEmpty(P02_NAME) ? "null": P02_NAME; rds[i][14] = StringUtils.isEmpty(OFFICE_NAME) ? "null": OFFICE_NAME; rds[i][15]LICENSE_DESC=Utils.convertToString(row2.get("LICENSE_DESC")); rds[i][16]IDENTIFY_LICE_DATE=Utils.convertToString(row2.get("IDENTIFY_LICE_DATE")); */