首页 \ 问答 \ 复杂更新Sql语句(Complex Update Sql Statement)

复杂更新Sql语句(Complex Update Sql Statement)

我有两个表,一个表有一个id和一个username名表的名称是user 。 我有另一个名为value表,表有一个id ,用于存储来自user表的id。 表value还有一个名为value的列和item_id ,用于存储项目。

我想写一个update语句来更新value id, value, item_id中的以下列id, value, item_id但是我必须执行语句的值是username = $username, value = $value and item_id=$item_id (基于应用程序)

如何编写存储id (用户名id), valueitem_id的更新语句

使用更新语句的原因是因为该用户可以随时更改value列中的value


I have two tables one table has an id and a username the name of the table is user. I have another table called value that table has an id which is to store the id from the user table. The table valuealso has a column called value and item_id which is used to store the item.

I want to write an update statement that updates the following columns within value id, value, item_id however the values I have to execute the statement is username = $username, value = $value and item_id=$item_id (based on the application)

How can I write an update statement that stores the id (username id), value and item_id

The reason for using an update statement is because that user can change the value within the value column at any time


原文:https://stackoverflow.com/questions/17094268
更新时间:2022-02-15 22:02

最满意答案

我找到了一个解决方案,但我不确定为什么这会产生问题。 如果您知道为什么会这样,请发布您的答案。

问题是@EnableWebMvc注释

@Configuration
// @EnableWebMvc
@Import(MyServiceConfiguration.class)
    public class MyRestServiceConfiguration {

}

删除后,一切正常。

从Spring Boot指南:

通常你会为Spring MVC应用程序添加@EnableWebMvc,但Spring Boot会在类路径上看到spring-webmvc时自动添加它。 这会将应用程序标记为Web应用程序并激活关键行为,例如设置DispatcherServlet。

很明显, @EnableWebMvc注释,但为什么会出现问题呢?

编辑:

从Spring Boot参考:

完全控制MVC配置的最简单方法是使用@EnableWebMvc注释提供您自己的@Configuration。 这将使所有MVC配置保留在您的手中。

来自Spring的@EnableWebMvc文档:

将此批注添加到@Configuration类可从WebMvcConfigurationSupport导入Spring MVC配置,例如:

 @Configuration
 @EnableWebMvc
 @ComponentScan(basePackageClasses = { MyConfiguration.class })
 public class MyWebConfiguration {

 }

所以,问题是@EnableWebMvc注释无法解决Spring Boot的默认配置,因为Spring不知道在哪里寻找静态资源。 如果我出错了,请纠正我。


I have found a solution, but I am not really sure why this makes problem. Please post your answer if you know why is this happening.

The problem was @EnableWebMvc annotation in MyRestServiceConfiguration

@Configuration
// @EnableWebMvc
@Import(MyServiceConfiguration.class)
    public class MyRestServiceConfiguration {

}

After removing it, everything works as it should.

From Spring Boot guide:

Normally you would add @EnableWebMvc for a Spring MVC app, but Spring Boot adds it automatically when it sees spring-webmvc on the classpath. This flags the application as a web application and activates key behaviors such as setting up a DispatcherServlet.

It's clear that @EnableWebMvc annotation is not needed, but why does it make problems?

EDIT:

From Spring Boot reference:

The easiest way to take complete control over MVC configuration is to provide your own @Configuration with the @EnableWebMvc annotation. This will leave all MVC configuration in your hands.

From Spring's @EnableWebMvc documentation:

Adding this annotation to an @Configuration class imports the Spring MVC configuration from WebMvcConfigurationSupport, e.g.:

 @Configuration
 @EnableWebMvc
 @ComponentScan(basePackageClasses = { MyConfiguration.class })
 public class MyWebConfiguration {

 }

So, the problem was that @EnableWebMvc annotation dissabled default Spring Boot's configuration and because of that Spring didn't know where to look for static resources. If I got something wrong, please correct me.

相关问答

更多

相关文章

更多

最新问答

更多
  • 如何在Laravel 5.2中使用paginate与关系?(How to use paginate with relationships in Laravel 5.2?)
  • linux的常用命令干什么用的
  • 由于有四个新控制器,Auth刀片是否有任何变化?(Are there any changes in Auth blades due to four new controllers?)
  • 如何交换返回集中的行?(How to swap rows in a return set?)
  • 在ios 7中的UITableView部分周围绘制边界线(draw borderline around UITableView section in ios 7)
  • 使用Boost.Spirit Qi和Lex时的空白队长(Whitespace skipper when using Boost.Spirit Qi and Lex)
  • Java中的不可变类(Immutable class in Java)
  • WordPress发布查询(WordPress post query)
  • 如何在关系数据库中存储与IPv6兼容的地址(How to store IPv6-compatible address in a relational database)
  • 是否可以检查对象值的条件并返回密钥?(Is it possible to check the condition of a value of an object and JUST return the key?)
  • GEP分段错误LLVM C ++ API(GEP segmentation fault LLVM C++ API)
  • 绑定属性设置器未被调用(Bound Property Setter not getting Called)
  • linux ubuntu14.04版没有那个文件或目录
  • 如何使用JSF EL表达式在param中迭代变量(How to iterate over variable in param using JSF EL expression)
  • 是否有可能在WPF中的一个单独的进程中隔离一些控件?(Is it possible to isolate some controls in a separate process in WPF?)
  • 使用Python 2.7的MSI安装的默认安装目录是什么?(What is the default installation directory with an MSI install of Python 2.7?)
  • 寻求多次出现的表达式(Seeking for more than one occurrence of an expression)
  • ckeditor config.protectedSource不适用于editor.insertHtml上的html元素属性(ckeditor config.protectedSource dont work for html element attributes on editor.insertHtml)
  • linux只知道文件名,不知道在哪个目录,怎么找到文件所在目录
  • Actionscript:检查字符串是否包含域或子域(Actionscript: check if string contains domain or subdomain)
  • 将CouchDB与AJAX一起使用是否安全?(Is it safe to use CouchDB with AJAX?)
  • 懒惰地初始化AutoMapper(Lazily initializing AutoMapper)
  • 使用hasclass为多个div与一个按钮问题(using hasclass for multiple divs with one button Problems)
  • Windows Phone 7:检查资源是否存在(Windows Phone 7: Check If Resource Exists)
  • 无法在新线程中从FREContext调用getActivity()?(Can't call getActivity() from FREContext in a new thread?)
  • 在Alpine上升级到postgres96(/ usr / bin / pg_dump:没有这样的文件或目录)(Upgrade to postgres96 on Alpine (/usr/bin/pg_dump: No such file or directory))
  • 如何按部门显示报告(How to display a report by Department wise)
  • Facebook墙贴在需要访问令牌密钥后无法正常工作(Facebook wall post not working after access token key required)
  • Javascript - 如何在不擦除输入的情况下更改标签的innerText(Javascript - how to change innerText of label while not wiping out the input)
  • WooCommerce / WordPress - 不显示具有特定标题的产品(WooCommerce/WordPress - Products with specific titles are not displayed)