亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

If you don’t use SQL, you can consider using the chain of responsibility model to get all the data and put it in the linkedlist.
Then write a filter to filter the content in the collection. Each condition can be equivalent to a filter

How big is your user table? Find out all of it.

The formal method is to use sql to check. . .

A more advanced approach should be to customize the domain-specific language and then convert it to sql. It is impossible to use xml filtering anyway.

I feel better about youcondition表沒什么用??？僅僅是存儲數(shù)據(jù)？如果臨時的直接用json傳過來就好了，如果你要持久存儲的話，起碼要個admin_id什么的，來標(biāo)記下是誰的篩選條件。感覺效率不如直接扔到redis.

See you are using Java, but I am used to using PHP, so I will briefly describe my idea using PHP...

Write oneFilter類處理condition轉(zhuǎn)換為sql.

class Filter {
    public function doFilter() {
        //1. 獲取登錄的admin_id
        //2. 獲取篩選條件
        /**
         * 數(shù)據(jù)格式例子為: [
         *    'field' => 'age';, 
         *    'type'  => 'compare',
         *    'ext'   => '>',
         *    'value' => '2'
         * ]
         */
        foreach($conditions as $condition) {
            // 根據(jù)type獲取對應(yīng)的$conditionHandle
            $conditionHandle::parse($condition);
        }
    }
}

// Condition接口
interface Condition {
    // 解析數(shù)據(jù)，返回sql片段和需要填充的數(shù)據(jù)（此處使用PDO預(yù)處理，減少SQL注入）
    static function parse($data);
}

// ConditionHandle
namespace Condition;
class Compare implements Condition {
    // 執(zhí)行流程
    public static function parse($data) {
        ...
        return [
            'sql' => 'age > ?',
            'params' => [ 2 ]
        ];
    }
}

Handwritten, please ignore grammatical errors...