黑馬day09筆記第1章完善登錄

第2藥導(dǎo)2.1 Apache--wb--sheet--row--HSSF2003版--//寫入2003//寫入2003excel文publicvoidhssf_write()throws//1.Workbookworkbook=newHSSFWorkbook();for(ints=0;s<5;s++){//2.通過wb表格Sheetsheetworkbook.createSheet("第"+s+"張表");for(intr=0;r<10;r++){//3.通過sheet獲得行--rowRowrowsheet.createRow(r);//4.通過rowcellfor(intc=0;c<8;c++){Cellcell=//5通過cellcell.setCellValue(r+"@@"+}}}}//6workbookFileOutputStreamoutputStream=newFileOutputStream("1.xls");}XSSF2010版--XSSF2010//寫//寫入2010excel文publicvoidxssf_write()throws//1.Workbookworkbook=newXSSFWorkbook();for(ints=0;s<5;s++){//2.通過wb表格Sheetsheetworkbook.createSheet("第"+s+"張表");for(intr=0;r<10;r++){//3.通過sheet獲得行--rowRowrowsheet.createRow(r);//4.通過rowcellfor(intc=0;c<8;c++){Cellcell=cell.setCellValue(r+"@@"+}}}//6workbookFileOutputStreamoutputStream=newFileOutputStream("2.xlsx");}SXSSF2010版--SXSSFWorkbook()SXSSFWorkbook(size)，設(shè)置刷新行數(shù)，如果-1////寫入2010excel文檔--寫大量publicvoidsxssf_write()throws//1.Workbookworkbook=new//2.通過wb表格Sheetsheetworkbook.createSheet("1張表");for(intr=0;r<30000;r++){//3.通過sheet獲得行--rowRowrowsheet.createRow(r);//4.通過rowfor(intc=0c200c256Cellcell=row.createCell(c);//5通過cellcell.setCellValue(cell.setCellValue(r+"@@"+}if((r+1)%1000==0}}//6workbookFileOutputStreamoutputStream=newFileOutputStream("4.xlsx");}提供工具publicvoidsxssf_write_util()throwsList<String>fieldNames=newArrayList<String>(); fieldNames.add("藥品 稱fieldNames.add("價格//2需要顯示數(shù)據(jù)的javabeanfieldNames列表名稱對應(yīng)關(guān)系。List<String>fieldCodes=newArrayList<String>();//寫入List<YpxxTestBeandatalistnewArrayList<YpxxTestBean>();datalist.add(newYpxxTestBean("yp001","頭孢",100f));datalist.add(newYpxxTestBean("yp002","青霉素",998f));datalist.add(newYpxxTestBean("yp003"牛黃解毒片9999f));//設(shè)置基本ExcelExportSXXSSFexportSXXSSF=ExcelExportSXXSSF.start("./","","ypxx",fieldNames,fieldCodes,100);//設(shè)置需要寫入Stringpath=exportSXXSSF.exportFile();}讀操作步HSSF2003版--////2003publicvoidhssf_read()throwsWorkbookworkbook=newHSSFWorkbook(newSheetsheet=//*RowNum()*sheet.getLastRowNum()for(intr= RowNum();r<sheet.getLastRowNum();++){Rowrow=* for(intc= CellNum();c<row.getLastCellNum();Cellcell=Stringvalue=System.out.print(",}}}XSSF2010版--////2010publicvoidxssf_read()throws=Sheetsheet=//*RowNum()*sheet.getLastRowNum()for(intr= RowNum();r<=sheet.getLastRowNum();rRowrow=4* for(intc= CellNum();c<row.getLastCellNum();Cellcell=Stringvalue=System.out.print(",}}}Listener【////2003publicvoidlistener_read()throwsHSSFEventFactoryeventFactory=new HSSFRequestreq=new//2.1設(shè) {SSTRecordsstRecord=null;publicvoidprocessRecord(Recordrecord) 記錄所有數(shù)據(jù)，需要從所有中篩選需要的（單元格數(shù)據(jù)SSTRecord.sid){sstRecord=(SSTRecord)}LabelSSTRecord.sid){if(sstRecord!=LabelSSTRecordlabelSSTRecord=(LabelSSTRecord)record; }}}//3設(shè)置FileSystem，確定excelPOIFSFileSystemfs=newPOIFSFileSystem(new//處理--以“請求方式req”處理“文件//*需要在請求中定 }Listener工具publicvoidlistener_read_util()throws }publicpublicclassYpxxImportServiceImplimplementsHxlsOptRowsInterfacepublicStringsaveOptRows(intsheetIndex,intcurRow,List<String>rowlist)throwsException{//解析//獲取流Stringbm=//獲取通StringStringmc=Stringzbjg=//構(gòu)造一個poYpxxTestBeanypxx=newYpxxTestBean(bm,mc, return"1"; 分實(shí))通過流水號查詢通過流水號查詢@parampublicYpxxfindYpxxByBm(StringpublicYpxxfindYpxxByBm(String{=ons.eq("bm",bm)));if(list!=null&&list.size()0){return(Ypxx)}return}publicclassYpxxImportServiceImplimplementsHxlsOptRowsInterfaceprivateYpmlDao*返回結(jié)果，成功success，失敗返回publicStringsaveOptRows(intsheetIndex,intcurRow,List<String>rowlist)throwsException{//1.解析rowlist,獲得一行的//獲取流Stringbm=//獲取通Stringmc=//劑Stringjx=//規(guī)Stringgg=//單Stringdw=//轉(zhuǎn)換Stringzhxs=//獲取中標(biāo)Floatzbjg=//生產(chǎn)企業(yè)Stringscqymc=//Stringspmc=//交易Stringjyzt=//2將數(shù)據(jù)封裝到j(luò)avabeanypxxYpxxypxx=newYpxx();SysDictInfosysDictInfoByJyztnewSysDictInfo();if("1".equals(jyzt)){//1和正常elseif("2".equals(jyzt)){//2}}elsereturn"";//}YpxxypxxTemp=ypmlDao.findYpxxByBm(bm);if(ypxxTemp!=null){return}//4保//5返回，如果success表示成功一次，否則returnreturn}}//導(dǎo)入jsp頁//導(dǎo)入jsp頁publicimportypxx(){returnprivateprivateFileprivateString//導(dǎo)入//導(dǎo)入publicvoidimportypxxsubmit()throwsYpxxVoypxxVo= =+Filefile=newFile("F:/upload",filename);HxlsReadhxlsRead=newHxlsRead(file,1, Stringstr="已成功導(dǎo)入"+hxlsRead.getOptRows_success()+"條，失敗}//成功提//成功提示 = "+xHxlsRead.getOptRows_success()+"條，失敗導(dǎo)入"+xHxlsRead.getOptRows_failure()+"條//失敗提示List<ResultInfo>list=newfor(String g: { }functionfunction}//錯誤數(shù)據(jù)--將錯誤寫入到excel，并返回路徑提供給 //錯誤數(shù)據(jù)--將錯誤寫入到excel，并返回路徑提供給 第3章系統(tǒng)參數(shù) 第4章藥 同概XML（標(biāo)準(zhǔn)通用標(biāo)記語言下的一個子集）標(biāo)準(zhǔn)來描述、發(fā)布、發(fā)現(xiàn)、協(xié)調(diào)和配置這些應(yīng)用程WebService多系統(tǒng)之間，通過交互的方式，進(jìn)行模HTTP協(xié)議方法（HTTPTCP協(xié)議JDKProtocol：publicpublicclassWsYpxxServiceImplimplementspublicStringfindById(Stringid){return"服務(wù)端："+id;}}}publicpublicclassWsYpxxServiceImplimplementsWsYpxxService//2：當(dāng)前運(yùn)行調(diào)用時，執(zhí)行程序",newwsimportd-s-d-d-G:\Workspaces\20160602\webservice-client-WsYpxxServiceImplwsYpxxService= Serviceservice=Service.create(wsdlUrl,=. 2：具體的服務(wù)名稱，從xmlNamespace獲//1xmlURLwsdlUrl=new//2xml//參數(shù)1：xml