getmessagesservlet.java

用java编写的程序

package webbook.guestbook;

import java.io.IOException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import webbook.util.OracleUtil;

public class GetMessagesServlet extends HttpServlet {
	private static final long serialVersionUID = 5964428201228635704L;

	public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String sql = "select * from guestbook order by id desc";
		List list = null;
		OracleUtil db = new OracleUtil("java:/comp/env/jdbc/oracleds");
		db.init();
		list = (List) db.query(sql, null, new BeanListHandler(Guestbook.class));
		request.setAttribute("results", list);
		request.getRequestDispatcher("/getMessages.jsp").forward(request, response);
	}
}