dbutils中的问题,大虾请帮忙看哈
public class BlogServlet extends HttpServlet {private static final long serialVersionUID = 1L;
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request, response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String title=request.getParameter("title");
String content=request.getParameter("content");
String categoryId=request.getParameter("category");
System.out.println(title);
System.out.println(content);
System.out.println(categoryId);
int result=0;
Connection conn=SQLConnection.getConnection();
String sql= "insert into blog(title,content,category_id,create_time) values(?,?,?,getdate())";
try {
String[] params={title,content,categoryId};
QueryRunner qr=new QueryRunner();
result=qr.update(conn,sql,params);
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
String message="";
if(result==1){
message="添加博文成功!";
}else{
message="添加博文失败!";
}
request.setAttribute("message",message);
request.getRequestDispatcher("/addBlogResult.jsp").forward(request,response);
}
}
执行这句时出现错误: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'SET' 附近有语法错误。 Query: insert into blog(title,content,category_id,create_time) values(?,?,?,getdate())
这是怎么回事啊?
搜索更多相关主题的帖子:
dbutils
----------------解决方案--------------------------------------------------------
那位帮忙指导哈呀
----------------解决方案--------------------------------------------------------
把getdate函数也换成参数试试
----------------解决方案--------------------------------------------------------
我也遇到这个问题了。
后来发现很简单。
只要把这句代码String sql= "insert into blog(title,content,category_id,create_time) values(?,?,?,getdate())";
中的blog后面加一个空格就ok了。
----------------解决方案--------------------------------------------------------