/** Initialize the contents of the frame. */ private void initialize() { frame = new JFrame(); frame.getContentPane().setBackground(new Color(153, 50, 204)); frame.setBounds(100, 100, 725, 547); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.getContentPane().setLayout(null); JLabel lblNewLabel = new JLabel("Username"); lblNewLabel.setFont(new Font("Tahoma", Font.PLAIN, 18)); lblNewLabel.setBounds(119, 113, 146, 36); frame.getContentPane().add(lblNewLabel); textField = new JTextField(); textField.setBounds(355, 122, 153, 22); frame.getContentPane().add(textField); textField.setColumns(10); JLabel lblNewLabel_1 = new JLabel("Password"); lblNewLabel_1.setFont(new Font("Tahoma", Font.PLAIN, 18)); lblNewLabel_1.setBounds(119, 213, 87, 22); frame.getContentPane().add(lblNewLabel_1); JButton btnNewButton = new JButton("Back"); btnNewButton.setFont(new Font("Tahoma", Font.PLAIN, 22)); btnNewButton.setBounds(124, 313, 121, 36); frame.getContentPane().add(btnNewButton); JButton btnNewButton_1 = new JButton("Login"); btnNewButton_1.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent arg0) { try { String query = "select * from logindetails where UserName=? and Password=?"; PreparedStatement pst = connect.prepareStatement(query); pst.setString(1, textField.getText()); pst.setString(2, passwordField.getText()); ResultSet rs = pst.executeQuery(); if (rs.next()) { // JOptionPane.showMessageDialog(null, "connection successfull"); ah.setVisible(true); frame.dispose(); } else { JOptionPane.showMessageDialog( null, "user credentials are wrong.Try again with correct credentials"); } } catch (Exception e) { JOptionPane.showMessageDialog(null, e); } } }); btnNewButton_1.setFont(new Font("Tahoma", Font.PLAIN, 22)); btnNewButton_1.setBounds(424, 314, 97, 35); frame.getContentPane().add(btnNewButton_1); passwordField = new JPasswordField(); passwordField.setBounds(355, 215, 166, 22); frame.getContentPane().add(passwordField); JLabel lblNewLabel_2 = new JLabel("Administrator Login"); lblNewLabel_2.setForeground(new Color(128, 128, 128)); lblNewLabel_2.setFont(new Font("Tahoma", Font.BOLD, 28)); lblNewLabel_2.setBounds(199, 48, 309, 34); frame.getContentPane().add(lblNewLabel_2); }
/** Initialize the contents of the frame. */ private void initialize() { JPanel mainPanel = new JPanel(); JButton book = new JButton("Book"); mainPanel.add(book); book.setPreferredSize(new Dimension(200, 80)); JTextField enterFlightNum = new JTextField("Enter Flight Number"); enterFlightNum.setColumns(10); enterFlightNum.setBounds(227, 251, 286, 42); mainPanel.add(enterFlightNum); JButton mainMenu = new JButton("Main Menu"); mainPanel.add(mainMenu); mainMenu.setPreferredSize(new Dimension(200, 80)); mainMenu.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent e) { fFrame.setVisible(false); new MainUI(c1); } }); book.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent e) { try { c1.bookFlight(Integer.parseInt(enterFlightNum.getText())); ; } catch (Exception ex) { ex.printStackTrace(); } } }); JPanel mainPanel2 = new JPanel(); JLabel listFlights = new JLabel(); mainPanel2.add(listFlights); Connection connection; String labelText = "<html>"; try { Class.forName("com.mysql.jdbc.Driver"); System.out.println("Driver loaded"); connection = DriverManager.getConnection("jdbc:mysql://localhost/mydb", "CIS3270", "Cis3270"); System.out.println("Connection complete"); Statement statement; statement = connection.createStatement(); String queryString = "select * from flight"; ResultSet rs = statement.executeQuery(queryString); while (rs.next()) { labelText = labelText + rs.getString(1) + " " + rs.getString(3) + " " + rs.getString(4) + " " + rs.getString(5) + " " + rs.getString(6) + "<br>"; } } catch (Exception e) { } listFlights.setText(labelText); System.out.println(labelText); JPanel mainCombine = new JPanel(); mainCombine.add(mainPanel, BorderLayout.NORTH); mainCombine.add(mainPanel2, BorderLayout.SOUTH); fFrame = new JFrame(); fFrame.setSize(1000, 800); fFrame.add(mainCombine); fFrame.setVisible(true); fFrame.setResizable(false); fFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); fFrame.getContentPane().setLayout(null); }
/** Create the frame. */ public SotrudnikDialog() { setTitle( "\u041D\u043E\u0432\u044B\u0439 \u0441\u043E\u0442\u0440\u0443\u0434\u043D\u0438\u043A"); setDefaultCloseOperation(DISPOSE_ON_CLOSE); setBounds(100, 100, 450, 330); contentPane = new JPanel(); contentPane.setBackground(new Color(255, 204, 255)); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); JLabel label_familiya = new JLabel("\u0424\u0430\u043C\u0438\u043B\u0438\u044F"); label_familiya.setBounds(10, 37, 110, 14); contentPane.add(label_familiya); JLabel label_imya = new JLabel("\u0418\u043C\u044F"); label_imya.setBounds(10, 62, 110, 14); contentPane.add(label_imya); JLabel label_otchestvo = new JLabel("\u041E\u0442\u0447\u0435\u0441\u0442\u0432\u043E"); label_otchestvo.setBounds(10, 87, 110, 14); contentPane.add(label_otchestvo); textField_otchestvo = new JTextField(); textField_otchestvo.setBounds(167, 84, 186, 20); contentPane.add(textField_otchestvo); textField_otchestvo.setColumns(10); textField_imya = new JTextField(); textField_imya.setBounds(167, 58, 186, 20); contentPane.add(textField_imya); textField_imya.setColumns(10); textField_familiya = new JTextField(); textField_familiya.setBounds(167, 33, 186, 20); contentPane.add(textField_familiya); textField_familiya.setColumns(10); JLabel label_data_priema = new JLabel( "\u0414\u0430\u0442\u0430 \u043F\u0440\u0438\u0435\u043C\u0430 \u043D\u0430 \u0440\u0430\u0431\u043E\u0442\u0443"); label_data_priema.setBounds(10, 112, 147, 14); contentPane.add(label_data_priema); JLabel label_phone = new JLabel("\u0422\u0435\u043B\u0435\u0444\u043E\u043D"); label_phone.setBounds(10, 137, 134, 14); contentPane.add(label_phone); JLabel label_doljnost = new JLabel("\u0414\u043E\u043B\u0436\u043D\u043E\u0441\u0442\u044C"); label_doljnost.setBounds(10, 162, 140, 14); contentPane.add(label_doljnost); JLabel label_kvalification = new JLabel("\u041A\u0432\u0430\u043B\u0438\u0444\u0438\u043A\u0430\u0446\u0438\u044F"); label_kvalification.setBounds(10, 190, 147, 14); contentPane.add(label_kvalification); textField_phone = new JTextField(); textField_phone.setBounds(167, 134, 186, 20); contentPane.add(textField_phone); textField_phone.setColumns(10); textField_date.setBounds(167, 109, 186, 20); contentPane.add(textField_date); label_id_hidden.setFont(new Font("Tahoma", Font.BOLD, 12)); label_id_hidden.setBounds(143, 11, 122, 14); contentPane.add(label_id_hidden); button_insert.setBounds(83, 230, 160, 23); contentPane.add(button_insert); button_cancel.setBounds(264, 230, 104, 23); contentPane.add(button_cancel); button_update.setBounds(83, 230, 160, 23); contentPane.add(button_update); JButton button_plus_doljnost = new JButton("+"); button_plus_doljnost.addActionListener( new ActionListener() { @SuppressWarnings("deprecation") public void actionPerformed(ActionEvent arg0) { DoljnostDialog d = new DoljnostDialog(); d.setTitle("Добавление должности"); d.show(); } }); button_plus_doljnost.setBounds(359, 159, 41, 23); contentPane.add(button_plus_doljnost); JButton button_plus_kvalification = new JButton("+"); button_plus_kvalification.addActionListener( new ActionListener() { @SuppressWarnings("deprecation") public void actionPerformed(ActionEvent arg0) { KvalificationDialog d = new KvalificationDialog(); d.setTitle("Добавление квалификации"); d.show(); } }); button_plus_kvalification.setBounds(359, 184, 41, 23); contentPane.add(button_plus_kvalification); JLabel label = new JLabel( "\u041F\u043E\u043B\u044F, \u043E\u0442\u043C\u0435\u0447\u0435\u043D\u043D\u044B\u0435 "); label.setBounds(60, 264, 122, 14); contentPane.add(label); JLabel label_3 = new JLabel("*"); label_3.setForeground(Color.RED); label_3.setFont(new Font("Tahoma", Font.BOLD, 11)); label_3.setBounds(186, 264, 12, 14); contentPane.add(label_3); JLabel label_4 = new JLabel( "\u043E\u0431\u044F\u0437\u0430\u0442\u0435\u043B\u044C\u043D\u044B \u0434\u043B\u044F \u0437\u0430\u043F\u043E\u043B\u043D\u0435\u043D\u0438\u044F!"); label_4.setBounds(197, 264, 203, 14); contentPane.add(label_4); JLabel label_5 = new JLabel("*"); label_5.setForeground(Color.RED); label_5.setFont(new Font("Tahoma", Font.BOLD, 11)); label_5.setBounds(356, 37, 12, 14); contentPane.add(label_5); JLabel label_1 = new JLabel("*"); label_1.setForeground(Color.RED); label_1.setFont(new Font("Tahoma", Font.BOLD, 11)); label_1.setBounds(356, 62, 12, 14); contentPane.add(label_1); comboBox_doljnost.setBounds(167, 159, 186, 20); contentPane.add(comboBox_doljnost); comboBox_kvalification.setBounds(167, 187, 186, 20); contentPane.add(comboBox_kvalification); // Actions for button "Добавить" button_insert.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent arg0) { if (!textField_familiya.getText().equals("") && !textField_imya.getText().equals("")) { try { Sotrudnik s = new Sotrudnik(); s.setFamiliya(textField_familiya.getText()); s.setImya(textField_imya.getText()); s.setOtchestvo(textField_otchestvo.getText()); s.setData_priema(Date.valueOf(textField_date.getText())); s.setPhone(textField_phone.getText()); Doljnost d = (Doljnost) comboBox_doljnost.getSelectedItem(); s.setId_doljnosti(d.getId_doljnosti()); Kvalification k = (Kvalification) comboBox_kvalification.getSelectedItem(); s.setId_kvalification(k.getId_kvalification()); DBClass db = new DBClass(); db.sotrudnikUpsert(s, "INSERT"); MyFrame.updateList(); ZakazDialog.updateSotrudnik(); } catch (SQLException e) { e.printStackTrace(); JOptionPane.showMessageDialog(panelException, e.getMessage()); } catch (ClassNotFoundException ee) { ee.printStackTrace(); JOptionPane.showMessageDialog(panelException, ee.getMessage()); } finally { dispose(); } } else JOptionPane.showMessageDialog(null, "Введите обязательные параметры!"); } }); // Actions for button "Отмена" button_cancel.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent arg0) { dispose(); } }); // Actions for button "Сохранить изменения" button_update.addActionListener( new ActionListener() { public void actionPerformed(ActionEvent arg0) { if (!textField_familiya.getText().equals("") && !textField_imya.getText().equals("") && !textField_date.getText().equals("")) { if (textField_date.getText().length() == 10) { try { Integer.parseInt((textField_date.getText().substring(0, 3))); Integer.parseInt((textField_date.getText().substring(5, 6))); Integer.parseInt((textField_date.getText().substring(8, 9))); Sotrudnik s = new Sotrudnik(); s.setId_sotrudnika(Integer.parseInt(label_id_hidden.getText())); s.setFamiliya(textField_familiya.getText()); s.setImya(textField_imya.getText()); s.setOtchestvo(textField_otchestvo.getText()); s.setPhone(textField_phone.getText()); Doljnost d = (Doljnost) comboBox_doljnost.getSelectedItem(); s.setId_doljnosti(d.getId_doljnosti()); Kvalification k = (Kvalification) comboBox_kvalification.getSelectedItem(); s.setId_kvalification(k.getId_kvalification()); DBClass db = new DBClass(); db.sotrudnikUpsert(s, "UPDATE"); MyFrame.updateList(); dispose(); } catch (NumberFormatException e) { JOptionPane.showMessageDialog(panelException, e.getMessage()); } catch (SQLException e) { // e.printStackTrace(); JOptionPane.showMessageDialog(panelException, e.getMessage()); } catch (ClassNotFoundException ee) { // ee.printStackTrace(); JOptionPane.showMessageDialog(panelException, ee.getMessage()); } } else JOptionPane.showMessageDialog(null, "Введите дату в правильном формате!"); } else JOptionPane.showMessageDialog(null, "Введите обязательные параметры!"); } }); }