第12章 网络留言板（JSP+Servlet+JavaBean）
代码案例：package com.cjg.servlet;
import java.io.IOException;
import java.text.SimpleDateFormat;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import com.cjg.tool.*;
public class AddMessageServlet extends HttpServlet {
private static final long serialVersionUID = -8349454122547148005L;
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sql = "insert into guestbook (id,name,email,phone,title,content,time) values(gb_seq.nextval,?,?,?,?,?,?)";
int result = 0;
String message = "";
String name = request.getParameter("name");
String title = request.getParameter("title");
if (StringTool.validateNull(name)) {
message = "对不起，姓名不能为空，请您重新输入！<br>";
} else if (StringTool.validateNull(title)) {
message = "对不起，主题不能为空，请您重新输入！<br>";
} else {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String param[] = { StringTool.filterHtml(name), StringTool.filterHtml(request.getParameter("email")),
StringTool.filterHtml(request.getParameter("phone")), StringTool.filterHtml(title),
request.getParameter("content"), sdf.format(new java.util.Date()) };
OracleTool db = new OracleTool("java:/comp/env/jdbc/oracleds");
db.init();
result = db.update(sql, param);
if (result == 0) {
message = "对不起，添加留言不成功，请您重新输入！";
} else {
message = "祝贺您，成功添加留言。";
}
}
request.setAttribute("message", message);
request.getRequestDispatcher("/addResult.jsp").forward(request, response);
}
}
package com.cjg.servlet;
import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import com.cjg.tool.OracleTool;
public class ManageServlet extends HttpServlet {
OracleTool db = null;
private static final long serialVersionUID = 204655027689309554L;
public void edit(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String params[] = { request.getParameter("id") };
String sql = "select * from guestbook where id=?";
List list = (List) db.query(sql, params, new BeanListHandler(MessageBook.class));
request.setAttribute("guestbook.admin.edit", list.get(0));
request.getRequestDispatcher("/admin/secure/edit.jsp").forward(request, response);
}
public void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String params[] = { request.getParameter("name"), request.getParameter("email"), request.getParameter("phone"),
request.getParameter("title"), request.getParameter("content"), request.getParameter("id") };
int i = db.update("update guestbook set name=?,email=?,phone=?,title=? ,content=? where id=?", params);
if (i == 1) {
request.setAttribute("guestbook.admin.update.message", "更新成功！");
MessageBook gb = new MessageBook();
gb.setId(Integer.parseInt(request.getParameter("id")));
gb.setName(request.getParameter("name"));
gb.setEmail(request.getParameter("email"));
gb.setPhone(request.getParameter("phone"));
gb.setTitle(request.getParameter("title"));
gb.setContent(request.getParameter("content"));
request.setAttribute("guestbook.admin.edit", gb);
} else {
request.setAttribute("guestbook.admin.update.message", "更新失败！");
} request.getRequestDispatcher("/admin/secure/updateResult.jsp").forward(request, response);
}
public void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String params[] = { request.getParameter("id") };
int i = db.update("delete from guestbook where id=?", params);
if (i == 1) {
request.setAttribute("guestbook.admin.delete.message", "删除成功");
} else {
request.setAttribute("guestbook.admin.delete.message", "删除失败");
} request.getRequestDispatcher("/admin/secure/deleteResult.jsp").forward(request, response);
}
public void list(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List list = (List) db.query("select id,name,title from guestbook order by id desc", null, new BeanListHandler(
MessageBook.class));
request.setAttribute("guestbook.admin.list", list);
request.getRequestDispatcher("/admin/secure/list.jsp").forward(request, response);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
db = new OracleTool("java:/comp/env/jdbc/oracleds");
db.init();
String method = request.getParameter("q");
if(method==null){
method="list";
}
if (method.equals("edit")) {
edit(request, response);
} else if (method.equals("delete")) {
delete(request, response);
} else if (method.equals("update")) {
update(request, response);
} else {
list(request, response);
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
资料下载地址：点击下载
页:
[1]