首次提交

826220679@qq.com

2025-08-07 4d6cd980c5c69e4d9d150669c89734642297e0cd

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
package dell_system;
import databases.DBConnector;
import targets.Department;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
public class Dell_department {
    // ²éѯËùÓв¿ÃÅ
    static List<Department> departments=null;
    public static List<Department> getAllDepartments() throws SQLException {
        departments= new ArrayList<>();
        ResultSet rs = DBConnector.queryTableData("department");
 
        while (rs.next()) {
            Department dept = new Department();
            dept.setId(rs.getString("id"));
            dept.setDepartmentName(rs.getString("department_name"));
            dept.setAddedBy(rs.getString("added_by"));
            dept.setCompany(rs.getString("company"));
            dept.setViewPermission(rs.getString("view_permission"));
            dept.setAddPermission(rs.getString("add_permission"));
            dept.setEditPermission(rs.getString("edit_permission"));
            dept.setDeletePermission(rs.getString("delete_permission"));
            dept.setAddedDate(rs.getString("added_date"));
            dept.setReserved1(rs.getString("reserved1"));
            dept.setReserved2(rs.getString("reserved2"));
            dept.setReserved3(rs.getString("reserved3"));
            dept.setReserved4(rs.getString("reserved4"));
            departments.add(dept);
        }
        return departments;
    }
 
    // ÐÂÔö²¿ÃÅ
    public static void insertDepartment(Department department) throws SQLException {
        String sql = "INSERT INTO department (department_name, company, added_by) " +
                "VALUES (?, ?, ?)";
        DBConnector.executeUpdate(sql,
                department.getDepartmentName(),
                department.getCompany(),
                department.getAddedBy());
    }
 
    // É¾³ý²¿ÃÅ
    public static void deleteDepartment(String departmentId) throws SQLException {
        String sql = "DELETE FROM department WHERE id = ?";
        DBConnector.executeUpdate(sql, departmentId);
    }
 
 
    // ¸üв¿ÃÅ
    public static void updateDepartment(Department department) throws SQLException {
        String sql = "UPDATE department SET department_name = ?, company = ?, " +
                "view_permission = ?, add_permission = ?, " +
                "edit_permission = ?, delete_permission = ? " +
                "WHERE id = ?";
        DBConnector.executeUpdate(sql,
                department.getDepartmentName(),
                department.getCompany(),
                department.getViewPermission(),
                department.getAddPermission(),
                department.getEditPermission(),
                department.getDeletePermission(),
                department.getId());
    }
 
    // ÐÂÔö·½·¨£º»ñÈ¡ËùÓв¿ÃÅÃû³ÆµÄ×Ö·û´®Êý×é     
    public static String[] getAllDepartmentNames() {
        if (departments == null || departments.isEmpty()) {
            return new String[0]; // ·µ»Ø¿ÕÊý×é¶ø²»ÊÇnull
        }
        
        String[] departmentNames = new String[departments.size()];
        for (int i = 0; i < departments.size(); i++) {
            departmentNames[i] = departments.get(i).getDepartmentName();
        }
        
        return departmentNames;
    }
 
    // ¼ì²éÃû³ÆÊÇ·ñ´æÔÚ
    public static boolean isDepartmentNameExists(String Name) {
        if (departments== null) return false;
        for (Department f : departments) {
            if (Name.equals(f.getDepartmentName())) {
                return true;
            }
        }
        return false;
    }
}