• 动态查询.getStart.getBy.getAllBy
    • 支持 get10start2
    • 支持 getBy
    • 支持 getAllBy

    动态查询.getStart.getBy.getAllBy

    支持 get10start2

    1. # SELECT `test`.* FROM `test` LIMIT 0,10
    2. Db::table('test')->
    3. get10();
    4. # SELECT `test`.* FROM `test` LIMIT 3,10
    5. Db::table('test')->
    6. get10start3();

    支持 getBy

    1. # SELECT `test`.* FROM `test` WHERE `test`.`user_name` = '1111' LIMIT 1
    2. Db::table('test')->
    3. getByUserName('1111');
    4. # SELECT `test`.* FROM `test` WHERE `test`.`UserName` = '1111' LIMIT 1
    5. Db::table('test')->
    6. getByUserName_('1111');

    支持 getAllBy

    1. # SELECT `test`.* FROM `test` WHERE `test`.`user_name` = '1111' AND `test`.`sex` = '222'
    2. Db::table('test')->
    3. getAllByUserNameAndSex('1111', '222');
    4. # SELECT `test`.* FROM `test` WHERE `test`.`UserName` = '1111' AND `test`.`Sex` = '222'
    5. Db::table('test')->
    6. getAllByUserNameAndSex_('1111', '222');