public void display(ResultSet rs) { try { boolean recordNumber = rs.next(); if (recordNumber) { payNo = rs.getString(1); pasNo = rs.getString(2); pasName = rs.getString(3); mode = rs.getString(4); dt = rs.getString(5); amount = rs.getString(6); rev = rs.getString(7); text1.setText(payNo); combo1.setSelectedItem(pasNo); combo2.setSelectedItem(pasName); combo4.setSelectedItem(mode); p_date.setText(dt); combo8.setSelectedItem(amount); combo3.setSelectedItem(rev); } else { JOptionPane.showMessageDialog( null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION); } } catch (SQLException sqlex) { sqlex.printStackTrace(); } }
/** * Create a default filename given the current date selection. If custom dates are selected, use * those dates; otherwise, use year and week numbers. * * @return The default filename. */ private String getDefaultFilename() { if (yearCB.getSelectedIndex() == 0 || weekCB.getSelectedIndex() == 0) return "timesheet-" + dateFormat.format(fromDate.getDate()).replaceAll("/", "") + "-" + dateFormat.format(toDate.getDate()).replaceAll("/", "") + ".txt"; return "timesheet-" + yearCB.getSelectedItem() + "wk" + weekCB.getSelectedItem() + ".txt"; }
/** * Set calendar to this week's Monday; set year and week combo boxes to the currently set date; * set the date labels appropriately; and, refresh the review table. */ private void updateYearWeekDates() { yearWeekCalendar.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); yearWeekCalendar.set(Calendar.HOUR_OF_DAY, 0); yearWeekCalendar.set(Calendar.MINUTE, 0); yearWeekCalendar.set(Calendar.SECOND, 0); yearWeekCalendar.set(Calendar.MILLISECOND, 0); yearCB.setSelectedItem(yearWeekCalendar.get(Calendar.YEAR)); weekCB.setSelectedItem(yearWeekCalendar.get(Calendar.WEEK_OF_YEAR)); fromDate.setDate(yearWeekCalendar); yearWeekCalendar.add(Calendar.DAY_OF_MONTH, 7); toDate.setDate(yearWeekCalendar); yearWeekCalendar.add(Calendar.DAY_OF_MONTH, -7); refreshReviewTable(); }
private void setamount() { try { ResultSet rst = DBConnection.getDBConnection() .createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE) .executeQuery( "SELECT Amount FROM BOOKING where Pass_No='" + combo1.getSelectedItem() + "'"); while (rst.next()) { combo8.addItem(rst.getString(1)); } } catch (Exception n) { n.printStackTrace(); } }
private void setcbr() { try { ResultSet rst = DBConnection.getDBConnection() .createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE) .executeQuery( "SELECT * FROM Passenger where Booked_status='Booked' and Pay_Status='Not_Paid'"); System.out.println("Hello"); while (rst.next()) { combo1.addItem(rst.getString(1)); combo2.addItem(rst.getString(2)); } } catch (Exception n) { n.printStackTrace(); } }
private void setCombo() { try { ResultSet rst = DBConnection.getDBConnection() .createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE) .executeQuery( "SELECT Emp.empNo, Emp.Sname, Emp.Fname, Emp.Lname, Emp.Designation FROM Emp WHERE Emp.Designation='Booking Clerk'"); while (rst.next()) { combo3.addItem(rst.getString(3)); } } catch (Exception n) { n.printStackTrace(); } }
public void setRenderer(ListCellRenderer<? super Locale> newValue) { renderer = null; super.setRenderer(newValue); }
public void setLocale(Locale newValue) { super.setLocale(newValue); sort(); }
/** * Returns the unique ID of a week prefixed with the year. * * @return Selected week's ID. */ String getSelectedWeekID() { String weekNo = weekCB.getSelectedItem().toString(); if (weekNo.length() == 1) weekNo = "0" + weekNo; return yearCB.getSelectedItem() + "wk" + weekNo; }
/** * Checks whether the interval has been set using the date chooser. * * @return True if custom. */ boolean isIntervalCustom() { return yearCB.getSelectedIndex() == 0 || weekCB.getSelectedIndex() == 0; }
/** Set both year and week combo boxes to field "Custom". */ private void resetYearWeekComboBoxes() { yearCB.setSelectedIndex(0); weekCB.setSelectedIndex(0); }
public Payment() { super("Payment Process", false, true, false, true); setDefaultCloseOperation(DISPOSE_ON_CLOSE); label1 = new JLabel("Paymnent Number"); label2 = new JLabel("Passenger Number"); label3 = new JLabel("Passenger Name"); label6 = new JLabel("Mode of Payment"); label4 = new JLabel("Date of Payment"); label5 = new JLabel("Amount Paid"); label7 = new JLabel("Received By"); text1 = new JTextField(10); text5 = new JTextField(10); p_date = new DateButton(); p_date.setForeground(Color.red); combo1 = new JComboBox(); combo2 = new JComboBox(); combo3 = new JComboBox(); combo4 = new JComboBox(); combo4.addItem("Cash"); combo4.addItem("Bank"); combo8 = new JComboBox(); button1 = new JButton("Pay", new ImageIcon(ClassLoader.getSystemResource("Images/payments.png"))); button2 = new JButton( "Print Receipt", new ImageIcon(ClassLoader.getSystemResource("Images/print.png"))); button3 = new JButton("Cancel", new ImageIcon(ClassLoader.getSystemResource("Images/exit.png"))); button4 = new JButton("Search", new ImageIcon(ClassLoader.getSystemResource("Images/search.png"))); button5 = new JButton("Delete", new ImageIcon(ClassLoader.getSystemResource("Images/delete.png"))); // combo3.addItem(new) panel1 = new JPanel(new GridLayout(7, 2)); panel1.setPreferredSize(new Dimension(350, 250)); panel1.add(label1); panel1.add(text1); panel1.add(label2); panel1.add(combo1); panel1.add(label3); panel1.add(combo2); panel1.add(label6); panel1.add(combo4); panel1.add(label4); panel1.add(p_date); panel1.add(label5); panel1.add(combo8); panel1.add(label7); panel1.add(combo3); // combo8.removeAllItems(); pane = new JPanel(); pane.add(button1); pane.add(button2); pane.add(button3); pane.add(button4); panel3 = new JPanel(); panel3.add(panel1); panel3.add(pane); button2.setEnabled(false); add(panel3); setSize(500, 350); setCombo(); setcbr(); generator(); setamount(); setLocation((screen.width - 300) / 2, ((screen.height - 300) / 2)); setResizable(false); combo1.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) { combo2.setSelectedIndex(combo1.getSelectedIndex()); combo8.removeItem(combo8.getSelectedItem()); setamount(); } }); button3.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) { setVisible(true); dispose(); } }); button2.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) { Receipt frm = new Receipt(); MDIWindow.desktop.add(frm); frm.setVisible(true); button2.setEnabled(false); } }); button1.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) { if (combo1.getSelectedItem() == null) { JOptionPane.showMessageDialog( null, "All Passenger have paid", "Error", JOptionPane.DEFAULT_OPTION); return; } if (combo2.getSelectedItem() == null) { JOptionPane.showMessageDialog( null, "All Passenger have paid", "Error", JOptionPane.DEFAULT_OPTION); return; } generator(); if (combo8.getSelectedItem() == null) { JOptionPane.showMessageDialog( null, "The Passenger has not been booked", "ERROR", JOptionPane.DEFAULT_OPTION); return; } try { Statement statement = DBConnection.getDBConnection().createStatement(); { String temp = "INSERT INTO Payment (Payment_No, Pass_No, Pass_Name, Payment_Mode, Date_Payment,Amount_Paid,Received_By) VALUES ('" + text1.getText() + "', '" + combo1.getSelectedItem() + "', '" + combo2.getSelectedItem() + "', '" + combo4.getSelectedItem() + "', '" + p_date.getText() + "', '" + combo8.getSelectedItem() + "', '" + combo3.getSelectedItem() + "')"; combo1.removeItem(combo1.getSelectedItem()); combo2.removeItem(combo2.getSelectedItem()); int result = statement.executeUpdate(temp); JOptionPane.showMessageDialog( null, "Passenger Account updated", "Updated", JOptionPane.DEFAULT_OPTION); } } catch (SQLException sqlex) { sqlex.printStackTrace(); } try { Statement statement = DBConnection.getDBConnection().createStatement(); { String temp = "UPDATE Passenger SET Pay_Status='Paid'" + "WHERE Pass_NO LIKE '" + combo1.getSelectedItem() + "'"; int result = statement.executeUpdate(temp); } } catch (SQLException sqlex) { sqlex.printStackTrace(); } button1.setEnabled(false); button2.setEnabled(true); } }); button4.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent e) { try { if (!text1.equals("")) { Statement statement = DBConnection.getDBConnection().createStatement(); String query = ("SELECT * FROM Payment where Payment_No ='" + text1.getText() + "'"); ResultSet rs = statement.executeQuery(query); display(rs); statement.close(); } } catch (SQLException sqlex) { sqlex.printStackTrace(); } setVisible(true); } }); }