Spring:您的SQL语法中有一个错误;检查与您的MariaDB服务器版本对应的手册,以了解在附近使用的正确语法

e5nszbig  于 2023-05-05  发布在  Spring
关注(0)|答案(3)|浏览(202)

首先我想道歉,因为我的英语不好。我正在学习Spring框架,我正在使用Sping Boot ,Spring Data,Spring MVC制作一个简单的应用程序。
现在我有一个错误,但我不知道为什么。
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:SQL语法中有错误;检查与您的MariaDB服务器版本对应的手册,以获得正确的语法,在第1行使用'describe =' Education ',name_room =' Boston ',id_status =' 2 ' where id_room =' 1 ''
这是我的代码:

Room Model

    @Entity
    @Table(name ="room")
     public class Room implements Serializable {
     private static final long serialVersionUID = 1L;
     @Id
        @GeneratedValue(strategy = GenerationType.AUTO)
        @Column(name = "ID_room", nullable = false)
        private String id;

        @Column(name = "name_room", nullable = false)
        private String name;

        @Column(name = "Describe")
        private String describe;

        @Column(name = "ID_status")
        private String status;

        public Room() {
            super();
        }

        public Room(String id, String name, String describe, String status) {
            super();
            this.id = id;
            this.name = name;
            this.describe = describe;
            this.status = status;

        }

        public String getId() {
            return id;
        }

        public void setId(String id) {
            this.id = id;
        }

        public String getName() {
            return name;
        }

        public void setName(String name) {
            this.name = name;
        }

        public String getDescribe() {
            return describe;
        }

        public void setDescribe(String describe) {
            this.describe = describe;
        }

        public String getStatus() {
            return status;
        }

        public void setStatus(String status) {
            this.status = status;
        }

}

RoomController

    @GetMapping("/manager/{id}/edit")
    public String edit(@PathVariable String id, Model model) {
        model.addAttribute("room", romService.findOne(id));
        return "roomForm";
    }

    @PostMapping("/manager/save")
    public String save(@Valid Room room, BindingResult result, RedirectAttributes redirect) {
        if (result.hasErrors()) {
            return "roomform";
        }
        romService.save(room);
        redirect.addFlashAttribute("success", "Saved user successfully!");
        return "redirect:/manager";
    }

代码正在工作,但我有一个SQL错误。我不知道为什么。请帮帮我

Hibernate: update room set describe=?, name_room=?, id_status=? where id_room=?
2018-06-08 09:41:12.881  WARN 9308 --- [io-8080-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 1064, SQLState: 42000
2018-06-08 09:41:12.882 ERROR 9308 --- [io-8080-exec-10] o.h.engine.jdbc.spi.SqlExceptionHelper   : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'describe='Education', name_room='Boston', id_status='2' where id_room='1'' at line 1
jv4diomz

jv4diomz1#

这是因为'describe'是Mysql中的关键字,不应该使用。为此字段给予其他名称。
或者,如果你想使用关键字作为字段名称,那么描述,然后把它像这样。中间**describe**(反勾字符)

pdsfdshx

pdsfdshx2#

可以尝试将name =“Describe”更新为“Describe

@Column(name = "`Describe`")
        private String describe;
xu3bshqb

xu3bshqb3#

你应该避免使用SQL关键字作为列名,即使使用“desc”也会抛出同样的错误(我知道了!)。请使用任何其他列名,而不要使用“Describe”。

相关问题