Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package dbprojekt;
- import java.awt.event.KeyEvent;
- import java.sql.*;
- import javax.swing.JOptionPane;
- import javax.swing.table.DefaultTableModel;
- import java.text.SimpleDateFormat;
- import java.util.Date;
- import java.util.logging.Level;
- import java.util.logging.Logger;
- public class GUI extends javax.swing.JFrame {
- public static Statement stmt = null;
- public static Connection conn = null;
- private static final String dbURL = "jdbc:oracle:thin:@localhost:1521:kosmos";
- static String user = "gniewko";
- static String password = "watek";
- public static void createConnection() {
- try {
- System.out.print("jestem tu");
- conn = DriverManager.getConnection(dbURL, user, password);
- } catch (Exception except) {
- }
- }
- DefaultTableModel model = new DefaultTableModel();
- public GUI() {
- initComponents();
- //Dodawanie kolumn w jTable = kolumny w tabeli w bazie - filmy
- model.addColumn("ID POBYTU");
- model.addColumn("KLIENT");
- model.addColumn("RASA");
- model.addColumn("GATUNEK");
- model.addColumn("ZWIERZAK");
- model.addColumn("POKOJ");
- model.addColumn("OD KIEDY");
- model.addColumn("DO KIEDY");
- model.addColumn("PLATNOSC");
- //Przeszukanie całej tablicy filmy i dodanie ich do kolumn
- try {
- stmt = conn.createStatement();
- ResultSet Rs = stmt.executeQuery("SELECT * FROM pobyt");
- int id_pobyt, id_klient, id_gatunek, id_zwierzak, id_pokoj, id_rasa, platnosc;
- String od_kiedy, do_kiedy;
- while (Rs.next()) {
- id_pobyt = Rs.getInt("id_pobyt");
- id_klient = Rs.getInt("id_klient");
- id_rasa = Rs.getInt("id_rasa");
- id_gatunek = Rs.getInt("id_gatunek");
- id_zwierzak = Rs.getInt("id_zwierzak");
- id_pokoj = Rs.getInt("id_pokoj");
- od_kiedy = Rs.getString("od_kiedy");
- do_kiedy = Rs.getString("do_kiedy");
- platnosc = Rs.getInt("wysokosc_platnosci");
- model.addRow(new Object[]{id_pobyt, id_klient, id_rasa, id_gatunek, id_zwierzak, id_pokoj, od_kiedy, do_kiedy, platnosc}); //dodawanie do tabeli
- }
- } catch (Exception e) {
- System.err.println(e);
- }
- tble.setModel(model);
- }
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jComboBox1 = new javax.swing.JComboBox();
- jButton3 = new javax.swing.JButton();
- jButton4 = new javax.swing.JButton();
- txtszu = new javax.swing.JTextField();
- jScrollPane1 = new javax.swing.JScrollPane();
- tble = new javax.swing.JTable();
- jButton2 = new javax.swing.JButton();
- jButton5 = new javax.swing.JButton();
- jButton6 = new javax.swing.JButton();
- jLabel1 = new javax.swing.JLabel();
- idklienta = new javax.swing.JTextField();
- idrasy = new javax.swing.JTextField();
- dokiedy = new javax.swing.JTextField();
- idgatunku = new javax.swing.JTextField();
- idzwierzaka = new javax.swing.JTextField();
- idpokoju = new javax.swing.JTextField();
- jLabel2 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jLabel4 = new javax.swing.JLabel();
- jLabel5 = new javax.swing.JLabel();
- jLabel6 = new javax.swing.JLabel();
- jLabel7 = new javax.swing.JLabel();
- jButton8 = new javax.swing.JButton();
- jButton9 = new javax.swing.JButton();
- jMenuBar1 = new javax.swing.JMenuBar();
- jMenu1 = new javax.swing.JMenu();
- jMenuItem4 = new javax.swing.JMenuItem();
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- setBackground(new java.awt.Color(204, 255, 204));
- setFocusCycleRoot(false);
- setMinimumSize(new java.awt.Dimension(680, 580));
- getContentPane().setLayout(null);
- jButton3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton3.setText("Szukaj");
- jButton3.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton3ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton3);
- jButton3.setBounds(140, 440, 150, 40);
- jButton4.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N
- jButton4.setText("Odśwież");
- jButton4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton4ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton4);
- jButton4.setBounds(320, 440, 140, 40);
- txtszu.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
- txtszu.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- txtszuActionPerformed(evt);
- }
- });
- txtszu.addKeyListener(new java.awt.event.KeyAdapter() {
- public void keyPressed(java.awt.event.KeyEvent evt) {
- txtszuKeyPressed(evt);
- }
- });
- getContentPane().add(txtszu);
- txtszu.setBounds(100, 400, 390, 30);
- tble.setModel(new javax.swing.table.DefaultTableModel(
- new Object [][] {
- },
- new String [] {
- "ID POBYTU", "KLIENT", "RASA", "GATUNEK", "ZWIERZAK", "POKOJ", "OD KIEDY", "DO KIEDY", "PLATNOSC"
- }
- ) {
- boolean[] canEdit = new boolean [] {
- false, false, false, true, false, true, true, true, true
- };
- public boolean isCellEditable(int rowIndex, int columnIndex) {
- return canEdit [columnIndex];
- }
- });
- tble.addMouseListener(new java.awt.event.MouseAdapter() {
- public void mouseClicked(java.awt.event.MouseEvent evt) {
- tbleMouseClicked(evt);
- }
- });
- jScrollPane1.setViewportView(tble);
- if (tble.getColumnModel().getColumnCount() > 0) {
- tble.getColumnModel().getColumn(3).setResizable(false);
- }
- getContentPane().add(jScrollPane1);
- jScrollPane1.setBounds(10, 10, 890, 380);
- jButton2.setText("POKOJE");
- jButton2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton2ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton2);
- jButton2.setBounds(610, 450, 120, 40);
- jButton5.setText("ZWIERZAKI");
- jButton5.setToolTipText("");
- jButton5.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton5ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton5);
- jButton5.setBounds(740, 400, 160, 40);
- jButton6.setText("Dodaj ");
- jButton6.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton6ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton6);
- jButton6.setBounds(960, 310, 120, 40);
- jLabel1.setFont(new java.awt.Font("Tahoma", 0, 20)); // NOI18N
- jLabel1.setText("Dodaj nowy pobyt");
- getContentPane().add(jLabel1);
- jLabel1.setBounds(930, 10, 170, 30);
- idklienta.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- idklientaActionPerformed(evt);
- }
- });
- getContentPane().add(idklienta);
- idklienta.setBounds(1000, 50, 120, 30);
- getContentPane().add(idrasy);
- idrasy.setBounds(1000, 90, 120, 30);
- getContentPane().add(dokiedy);
- dokiedy.setBounds(1000, 250, 120, 30);
- getContentPane().add(idgatunku);
- idgatunku.setBounds(1000, 130, 120, 30);
- getContentPane().add(idzwierzaka);
- idzwierzaka.setBounds(1000, 170, 120, 30);
- getContentPane().add(idpokoju);
- idpokoju.setBounds(1000, 210, 120, 30);
- jLabel2.setText("DO KIEDY");
- getContentPane().add(jLabel2);
- jLabel2.setBounds(910, 250, 80, 30);
- jLabel3.setText("ID KLIENTA");
- getContentPane().add(jLabel3);
- jLabel3.setBounds(910, 50, 80, 30);
- jLabel4.setText("ID RASY");
- getContentPane().add(jLabel4);
- jLabel4.setBounds(910, 90, 80, 30);
- jLabel5.setText("ID GATUNKU");
- getContentPane().add(jLabel5);
- jLabel5.setBounds(910, 130, 80, 30);
- jLabel6.setText("ID ZWIERZAKA");
- getContentPane().add(jLabel6);
- jLabel6.setBounds(910, 170, 90, 30);
- jLabel7.setText("ID POKOJU");
- getContentPane().add(jLabel7);
- jLabel7.setBounds(910, 210, 80, 30);
- jButton8.setText("KLIENCI");
- jButton8.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton8ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton8);
- jButton8.setBounds(610, 400, 120, 40);
- jButton9.setText("GATUNEK I RASA");
- jButton9.setToolTipText("");
- jButton9.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton9ActionPerformed(evt);
- }
- });
- getContentPane().add(jButton9);
- jButton9.setBounds(740, 450, 160, 40);
- jMenu1.setText("Baza danych hotelu dla zwierząt");
- jMenuItem4.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_F5, 0));
- jMenuItem4.setText("Odśwież");
- jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jMenuItem4ActionPerformed(evt);
- }
- });
- jMenu1.add(jMenuItem4);
- jMenuBar1.add(jMenu1);
- setJMenuBar(jMenuBar1);
- pack();
- }// </editor-fold>
- private void GetValue(int i) {
- //Funkcja pobiera z textfieldów
- /*try {
- //textfieldy
- txtId.setText(model.getValueAt(i, 0).toString());
- txtKat.setText(model.getValueAt(i, 1).toString());
- txtNaz.setText(model.getValueAt(i, 2).toString());
- txtKli.setText(model.getValueAt(i, 3).toString());
- } catch (Exception e) {
- System.err.println(e);
- JOptionPane.showMessageDialog(null, "Błąd!" + e.getLocalizedMessage());
- }*/
- }
- private void PrintDB() {
- try {
- model.setRowCount(0);
- stmt = conn.createStatement();
- ResultSet Rs = stmt.executeQuery("SELECT * FROM pobyt");
- int id_pobyt, id_klient, id_gatunek, id_zwierzak, id_pokoj;
- String od_kiedy, do_kiedy;
- while (Rs.next()) {
- id_pobyt = Rs.getInt("id_pobyt");
- id_klient = Rs.getInt("id_klient");
- id_gatunek = Rs.getInt("id_gatunek");
- id_zwierzak = Rs.getInt("id_zwierzak");
- id_pokoj = Rs.getInt("id_pokoj");
- od_kiedy = Rs.getString("od_kiedy");
- do_kiedy = Rs.getString("do_kiedy");
- model.addRow(new Object[]{id_pobyt, id_klient, id_klient, id_gatunek, id_zwierzak, id_pokoj, od_kiedy, do_kiedy }); //dodawanie do tabeli
- }
- } catch (Exception e) {
- System.err.println(e);
- }
- tble.setModel(model);
- // Przeszukuje tabelę filmy by dodać je do tabelki.
- }
- private void txtszuActionPerformed(java.awt.event.ActionEvent evt) {
- }
- private void tbleMouseClicked(java.awt.event.MouseEvent evt) {
- try {
- int i = tble.getSelectedRow(); GetValue(i);
- } catch (Exception e) {
- JOptionPane.showMessageDialog(null, "Błąd " + e.getLocalizedMessage());
- }
- // Pobiera do pól o danym elemencie
- }
- private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
- PrintDB();
- // PO KLIKNIĘCIU PRZYCISKU WYŚWIETLA AKTUALNY STAN TABELI.
- }
- private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
- /* try {
- model.setRowCount(0); // Wyczyszczenie tabeli
- {
- Rs = stm.executeQuery("SELECT * FROM filmy WHERE nazwa LIKE \"%" + txtszu.getText() + "%\"");
- }
- int id_filmu, id_kategorii, id_klienta;
- String nazwa;
- while (Rs.next()) {
- id_filmu = Rs.getInt("id_filmu");
- id_kategorii = Rs.getInt("id_kategorii");
- id_klienta = Rs.getInt("id_klienta");
- nazwa = Rs.getString("nazwa");
- model.addRow(new Object[]{id_filmu, id_kategorii, id_klienta, nazwa});
- }
- if (model.getRowCount() == 0) {
- JOptionPane.showMessageDialog(null, "Brak wyników.");
- } else {
- int i = 0;
- GetValue(i);
- }
- } catch (Exception e) {
- System.err.println(e);
- JOptionPane.showMessageDialog(null, e.getMessage());
- }*/
- //Wyszukiwarka, przeszukuje po fragmencie (%like)
- // Jesli nie ma wyswietla ze nie ma wynikow
- }
- private void jMenuItem4ActionPerformed(java.awt.event.ActionEvent evt) {
- PrintDB();
- //Refreshuje tabelke
- }
- private void txtszuKeyPressed(java.awt.event.KeyEvent evt) {
- if (evt.getKeyCode() == KeyEvent.VK_ENTER) //Jesli klikniesz ENTERa
- {
- try {
- model.setRowCount(0); // WCzyszczenie tabelki.
- {
- }
- ResultSet Rs = stmt.executeQuery("SELECT * FROM filmy AND nazwa LIKE \"%" + txtszu.getText() + "%\"");
- int id_filmu, id_kategorii, id_klienta;
- String nazwa;
- while (Rs.next()) {
- id_filmu = Rs.getInt("id_filmu");
- id_kategorii = Rs.getInt("id_kategorii");
- id_klienta = Rs.getInt("id_klienta");
- nazwa = Rs.getString("nazwa");
- model.addRow(new Object[]{id_filmu, id_kategorii, id_klienta, nazwa});
- }
- if (model.getRowCount() == 0) {
- JOptionPane.showMessageDialog(null, "Brak wyników.");
- } else {
- int i = 0;
- GetValue(i);
- }
- } catch (Exception e) {
- System.err.println(e);
- JOptionPane.showMessageDialog(null, e.getMessage());
- }
- }
- // Wyszukiwarka aktywowana ENTER
- // to samo co u gory
- }
- private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
- Date currentDate = new Date();
- SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy");
- int klienta = Integer.parseInt(idklienta.getText());
- int rasa = Integer.parseInt(idrasy.getText());
- int gatunek = Integer.parseInt(idgatunku.getText());
- int zwierzak = Integer.parseInt(idzwierzaka.getText());
- int pokoj = Integer.parseInt(idpokoju.getText());
- String od_kiedy = dateFormat.format(currentDate);
- String do_kiedy = dokiedy.getText();
- System.out.print(od_kiedy);
- try {
- CallableStatement cstmt = conn.prepareCall("{ = call add_pobyt (?,?,?,?,?,?,?)}"); //linia 454
- cstmt.setInt(2, klienta);
- cstmt.setInt(3, rasa);
- cstmt.setInt(4, gatunek);
- cstmt.setInt(5, zwierzak);
- cstmt.setInt(6, pokoj);
- cstmt.setString(7, od_kiedy);
- cstmt.setString(8, do_kiedy);
- cstmt.executeUpdate();
- } catch (SQLException ex) {
- Logger.getLogger(GUI.class.getName()).log(Level.SEVERE, null, ex);
- }
- }
- private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- private void idklientaActionPerformed(java.awt.event.ActionEvent evt) {
- // TODO add your handling code here:
- }
- public static void main(String args[]) {
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new GUI().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify
- private javax.swing.JTextField dokiedy;
- private javax.swing.JTextField idgatunku;
- private javax.swing.JTextField idklienta;
- private javax.swing.JTextField idpokoju;
- private javax.swing.JTextField idrasy;
- private javax.swing.JTextField idzwierzaka;
- private javax.swing.JButton jButton2;
- private javax.swing.JButton jButton3;
- private javax.swing.JButton jButton4;
- private javax.swing.JButton jButton5;
- private javax.swing.JButton jButton6;
- private javax.swing.JButton jButton8;
- private javax.swing.JButton jButton9;
- private javax.swing.JComboBox jComboBox1;
- private javax.swing.JLabel jLabel1;
- private javax.swing.JLabel jLabel2;
- private javax.swing.JLabel jLabel3;
- private javax.swing.JLabel jLabel4;
- private javax.swing.JLabel jLabel5;
- private javax.swing.JLabel jLabel6;
- private javax.swing.JLabel jLabel7;
- private javax.swing.JMenu jMenu1;
- private javax.swing.JMenuBar jMenuBar1;
- private javax.swing.JMenuItem jMenuItem4;
- private javax.swing.JScrollPane jScrollPane1;
- private javax.swing.JTable tble;
- private javax.swing.JTextField txtszu;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement