修改

826220679@qq.com

10 天以前 176cfa1a137d2050d4e8a105dfdbdc8f1b32afb2

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
package dell_system;
import databases.DBConnector;
import targets.Company;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
public class Dell_company {
    static List<Company> companies=null;
    // ²éѯËùÓй«Ë¾
    public static List<Company> getAllCompanies() throws SQLException {
        companies = new ArrayList<>();
        ResultSet rs = DBConnector.queryTableData("company");
 
        while (rs.next()) {
            Company company = new Company();
            company.setId(rs.getInt("id"));
            company.setCompanyName(rs.getString("company_name"));
            company.setCompanyLogoUrl(rs.getString("company_logo_url"));
            company.setAddedBy(rs.getString("added_by"));
            company.setAddedDate(rs.getString("added_date"));
            companies.add(company);
        }
        return companies;
    }
 
    // ÐÂÔö¹«Ë¾
    public static void insertCompany(Company company) throws SQLException {
        String sql = "INSERT INTO company (company_name, added_date) " +
                "VALUES (?, ?)";
        DBConnector.executeUpdate(sql,
                company.getCompanyName(),
                company.getAddedDate());
    }
 
    // ¸üй«Ë¾
    public static void updateCompany(Company company) throws SQLException {
        String sql = "UPDATE company SET company_name = ? WHERE id = ?";
        DBConnector.executeUpdate(sql, 
                company.getCompanyName(), 
                company.getId());
    }
 
    // É¾³ý¹«Ë¾
    public static void deleteCompany(int companyId) throws SQLException {
        String sql = "DELETE FROM company WHERE id = ?";
        DBConnector.executeUpdate(sql, companyId);
    }
 
    // ÐÂÔö£º»ñÈ¡ËùÓй«Ë¾Ãû³ÆÊý×é
    public static String[] getAllCompanyNames() {
        if (companies == null || companies.isEmpty()) {
            return new String[0];
        }
 
        String[] companyNames = new String[companies.size()];
        for (int i = 0; i < companies.size(); i++) {
            companyNames[i] = companies.get(i).getCompanyName();
        }
 
        return companyNames;
    }
}