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);
}
4 回答
蠱毒傳說
TA貢獻1895條經(jīng)驗 獲得超3個贊
報的是sql語法錯誤，是因為你建表的使用了mysql的保留字作為字段名。從錯誤信息中可以看到condition和index字段都是保留字。改一下字段名稱吧。
慕田峪9158850
TA貢獻1794條經(jīng)驗 獲得超7個贊
根據(jù)報錯信息，是sql語句不正確，請檢查下sql語句，例如字段名稱，字段個數(shù)，數(shù)據(jù)與字段是否匹配
添加回答
舉報
0/150
提交
取消