当前位置： 文江博客话题详情

百里叶＆＃x2B;春季保存新对象而不是更新

发布于 2025-01-26 23:37:51 字数 14762 浏览 1 评论 0原文

我要提示。我搜索了很长一段时间以解决这个问题，但我已经绝望了。我希望更新操作在表中更新记录，而不是编写新的记录。对不起，我的代码是初学者。

这是我的代码：

  @Entity
public class Job {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;

    @NotEmpty(message = "You must enter the title.")
    @Size(min=2, max = 30, message = "You must add a description with length beetwen 2 and 30 letters.")
    @Column(name = "title")
    private String title;

    @NotEmpty(message = "You must enter the description.")
    @Size(min=10, max = 150, message = "You must add a description with length beetwen 10 and 150 letters.")
    @Column(name = "description")
    private String description;

    @NotEmpty(message = "You must select profession")
    @Column(name = "profession")
    private String profession;

    @NotEmpty(message = "You must select status")
    @Column(name = "status")
    private String status;

    @NotEmpty(message = "You must select location")
    @Column(name = "location")
    private String location;

    @CreationTimestamp
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "publishDate")
    private Date publishDate;
  • getters设置器和构造仪

服务层：

@Service
public class JobServiceImpl implements JobService {

    @Autowired
    private JobRepository repository;

    @Override
    public Job saveJob(Job job) {

        return repository.save(job);
    }


    @Override
    public Job getJobById(Long id) throws JobNotFoundException {

        Optional<Job> optional = repository.findById(id);

        if (optional.isPresent()) {
            return optional.get();
        } else {
            throw new JobNotFoundException("Job with id: " + id + " not found ");
        }

    }

    @Override
    public void deleteJobById(Long id) throws JobNotFoundException {
        repository.delete(getJobById(id));

    }

    @Override
    public void updateJob(Job job) {

        repository.save(job);
    }

控制器方法：

@GetMapping("/edit")
    public String getEditPage(Model model, RedirectAttributes attributes, @RequestParam Long id) {
        String page = null;
        initModel(model);
        try {
            Job job = service.getJobById(id);
            model.addAttribute("job", job);
            page = "editJobPage";
        } catch (JobNotFoundException e) {
            e.printStackTrace();
            attributes.addAttribute("message", e.getMessage());
            page = "redirect:getAllJobs";
        }
        return page;
    }

    @PostMapping("/edit")
    public String updateJob(@ModelAttribute Job job, Model model, RedirectAttributes attributes) {
        initModel(model);
        service.updateJob(job);
        Long id = job.getId();
        attributes.addAttribute("message", "Job advertisement with id: '" + id + "' is updated successfully !");
        return "redirect:getAllJobs";
    }

和查看层：

<html xmlns:th="https://www.thymeleaf.org">
<head>
<link rel="stylesheet"
    href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" />
<script
    src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
<link rel="stylesheet"
    href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css" />
</head>
<body>
    <div class="col-md-12">
        <div class="container">

            <div class="card">
                <div class="card-header text-center text-black">
                    <h3>Edit advertisement</h3>
                </div>
                <div class="card-body">
                    <form action="/job/edit" th:action="@{/job/edit}" th:object="${job}"
                        method="POST" id="editJobPage">
                        <div class="row">
                            <div class="col-2">
                                <label for="title"><b>Title</b></label>
                                
                            </div>
                            <div class="col-6">
                                <input type="text" class="form-control"
                                    name="title" th:field="*{title}"><br />
                            
                            </div>
                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="location"><b>Location</b></label>
                            </div>
                            <select id="location" name="location">
                                <option value="" disabled selected>Select location</option>
                                <option th:each="location : ${locationsList}"
                                    th:text="${location}" />
                            </select> 
                            

                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="description"><b>Description</b></label>
                            </div>
                            <div class="col-6">
                                <textarea class="form-control" rows="3" 
                                     name="description"
                                    th:field="*{description}"></textarea>
                                <br />
                    
                            </div>
                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="profession"><b>Profession</b></label>
                            </div>
                            <select name="profession">
                                <option value="" disabled selected>Select profession</option>
                                <option th:each="profession : ${professionsList}"
                                    th:text="${profession}" />

