List of usage examples for org.apache.poi.hssf.usermodel HSSFFont setBold
public void setBold(boolean bold)
From source file:net.algem.planning.export.PlanningExportService.java
License:Open Source License
/** * * @param p current schedule/*from ww w . ja va2 s . c o m*/ * @param wb workbook * @return a formatted-string */ private RichTextString getLabel(ScheduleObject p, HSSFWorkbook wb) { String header = p.getStart() + "-" + p.getEnd() + "\n"; StringBuilder sb = new StringBuilder(); sb.append(header); switch (p.getType()) { case Schedule.COURSE: case Schedule.WORKSHOP: case Schedule.TRAINING: Course c = ((CourseSchedule) p).getCourse(); sb.append(c.getLabel() != null && c.getLabel().length() > 0 ? c.getLabel() : c.getTitle()); sb.append('\n'); sb.append(p.getPerson().getAbbrevFirstNameName()); if (p.getLength() > 30 && printMembers) { try { List<Person> members = planningService.getPersons(p.getId()); if (members.size() == 1) { Person per = members.get(0); sb.append('\n') .append(per.getNickName() != null && per.getNickName().length() > 0 ? per.getNickName() : per.getAbbrevFirstNameName()); } } catch (SQLException ex) { GemLogger.log(ex.getMessage()); } } break; default: sb.append(p.getScheduleLabel()); } String content = sb.toString(); HSSFFont bf = wb.createFont(); bf.setBold(true); HSSFFont nf = wb.createFont(); java.awt.Color textColor = colorizer.getTextColor(p); bf.setColor(getColorIndex(wb, textColor)); nf.setColor(getColorIndex(wb, textColor)); // RichTextString is used here to apply bold font to title RichTextString rts = new HSSFRichTextString(content); //int idx = content.indexOf("\n", content.indexOf("\n")+1); int idx = content.indexOf("\n") + 1; rts.applyFont(0, header.length(), bf); if (idx >= header.length()) {// some additional content was found rts.applyFont(header.length(), content.length(), nf); } return rts; }
From source file:opisiame.controller.gestion_resultat.Choix_exportController.java
@FXML public void excel_export() { File excel_file = choix_chemin_enregistrement("Excel files (*.xls)", "*.xls"); if (onglet_actif.equals("questions")) { if (excel_file != null) { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("Resultat par question"); sheet.autoSizeColumn(5);// w w w . jav a 2s . c o m create_data1(sheet, 0, "Question", "Pourcentage reponse A", "Pourcentage reponse B", "Pourcentage reponse C", "Pourcentage reponse D", "Pourcentage bonne rponse"); Row row = sheet.getRow(0); HSSFCellStyle cellStyle = null; HSSFFont font = wb.createFont(); font.setBold(true); cellStyle = wb.createCellStyle(); cellStyle.setFont(font); row.setRowStyle(cellStyle); for (int i = 0; i < reponse_questions.size(); i++) { Reponse_question rq = reponse_questions.get(i); create_data1(sheet, i + 1, rq.getQuestion(), rq.getStr_pourcentage_rep_a(), rq.getStr_pourcentage_rep_b(), rq.getStr_pourcentage_rep_c(), rq.getStr_pourcentage_rep_d(), rq.getStr_pourcentage()); } FileOutputStream fileOut; try { fileOut = new FileOutputStream(excel_file); wb.write(fileOut); fileOut.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } } else if (onglet_actif.equals("eleves")) { if (excel_file != null) { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("Resultat des tudiants"); sheet.autoSizeColumn(5); create_data2(sheet, 0, "Nom", "Prnom", "N tudiant", "Note", "Pourcentage"); Row row = sheet.getRow(0); HSSFCellStyle cellStyle = null; HSSFFont font = wb.createFont(); font.setBold(true); cellStyle = wb.createCellStyle(); cellStyle.setFont(font); row.setRowStyle(cellStyle); for (int i = 0; i < resultats_eleves.size(); i++) { Rep_eleves_quiz re = resultats_eleves.get(i); create_data2(sheet, i + 1, re.getNom_eleve(), re.getPrenom_eleve(), re.getNum_eleve().toString(), re.getNote_eleve().toString(), re.getPourcent_eleve().toString()); } FileOutputStream fileOut; try { fileOut = new FileOutputStream(excel_file); wb.write(fileOut); fileOut.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } } else if (onglet_actif.equals("eleves_pas_num")) { if (excel_file != null) { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("Resultat des tudiants"); sheet.autoSizeColumn(4); create_data3(sheet, 0, "Nom", "Prnom", "Note", "Pourcentage"); Row row = sheet.getRow(0); HSSFCellStyle cellStyle = null; HSSFFont font = wb.createFont(); font.setBold(true); cellStyle = wb.createCellStyle(); cellStyle.setFont(font); row.setRowStyle(cellStyle); for (int i = 0; i < resultats_eleves.size(); i++) { Rep_eleves_quiz re = resultats_eleves.get(i); create_data3(sheet, i + 1, re.getNom_eleve(), re.getPrenom_eleve(), re.getNote_eleve().toString(), re.getPourcent_eleve().toString()); } FileOutputStream fileOut; try { fileOut = new FileOutputStream(excel_file); wb.write(fileOut); fileOut.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } } close_window(); }
From source file:org.forzaframework.util.XlsUtils.java
License:Apache License
static public void modelToExcelSheet(HSSFWorkbook wb, String sheetName, List<Map<String, Object>> headers, List<Map<String, Object>> data, List<Map<String, Object>> footers, Integer freezePane, Boolean defaultFormat, Boolean createNewSheet, Integer indexSheet, Integer startInRow, Boolean printHeader, Boolean autoSizeColumns) { HSSFSheet sheet = getSheet(wb, sheetName, createNewSheet, indexSheet); HSSFCellStyle headerCellStyle = getDefaultHeaderCellStyle(wb, defaultFormat); HSSFCellStyle titlesCellStyle = null; if (defaultFormat != null && defaultFormat) { titlesCellStyle = wb.createCellStyle(); //Creamos el tipo de fuente HSSFFont titleFont = wb.createFont(); // headerFont.setFontName(HSSFFont.FONT_ARIAL); titleFont.setBold(Boolean.TRUE); titleFont.setColor(HSSFFont.COLOR_NORMAL); titleFont.setFontHeightInPoints((short) 8); titlesCellStyle.setFont(titleFont); }/*from ww w .j a v a2 s .c om*/ Integer col = 0; Integer row = 0; if (startInRow != null) { row = startInRow; } Map<Integer, Integer> columnWidthMap = new HashMap<Integer, Integer>(); //Indice de la fila donde empieza los encabezados de titulo de cada columna Integer principalHeaderIndex = headers.size() - 1; if (printHeader != null && printHeader) { //Armamos el encabezado for (Map<String, Object> header : headers) { for (Map.Entry<String, Object> entry : header.entrySet()) { HSSFCell cell = getCell(sheet, row, col); if (defaultFormat != null && defaultFormat) { if (principalHeaderIndex.equals(row)) { //Colocamos el formato de la celda cell.setCellStyle(headerCellStyle); } else { cell.setCellStyle(titlesCellStyle); } } setValue(cell, entry.getValue()); //Especificamos el ancho que tendra la columna if (autoSizeColumns != null && autoSizeColumns) { columnWidthMap.put(col, entry.getValue().toString().length()); } col++; } row++; col = 0; } //Ponemos la altura del encabezado setRowHeight(sheet, row - 1, (short) 420); } HSSFCellStyle detailCellStyle = getDefaultDetailCellStyle(wb, defaultFormat); Map<String, Object> principalHeader = headers.get(principalHeaderIndex); // datos for (Map<String, Object> map : data) { for (Map.Entry<String, Object> entry : principalHeader.entrySet()) { Object value = map.get(entry.getKey()); buildCellAndCalculateColumnWidth(sheet, value, col, row, detailCellStyle, columnWidthMap, autoSizeColumns); col++; } col = 0; row++; } HSSFCellStyle totalCellStyle = null; if (defaultFormat != null && defaultFormat) { //Armamos el formato los totales totalCellStyle = wb.createCellStyle(); HSSFFont totalFont = wb.createFont(); totalFont.setBold(Boolean.TRUE); totalFont.setColor(HSSFFont.COLOR_NORMAL); totalFont.setFontHeightInPoints((short) 8); totalCellStyle.setFont(totalFont); } if (footers != null) { for (Map<String, Object> footer : footers) { for (Map.Entry<String, Object> entry : principalHeader.entrySet()) { HSSFCell cell = getCell(sheet, row, col++); if (totalCellStyle != null) { //Colocamos el formato de la celda cell.setCellStyle(totalCellStyle); } Object object = footer.get(entry.getKey()); if (object != null) { setValue(cell, object); } else { setText(cell, ""); } } } } if (autoSizeColumns != null && autoSizeColumns) { setColumnsWidth(sheet, columnWidthMap, principalHeader.size()); } if (freezePane != null && freezePane > 0) { //Colocamos la columna estatica y las filas del encabezado estaticas sheet.createFreezePane(freezePane, headers.size()); } }
From source file:org.forzaframework.util.XlsUtils.java
License:Apache License
public static HSSFCellStyle getDefaultHeaderCellStyle(HSSFWorkbook wb, Boolean defaultFormat) { HSSFCellStyle headerCellStyle = null; if (defaultFormat != null && defaultFormat) { //Le damos formato a los encabezados headerCellStyle = wb.createCellStyle(); headerCellStyle.setBorderBottom(BorderStyle.DOTTED); headerCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND); // headerCellStyle.setFillBackgroundColor(HSSFColor.GREY_25_PERCENT.index); headerCellStyle.setFillForegroundColor(HSSFColor.HSSFColorPredefined.GREY_25_PERCENT.getIndex()); //Creamos el tipo de fuente HSSFFont headerFont = wb.createFont(); // headerFont.setFontName(HSSFFont.FONT_ARIAL); headerFont.setBold(Boolean.TRUE); headerFont.setColor(HSSFFont.COLOR_NORMAL); headerFont.setFontHeightInPoints((short) 8); headerCellStyle.setFont(headerFont); }/*from w w w .j a v a2s . c o m*/ return headerCellStyle; }
From source file:ReadExcel.HSSFReadWrite.java
License:Apache License
/** * given a filename this outputs a sample sheet with just a set of * rows/cells./*from www .j a v a 2s . c om*/ */ private static void testCreateSampleSheet(String outputFilename) throws IOException { int rownum; HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet s = wb.createSheet(); HSSFCellStyle cs = wb.createCellStyle(); HSSFCellStyle cs2 = wb.createCellStyle(); HSSFCellStyle cs3 = wb.createCellStyle(); HSSFFont f = wb.createFont(); HSSFFont f2 = wb.createFont(); f.setFontHeightInPoints((short) 12); f.setColor((short) 0xA); f.setBold(true); f2.setFontHeightInPoints((short) 10); f2.setColor((short) 0xf); f2.setBold(true); cs.setFont(f); cs.setDataFormat(HSSFDataFormat.getBuiltinFormat("($#,##0_);[Red]($#,##0)")); cs2.setBorderBottom(BorderStyle.THIN); cs2.setFillPattern((short) 1); // fill w fg cs2.setFillForegroundColor((short) 0xA); cs2.setFont(f2); wb.setSheetName(0, "HSSF Test"); for (rownum = 0; rownum < 300; rownum++) { HSSFRow r = s.createRow(rownum); if ((rownum % 2) == 0) { r.setHeight((short) 0x249); } for (int cellnum = 0; cellnum < 50; cellnum += 2) { HSSFCell c = r.createCell(cellnum); c.setCellValue(rownum * 10000 + cellnum + (((double) rownum / 1000) + ((double) cellnum / 10000))); if ((rownum % 2) == 0) { c.setCellStyle(cs); } c = r.createCell(cellnum + 1); c.setCellValue(new HSSFRichTextString("TEST")); // 50 characters divided by 1/20th of a point s.setColumnWidth(cellnum + 1, (int) (50 * 8 / 0.05)); if ((rownum % 2) == 0) { c.setCellStyle(cs2); } } } // draw a thick black border on the row at the bottom using BLANKS rownum++; rownum++; HSSFRow r = s.createRow(rownum); cs3.setBorderBottom(BorderStyle.THICK); for (int cellnum = 0; cellnum < 50; cellnum++) { HSSFCell c = r.createCell(cellnum); c.setCellStyle(cs3); } s.addMergedRegion(new CellRangeAddress(0, 3, 0, 3)); s.addMergedRegion(new CellRangeAddress(100, 110, 100, 110)); // end draw thick black border // create a sheet, set its title then delete it wb.createSheet(); wb.setSheetName(1, "DeletedSheet"); wb.removeSheetAt(1); // end deleted sheet FileOutputStream out = new FileOutputStream(outputFilename); try { wb.write(out); } finally { out.close(); } wb.close(); }
From source file:Sales.MainMenu.java
private void submitToPublishingPDFButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_submitToPublishingPDFButtonActionPerformed String validityFrom = validityFromDatePicker.getJFormattedTextField().getText(); String validityTo = validityToDatePicker.getJFormattedTextField().getText(); String kkluNumber = kkluNumberTextField.getText(); String pol = pPolTextField.getText(); String pod = pPodTextField.getText(); String commClass = pCommodityClassComboBox.getSelectedItem().toString(); String handlingInstructions = pHandlingInstructions.getSelectedItem().toString(); String commDesc = pCommodityDescriptionTextField.getText(); String oft = pOftTextField.getText(); String oftUnit = pOftComboBox.getSelectedItem().toString(); String baf = null;//from w w w . j ava 2 s. c o m String bafText = pBafTextField.getText(); Boolean bafIncluded = pBafIncludedCheckBox.isSelected(); String eca = null; String ecaText = pEcaTextField.getText(); String ecaUnit = pEcaComboBox.getSelectedItem().toString(); Boolean ecaIncluded = pEcaIncludedCheckBox.isSelected(); String thc = null; String thcText = "$" + pThcTextField.getText(); String thcUnit = pThcComboBox.getSelectedItem().toString(); Boolean thcIncluded = pThcIncludedCheckBox.isSelected(); Boolean thcSubjectToTariff = thcSubjectToTariffCheckBox.isSelected(); String wfg = null; String wfgText = pWfgTextField.getText(); String wfgUnit = pWfgComboBox.getSelectedItem().toString(); Boolean wfgIncluded = pWfgIncludedCheckBox.isSelected(); Boolean wfgSubjectToTariff = wfgSubjectToTariffCheckBox.isSelected(); String docFee = pDocFeeComboBox.getSelectedItem().toString(); Boolean docFeeIncluded = pDocFeeIncludedCheckBox.isSelected(); String comments = pCommentsTextArea.getText(); Boolean warRisk = pWarRiskCheckBox.isSelected(); String quoteID = pQuoteNumberTextField.getText(); String bookingNumber = pBookingNumberTextField.getText(); String storage = null; String storageText = storageTextField.getText(); String storageUnit = storageUnitComboBox.getSelectedItem().toString(); Boolean storageIncluded = storageIncludedCheckBox.isSelected(); Boolean storageSubjectToTariff = storageSubjectToTariffCheckBox.isSelected(); Boolean bafSubjectToTariff = bafSubjectToTariffCheckBox.isSelected(); Boolean ecaSubjectToTariff = ecaSubjectToTariffCheckBox.isSelected(); String TIME_STAMP = new SimpleDateFormat("MM/dd/yyyy HH:mm").format(Calendar.getInstance().getTime()); if (bafIncluded != true && bafSubjectToTariff != true) { baf = bafText; } else if (bafIncluded == true) { baf = "Included"; } else if (bafSubjectToTariff == true) { baf = "Subject to Tariff"; } if (ecaIncluded != true && ecaSubjectToTariff != true) { eca = ecaText; } else if (ecaIncluded == true) { eca = "Included"; } else if (ecaSubjectToTariff == true) { eca = "Subject to Tariff"; } else if (ecaSubjectToTariff == true) { eca = "Subject to Tariff"; } if (thcSubjectToTariff == true) { thc = "Subject to Tariff"; } else if (thcSubjectToTariff != true && thcIncluded != true) { thc = thcText; } else if (thcSubjectToTariff != true && thcIncluded == true) { thc = "Included"; } else if (thcIncluded == true && thcSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } if (wfgSubjectToTariff == true) { wfg = "Subject to Tariff"; wfgUnit = "N/A"; } else if (wfgSubjectToTariff != true && wfgIncluded != true) { wfg = wfgText; } else if (wfgSubjectToTariff != true && wfgIncluded == true) { wfg = "Included"; } else if (wfgIncluded == true && wfgSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } if (storageSubjectToTariff == true) { storage = "Subject to Tariff"; storageUnit = "N/A"; } else if (storageSubjectToTariff != true && storageIncluded != true) { storage = storageText; } else if (storageIncluded == true && storageSubjectToTariff != true) { storage = "Included"; } else if (storageIncluded == true && storageSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } String sql = "INSERT INTO spotrates (validityFrom, validityTo, tariffNumber, pol, pod, bookingNumber, commClass, handlingInstructions, commDesc, oft, oftUnit, baf, bafIncluded, bafPerTariff, ecaBaf, ecaBafUnit, ecaIncluded, ecaPerTariff, thc, thcUnit,thcIncluded, thcPerTariff, wfg, wfgUnit, wfgIncluded, wfgPerTariff, storage, storageUnit, storageIncluded, storagePerTariff, docFee, docFeeIncluded, comments, quoteID, warRisk) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; try { PreparedStatement ps = CONN.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); ps.setString(1, validityFrom); ps.setString(2, validityTo); ps.setString(3, kkluNumber); ps.setString(4, pol); ps.setString(5, pod); ps.setString(6, bookingNumber); ps.setString(7, commClass); ps.setString(8, handlingInstructions); ps.setString(9, commDesc); ps.setString(10, oft); ps.setString(11, oftUnit); ps.setString(12, baf); ps.setBoolean(13, bafIncluded); ps.setBoolean(14, bafSubjectToTariff); ps.setString(15, eca); ps.setString(16, ecaUnit); ps.setBoolean(17, ecaIncluded); ps.setBoolean(18, ecaSubjectToTariff); ps.setString(19, thc); ps.setString(20, thcUnit); ps.setBoolean(21, thcIncluded); ps.setBoolean(22, thcSubjectToTariff); ps.setString(23, wfg); ps.setString(24, wfgUnit); ps.setBoolean(25, wfgIncluded); ps.setBoolean(26, wfgSubjectToTariff); ps.setString(27, storage); ps.setString(28, storageUnit); ps.setBoolean(29, storageIncluded); ps.setBoolean(30, storageSubjectToTariff); ps.setString(31, docFee); ps.setBoolean(32, docFeeIncluded); ps.setString(33, comments); ps.setString(34, quoteID); ps.setBoolean(35, warRisk); // Execute the update ps.executeUpdate(); //Return the auto-generated key ResultSet keys = ps.getGeneratedKeys(); int lastKey = 1; while (keys.next()) { lastKey = keys.getInt(1); } int pid = lastKey; Double oft1 = (Double) (Double.parseDouble(oft)); String eca1 = ""; switch (eca) { case "Included": eca1 = "Included"; break; case "Subject to Tariff": eca1 = "Subject to Tariff"; break; default: eca1 = eca; break; } String baf1; switch (baf) { case "Included": baf1 = "Included"; break; case "Subject To Tariff": baf1 = "Subject to Tariff"; break; default: baf1 = baf; break; } String thc1; switch (thc) { case "Included": thc1 = thc; break; case "Subject to Tariff": thc1 = "Subject to Tariff"; break; default: thc1 = "$" + thc + " per " + thcUnit; break; } switch (thcUnit) { case "FAS": thc1 = thcUnit; break; case "Subject to local charges": thc1 = thcUnit; default: break; } String wfg1; switch (wfg) { case "Included": wfg1 = wfg; break; case "Subject to Tariff": wfg1 = "Subject to Tariff"; break; default: wfg1 = "$" + wfg + " per " + wfgUnit; break; } switch (wfgUnit) { case "FAS": wfg1 = wfgUnit; break; case "Subject to local charges": wfg1 = wfgUnit; default: break; } /* *************************************** *************************************** *************************************** */ String filename = USER_HOME_FOLDER + "\\Desktop\\Publishing\\" + pol + " To " + pod + "; " + commDesc + " PID" + lastKey + ".xls"; HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("KKLU" + kkluNumber); sheet.setColumnWidth(0, 650); sheet.setColumnWidth(1, 5742); sheet.setColumnWidth(2, 5920); sheet.setColumnWidth(3, 3668); sheet.setColumnWidth(4, 5711); //Bold Font HSSFFont font = workbook.createFont(); font.setBold(true); CellStyle style = workbook.createCellStyle(); style.setFont(font); //Currency cell type CellStyle currency = workbook.createCellStyle(); currency.setDataFormat((short) 7); //Percentage cell type CellStyle percentage = workbook.createCellStyle(); percentage.setDataFormat((short) 0xa); sheet.setDisplayGridlines(false); //Black medium sized border around cell CellStyle blackBorder = workbook.createCellStyle(); blackBorder.setBorderBottom(CellStyle.BORDER_MEDIUM); blackBorder.setBottomBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderLeft(CellStyle.BORDER_MEDIUM); blackBorder.setLeftBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderRight(CellStyle.BORDER_MEDIUM); blackBorder.setRightBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderTop(CellStyle.BORDER_MEDIUM); blackBorder.setTopBorderColor(IndexedColors.BLACK.getIndex()); //Red font CellStyle redFontStyle = workbook.createCellStyle(); HSSFFont redFont = workbook.createFont(); redFont.setColor(HSSFColor.RED.index); redFontStyle.setFont(redFont); HSSFRow rowhead = sheet.createRow((short) 0); rowhead.createCell(3).setCellValue(validityFrom); HSSFRow row1 = sheet.createRow((short) 1); Cell cell = row1.createCell(1); cell.setCellValue("FILING REQUEST TO RICLFILE"); cell.setCellStyle(style); sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 3)); sheet.setPrintGridlines(false); HSSFRow row2 = sheet.createRow((short) 2); row2.createCell(0).setCellValue("A)"); row2.createCell(1).setCellValue("Tariff Number(KKLU):"); row2.createCell(2).setCellValue(kkluNumber); HSSFRow space0 = sheet.createRow((short) 3); HSSFRow row4 = sheet.createRow((short) 4); row4.createCell(0).setCellValue("B)"); row4.createCell(1).setCellValue("Commodity:"); row4.createCell(2).setCellValue(commDesc); HSSFRow space2 = sheet.createRow((short) 5); HSSFRow row5 = sheet.createRow((short) 6); row5.createCell(0).setCellValue("C)"); row5.createCell(1).setCellValue("POL:"); row5.createCell(2).setCellValue(pol); HSSFRow space3 = sheet.createRow((short) 7); HSSFRow row6 = sheet.createRow((short) 8); row6.createCell(0).setCellValue("D)"); row6.createCell(1).setCellValue("POD:"); row6.createCell(2).setCellValue(pod); HSSFRow space4 = sheet.createRow((short) 9); HSSFRow row7 = sheet.createRow((short) 10); row7.createCell(0).setCellValue("E)"); row7.createCell(1).setCellValue("Rate:"); Cell rate = row7.createCell(2); rate.setCellValue(oft1); rate.setCellStyle(currency); HSSFRow space5 = sheet.createRow((short) 11); HSSFRow row8 = sheet.createRow((short) 12); row8.createCell(0).setCellValue("F)"); row8.createCell(1).setCellValue("Rate Basis:"); row8.createCell(2).setCellValue(oftUnit); HSSFRow space6 = sheet.createRow((short) 13); HSSFRow row9 = sheet.createRow((short) 14); row9.createCell(0).setCellValue("G)"); row9.createCell(1).setCellValue("BAF:"); Cell Baf = row9.createCell(2); switch (baf1) { case "Included": Baf.setCellValue("Included"); break; case "Subject to Tariff": Baf.setCellValue("Subject to Tariff"); break; default: Baf.setCellValue(baf1); Baf.setCellStyle(percentage); break; } HSSFRow space7 = sheet.createRow((short) 15); HSSFRow row10 = sheet.createRow((short) 16); row10.createCell(0).setCellValue("H)"); row10.createCell(1).setCellValue("ECA BAF:"); Cell ecaBaf = row10.createCell(2); switch (eca) { case "Included": ecaBaf.setCellValue("Included"); break; case "Subject to Tariff": ecaBaf.setCellValue("Subject to Tariff"); break; default: ecaBaf.setCellValue(eca1 + " per " + ecaUnit); ecaBaf.setCellStyle(currency); break; } HSSFRow space8 = sheet.createRow((short) 17); HSSFRow row11 = sheet.createRow((short) 18); row11.createCell(0).setCellValue("I)"); row11.createCell(1).setCellValue("THC/WFG:"); row11.createCell(2).setCellValue(thc1 + " / " + wfg1); HSSFRow space = sheet.createRow((short) 19); HSSFRow row12 = sheet.createRow((short) 20); row12.createCell(0).setCellValue("J)"); row12.createCell(1).setCellValue("Storage:"); row12.createCell(2).setCellValue(storage); HSSFRow space10 = sheet.createRow((short) 21); HSSFRow row13 = sheet.createRow((short) 22); row13.createCell(0).setCellValue("K)"); row13.createCell(1).setCellValue("Doc Fee:"); row13.createCell(2).setCellValue(docFee); HSSFRow space11 = sheet.createRow((short) 23); HSSFRow row14 = sheet.createRow((short) 24); row14.createCell(0).setCellValue("L)"); row14.createCell(1).setCellValue("War Risk:"); HSSFRow space12 = sheet.createRow((short) 25); if (warRisk == true) { String warRiskPercentage = "3%"; row14.createCell(2).setCellValue(warRiskPercentage); } else if (warRisk != true) { String warRiskPercentage = "N/A"; row14.createCell(2).setCellValue(warRiskPercentage); } HSSFRow row15 = sheet.createRow((short) 26); row15.createCell(0).setCellValue("M)"); row15.createCell(1).setCellValue("Validity"); row15.createCell(2).setCellValue("Effective: " + validityFrom); HSSFRow row16 = sheet.createRow((short) 27); row16.createCell(2).setCellValue("Expiration: " + validityTo); HSSFRow space13 = sheet.createRow((short) 28); HSSFRow row17 = sheet.createRow((short) 29); row17.createCell(0).setCellValue("N)"); row17.createCell(1).setCellValue("Remarks"); row17.createCell(2).setCellValue(comments); HSSFRow space14 = sheet.createRow((short) 30); HSSFRow row18 = sheet.createRow((short) 31); row18.createCell(0).setCellValue("O)"); row18.createCell(1).setCellValue("Booking #:"); row18.createCell(2).setCellValue(bookingNumber); HSSFRow space15 = sheet.createRow((short) 32); HSSFRow row19 = sheet.createRow((short) 33); row19.createCell(0).setCellValue("P)"); row19.createCell(1).setCellValue("RQS #:"); row19.createCell(2).setCellValue(quoteID); HSSFRow space16 = sheet.createRow((short) 34); HSSFRow row20 = sheet.createRow((short) 35); row20.createCell(0).setCellValue("Q)"); row20.createCell(1).setCellValue("PID #:"); row20.createCell(2).setCellValue(pid); HSSFRow space17 = sheet.createRow((short) 36); HSSFRow space18 = sheet.createRow((short) 37); HSSFRow row21 = sheet.createRow((short) 38); row21.createCell(0).setCellValue(""); row21.createCell(1).setCellValue("For RICLFILE Use Only"); HSSFRow space19 = sheet.createRow((short) 39); HSSFRow row22 = sheet.createRow((short) 40); Cell comm = row22.createCell(1); comm.setCellValue("Commodity #:"); comm.setCellStyle(redFontStyle); row22.createCell(2).setCellValue(""); Cell desc = row22.createCell(3); desc.setCellValue("Description:"); desc.setCellStyle(redFontStyle); row22.createCell(4).setCellValue(""); HSSFRow space20 = sheet.createRow((short) 41); HSSFRow row24 = sheet.createRow((short) 42); Cell TLI = row24.createCell(1); TLI.setCellValue("TLI #:"); TLI.setCellStyle(redFontStyle); row24.createCell(2).setCellValue(""); HSSFRow space21 = sheet.createRow((short) 43); HSSFRow row26 = sheet.createRow((short) 44); Cell exp = row26.createCell(1); exp.setCellValue("Expiration: "); exp.setCellStyle(redFontStyle); row26.createCell(2).setCellValue(""); try (FileOutputStream fileOut = new FileOutputStream(filename)) { workbook.write(fileOut); } System.out.print("Your excel file has been generate"); String spotRateId = String.valueOf(lastKey); JOptionPane.showMessageDialog(null, "The spot filing (PID" + spotRateId + ") for " + quoteID + " has been succsefully generated."); pQuoteIDTextField.setText(""); validityFromDatePicker.getJFormattedTextField().setText(""); validityToDatePicker.getJFormattedTextField().setText(""); kkluNumberTextField.setText(""); pPolTextField.setText(""); pPodTextField.setText(""); pCommodityClassComboBox.setSelectedIndex(0); pHandlingInstructions.setSelectedIndex(0); pCommodityDescriptionTextField.setText(""); pOftTextField.setText(""); pOftComboBox.setSelectedItem(""); bafSubjectToTariffCheckBox.setSelected(false); pBafTextField.setText(""); pBafIncludedCheckBox.setSelected(false); pEcaTextField.setText(""); pEcaComboBox.setSelectedIndex(0); pEcaIncludedCheckBox.setSelected(false); ecaSubjectToTariffCheckBox.setSelected(false); pThcTextField.setText(""); pThcComboBox.setSelectedIndex(0); pThcIncludedCheckBox.setSelected(false); thcSubjectToTariffCheckBox.setSelected(false); pWfgTextField.setText(""); pWfgComboBox.setSelectedIndex(0); pWfgIncludedCheckBox.setSelected(false); wfgSubjectToTariffCheckBox.setSelected(false); pDocFeeComboBox.setSelectedIndex(0); pWarRiskCheckBox.setSelected(false); storageSubjectToTariffCheckBox.setSelected(false); pCommentsTextArea.setText(""); pBookingNumberTextField.setText(""); pQuoteNumberTextField.setText(""); pIDTextField.setText(""); } catch (SQLException | IOException e) { JOptionPane.showMessageDialog(null, "Error: " + e.getMessage()); System.out.println(e.getMessage()); } }
From source file:Sales.MainMenu.java
private void saveChangesPublishingPDFButtonActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_saveChangesPublishingPDFButtonActionPerformed // Save spot rate changes String validityFrom = validityFromDatePicker.getJFormattedTextField().getText(); String validityTo = validityToDatePicker.getJFormattedTextField().getText(); String kkluNumber = kkluNumberTextField.getText(); String pol = pPolTextField.getText(); String pod = pPodTextField.getText(); String commClass = pCommodityClassComboBox.getSelectedItem().toString(); String handlingInstructions = pHandlingInstructions.getSelectedItem().toString(); String commDesc = pCommodityDescriptionTextField.getText(); String oft = pOftTextField.getText(); String oftUnit = pOftComboBox.getSelectedItem().toString(); String baf = null;/*from www .j av a 2 s. com*/ String bafText = pBafTextField.getText(); Boolean bafIncluded = pBafIncludedCheckBox.isSelected(); String eca = null; String ecaText = pEcaTextField.getText(); String ecaUnit = pEcaComboBox.getSelectedItem().toString(); Boolean ecaIncluded = pEcaIncludedCheckBox.isSelected(); String thc = null; String thcText = "$" + pThcTextField.getText(); String thcUnit = pThcComboBox.getSelectedItem().toString(); Boolean thcIncluded = pThcIncludedCheckBox.isSelected(); Boolean thcSubjectToTariff = thcSubjectToTariffCheckBox.isSelected(); String wfg = null; String wfgText = pWfgTextField.getText(); String wfgUnit = pWfgComboBox.getSelectedItem().toString(); Boolean wfgIncluded = pWfgIncludedCheckBox.isSelected(); Boolean wfgSubjectToTariff = wfgSubjectToTariffCheckBox.isSelected(); String docFee = pDocFeeComboBox.getSelectedItem().toString(); Boolean docFeeIncluded = pDocFeeIncludedCheckBox.isSelected(); String comments = pCommentsTextArea.getText(); Boolean warRisk = pWarRiskCheckBox.isSelected(); String quoteID = pQuoteNumberTextField.getText(); String bookingNumber = pBookingNumberTextField.getText(); String storage = null; String storageText = storageTextField.getText(); String storageUnit = storageUnitComboBox.getSelectedItem().toString(); Boolean storageIncluded = storageIncludedCheckBox.isSelected(); Boolean storageSubjectToTariff = storageSubjectToTariffCheckBox.isSelected(); Boolean bafSubjectToTariff = bafSubjectToTariffCheckBox.isSelected(); Boolean ecaSubjectToTariff = ecaSubjectToTariffCheckBox.isSelected(); String ID = pQuoteIDTextField.getText(); String timeStamp = new SimpleDateFormat("MM/dd/yyyy HH:mm").format(Calendar.getInstance().getTime()); if (bafIncluded != true && bafSubjectToTariff != true) { baf = bafText; } else if (bafIncluded == true) { baf = "Included"; } else if (bafSubjectToTariff == true) { baf = "Subject to Tariff"; } if (ecaIncluded != true && ecaSubjectToTariff != true) { eca = ecaText; } else if (ecaIncluded == true) { eca = "Included"; } else if (ecaSubjectToTariff == true) { eca = "Subject to Tariff"; } else if (ecaSubjectToTariff == true) { eca = "Subject to Tariff"; } if (thcSubjectToTariff == true) { thc = "Subject to Tariff"; } else if (thcSubjectToTariff != true && thcIncluded != true) { thc = thcText; } else if (thcSubjectToTariff != true && thcIncluded == true) { thc = "Included"; } else if (thcIncluded == true && thcSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } if (wfgSubjectToTariff == true) { wfg = "Subject to Tariff"; wfgUnit = "N/A"; } else if (wfgSubjectToTariff != true && wfgIncluded != true) { wfg = wfgText; } else if (wfgSubjectToTariff != true && wfgIncluded == true) { wfg = "Included"; } else if (wfgIncluded == true && wfgSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } if (storageSubjectToTariff == true) { storage = "Subject to Tariff"; storageUnit = "N/A"; } else if (storageSubjectToTariff != true && storageIncluded != true) { storage = storageText; } else if (storageIncluded == true && storageSubjectToTariff != true) { storage = "Included"; } else if (storageIncluded == true && storageSubjectToTariff == true) { JOptionPane.showMessageDialog(null, "You can only select one"); } String sql = "UPDATE spotrates SET validityFrom=?, validityTo=?, tariffNumber=?, pol=?, pod=?, bookingNumber=?, commClass=?, handlingInstructions=?, commDesc=?, oft=?, oftUnit=?, baf=?,bafIncluded=?, bafPerTariff=?, ecaBaf=?, ecaBafUnit=?, ecaIncluded=?, ecaPerTariff=?, thc=?, thcUnit=?, thcIncluded=?, thcPerTariff=?, wfg=?, wfgUnit=?, wfgIncluded=?, wfgPerTariff=?, storage=?, storageUnit=?, storageIncluded=?, storagePerTariff=?, docFee=?, docFeeIncluded=?, comments=?, quoteID=?, warRisk=? WHERE ID=?"; try { PreparedStatement ps = CONN.prepareStatement(sql); ps.setString(1, validityFrom); ps.setString(2, validityTo); ps.setString(3, kkluNumber); ps.setString(4, pol); ps.setString(5, pod); ps.setString(6, bookingNumber); ps.setString(7, commClass); ps.setString(8, handlingInstructions); ps.setString(9, commDesc); ps.setString(10, oft); ps.setString(11, oftUnit); ps.setString(12, baf); ps.setBoolean(13, bafIncluded); ps.setBoolean(14, bafSubjectToTariff); ps.setString(15, eca); ps.setString(16, ecaUnit); ps.setBoolean(17, ecaIncluded); ps.setBoolean(18, ecaSubjectToTariff); ps.setString(19, thc); ps.setString(20, thcUnit); ps.setBoolean(21, thcIncluded); ps.setBoolean(22, thcSubjectToTariff); ps.setString(23, wfg); ps.setString(24, wfgUnit); ps.setBoolean(25, wfgIncluded); ps.setBoolean(26, wfgSubjectToTariff); ps.setString(27, storage); ps.setString(28, storageUnit); ps.setBoolean(29, storageIncluded); ps.setBoolean(30, storageSubjectToTariff); ps.setString(31, docFee); ps.setBoolean(32, docFeeIncluded); ps.setString(33, comments); ps.setString(34, quoteID); ps.setBoolean(35, warRisk); ps.setString(40, ID); ps.executeUpdate(); String addBookingNumber = "UPDATE allquotes SET bookingNumber='" + bookingNumber + "', publishingID='" + ID + "' WHERE ID='" + quoteID + "';"; PreparedStatement psAddBookingNumber = CONN.prepareStatement(addBookingNumber); psAddBookingNumber.executeUpdate(addBookingNumber); Double oft1 = (Double) (Double.parseDouble(oft)); String eca1 = ""; switch (eca) { case "Included": eca1 = "Included"; break; case "Subject to Tariff": eca1 = "Subject to Tariff"; break; default: eca1 = "$" + eca + " " + ecaUnit; break; } String baf1; switch (baf) { case "Included": baf1 = "Included"; break; case "Subject To Tariff": baf1 = "Subject to Tariff"; break; default: baf1 = baf + "%"; break; } String thc1; switch (thc) { case "Included": thc1 = thc; break; case "Subject to Tariff": thc1 = "Subject to Tariff"; break; default: thc1 = "$" + thc + " per " + thcUnit; break; } switch (thcUnit) { case "FAS": thc1 = thcUnit; break; case "Subject to local charges": thc1 = thcUnit; default: break; } String wfg1; switch (wfg) { case "Included": wfg1 = wfg; break; case "Subject to Tariff": wfg1 = "Subject to Tariff"; break; default: wfg1 = "$" + wfg + " per " + wfgUnit; break; } switch (wfgUnit) { case "FAS": wfg1 = wfgUnit; break; case "Subject to local charges": wfg1 = wfgUnit; default: break; } /* *************************************** *************************************** *************************************** */ String filename = USER_HOME_FOLDER + "\\Desktop\\Publishing\\" + pol + " To " + pod + "; " + commDesc + " PID" + ID + ".xls"; HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("KKLU" + kkluNumber); sheet.setColumnWidth(0, 650); sheet.setColumnWidth(1, 5742); sheet.setColumnWidth(2, 5920); sheet.setColumnWidth(3, 3668); sheet.setColumnWidth(4, 5711); //Bold Font HSSFFont font = workbook.createFont(); font.setBold(true); CellStyle style = workbook.createCellStyle(); style.setFont(font); //Currency cell type CellStyle currency = workbook.createCellStyle(); currency.setDataFormat((short) 7); //Percentage cell type CellStyle percentage = workbook.createCellStyle(); percentage.setDataFormat((short) 0xa); sheet.setDisplayGridlines(false); //Black medium sized border around cell CellStyle blackBorder = workbook.createCellStyle(); blackBorder.setBorderBottom(CellStyle.BORDER_MEDIUM); blackBorder.setBottomBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderLeft(CellStyle.BORDER_MEDIUM); blackBorder.setLeftBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderRight(CellStyle.BORDER_MEDIUM); blackBorder.setRightBorderColor(IndexedColors.BLACK.getIndex()); blackBorder.setBorderTop(CellStyle.BORDER_MEDIUM); blackBorder.setTopBorderColor(IndexedColors.BLACK.getIndex()); //Red font CellStyle redFontStyle = workbook.createCellStyle(); HSSFFont redFont = workbook.createFont(); redFont.setColor(HSSFColor.RED.index); redFontStyle.setFont(redFont); HSSFRow rowhead = sheet.createRow((short) 0); rowhead.createCell(3).setCellValue(validityFrom); HSSFRow row1 = sheet.createRow((short) 1); Cell cell = row1.createCell(1); cell.setCellValue("FILING REQUEST TO RICLFILE"); cell.setCellStyle(style); sheet.addMergedRegion(new CellRangeAddress(1, 1, 1, 3)); sheet.setPrintGridlines(false); HSSFRow row2 = sheet.createRow((short) 2); row2.createCell(0).setCellValue("A)"); row2.createCell(1).setCellValue("Tariff Number(KKLU):"); row2.createCell(2).setCellValue(kkluNumber); HSSFRow space0 = sheet.createRow((short) 3); HSSFRow row4 = sheet.createRow((short) 4); row4.createCell(0).setCellValue("B)"); row4.createCell(1).setCellValue("Commodity:"); row4.createCell(2).setCellValue(commDesc); HSSFRow space2 = sheet.createRow((short) 5); HSSFRow row5 = sheet.createRow((short) 6); row5.createCell(0).setCellValue("C)"); row5.createCell(1).setCellValue("POL:"); row5.createCell(2).setCellValue(pol); HSSFRow space3 = sheet.createRow((short) 7); HSSFRow row6 = sheet.createRow((short) 8); row6.createCell(0).setCellValue("D)"); row6.createCell(1).setCellValue("POD:"); row6.createCell(2).setCellValue(pod); HSSFRow space4 = sheet.createRow((short) 9); HSSFRow row7 = sheet.createRow((short) 10); row7.createCell(0).setCellValue("E)"); row7.createCell(1).setCellValue("Rate:"); Cell rate = row7.createCell(2); rate.setCellValue(oft1); rate.setCellStyle(currency); HSSFRow space5 = sheet.createRow((short) 11); HSSFRow row8 = sheet.createRow((short) 12); row8.createCell(0).setCellValue("F)"); row8.createCell(1).setCellValue("Rate Basis:"); row8.createCell(2).setCellValue(oftUnit); HSSFRow space6 = sheet.createRow((short) 13); HSSFRow row9 = sheet.createRow((short) 14); row9.createCell(0).setCellValue("G)"); row9.createCell(1).setCellValue("BAF:"); Cell Baf = row9.createCell(2); switch (baf1) { case "Included": Baf.setCellValue("Included"); break; case "Subject to Tariff": Baf.setCellValue("Subject to Tariff"); break; default: Baf.setCellValue(baf1); break; } HSSFRow space7 = sheet.createRow((short) 15); HSSFRow row10 = sheet.createRow((short) 16); row10.createCell(0).setCellValue("H)"); row10.createCell(1).setCellValue("ECA BAF:"); Cell ecaBaf = row10.createCell(2); switch (eca) { case "Included": ecaBaf.setCellValue("Included"); break; case "Subject to Tariff": ecaBaf.setCellValue("Subject to Tariff"); break; default: ecaBaf.setCellValue("$" + eca1 + " per " + ecaUnit); ecaBaf.setCellStyle(currency); break; } HSSFRow space8 = sheet.createRow((short) 17); HSSFRow row11 = sheet.createRow((short) 18); row11.createCell(0).setCellValue("I)"); row11.createCell(1).setCellValue("THC/WFG:"); row11.createCell(2).setCellValue(thc1 + " / " + wfg1); HSSFRow space = sheet.createRow((short) 19); HSSFRow row12 = sheet.createRow((short) 20); row12.createCell(0).setCellValue("J)"); row12.createCell(1).setCellValue("Storage:"); row12.createCell(2).setCellValue(storage); HSSFRow space10 = sheet.createRow((short) 21); HSSFRow row13 = sheet.createRow((short) 22); row13.createCell(0).setCellValue("K)"); row13.createCell(1).setCellValue("Doc Fee:"); row13.createCell(2).setCellValue(docFee); HSSFRow space11 = sheet.createRow((short) 23); HSSFRow row14 = sheet.createRow((short) 24); row14.createCell(0).setCellValue("L)"); row14.createCell(1).setCellValue("War Risk:"); HSSFRow space12 = sheet.createRow((short) 25); if (warRisk == true) { String warRiskPercentage = "3%"; row14.createCell(2).setCellValue(warRiskPercentage); } else if (warRisk != true) { String warRiskPercentage = "N/A"; row14.createCell(2).setCellValue(warRiskPercentage); } HSSFRow row15 = sheet.createRow((short) 26); row15.createCell(0).setCellValue("M)"); row15.createCell(1).setCellValue("Validity"); row15.createCell(2).setCellValue("Effective: " + validityFrom); HSSFRow row16 = sheet.createRow((short) 27); row16.createCell(2).setCellValue("Expiration: " + validityTo); HSSFRow space13 = sheet.createRow((short) 28); HSSFRow row17 = sheet.createRow((short) 29); row17.createCell(0).setCellValue("N)"); row17.createCell(1).setCellValue("Remarks"); row17.createCell(2).setCellValue(comments); HSSFRow space14 = sheet.createRow((short) 30); HSSFRow row18 = sheet.createRow((short) 31); row18.createCell(0).setCellValue("O)"); row18.createCell(1).setCellValue("Booking #:"); row18.createCell(2).setCellValue(bookingNumber); HSSFRow space15 = sheet.createRow((short) 32); HSSFRow row19 = sheet.createRow((short) 33); row19.createCell(0).setCellValue("P)"); row19.createCell(1).setCellValue("RQS #:"); row19.createCell(2).setCellValue(quoteID); HSSFRow space16 = sheet.createRow((short) 34); HSSFRow row20 = sheet.createRow((short) 35); row20.createCell(0).setCellValue("Q)"); row20.createCell(1).setCellValue("PID #:"); row20.createCell(2).setCellValue(ID); HSSFRow space17 = sheet.createRow((short) 36); HSSFRow space18 = sheet.createRow((short) 37); HSSFRow row21 = sheet.createRow((short) 38); row21.createCell(0).setCellValue(""); row21.createCell(1).setCellValue("For RICLFILE Use Only"); HSSFRow space19 = sheet.createRow((short) 39); HSSFRow row22 = sheet.createRow((short) 40); Cell comm = row22.createCell(1); comm.setCellValue("Commodity #:"); comm.setCellStyle(redFontStyle); row22.createCell(2).setCellValue(""); Cell desc = row22.createCell(3); desc.setCellValue("Description:"); desc.setCellStyle(redFontStyle); row22.createCell(4).setCellValue(""); HSSFRow space20 = sheet.createRow((short) 41); HSSFRow row24 = sheet.createRow((short) 42); Cell TLI = row24.createCell(1); TLI.setCellValue("TLI #:"); TLI.setCellStyle(redFontStyle); row24.createCell(2).setCellValue(""); HSSFRow space21 = sheet.createRow((short) 43); HSSFRow row26 = sheet.createRow((short) 44); Cell exp = row26.createCell(1); exp.setCellValue("Expiration: "); exp.setCellStyle(redFontStyle); row26.createCell(2).setCellValue(""); try (FileOutputStream fileOut = new FileOutputStream(filename)) { workbook.write(fileOut); } System.out.print("Your excel file has been generate"); String spotRateId = String.valueOf(ID); JOptionPane.showMessageDialog(null, "PID" + ID + " has been successfully update."); pQuoteIDTextField.setText(""); validityFromDatePicker.getJFormattedTextField().setText(""); validityToDatePicker.getJFormattedTextField().setText(""); kkluNumberTextField.setText(""); pPolTextField.setText(""); pPodTextField.setText(""); pCommodityClassComboBox.setSelectedIndex(0); pHandlingInstructions.setSelectedIndex(0); pCommodityDescriptionTextField.setText(""); pOftTextField.setText(""); pOftComboBox.setSelectedItem(""); bafSubjectToTariffCheckBox.setSelected(false); pBafTextField.setText(""); pBafIncludedCheckBox.setSelected(false); pEcaTextField.setText(""); pEcaComboBox.setSelectedItem(""); pEcaIncludedCheckBox.setSelected(false); ecaSubjectToTariffCheckBox.setSelected(false); pThcTextField.setText(""); pThcComboBox.setSelectedIndex(0); pThcIncludedCheckBox.setSelected(false); thcSubjectToTariffCheckBox.setSelected(false); pWfgTextField.setText(""); pWfgComboBox.setSelectedIndex(0); pWfgIncludedCheckBox.setSelected(false); wfgSubjectToTariffCheckBox.setSelected(false); pDocFeeComboBox.setSelectedIndex(0); pWarRiskCheckBox.setSelected(false); storageSubjectToTariffCheckBox.setSelected(false); pCommentsTextArea.setText(""); pBookingNumberTextField.setText(""); storageTextField.setText(""); storageUnitComboBox.setSelectedIndex(0); storageIncludedCheckBox.setSelected(false); pQuoteNumberTextField.setText(""); pIDTextField.setText(""); } catch (SQLException | IOException e) { JOptionPane.showMessageDialog(null, "Error: " + e.getMessage()); System.out.println(e.getMessage()); } }