clientshowonecommodityaction.java

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

package Client;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.util.ArrayList;
import Common.DBConnectBean;
public class clientShowOneCommodityAction 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","","");
		Hashtable table=new Hashtable();
		int id=0;
		id=Integer.parseInt(request.getParameter("id"));
		table=dbConnectBean.getOneRecord("select * from commodity where id="+id);
		int i=Integer.parseInt(table.get("concern".toUpperCase()).toString())+1;
		dbConnectBean.updata("update  commodity set concern="+i+" where id="+id);
		//这个是用户私人拥有的，所以用session来保存
		HttpSession session=request.getSession();
		session.setAttribute("table".toUpperCase(),table);
		application.getRequestDispatcher("/client/clientShowOneCommodity.jsp").forward(request,response);

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