Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package aplikacja_package;
- import java.sql.*;
- import javax.swing.JButton;
- import javax.swing.JCheckBox;
- import javax.swing.JComboBox;
- import javax.swing.JLabel;
- import javax.swing.JTextField;
- import net.sf.jasperreports.engine.JasperCompileManager;
- import net.sf.jasperreports.engine.JasperFillManager;
- import net.sf.jasperreports.engine.JasperPrint;
- import net.sf.jasperreports.engine.JasperReport;
- import net.sf.jasperreports.engine.design.JRDesignQuery;
- import net.sf.jasperreports.engine.design.JasperDesign;
- import net.sf.jasperreports.engine.xml.JRXmlLoader;
- import net.sf.jasperreports.view.JasperViewer;
- /**
- *
- * @author Mateusz
- */
- public class aplikacjaForm extends javax.swing.JFrame {
- /**
- * Creates new form aplikacjaForm
- */
- Connection conn = null;
- ResultSet rs = null;
- PreparedStatement pst = null;
- public int flag = 1;
- public aplikacjaForm() {
- initComponents();
- try {
- Class.forName("com.mysql.cj.jdbc.Driver");
- conn = DriverManager.getConnection("jdbc:mysql://localhost/silownia", "root", "");
- } catch (Exception ex) {
- System.out.println("Error: " + ex);
- }
- }
- public JComboBox<String> getjComboBox1() {
- return jComboBox1;
- }
- public JCheckBox getjCheckBox1() {
- return jCheckBox1;
- }
- public JCheckBox getjCheckBox2() {
- return jCheckBox2;
- }
- public JLabel getjLabel2() {
- return jLabel2;
- }
- public JButton getjButton1() {
- return jButton1;
- }
- public JLabel getjLabel3() {
- return jLabel3;
- }
- public JLabel getjLabel4() {
- return jLabel4;
- }
- public JLabel getjLabel5() {
- return jLabel5;
- }
- public JLabel getjLabel6() {
- return jLabel6;
- }
- public JTextField getjTextField1() {
- return jTextField1;
- }
- public JTextField getjTextField2() {
- return jTextField2;
- }
- public JTextField getjTextField3() {
- return jTextField3;
- }
- public JTextField getjTextField4() {
- return jTextField4;
- }
- public void setCheckboxes() {
- if (getjComboBox1().getSelectedItem().equals("Klienci")) {
- getjLabel2().setText("Raport o klientach:");
- getjCheckBox1().setText("wygeneruj raport tylko dla klientów posiadających szafkę");
- getjCheckBox2().setText("wygeneruj raport tylko dla klientów posiadających karnet");
- flag = 1;
- getjLabel3().setVisible(true);
- getjLabel4().setVisible(true);
- getjLabel5().setVisible(true);
- getjLabel6().setVisible(true);
- getjTextField1().setVisible(true);
- getjTextField2().setVisible(true);
- getjTextField3().setVisible(true);
- getjTextField4().setVisible(true);
- getjTextField1().setText("");
- getjTextField2().setText("");
- getjTextField3().setText("");
- getjTextField4().setText("");
- } else if (getjComboBox1().getSelectedItem().equals("Konserwacja_urzadzen")) {
- getjLabel2().setText("Raport na temat konserwacji urządzeń:");
- getjCheckBox1().setText("wygeneruj raport wyświetlający ilość zaplanowanych konserwacji");
- getjCheckBox2().setText("wygeneruj raport wyświetlający konserwacje zaplanowane na 2019 rok");
- getjLabel3().setVisible(false);
- getjLabel4().setVisible(false);
- getjLabel5().setVisible(false);
- getjLabel6().setVisible(false);
- getjTextField1().setVisible(false);
- getjTextField2().setVisible(false);
- getjTextField3().setVisible(false);
- getjTextField4().setVisible(false);
- flag = 2;
- } else if (getjComboBox1().getSelectedItem().equals("Urzadzenia")) {
- getjLabel2().setText("Raport na temat urządzeń:");
- getjCheckBox1().setText("wygeneruj raport tylko dla urządzeń, których jest więcej niż jedna sztuka");
- getjCheckBox2().setText("wygeneruj raport tylko dla urządzeń, których jest dokładnie pięć lub mniej");
- getjLabel3().setVisible(false);
- getjLabel4().setVisible(false);
- getjLabel5().setVisible(false);
- getjLabel6().setVisible(false);
- getjTextField1().setVisible(false);
- getjTextField2().setVisible(false);
- getjTextField3().setVisible(false);
- getjTextField4().setVisible(false);
- flag = 3;
- } else if (getjComboBox1().getSelectedItem().equals("Zajecia")) {
- getjLabel2().setText("Raport na temat zajęć:");
- getjCheckBox1().setText("wygeneruj raport tylko dla zajęć, które odbywają się więcej niż raz w tygodniu");
- getjCheckBox2().setText("wygeneruj raport tylko dla zajęć, których cena za wejście jest większa niż 10 PLN");
- getjLabel3().setVisible(false);
- getjLabel4().setVisible(false);
- getjLabel5().setVisible(false);
- getjLabel6().setVisible(false);
- getjTextField1().setVisible(false);
- getjTextField2().setVisible(false);
- getjTextField3().setVisible(false);
- getjTextField4().setVisible(false);
- flag = 4;
- }
- }
- /**
- * This method is called from within the constructor to initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is always
- * regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
- private void initComponents() {
- jPanel1 = new javax.swing.JPanel();
- jLabel1 = new javax.swing.JLabel();
- jComboBox1 = new javax.swing.JComboBox<>();
- jLabel2 = new javax.swing.JLabel();
- jCheckBox1 = new javax.swing.JCheckBox();
- jCheckBox2 = new javax.swing.JCheckBox();
- jButton1 = new javax.swing.JButton();
- jTextField1 = new javax.swing.JTextField();
- jLabel4 = new javax.swing.JLabel();
- jTextField2 = new javax.swing.JTextField();
- jLabel5 = new javax.swing.JLabel();
- jTextField3 = new javax.swing.JTextField();
- jLabel6 = new javax.swing.JLabel();
- jLabel3 = new javax.swing.JLabel();
- jTextField4 = new javax.swing.JTextField();
- setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
- setPreferredSize(new java.awt.Dimension(590, 340));
- setResizable(false);
- jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout());
- jLabel1.setText("Generuj raport dla tabeli:");
- jPanel1.add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, -1, -1));
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "Klienci", "Konserwacja_urzadzen", "Urzadzenia", "Zajecia" }));
- jComboBox1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jComboBox1ActionPerformed(evt);
- }
- });
- jPanel1.add(jComboBox1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 30, 180, 30));
- jLabel2.setText("Raport o klientach:");
- jPanel1.add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 70, -1, -1));
- jCheckBox1.setText("wygeneruj raport tylko dla klientów posiadających szafkę");
- jPanel1.add(jCheckBox1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 120, -1, -1));
- jCheckBox2.setText("wygeneruj raport tylko dla klientów posiadających karnet");
- jPanel1.add(jCheckBox2, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 150, -1, -1));
- jButton1.setText("Generuj raport");
- jButton1.setFocusable(false);
- jButton1.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jPanel1.add(jButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(220, 190, -1, -1));
- jTextField1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField1ActionPerformed(evt);
- }
- });
- jPanel1.add(jTextField1, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 90, 70, -1));
- jLabel4.setText("Imię:");
- jPanel1.add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 90, -1, 30));
- jTextField2.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jTextField2ActionPerformed(evt);
- }
- });
- jPanel1.add(jTextField2, new org.netbeans.lib.awtextra.AbsoluteConstraints(40, 90, 70, -1));
- jLabel5.setText("Nazwisko:");
- jPanel1.add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(120, 90, -1, 30));
- jPanel1.add(jTextField3, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 90, 70, -1));
- jLabel6.setText("Telefon:");
- jPanel1.add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(260, 90, -1, 30));
- jLabel3.setText("Email:");
- jPanel1.add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(390, 90, -1, 30));
- jPanel1.add(jTextField4, new org.netbeans.lib.awtextra.AbsoluteConstraints(310, 90, 70, -1));
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 507, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(0, 187, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addContainerGap(78, Short.MAX_VALUE))
- );
- pack();
- }// </editor-fold>//GEN-END:initComponents
- private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox1ActionPerformed
- setCheckboxes();
- }//GEN-LAST:event_jComboBox1ActionPerformed
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
- switch (flag) {
- case 1:
- if (getjCheckBox1().isSelected() && getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Klienci_3.jrxml");
- String imie = getjTextField2().getText();
- String nazwisko = getjTextField3().getText();
- String telefon = getjTextField4().getText();
- String email = getjTextField1().getText();
- String sql = "";
- if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- }
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox1().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Klienci_1.jrxml");
- String imie = getjTextField2().getText();
- String nazwisko = getjTextField3().getText();
- String telefon = getjTextField4().getText();
- String email = getjTextField1().getText();
- String sql = "";
- if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else if (email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- } else {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Szafki IS NOT NULL ORDER BY ID_Klienta";
- }
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Klienci_2.jrxml");
- String imie = getjTextField2().getText();
- String nazwisko = getjTextField3().getText();
- String telefon = getjTextField4().getText();
- String email = getjTextField1().getText();
- String sql = "";
- if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (imie.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else if (email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- } else {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "' AND ID_Karnetu IS NOT NULL ORDER BY ID_Klienta";
- }
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Klienci.jrxml");
- String imie = getjTextField2().getText();
- String nazwisko = getjTextField3().getText();
- String telefon = getjTextField4().getText();
- String email = getjTextField1().getText();
- String sql = "";
- if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Email = '" + email + "'";
- } else if (imie.isEmpty() && nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "'";
- } else if (imie.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "'";
- } else if (nazwisko.isEmpty() && telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "'";
- } else if (imie.isEmpty() && nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Telefon = '" + telefon + "' AND Email = '" + email + "'";
- } else if (imie.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Email = '" + email + "'";
- } else if (imie.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "'";
- } else if (nazwisko.isEmpty() && telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Email = '" + email + "'";
- } else if (nazwisko.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "'";
- } else if (telefon.isEmpty() && email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "'";
- } else if (imie.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "'";
- } else if (nazwisko.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "'";
- } else if (telefon.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Email = '" + email + "'";
- } else if (email.isEmpty()) {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "'";
- } else {
- sql = "SELECT * FROM Klienci WHERE Imie = '" + imie + "' AND Nazwisko = '" + nazwisko + "' AND Telefon = '" + telefon + "' AND Email = '" + email + "'";
- }
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- }
- break;
- case 2:
- if (getjCheckBox1().isSelected() && getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Konserwacja_urzadzen_3.jrxml");
- String sql = "SELECT ID_Urzadzenia, COUNT(ID_Konserwacji) AS `Ilosc zaplanowanych konserwacji` FROM Konserwacja_urzadzen WHERE Data_zaplanowanej_konserwacji LIKE '2019%' GROUP BY ID_Urzadzenia";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox1().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Konserwacja_urzadzen_1.jrxml");
- String sql = "SELECT ID_Urzadzenia, COUNT(ID_Konserwacji) AS `Ilosc zaplanowanych konserwacji` FROM Konserwacja_urzadzen GROUP BY ID_Urzadzenia";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Konserwacja_urzadzen_2.jrxml");
- String sql = "SELECT * FROM Konserwacja_urzadzen WHERE Data_zaplanowanej_konserwacji LIKE '2019%'";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Konserwacja_urzadzen.jrxml");
- String sql = "SELECT * FROM Konserwacja_urzadzen";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- }
- break;
- case 3:
- if (getjCheckBox1().isSelected() && getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Urzadzenia_3.jrxml");
- String sql = "SELECT * FROM Urzadzenia WHERE Ilosc > 1 AND Ilosc <= 5";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox1().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Urzadzenia_1.jrxml");
- String sql = "SELECT * FROM Urzadzenia WHERE Ilosc > 1";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Urzadzenia_2.jrxml");
- String sql = "SELECT * FROM Urzadzenia WHERE Ilosc <= 5";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Urzadzenia.jrxml");
- String sql = "SELECT * FROM Urzadzenia";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- }
- break;
- case 4:
- if (getjCheckBox1().isSelected() && getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Zajecia_3.jrxml");
- String sql = "SELECT Nazwa, COUNT(Nazwa) AS `Ilosc zajec w tygodniu`, Cena_za_wejscie FROM Zajecia GROUP BY Nazwa HAVING `Ilosc zajec w tygodniu` > 1 AND Cena_za_wejscie > '10 PLN' AND LENGTH(Cena_za_wejscie) >= 6";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox1().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Zajecia_1.jrxml");
- String sql = "SELECT Nazwa, COUNT(Nazwa) AS `Ilosc zajec w tygodniu`, Cena_za_wejscie FROM Zajecia GROUP BY Nazwa HAVING `Ilosc zajec w tygodniu` > 1";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else if (getjCheckBox2().isSelected()) {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Zajecia_2.jrxml");
- String sql = "SELECT * FROM Zajecia WHERE Cena_za_wejscie > '10 PLN' AND LENGTH(Cena_za_wejscie) >= 6";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- } else {
- try {
- JasperDesign jd = JRXmlLoader.load("D:\\UTP\\Podstawy baz danych\\Projekt\\Aplikacja\\Aplikacja\\Zajecia.jrxml");
- String sql = "SELECT * FROM Zajecia";
- JRDesignQuery newQuery = new JRDesignQuery();
- newQuery.setText(sql);
- jd.setQuery(newQuery);
- JasperReport jr = JasperCompileManager.compileReport(jd);
- JasperPrint jp = JasperFillManager.fillReport(jr, null, conn);
- JasperViewer.viewReport(jp, false);
- } catch (Exception e) {
- System.out.println("Error: " + e);
- }
- }
- break;
- default:
- break;
- }
- }//GEN-LAST:event_jButton1ActionPerformed
- private void jTextField2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField2ActionPerformed
- // TODO add your handling code here:
- }//GEN-LAST:event_jTextField2ActionPerformed
- private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField1ActionPerformed
- // TODO add your handling code here:
- }//GEN-LAST:event_jTextField1ActionPerformed
- /**
- * @param args the command line arguments
- */
- public static void main(String args[]) {
- /* Set the Nimbus look and feel */
- //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
- /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
- * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
- */
- try {
- for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
- if ("Nimbus".equals(info.getName())) {
- javax.swing.UIManager.setLookAndFeel(info.getClassName());
- break;
- }
- }
- } catch (ClassNotFoundException ex) {
- java.util.logging.Logger.getLogger(aplikacjaForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (InstantiationException ex) {
- java.util.logging.Logger.getLogger(aplikacjaForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (IllegalAccessException ex) {
- java.util.logging.Logger.getLogger(aplikacjaForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- } catch (javax.swing.UnsupportedLookAndFeelException ex) {
- java.util.logging.Logger.getLogger(aplikacjaForm.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
- }
- //</editor-fold>
- /* Create and display the form */
- java.awt.EventQueue.invokeLater(new Runnable() {
- public void run() {
- new aplikacjaForm().setVisible(true);
- }
- });
- }
- // Variables declaration - do not modify//GEN-BEGIN:variables
- private javax.swing.JButton jButton1;
- private javax.swing.JCheckBox jCheckBox1;
- private javax.swing.JCheckBox jCheckBox2;
- private javax.swing.JComboBox<String> 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.JPanel jPanel1;
- private javax.swing.JTextField jTextField1;
- private javax.swing.JTextField jTextField2;
- private javax.swing.JTextField jTextField3;
- private javax.swing.JTextField jTextField4;
- // End of variables declaration//GEN-END:variables
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement