Spring：您的SQL语法中有一个错误；请查看与您的MariaDB服务器版本相对应的手册，以获得要使用的正确语法

Question

首先，我想道歉，因为我的英语不好。我正在学习Spring框架，我正在使用Spring Boot、Spring Data、Spring MVC制作一个简单的应用程序。

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";
    }

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

Answer 1

这是因为'description‘是Mysql中的关键字，不应该使用。给这个字段起一个不同的名字。

或者，如果您想使用关键字作为字段名，那么只能描述，然后将其这样放入。在'description'之间（反勾字符）