| | |
|---|
| | | |
|---|
| | | |
|---|
| | | public Config selectByKey(String key, Long systemId, int maxVersion) { |
|---|
| | | List list = sqlList(" SELECT a.* FROM (SELECT * FROM `wk_video_config` vc WHERE vc,`key`=? and vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", key, systemId, maxVersion); |
|---|
| | | List list = sqlListWithEntity("SELECT a.* FROM (SELECT * FROM `wk_video_config` vc where vc.`key`=? and vc.`systemId`=? AND vc.`minVersion`<=? ORDER BY vc.`minVersion` DESC) a GROUP BY a.`systemId`,a.`key`", Config.class, key, systemId, maxVersion); |
|---|
| | | if (list != null && list.size() > 0) |
|---|
| | | return (Config) list.get(0); |
|---|
| | | return null; |
|---|