                            </select>
                    

                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="status"><b>Status</b></label>
                            </div>
                            <select name="status">
                                <option value="" disabled selected>Select status</option>
                                <option th:each="status : ${statusList}" th:text="${status}" />

                            </select>
                    

                        </div>
                        <br />

                        <button type="submit" class="btn btn-success">
                            Update Advertisement <i class="fa fa-plus-square"
                                aria-hidden="true"></i>
                        </button>
                        
                    </form>
                </div>
                <div th:if="${message!=null}" class="card-footer bg-white text-info">
                    <span th:text="${message}"></span>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

新错误：

2022-05-07 15:51:48.027 DEBUG 29284 --- [nio-8080-exec-7] org.hibernate.SQL                        : select job0_.id as id1_0_0_, job0_.description as descript2_0_0_, job0_.location as location3_0_0_, job0_.profession as professi4_0_0_, job0_.publish_date as publish_5_0_0_, job0_.status as status6_0_0_, job0_.title as title7_0_0_ from job job0_ where job0_.id=?
2022-05-07 15:51:48.027 TRACE 29284 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [0]
com.example.job.advertisements.web.app.exceptionHandler.JobNotFoundException: Job with id: 0 not found 
    at com.example.job.advertisements.web.app.service.JobServiceImpl.getJobById(JobServiceImpl.java:39)
    at com.example.job.advertisements.web.app.service.JobServiceImpl.updateJob(JobServiceImpl.java:53)
    at com.example.job.advertisements.web.app.controller.JobController.updateJob(JobController.java:132)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.servlet.resource.ResourceUrlEncodingFilter.doFilter(ResourceUrlEncodingFilter.java:67)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.base/java.lang.Thread.run(Thread.java:829)
2022-05-07 15:51:48.049 DEBUG 29284 --- [nio-8080-exec-8] org.hibernate.SQL                        : select job0_.id as id1_0_, job0_.description as descript2_0_, job0_.location as location3_0_, job0_.profession as professi4_0_, job0_.publish_date as publish_5_0_, job0_.status as status6_0_, job0_.title as title7_0_ from job job0_
2022-05-07 15:51:48.050 TRACE 29284 --- [nio-8080-exec-8] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([id1_0_] : [BIGINT]) - [1]
原文

I am asking for a hint. I searched the internet for a long time for a solution to the problem, but I'm already desperate. I would like the update operation to update a record in the table instead of writing a new one. Sorry for my code i am a beginner.

It is my code:

  @Entity
public class Job {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;

    @NotEmpty(message = "You must enter the title.")
    @Size(min=2, max = 30, message = "You must add a description with length beetwen 2 and 30 letters.")
    @Column(name = "title")
    private String title;

    @NotEmpty(message = "You must enter the description.")
    @Size(min=10, max = 150, message = "You must add a description with length beetwen 10 and 150 letters.")
    @Column(name = "description")
    private String description;

    @NotEmpty(message = "You must select profession")
    @Column(name = "profession")
    private String profession;

    @NotEmpty(message = "You must select status")
    @Column(name = "status")
    private String status;

    @NotEmpty(message = "You must select location")
    @Column(name = "location")
    private String location;

    @CreationTimestamp
    @Temporal(TemporalType.TIMESTAMP)
    @Column(name = "publishDate")
    private Date publishDate;
  • getters setters and constructors

service layer:

@Service
public class JobServiceImpl implements JobService {

    @Autowired
    private JobRepository repository;

    @Override
    public Job saveJob(Job job) {

        return repository.save(job);
    }


    @Override
    public Job getJobById(Long id) throws JobNotFoundException {

        Optional<Job> optional = repository.findById(id);

        if (optional.isPresent()) {
            return optional.get();
        } else {
            throw new JobNotFoundException("Job with id: " + id + " not found ");
        }

    }

    @Override
    public void deleteJobById(Long id) throws JobNotFoundException {
        repository.delete(getJobById(id));

    }

