下面列出了怎么用org.apache.ibatis.annotations.Update的API类实例代码及写法,或者点击链接到github查看源代码。
/**
* 更新降级点策略
*
* @param strategyDO
* @return
*/
@Update("<script> update point_strategy <set> " +
" sds_scheme_name = #{newSdsSchemeName}, status = #{status}, operator_name = #{operatorName}, "
+ "operator_email = #{operatorEmail} " +
"<if test='visitThreshold != null'> , visit_threshold = #{visitThreshold} </if> " +
"<if test='concurrentThreshold != null'> , concurrent_threshold = #{concurrentThreshold} </if> " +
"<if test='exceptionThreshold != null'> , exception_threshold = #{exceptionThreshold} </if> " +
"<if test='exceptionRateThreshold != null'> , exception_rate_threshold = #{exceptionRateThreshold} </if> " +
"<if test='exceptionRateStart != null'> , exception_rate_start = #{exceptionRateStart} </if> " +
"<if test='timeoutThreshold != null'> , timeout_threshold = #{timeoutThreshold} </if> " +
"<if test='timeoutCountThreshold != null'> , timeout_count_threshold = #{timeoutCountThreshold} </if> " +
"<if test='tokenBucketGeneratedTokensInSecond != null'> , token_bucket_generated_tokens_in_second = "
+ "#{tokenBucketGeneratedTokensInSecond} </if> " +
"<if test='tokenBucketSize != null'> , token_bucket_size = #{tokenBucketSize} </if> " +
"<if test='delayTime != null'> , delay_time = #{delayTime} </if> " +
"<if test='retryInterval != null'> , retry_interval = #{retryInterval} </if> " +
"<if test='downgradeRate != null'> , downgrade_rate = #{downgradeRate} </if> " +
"<if test='pressureTestDowngrade != null'> , pressure_test_downgrade = #{pressureTestDowngrade} </if> " +
" </set> " +
" where app_group_name = #{appGroupName}" +
" and app_name = #{appName}" +
" and point = #{point}" +
" and sds_scheme_name = #{sdsSchemeName}" +
" </script>")
int updatePointStrategy(PointStrategyDO strategyDO);
@Update("UPDATE configurationApplications " +
"SET applicationId=#{newAppId}, applicationVersionId=#{newAppVerId} " +
"WHERE applicationId=#{appId} AND applicationVersionId=#{appVerId}")
void changeConfigurationsApplication(@Param("appId") Integer oldAppId,
@Param("appVerId") Integer oldAppVerId,
@Param("newAppId") Integer newAppId,
@Param("newAppVerId") Integer newAppVerId);
@Update("UPDATE applications " +
"SET latestVersion = (" +
" SELECT id " +
" FROM applicationVersions apv1 " +
" WHERE apv1.applicationId = applications.id " +
" AND mdm_app_version_comparison_index(apv1.version) = " +
" (SELECT MAX(mdm_app_version_comparison_index(apv2.version)) " +
" FROM applicationVersions apv2 " +
" WHERE apv2.applicationId = applications.id) " +
" LIMIT 1) " +
"WHERE id = #{id}")
void recalculateLatestVersion(@Param("id") Integer applicationId);
@Update("UPDATE configurationApplications " +
"SET applicationVersionId = #{newId} " +
"WHERE applicationId = #{appId} " +
"AND action <> 2 " +
"AND EXISTS (SELECT 1 " +
" FROM configurations " +
" WHERE configurations.id = configurationApplications.configurationId " +
" AND configurations.autoUpdate IS TRUE)")
int autoUpdateConfigurationsApplication(@Param("appId") Integer applicationId,
@Param("newId") Integer newAppVersionId);
@Update("UPDATE configurations " +
"SET mainAppId = #{newId} " +
"WHERE configurations.autoUpdate IS TRUE " +
"AND EXISTS (SELECT 1 FROM applicationVersions " +
" WHERE applicationVersions.id = configurations.mainAppId" +
" AND applicationVersions.applicationId = #{appId})")
int autoUpdateConfigurationsMainApplication(@Param("appId") Integer applicationId,
@Param("newId") Integer newAppVersionId);
@Update("UPDATE configurations " +
"SET mainAppId = (" +
" SELECT ca.applicationVersionId " +
" FROM configurationApplications ca " +
" INNER JOIN applications apps ON apps.id = ca.applicationId " +
" WHERE ca.configurationId = configurations.id " +
" AND ca.action = 1 " +
" AND apps.pkg = (SELECT apps2.pkg " +
" FROM applicationVersions av " +
" INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
" WHERE av.id = configurations.mainAppId)" +
") " +
"WHERE configurations.customerId = #{customerId} " +
"AND NOT configurations.mainAppId IS NULL")
int recheckConfigurationMainApplications(@Param("customerId") Integer customerId);
@Update("UPDATE configurations " +
"SET mainAppId = (" +
" SELECT ca.applicationVersionId " +
" FROM configurationApplications ca " +
" INNER JOIN applications apps ON apps.id = ca.applicationId " +
" WHERE ca.configurationId = configurations.id " +
" AND ca.action = 1 " +
" AND apps.pkg = (SELECT apps2.pkg " +
" FROM applicationVersions av " +
" INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
" WHERE av.id = configurations.mainAppId)" +
") " +
"WHERE configurations.id = #{configurationId} " +
"AND NOT configurations.mainAppId IS NULL")
int recheckConfigurationMainApplication(@Param("configurationId") Integer configurationId);
@Update("UPDATE configurations " +
"SET contentAppId = (" +
" SELECT ca.applicationVersionId " +
" FROM configurationApplications ca " +
" INNER JOIN applications apps ON apps.id = ca.applicationId " +
" WHERE ca.configurationId = configurations.id " +
" AND ca.action = 1 " +
" AND apps.pkg = (SELECT apps2.pkg " +
" FROM applicationVersions av " +
" INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
" WHERE av.id = configurations.contentAppId)" +
") " +
"WHERE configurations.customerId = #{customerId} " +
"AND NOT configurations.contentAppId IS NULL")
int recheckConfigurationContentApplications(@Param("customerId") Integer customerId);
@Update("UPDATE configurations " +
"SET contentAppId = (" +
" SELECT ca.applicationVersionId " +
" FROM configurationApplications ca " +
" INNER JOIN applications apps ON apps.id = ca.applicationId " +
" WHERE ca.configurationId = configurations.id " +
" AND ca.action = 1 " +
" AND apps.pkg = (SELECT apps2.pkg " +
" FROM applicationVersions av " +
" INNER JOIN applications apps2 ON apps2.id = av.applicationId " +
" WHERE av.id = configurations.contentAppId)" +
") " +
"WHERE configurations.id = #{configurationId} " +
"AND NOT configurations.contentAppId IS NULL")
int recheckConfigurationContentApplication(@Param("configurationId") Integer configurationId);
@Update("UPDATE configurations " +
"SET contentAppId = #{newId} " +
"WHERE configurations.autoUpdate IS TRUE " +
"AND EXISTS (SELECT 1 FROM applicationVersions " +
" WHERE applicationVersions.id = configurations.contentAppId" +
" AND applicationVersions.applicationId = #{appId})")
int autoUpdateConfigurationsContentApplication(@Param("appId") Integer applicationId,
@Param("newId") Integer newAppVersionId);
@Update("INSERT INTO deviceStatuses (deviceId, configFilesStatus, applicationsStatus) " +
"VALUES (#{deviceId}, #{filesStatus}, #{appsStatus})" +
"ON CONFLICT ON CONSTRAINT deviceStatuses_pr_key DO " +
"UPDATE SET configFilesStatus = EXCLUDED.configFilesStatus, applicationsStatus = EXCLUDED.applicationsStatus")
int updateDeviceStatuses(@Param("deviceId") Integer deviceId,
@Param("filesStatus") DeviceConfigFilesStatus deviceConfigFilesStatus,
@Param("appsStatus") DeviceApplicationsStatus deviceApplicatiosStatus);
@Update({"UPDATE configurations SET " +
"name=#{name}, " +
"description=#{description}, " +
"password=#{password}, " +
"backgroundColor=#{backgroundColor}, " +
"textColor=#{textColor}, " +
"backgroundImageUrl=#{backgroundImageUrl}, " +
"iconSize=#{iconSize}, " +
"desktopHeader=#{desktopHeader}, " +
"requestUpdates=#{requestUpdates}, " +
"pushOptions=#{pushOptions}, " +
"autoBrightness=#{autoBrightness}, " +
"brightness=#{brightness}, " +
"manageTimeout=#{manageTimeout}, " +
"timeout=#{timeout}, " +
"lockVolume=#{lockVolume}, " +
"passwordMode=#{passwordMode}, " +
"useDefaultDesignSettings=#{useDefaultDesignSettings}, " +
"gps=#{gps}, " +
"bluetooth=#{bluetooth}, " +
"wifi=#{wifi}, " +
"mobileData=#{mobileData}, " +
"usbStorage=#{usbStorage}, " +
"mainAppId=#{mainAppId}, " +
"contentAppId=#{contentAppId}, " +
"eventReceivingComponent=#{eventReceivingComponent}, " +
"kioskMode=#{kioskMode}, " +
"wifiSSID=#{wifiSSID}, " +
"wifiPassword=#{wifiPassword}, " +
"wifiSecurityType=#{wifiSecurityType}, " +
"autoUpdate=#{autoUpdate}, " +
"blockStatusBar=#{blockStatusBar}, " +
"systemUpdateType=#{systemUpdateType}, " +
"systemUpdateFrom=#{systemUpdateFrom}, " +
"systemUpdateTo=#{systemUpdateTo} " +
"WHERE id=#{id}"})
void updateConfiguration(Configuration configuration);
@Update("UPDATE plugin_devicelog_settings_rules SET " +
" settingId = #{settingId}, " +
" name = #{name}, " +
" active = #{active}, " +
" applicationId = #{applicationId}, " +
" severity = #{severity}, " +
" filter = #{filter}, " +
" groupId = #{groupId}, " +
" configurationId = #{configurationId} " +
"WHERE id = #{id}")
void updatePluginSettingsRule(PostgresDeviceLogRule rule);
@Update("update user set name=#{name},age=#{age} where id=#{id}")
//void updataById(@Param("id")String id,@Param("name")String name);
// void updataById(@Param("id")String id,@Param("name")String name);
int updateById(User user);
@Update("update user set name=#{name},age=#{age} where id=#{id}")
//void updataById(@Param("id")String id,@Param("name")String name);
// void updataById(@Param("id")String id,@Param("name")String name);
int updateById(User user);
@Update("update store_coupon set use_num=use_num+1 where id=#{id}")
void incUserNum(int id);
@Update("update store_member set user_money=user_money-#{money} where id=#{userId}")
int decUserMony(@Param("userId") int userId,@Param("money") double money);
@Update("update store_spec_goods_price set store_count=store_count-#{goodsNum} " +
"where goods_id=#{goodsId} and `key`=#{specKey}")
int decCount(@Param("goodsId") int goodsId,
@Param("specKey") String specKey,@Param("goodsNum") int goodsNum);
@Update("update sys_permission t set t.name = #{name}, t.permission = #{permission}, t.updateTime = #{updateTime} where t.id = #{id}")
int updateByOps(SysPermission sysPermission);
@Update("update sys_role t set t.name = #{name} ,t.updateTime = #{updateTime} where t.id = #{id}")
int updateByOps(SysRole sysRole);
@Update("update oauth_client_details t set t.client_secret = #{clientSecret},t.client_secret_str = #{clientSecretStr} where t.id = #{id}")
int update(Client client);
@Update("update student set name = #{name}, age = #{age} where id = #{id}")
int update(@Param("name") String name, @Param("age") Integer age, @Param("id") Integer id);
@Update("update sys_permission t set t.name = #{name}, t.permission = #{permission}, t.updateTime = #{updateTime} where t.id = #{id}")
int update(SysPermission sysPermission);
@Update("update sys_role t set t.name = #{name} ,t.updateTime = #{updateTime} where t.id = #{id}")
int update(SysRole sysRole);
@Update("update t_dict_data set is_deleted=1 where dict_code=#{dictCode} ")
void batchDeleteDictDataByDictCode(@Param("dictCode") String dictCode);
@Update("update stock set real_stock=real_stock-#{count} where prod_id = #{productId}")
Long deductionStock(@Param("productId") Long productId,@Param("count") int count);
@Update({"UPDATE customers SET name=#{name}, description=#{description} WHERE id=#{id} AND master = FALSE"})
void update(Customer customer);
@Update("UPDATE customers SET lastLoginTime = #{time} WHERE id = #{id}")
int recordLastLoginTime(@Param("id") int customerId, @Param("time") long time);
@Update({"UPDATE applications SET name=#{name}, pkg=#{pkg}, " +
"showIcon=#{showIcon}, system=#{system}, customerId=#{customerId}, runAfterInstall = #{runAfterInstall}, runAtBoot = #{runAtBoot}, " +
"type = #{type}, iconText = #{iconText}, iconId = #{iconId} " +
"WHERE id=#{id}"})
void updateApplication(Application application);
@Update({"UPDATE applicationVersions SET version = #{version}, url = #{url}, apkHash = #{apkHash} " +
"WHERE id=#{id}"})
void updateApplicationVersion(ApplicationVersion applicationVersion);