ViewMessageServlet.java----(Servlet基础)

package demoMAS;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.*;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class viewMessageServlet extends HttpServlet {
	private Connection con;
	/**
	 * Constructor of the object.
	 */
	public viewMessageServlet() {
//		super();
		String url="jdbc:mysql://localhost/liuyan";
		String userName="root";
		String password="123456";
		con=null;
			try{
			Class.forName("com.mysql.jdbc.Driver");
		}catch(ClassNotFoundException e){
			System.out.println(e.getMessage());
		}
		try{
			con=DriverManager.getConnection(url,userName,password);
		}catch(SQLException e){
			System.out.println(e.getMessage());
		}
	}

	/**
	 * Destruction of the servlet. <br>
	 */
//	public void destroy() {
//		super.destroy(); // Just puts "destroy" string in log
//		// Put your code here
//	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=gbk");
		Collection ret =new ArrayList();
		try{
			Statement stmt =con .createStatement();
			String s="select count(*) from message";
			ResultSet rs =stmt.executeQuery(s);
			int message_count= 0;
			if(rs.next()){
				message_count=rs.getInt(1);
				rs.close();
			}
			if(message_count>0){
				String s2 ="select * from message order by time desc";
				rs =stmt.executeQuery(s2);
				
				while(rs.next()){
					String title =rs.getString("title");
					String name= rs.getString("name");
					String email=rs.getString("email");
					String content =rs.getString("content");
					java.sql.Date date =rs.getDate("time");
					MessageVO message =new MessageVO();
					message.setContent(content);
					message.setName(name);
					message.setDate(date);
					message.setTitle(title);
					message.setEmail(email);
					ret.add(message);
				}
				rs.close();
				stmt.close();
				request.setAttribute("message", ret);
				RequestDispatcher dispatcher =request.getRequestDispatcher("ViewMessage.jsp");
				dispatcher.forward(request, response);
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		
		
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doGet(request,response);
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
//	public void init() throws ServletException {
//		// Put your code here
//	}

}