Package MVCTableDAO.model

Examples of MVCTableDAO.model.Department

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

  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;
View Full Code Here
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
    return null;
  }

  public List<Employee> readAllMitarbeiter() {
    ArrayList<Employee> employeesList = new ArrayList<Employee>();
    Department dep = null;
    try {
      statement = c.createStatement();
      String sql = new String("SELECT e.id AS e_id, e.vorname, e.nachname, d.id AS d_id, d.department FROM employees AS e JOIN departments AS d ON e.department_id = d_id;");
      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();
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
        });
    }

    public void btnCreate_ActionPerformed(ActionEvent e) {
      if(!(txtDepartmentId.getText().isEmpty() && txtDepartmentDescription.getText().isEmpty())) {
        Department dep = new Department(txtDepartmentId.getText(), txtDepartmentDescription.getText());
        try {
          model.createDepartment(dep);
        } catch (Exception e1) {
          e1.printStackTrace();
        }
      }
      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
298
299
300
301
302
303
304
305
306
307
308
        mainTable.updateUI();
    }

    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();
        }
View Full Code Here
309
310
311
312
313
314
315
316
317
318
319
        mainTable.updateUI();
    }

    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();
        }
View Full Code Here
TOP

Related Classes of MVCTableDAO.model.Department

  • 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.