当前位置: 代码迷 >> Java Web开发 >> dbutils中的问题,大虾请帮忙看哈
  详细解决方案

dbutils中的问题,大虾请帮忙看哈

热度:188   发布时间:2009-10-11 22:20:08.0
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了。

----------------解决方案--------------------------------------------------------