protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { WebApplicationContext ctx = WebApplicationContextUtils.getRequiredWebApplicationContext(this.getServletContext()); CourseManager manager = (CourseManager) ctx.getBean("courseManager"); HttpSession session = request.getSession(false); boolean b = false; if (request.getParameter("count") != null) { b = true; } List students = (List) session.getAttribute("students"); ByteArrayOutputStream ba = new ByteArrayOutputStream(); try { Document document = new Document(PageSize.A6.rotate(), 5, 5, 5, 5); PdfWriter writer = PdfWriter.getInstance(document, ba); document.open(); Image image = null; Clazz clazz; Student stmd; String SchoolName; String DeptName; StringBuilder StudentNo; Map map; Map StmdCardNum; // writer = PdfWriter.getInstance(document, ba); PdfContentByte cb = writer.getDirectContent(); BaseFont bf = BaseFont.createFont("/kaiu.ttf", "Identity-H", BaseFont.EMBEDDED); for (int i = 0; i < students.size(); i++) { stmd = (Student) manager .hqlGetBy( "FROM Student WHERE studentNo='" + ((Map) students.get(i)).get("student_no") + "'") .get(0); clazz = (Clazz) manager.hqlGetBy("FROM Clazz WHERE ClassNo='" + stmd.getDepartClass() + "'").get(0); map = manager.ezGetMap( "SELECT * FROM dept WHERE no='" + clazz.getClassNo().substring(0, 4) + "'"); try { // 系所名 DeptName = map.get("fname").toString(); } catch (Exception e) { DeptName = ""; } try { // 部制名 SchoolName = map.get("school_name").toString(); } catch (Exception e) { SchoolName = ""; } StudentNo = new StringBuilder(stmd.getStudentNo()); // List list=manager.hqlGetBy("FROM StdImage WHERE studentNo='"+StudentNo+"'"); /* if(b&&manager.testOnlineServer()){//寫入補發記錄 try{ //真實學號 manager.executeSql("INSERT INTO StmdCardNum (student_no, card_num)VALUES('"+stmd.getStudentNo()+"', 1)"); }catch(Exception e){ manager.executeSql("UPDATE StmdCardNum SET card_num=card_num+1 WHERE student_no='"+stmd.getStudentNo()+"'"); } StudentNo.append(manager.ezGetString("SELECT card_num FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'")); sendMailToLib(stmd, StudentNo.toString(), request); }else{ //檢查是否已發卡 StmdCardNum=manager.ezGetMap("SELECT * FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'"); if(StmdCardNum!=null){ StudentNo.append(manager.ezGetString("SELECT card_num FROM StmdCardNum WHERE student_no='"+stmd.getStudentNo()+"'")); } } */ StmdCardNum = manager.ezGetMap("SELECT * FROM StmdCardNum WHERE student_no='"); // 學號不滿8碼補空白, 未來改為9碼時? if (StudentNo.length() <= 8) { for (int j = StudentNo.length(); j < 8; j++) { StudentNo.append(" "); } } // 照片 try { image = getImage(StudentNo.toString()); } catch (Exception e) { continue; } if (image == null) continue; image.scaleAbsolute(54.94f, 74.37f); image.setAbsolutePosition(18, 166); // 條碼 Barcode39 code39 = new Barcode39(); code39.setCode(StudentNo.toString()); code39.setBarHeight(20); code39.setX(0.95f); code39.setStartStopText(false); code39.setGuardBars(false); code39.setExtended(false); code39.setChecksumText(false); code39.setSize(-1f); Image imageCode39 = code39.createImageWithBarcode(cb, null, null); imageCode39.setAbsolutePosition(83.15f, 152); cb.setColorStroke(Color.white); cb.rectangle(18, 150, 54.94f, 9); // 30 cb.setLineWidth(10); cb.stroke(); cb.closePath(); cb.closePathEoFillStroke(); cb.closePathFillStroke(); cb.closePathStroke(); // 文字 cb.beginText(); // 部制 cb.setFontAndSize(bf, 10); cb.showTextAligned(PdfContentByte.ALIGN_LEFT, SchoolName, 118, 229, 0); cb.endText(); cb.beginText(); // 科系 cb.setFontAndSize(bf, 10); if (DeptName.length() >= 9) { cb.setFontAndSize(bf, 8); } if (DeptName.length() >= 14) { cb.setFontAndSize(bf, 6); } cb.showTextAligned(PdfContentByte.ALIGN_LEFT, DeptName, 118, 215, 0); cb.endText(); cb.beginText(); // 學號 cb.setFontAndSize(bf, 10); cb.showTextAligned(PdfContentByte.ALIGN_LEFT, stmd.getStudentNo(), 118, 201, 0); cb.endText(); cb.beginText(); // 姓名 cb.setFontAndSize(bf, 10); cb.showTextAligned(PdfContentByte.ALIGN_LEFT, stmd.getStudentName(), 118, 187, 0); cb.endText(); document.add(image); document.add(imageCode39); document.newPage(); // bf=null; } document.close(); writer.close(); response.setHeader( "Content-Disposition", "attachment;filename=EmplCard" + Math.random() * 10 + ".pdf"); response.setContentLength(ba.size()); response.flushBuffer(); ServletOutputStream out = response.getOutputStream(); ba.writeTo(out); ba.close(); out.flush(); } catch (Exception e) { e.printStackTrace(); try { Document document = new Document(PageSize.A6.rotate(), 5, 5, 5, 5); PdfWriter writer = PdfWriter.getInstance(document, ba); document.open(); PdfContentByte cb = writer.getDirectContent(); BaseFont bf = BaseFont.createFont("/kaiu.ttf", "Identity-H", BaseFont.EMBEDDED); cb.beginText(); // 部制 cb.setFontAndSize(bf, 10); cb.showTextAligned(PdfContentByte.ALIGN_LEFT, "讀取資料有誤:" + e, 120, 226, 0); cb.endText(); // document.add(cb ); document.close(); document = null; } catch (DocumentException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } response.setContentType("text/html; charset=UTF-8"); response.setContentType("application/pdf"); response.setHeader("Content-disposition", "attachment;filename=TechTimetable.pdf"); response.setContentLength(ba.size()); ServletOutputStream out = response.getOutputStream(); ba.writeTo(out); out.flush(); } }