首次提交

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
package dell_suanfa;
import databases.DBConnector;
import targets.LayerManagement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
 
// ²ã¹ÜÀíÊý¾Ý²Ù×÷Àà
public class Dell_LayerManagement {
    static List<LayerManagement> layers=null;
    // »ñÈ¡ËùÓвãÐÅÏ¢
    public static List<LayerManagement> getAllLayers() throws SQLException {
        layers = new ArrayList<>(); // ´´½¨²ãÁбí
        // ²éѯ²ã¹ÜÀí±íÊý¾Ý
        ResultSet rs = DBConnector.queryTableData("layer_management");
        
        while (rs.next()) { // ±éÀú½á¹û¼¯
            LayerManagement layer = new LayerManagement(); // ´´½¨²ã¶ÔÏó
            // ÉèÖòãÊôÐÔ
            layer.setId(rs.getString("id")); // ÉèÖÃID
            layer.setLayerNumber(rs.getString("layer_number")); // ÉèÖòã±àºÅ
            layer.setBottomHeight(rs.getString("bottom_height")); // ÉèÖõײã¸ß¶È
            layer.setTopHeight(rs.getString("top_height")); // ÉèÖö¥²ã¸ß¶È
            layer.setCompany(rs.getString("company")); // ÉèÖÃËùÊô¹«Ë¾
            layer.setAddTime(rs.getString("add_time")); // ÉèÖÃÌí¼Óʱ¼ä
            layers.add(layer); // Ìí¼Óµ½Áбí
        }
        return layers; // ·µ»Ø²ãÁбí
    }
    
    // Ìí¼Óвã
    public static void insertLayer(LayerManagement layer) throws SQLException {
        // ²åÈëSQLÓï¾ä
        String sql = "INSERT INTO layer_management (layer_number, bottom_height, top_height, company, add_time) " +
                     "VALUES (?, ?, ?, ?, ?)";
        // Ö´ÐиüвÙ×÷
        DBConnector.executeUpdate(sql,
                layer.getLayerNumber(),
                layer.getBottomHeight(),
                layer.getTopHeight(),
                layer.getCompany(),
                layer.getAddTime());
    }
    
    // ¸üвãÐÅÏ¢
    public static void updateLayer(LayerManagement layer) throws SQLException {
        // ¸üÐÂSQLÓï¾ä
        String sql = "UPDATE layer_management SET layer_number = ?, bottom_height = ?, top_height = ?, company = ? WHERE id = ?";
        // Ö´ÐиüвÙ×÷
        DBConnector.executeUpdate(sql, 
                layer.getLayerNumber(),
                layer.getBottomHeight(),
                layer.getTopHeight(),
                layer.getCompany(),
                layer.getId());
    }
    
    // É¾³ý²ã
    public static void deleteLayer(int layerId) throws SQLException {
        // É¾³ýSQLÓï¾ä
        String sql = "DELETE FROM layer_management WHERE id = ?";
        // Ö´ÐÐɾ³ý²Ù×÷
        DBConnector.executeUpdate(sql, layerId);
    }
    
 // ÐÂÔö·½·¨£º»ñÈ¡ËùÓвã±àºÅµÄ×Ö·û´®Êý×é
    public static String[] getAllLayerNumbers() {
        if (layers == null || layers.isEmpty()) {
            return new String[0];
        }
 
        String[] layerNumbers = new String[layers.size()];
        for (int i = 0; i < layers.size(); i++) {
            layerNumbers[i] = layers.get(i).getLayerNumber();
        }
 
        return layerNumbers;
    }
    
}