Http servlet中使用hibernate无法添加数据到mysql

Question

public void doPost(HttpServletRequest request, HttpServletResponse response)             throws ServletException, IOException {         response.setContentType("text/html;charset=utf-8");         request.setCharacterEncoding("utf-8");//这里是设置一下编码格式         Configuration cfg=new AnnotationConfiguration().configure();         SessionFactory sessionfactory=cfg.buildSessionFactory();         Session session=sessionfactory.openSession();         Transaction tx=session.beginTransaction();         String _index= request.getParameter("index");         int _index1=Integer.parseInt(_index);         String  _content= request.getParameter("content");         System.out.println(_content);         String  _des= request.getParameter("des");         String  _style= request.getParameter("style");         String  _menu= request.getParameter("menu");         String  _campus= request.getParameter("campus");         String  _condition= request.getParameter("condition");         String  _wxNumber= request.getParameter("wxNumber");         int _wxNumber1 = Integer.parseInt(_wxNumber);         String  _phoneNumber= request.getParameter("phoneNumber");         int _phoneNumber1 = Integer.parseInt(_phoneNumber);         String  _date= request.getParameter("date");         String  _images= request.getParameter("images");         String  _userinfoAvatarUrl= request.getParameter("userinfoAvatarUrl");         String  _userinfoNickName= request.getParameter("userinfoNickName");         Topic topic =new Topic();         topic.setOpenid(_openid);         topic.setContent( _content);         topic.setIndex(_index1);         topic.setDes(_des);         topic.setDate(_date);         topic.setImages(_images);         topic.setStyle(_style);         topic.setMenu(_menu);         topic.setCampus(_campus);         topic.setCondition(_condition);         topic.setWxNumber(_wxNumber1);         topic.setPhoneNumber(_phoneNumber1);         topic.setUserinfoNickName(_userinfoNickName);         topic.setUserinfoAvatarUrl(_userinfoAvatarUrl);     }

Answer 1

报的是sql语法错误，是因为你建表的使用了mysql的保留字作为字段名。从错误信息中可以看到condition和index字段都是保留字。改一下字段名称吧。

Answer 2

根据报错信息，是sql语句不正确，请检查下sql语句，例如字段名称，字段个数，数据与字段是否匹配

Answer 3

session.save(topic);后面是不是少了=》session.getTransaction().commit();