    @Override
    public void updateJob(Job job) {

        repository.save(job);
    }

controller methods :

@GetMapping("/edit")
    public String getEditPage(Model model, RedirectAttributes attributes, @RequestParam Long id) {
        String page = null;
        initModel(model);
        try {
            Job job = service.getJobById(id);
            model.addAttribute("job", job);
            page = "editJobPage";
        } catch (JobNotFoundException e) {
            e.printStackTrace();
            attributes.addAttribute("message", e.getMessage());
            page = "redirect:getAllJobs";
        }
        return page;
    }

    @PostMapping("/edit")
    public String updateJob(@ModelAttribute Job job, Model model, RedirectAttributes attributes) {
        initModel(model);
        service.updateJob(job);
        Long id = job.getId();
        attributes.addAttribute("message", "Job advertisement with id: '" + id + "' is updated successfully !");
        return "redirect:getAllJobs";
    }

and view layer:

<html xmlns:th="https://www.thymeleaf.org">
<head>
<link rel="stylesheet"
    href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" />
<script
    src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script>
<link rel="stylesheet"
    href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css" />
</head>
<body>
    <div class="col-md-12">
        <div class="container">

            <div class="card">
                <div class="card-header text-center text-black">
                    <h3>Edit advertisement</h3>
                </div>
                <div class="card-body">
                    <form action="/job/edit" th:action="@{/job/edit}" th:object="${job}"
                        method="POST" id="editJobPage">
                        <div class="row">
                            <div class="col-2">
                                <label for="title"><b>Title</b></label>
                                
                            </div>
                            <div class="col-6">
                                <input type="text" class="form-control"
                                    name="title" th:field="*{title}"><br />
                            
                            </div>
                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="location"><b>Location</b></label>
                            </div>
                            <select id="location" name="location">
                                <option value="" disabled selected>Select location</option>
                                <option th:each="location : ${locationsList}"
                                    th:text="${location}" />
                            </select> 
                            

                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="description"><b>Description</b></label>
                            </div>
                            <div class="col-6">
                                <textarea class="form-control" rows="3" 
                                     name="description"
                                    th:field="*{description}"></textarea>
                                <br />
                    
                            </div>
                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="profession"><b>Profession</b></label>
                            </div>
                            <select name="profession">
                                <option value="" disabled selected>Select profession</option>
                                <option th:each="profession : ${professionsList}"
                                    th:text="${profession}" />

                            </select>
                    

                        </div>
                        <br />
                        <div class="row">
                            <div class="col-2">
                                <label for="status"><b>Status</b></label>
                            </div>
                            <select name="status">
                                <option value="" disabled selected>Select status</option>
                                <option th:each="status : ${statusList}" th:text="${status}" />

                            </select>
                    

                        </div>
                        <br />

                        <button type="submit" class="btn btn-success">
                            Update Advertisement <i class="fa fa-plus-square"
                                aria-hidden="true"></i>
                        </button>
                        
