From 981107bb993776ed20dfa2173948b8eae6ae989b Mon Sep 17 00:00:00 2001 From: shicf <shi_chongfu@163.com> Date: 星期日, 13 七月 2025 13:52:59 +0800 Subject: [PATCH] 版本升级 --- src/main/java/com/product/mobile/app/service/AppAdminService.java | 11 ++++++++--- 1 files changed, 8 insertions(+), 3 deletions(-) diff --git a/src/main/java/com/product/mobile/app/service/AppAdminService.java b/src/main/java/com/product/mobile/app/service/AppAdminService.java index 74c3a46..1f004e1 100644 --- a/src/main/java/com/product/mobile/app/service/AppAdminService.java +++ b/src/main/java/com/product/mobile/app/service/AppAdminService.java @@ -29,9 +29,14 @@ * @throws BaseException */ public FieldSetEntity checkVersion(String version) throws BaseException{ - String filter="version>?"; - DataTableEntity dt =baseDao.listTable(MobileCoreConst.TABLE_APP_MANAGER, filter, new String[] {version},"version"); - + String s[]=version.split("\\."); + String sql="select * from (\r\n" + + "SELECT *,\r\n" + + "SUBSTRING_INDEX(version,'.', 1) a,\r\n" + + "SUBSTRING_INDEX(SUBSTRING_INDEX(version,'.', 2),'.', -1) b,\r\n" + + "SUBSTRING_INDEX(version,'.', -1) c\r\n" + + "FROM product_sys_app_version ) b where a>? or b>? or c>? order by a desc ,b desc ,c desc"; + DataTableEntity dt =baseDao.listTable(sql, s); FieldSetEntity fs=new FieldSetEntity(); fs.setTableName(MobileCoreConst.TABLE_APP_MANAGER); if(DataTableEntity.isEmpty(dt)) { -- Gitblit v1.9.2