adlistaction.java

来自「电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看」· Java 代码 · 共 27 行

package Client;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.ArrayList;
import Common.DBConnectBean;
public class adListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
		ArrayList list=new ArrayList();
		Hashtable table=new Hashtable();
		
		list=dbConnectBean.getWantedRecord("select * from commodity order by concern",10);
		
		application.setAttribute("adList",list);
		application.getRequestDispatcher("/administrator/adList.jsp").forward(request,response);
		

	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	   throws IOException,ServletException
	   {
	   	doGet(request,response);
	   }
}