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;
    }
    
}