                    </form>
                </div>
                <div th:if="${message!=null}" class="card-footer bg-white text-info">
                    <span th:text="${message}"></span>
                </div>
            </div>
        </div>
    </div>
</body>
</html>

New error :

2022-05-07 15:51:48.027 DEBUG 29284 --- [nio-8080-exec-7] org.hibernate.SQL                        : select job0_.id as id1_0_0_, job0_.description as descript2_0_0_, job0_.location as location3_0_0_, job0_.profession as professi4_0_0_, job0_.publish_date as publish_5_0_0_, job0_.status as status6_0_0_, job0_.title as title7_0_0_ from job job0_ where job0_.id=?
2022-05-07 15:51:48.027 TRACE 29284 --- [nio-8080-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [0]
com.example.job.advertisements.web.app.exceptionHandler.JobNotFoundException: Job with id: 0 not found 
    at com.example.job.advertisements.web.app.service.JobServiceImpl.getJobById(JobServiceImpl.java:39)
    at com.example.job.advertisements.web.app.service.JobServiceImpl.updateJob(JobServiceImpl.java:53)
    at com.example.job.advertisements.web.app.controller.JobController.updateJob(JobController.java:132)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.servlet.resource.ResourceUrlEncodingFilter.doFilter(ResourceUrlEncodingFilter.java:67)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.base/java.lang.Thread.run(Thread.java:829)
2022-05-07 15:51:48.049 DEBUG 29284 --- [nio-8080-exec-8] org.hibernate.SQL                        : select job0_.id as id1_0_, job0_.description as descript2_0_, job0_.location as location3_0_, job0_.profession as professi4_0_, job0_.publish_date as publish_5_0_, job0_.status as status6_0_, job0_.title as title7_0_ from job job0_
2022-05-07 15:51:48.050 TRACE 29284 --- [nio-8080-exec-8] o.h.type.descriptor.sql.BasicExtractor   : extracted value ([id1_0_] : [BIGINT]) - [1]

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（2）

不回头走下去 2025-02-02 23:37:51

做到这一点的一种方法是首先获取与存储库中的作业参数匹配的作业，然后在保存（更新（更新）到数据库之前对其进行必要的更改。

@Override
public void updateJob(Job job) {
    //I assume  job.getId() returns an integer here, otherwise use another field that uniquely identifies a job
    Job dbJob = getJobById(job.getId());
    if(dbJob != null){
      
       dbJob.setStatus(job.getStatus());
       dbJob.setTitle(job.getTitle());
       //set all the other fields except id
       
     repository.save(dbJob);//this updates an existing job record
    }else{
      repository.save(job);//this inserts a new job 
    }
   
}

更新：该错误是由您的方法getJobbyId丢弃的。当然，您可以更改该方法，以便每当在存储库中找到记录时返回null（而不是像现在这样抛出异常）。请注意，在这种情况下，作业ID为0，并且在存储库中没有该ID（0）的记录。如果您要更新记录，则必须提供数据库中已经存在的唯一ID（无论是ID还是其他）。我猜您尚未将Job.ID明确设置为0，而是ID初始化为其默认值，即0。

One way to do this is by first fetching the job that matches your job argument from the repository and then applying the necessary changes to it before saving (updating) it to the database.

@Override
public void updateJob(Job job) {
    //I assume  job.getId() returns an integer here, otherwise use another field that uniquely identifies a job
    Job dbJob = getJobById(job.getId());
    if(dbJob != null){
      
       dbJob.setStatus(job.getStatus());
       dbJob.setTitle(job.getTitle());
       //set all the other fields except id
       
     repository.save(dbJob);//this updates an existing job record
    }else{
      repository.save(job);//this inserts a new job 
    }
   
}

UPDATE: That error is thrown by your method getJobById. You can, of course, change that method so that it returns null whenever a record is not found in the repository (rather than throwing an exception as you're doing now). Note that the job id in this case is 0 and there exists no record in the repository with that id (0). If you're updating a record then you have to provide a unique id that already exists in the database (whether it's id or something else). I'm guessing you haven't set Job.id explicitly to 0 but rather id is initialized to its default value, which is 0.

回复 原文
情释 2025-02-02 23:37:51

您看到这一点的原因是因为您的持久性提供商（大概是Hibernate）不知道要更新哪个版本，因此它将其视为新对象。

在您的模型中，只需添加

@Version
private Long version;

以及您应该有效的工作即可。该版本现在将成为对象的一部分，当您的更新请求返回时，只要填充版本字段，Hibernate就会知道需要更新哪一行。

另外，您需要将ID和版本添加到您的视图层（它们可以是隐藏的字段），它们在您的视图中看起来像这样

<input type="hidden" name="id" th:field="*{id}">
<input type="hidden" name="version" th:field="*{version}">

The reason you're seeing this is because your persistence provider (presumably hibernate) doesn't know which version you want to update, so it treats it as a new object.

To your model, simply add

@Version
private Long version;

and what you have there should work. The version will be a part of the object now and when your request to update comes back in, provided the version field is populated, hibernate will know which row it needs to update.

Also, you'll need to add the id and version to your view layer (they can be hidden fields), they will look like this in your view

<input type="hidden" name="id" th:field="*{id}">
<input type="hidden" name="version" th:field="*{version}">
回复 原文
~没有更多了~

关于作者

水波映月

暂无简介

文章
评论
27 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

达拉崩吧

文章 0 评论 0

PANGOO

文章 0 评论 0

kkgtx

文章 0 评论 0

WordPress小学生

文章 0 评论 0

酷炫老祖宗

文章 0 评论 0

硪扪都還晓

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文