Package MVCTableDAO.model

Examples of MVCTableDAO.model.Employee

106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
    }

  }

  public Employee readMitarbeiter(String id) {
    Employee ma = null;
    Department dep = null;
    try {
      String readEmployee = "SELECT * FROM employees AS e, departments as d WHERE e.id = " + id + ";";
      statement = c.createStatement();
      ResultSet rs = statement.executeQuery(readEmployee);

      while (rs.next()) {
        dep = new Department(rs.getString("d.id"), rs.getString("d.department"));
        ma = new Employee(rs.getString("id"), rs.getString("vorname"), rs.getString("nachname"), dep);
      }
      rs.close();
      statement.close();
      return ma;
    } catch (Exception e) {
View Full Code Here
137
138
139
140
141
142
143
144
145
146
147
      ResultSet rs = statement.executeQuery(sql);

      while (rs.next()) {
        dep = new Department(rs.getString("d_id"), rs.getString("department"));

        employeesList.add(new Employee(rs.getString(1), rs.getString(2), rs.getString(3), dep));

      }
      rs.close();
      statement.close();
    } catch (Exception e) {
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
          }else {
            System.err.println("File lesen fehlgeschlagen!");
            System.out.println(pathToFile);
          }
          imageIcon = new ImageIcon(data);
          Employee temp = model.readMitarbeiter(txtId.getText());
          temp.setImage(data);
          model.insertImageForEmployee(temp);
          imageLabel.setIcon(imageIcon);
        } catch (Exception e) {
           e.printStackTrace();
        }
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
        }
      }
      if (!(txtId.getText().isEmpty() || txtFirstName.getText().isEmpty() || txtLastName.getText().isEmpty())) {
          try {
              Department dep = new Department(txtDepartmentId.getText(), txtDepartmentDescription.getText());
              model.createMitarbeiter(new Employee(txtId.getText(), txtFirstName.getText(), txtLastName.getText(), dep));
          } catch (Exception ex) {
              ex.printStackTrace();
              JOptionPane.showMessageDialog(null, "Entweder wurde keine ID eingegen oder die ID ist bereits vorhanden!", "Fehler", JOptionPane.ERROR_MESSAGE);
          }
View Full Code Here
286
287
288
289
290
291
292
293
294
295
296
297
298
    }

    public void btnSearch_ActionPerformed(ActionEvent e) {
        try {
            Employee temp = model.readMitarbeiter(txtId.getText());
            txtFirstName.setText(temp.getVorname());
            txtLastName.setText(temp.getNachname());
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        mainTable.updateUI();
View Full Code Here
299
300
301
302
303
304
305
306
307
308
309
    }

    public void btnUpdate_ActionPerformed(ActionEvent e) {
        try {
          Department dep = new Department(txtDepartmentId.getText(), txtDepartmentDescription.getText());
          model.updateMitarbeiter(new Employee(txtId.getText(), txtFirstName.getText(), txtLastName.getText(), dep));
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        mainTable.updateUI();
View Full Code Here
310
311
312
313
314
315
316
317
318
319
320
    }

    public void btnDelete_ActionPerformed(ActionEvent e) {
        try {
          Department dep = new Department(txtDepartmentId.getText(), txtDepartmentDescription.getText());
          model.deleteMitarbeiter(new Employee(txtId.getText(), txtFirstName.getText(), txtLastName.getText(), dep));
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        mainTable.updateUI();
View Full Code Here
TOP

Related Classes of MVCTableDAO.model.Employee

  • MVCTableDAO.dao.MitarbeiterDAOToSQLite
  • MVCTableDAO.view.TableView
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.