package dell_Fence;
|
import databases.DBConnector;
|
import targets.Fence;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.List;
|
|
// ΧÀ¸Êý¾Ý²Ù×÷Àà
|
public class Dell_Fence {
|
static List<Fence> fences=null;
|
// »ñÈ¡ËùÓÐΧÀ¸ÐÅÏ¢
|
public static List<Fence> getAllFences() throws SQLException {
|
fences = new ArrayList<>();
|
// ²éѯΧÀ¸±íÊý¾Ý
|
ResultSet rs = DBConnector.queryTableData("fence");
|
|
while (rs.next()) {
|
Fence fence = new Fence();
|
// ÉèÖÃΧÀ¸ÊôÐÔ
|
fence.setId(rs.getString("id"));
|
fence.setFenceType(rs.getString("fence_type"));
|
fence.setFenceName(rs.getString("fence_name"));
|
fence.setRelatedDepartment(rs.getString("related_department"));
|
fence.setShape(rs.getString("shape"));
|
fence.setValidRangeXy(rs.getString("valid_range_xy"));
|
fence.setValidRangeCoordinates(rs.getString("valid_range_coordinates"));
|
fence.setEffectiveTime(rs.getString("effective_time"));
|
fence.setLayer(rs.getString("layer"));
|
fence.setExpirationTime(rs.getString("expiration_time"));
|
fence.setColor(rs.getString("color"));
|
fence.setIsEnabled(rs.getString("is_enabled"));
|
fence.setBottomHeight(rs.getString("bottom_height"));
|
fence.setTopHeight(rs.getString("top_height"));
|
fence.setGatheringRadius(rs.getString("gathering_radius"));
|
fence.setGatheringTime(rs.getString("gathering_time"));
|
fence.setMaxPeople(rs.getString("max_people"));
|
fence.setMinPeople(rs.getString("min_people"));
|
fence.setHazardousMaterial(rs.getString("hazardous_material"));
|
fence.setMaxDuration(rs.getString("max_duration"));
|
fence.setMinDuration(rs.getString("min_duration"));
|
fence.setLatestInspectionTime(rs.getString("latest_inspection_time"));
|
fence.setInspectionOrder(rs.getString("inspection_order"));
|
fence.setInspectionCount(rs.getString("inspection_count"));
|
fence.setSides(rs.getString("sides"));
|
fence.setCanEnter(rs.getString("can_enter"));
|
fence.setCanExit(rs.getString("can_exit"));
|
fence.setConstraintType(rs.getString("constraint_type"));
|
fence.setConstraintDescription(rs.getString("constraint_description"));
|
fence.setCameraNumber(rs.getString("camera_number"));
|
fence.setAddedTime(rs.getString("added_time"));
|
fence.setCompany(rs.getString("company"));
|
fence.setReserved1(rs.getString("reserved1"));
|
fence.setReserved2(rs.getString("reserved2"));
|
fence.setReserved3(rs.getString("reserved3"));
|
fence.setReserved4(rs.getString("reserved4"));
|
fence.setReserved5(rs.getString("reserved5"));
|
fence.setReserved6(rs.getString("reserved6"));
|
fence.setReserved7(rs.getString("reserved7"));
|
fence.setReserved8(rs.getString("reserved8"));
|
fence.setReserved9(rs.getString("reserved9"));
|
fence.setReserved10(rs.getString("reserved10"));
|
|
fences.add(fence);
|
}
|
return fences;
|
}
|
|
// Ð޸ĺóµÄinsertFence·½·¨
|
public static void insertFence(Fence fence) throws SQLException {
|
String sql = "INSERT INTO fence ("
|
+ "fence_type, fence_name, related_department, shape, valid_range_xy, "
|
+ "valid_range_coordinates, effective_time, layer, expiration_time, color, "
|
+ "is_enabled, bottom_height, top_height, gathering_radius, gathering_time, "
|
+ "max_people, min_people, hazardous_material, max_duration, min_duration, "
|
+ "latest_inspection_time, inspection_order, inspection_count, sides, can_enter, "
|
+ "can_exit, constraint_type, constraint_description, camera_number, added_time, "
|
+ "company, reserved1, reserved2, reserved3, reserved4, reserved5, reserved6, "
|
+ "reserved7, reserved8, reserved9, reserved10"
|
+ ") VALUES ("
|
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
|
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
|
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, "
|
+ "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; // Ð޸Ĵ˴¦£ºÔö¼ÓÒ»¸öÎʺÅ
|
|
DBConnector.executeUpdate(sql,
|
fence.getFenceType(),
|
fence.getFenceName(),
|
fence.getRelatedDepartment(),
|
fence.getShape(),
|
fence.getValidRangeXy(),
|
fence.getValidRangeCoordinates(),
|
fence.getEffectiveTime(),
|
fence.getLayer(),
|
fence.getExpirationTime(),
|
fence.getColor(),
|
fence.getIsEnabled(),
|
fence.getBottomHeight(),
|
fence.getTopHeight(),
|
fence.getGatheringRadius(),
|
fence.getGatheringTime(),
|
fence.getMaxPeople(),
|
fence.getMinPeople(),
|
fence.getHazardousMaterial(),
|
fence.getMaxDuration(),
|
fence.getMinDuration(),
|
fence.getLatestInspectionTime(),
|
fence.getInspectionOrder(),
|
fence.getInspectionCount(),
|
fence.getSides(),
|
fence.getCanEnter(),
|
fence.getCanExit(),
|
fence.getConstraintType(),
|
fence.getConstraintDescription(),
|
fence.getCameraNumber(),
|
fence.getAddedTime(),
|
fence.getCompany(),
|
fence.getReserved1(),
|
fence.getReserved2(),
|
fence.getReserved3(),
|
fence.getReserved4(),
|
fence.getReserved5(),
|
fence.getReserved6(),
|
fence.getReserved7(),
|
fence.getReserved8(),
|
fence.getReserved9(),
|
fence.getReserved10()
|
);
|
}
|
|
// ɾ³ýΧÀ¸
|
public static void deleteFence(String fenceId) throws SQLException {
|
String sql = "DELETE FROM fence WHERE id = ?";
|
DBConnector.executeUpdate(sql, fenceId);
|
}
|
|
// »ñÈ¡ËùÓÐΧÀ¸Ãû³ÆµÄ×Ö·û´®Êý×é
|
public static String[] getAllFenceNames() {
|
if (fences == null || fences.isEmpty()) {
|
return new String[0];
|
}
|
|
String[] fenceNames = new String[fences.size()];
|
for (int i = 0; i < fences.size(); i++) {
|
fenceNames[i] = fences.get(i).getFenceName();
|
}
|
return fenceNames;
|
}
|
|
// ¼ì²éΧÀ¸Ãû³ÆÊÇ·ñ´æÔÚ
|
public static boolean isFenceNameExists(String fenceName) {
|
if (fences == null) return false;
|
for (Fence f : fences) {
|
if (fenceName.equals(f.getFenceName())) {
|
return true;
|
}
|
}
|
return false;
|
}
|
|
// ¸ù¾ÝID»ñȡΧÀ¸
|
public static Fence getFenceById(String fenceId) throws SQLException {
|
String sql = "SELECT * FROM fence WHERE id = ?";
|
try (ResultSet rs = DBConnector.executeQuery(sql, fenceId)) {
|
if (rs.next()) {
|
Fence fence = new Fence();
|
fence.setId(rs.getString("id"));
|
fence.setFenceType(rs.getString("fence_type"));
|
fence.setFenceName(rs.getString("fence_name"));
|
fence.setRelatedDepartment(rs.getString("related_department"));
|
fence.setShape(rs.getString("shape"));
|
fence.setValidRangeXy(rs.getString("valid_range_xy"));
|
fence.setValidRangeCoordinates(rs.getString("valid_range_coordinates"));
|
fence.setEffectiveTime(rs.getString("effective_time"));
|
fence.setLayer(rs.getString("layer"));
|
fence.setExpirationTime(rs.getString("expiration_time"));
|
fence.setColor(rs.getString("color"));
|
fence.setIsEnabled(rs.getString("is_enabled"));
|
fence.setBottomHeight(rs.getString("bottom_height"));
|
fence.setTopHeight(rs.getString("top_height"));
|
fence.setGatheringRadius(rs.getString("gathering_radius"));
|
fence.setGatheringTime(rs.getString("gathering_time"));
|
fence.setMaxPeople(rs.getString("max_people"));
|
fence.setMinPeople(rs.getString("min_people"));
|
fence.setHazardousMaterial(rs.getString("hazardous_material"));
|
fence.setMaxDuration(rs.getString("max_duration"));
|
fence.setMinDuration(rs.getString("min_duration"));
|
fence.setLatestInspectionTime(rs.getString("latest_inspection_time"));
|
fence.setInspectionOrder(rs.getString("inspection_order"));
|
fence.setInspectionCount(rs.getString("inspection_count"));
|
fence.setSides(rs.getString("sides"));
|
fence.setCanEnter(rs.getString("can_enter"));
|
fence.setCanExit(rs.getString("can_exit"));
|
fence.setConstraintType(rs.getString("constraint_type"));
|
fence.setConstraintDescription(rs.getString("constraint_description"));
|
fence.setCameraNumber(rs.getString("camera_number"));
|
fence.setAddedTime(rs.getString("added_time"));
|
fence.setCompany(rs.getString("company"));
|
fence.setReserved1(rs.getString("reserved1"));
|
fence.setReserved2(rs.getString("reserved2"));
|
fence.setReserved3(rs.getString("reserved3"));
|
fence.setReserved4(rs.getString("reserved4"));
|
fence.setReserved5(rs.getString("reserved5"));
|
fence.setReserved6(rs.getString("reserved6"));
|
fence.setReserved7(rs.getString("reserved7"));
|
fence.setReserved8(rs.getString("reserved8"));
|
fence.setReserved9(rs.getString("reserved9"));
|
fence.setReserved10(rs.getString("reserved10"));
|
return fence;
|
}
|
}
|
return null; // δÕÒµ½·µ»Ønull
|
}
|
|
// »ñÈ¡Ìض¨ÀàÐ͵ÄΧÀ¸Áбí
|
public static List<Fence> getFencesByType(String fenceType) throws SQLException {
|
List<Fence> fences = new ArrayList<>();
|
String sql = "SELECT * FROM fence WHERE fence_type = ?";
|
try (ResultSet rs = DBConnector.executeQuery(sql, fenceType)) {
|
while (rs.next()) {
|
Fence fence = new Fence();
|
fence.setId(rs.getString("id"));
|
fence.setFenceType(rs.getString("fence_type"));
|
fence.setFenceName(rs.getString("fence_name"));
|
fence.setRelatedDepartment(rs.getString("related_department"));
|
fence.setShape(rs.getString("shape"));
|
fence.setValidRangeXy(rs.getString("valid_range_xy"));
|
fence.setValidRangeCoordinates(rs.getString("valid_range_coordinates"));
|
fence.setEffectiveTime(rs.getString("effective_time"));
|
fence.setLayer(rs.getString("layer"));
|
fence.setExpirationTime(rs.getString("expiration_time"));
|
fence.setColor(rs.getString("color"));
|
fence.setIsEnabled(rs.getString("is_enabled"));
|
fence.setBottomHeight(rs.getString("bottom_height"));
|
fence.setTopHeight(rs.getString("top_height"));
|
fence.setGatheringRadius(rs.getString("gathering_radius"));
|
fence.setGatheringTime(rs.getString("gathering_time"));
|
fence.setMaxPeople(rs.getString("max_people"));
|
fence.setMinPeople(rs.getString("min_people"));
|
fence.setHazardousMaterial(rs.getString("hazardous_material"));
|
fence.setMaxDuration(rs.getString("max_duration"));
|
fence.setMinDuration(rs.getString("min_duration"));
|
fence.setLatestInspectionTime(rs.getString("latest_inspection_time"));
|
fence.setInspectionOrder(rs.getString("inspection_order"));
|
fence.setInspectionCount(rs.getString("inspection_count"));
|
fence.setSides(rs.getString("sides"));
|
fence.setCanEnter(rs.getString("can_enter"));
|
fence.setCanExit(rs.getString("can_exit"));
|
fence.setConstraintType(rs.getString("constraint_type"));
|
fence.setConstraintDescription(rs.getString("constraint_description"));
|
fence.setCameraNumber(rs.getString("camera_number"));
|
fence.setAddedTime(rs.getString("added_time"));
|
fence.setCompany(rs.getString("company"));
|
fences.add(fence);
|
}
|
}
|
return fences;
|
}
|
}
|
