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
// }
}