右边的Source Editor中，新建的PostAction.java已经打开了；接下来我们要把记录在NewForm bean里的数据保存进数据库，为了测试的需要，在添加数据以后，将添加成功与否的结果显示在result.jsp上面。
1 public ActionForward execute(ActionMapping mapping, ActionForm form,
2 HttpServletRequest request, HttpServletResponse response) {
3 NewForm f = (NewForm) form;
4 String sql = "insert into guestbook (name,subject,email,url,content,iconId,password,font,replyId,date,lastReplyTime) " +
5 " values(?,?,?,?,?,?,?,?,-1,now(),now())";
6
7 String content = f.getContent();
8 content = content.replaceAll(" ", " ");
9 content = content.replaceAll("\n", "<br>");
10
11 String params[] = {f.getName(), f.getSubject(), f.getEmail(), f.getUrl(), content, new Integer(f.getIconId()).toString(), f.getPassword(), f.getFont()};
12
13 QueryRunner qr = DbHelper.getQueryRunner();
14
15 String result = null;
16 try {
17 if (qr.update(sql, params) == 1){
18 result = "更新成功";
19 }else{
20 result = "更新失败";
21 }
22 } catch (SQLException ex) {
23 Logger.getLogger(PostAction.class.getName()).log(Level.SEVERE, null, ex);
24 }
25 f.setResult(result);
26 return mapping.findForward(SUCCESS);
27 }
7，8，9行主要是将content里的空格和回车符号转成html中所对应的空格和回车。