public class DynamicQueryCondition {
    private Operator operator;
    private String field;
    private Object value;
    private LogicalOperator logicalOperator;
    
    // 省略getter和setter方法
}

public String buildDynamicQuery(List<DynamicQueryCondition> conditions) {
    StringBuilder sb = new StringBuilder();
    
    for (int i = 0; i < conditions.size(); i++) {
        DynamicQueryCondition condition = conditions.get(i);
        
        // 拼接字段名和操作符
        sb.append(condition.getField())
          .append(" ")
          .append(condition.getOperator().getValue())
          .append(" ");
        
        // 拼接值
        sb.append(condition.getValue());
        
        // 處理邏輯運(yùn)算符
        if (i < conditions.size() - 1) {
            sb.append(" ")
              .append(condition.getLogicalOperator().getValue())
              .append(" ");
        }
    }
    
    return sb.toString();
}

public List<User> executeDynamicQuery(List<DynamicQueryCondition> conditions) {
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    
    try {
        // 獲取數(shù)據(jù)庫連接
        conn = DriverManager.getConnection(url, username, password);
        
        // 構(gòu)建動(dòng)態(tài)查詢語句
        String sql = buildDynamicQuery(conditions);
        
        // 創(chuàng)建PreparedStatement對象，并設(shè)置參數(shù)
        pstmt = conn.prepareStatement(sql);
        int index = 1;
        for (DynamicQueryCondition condition : conditions) {
            pstmt.setObject(index++, condition.getValue());
        }
        
        // 執(zhí)行查詢
        rs = pstmt.executeQuery();
        
        // 處理結(jié)果集
        List<User> users = new ArrayList<>();
        while (rs.next()) {
            User user = new User();
            // 從結(jié)果集中獲取數(shù)據(jù)并設(shè)置到User對象中
            // ...
            users.add(user);
        }
        
        return users;
    } catch (SQLException e) {
        // 處理異常
    } finally {
        // 關(guān)閉資源
        // ...
    }
    
    return null;
}