1addlistaction.java

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

package Administrator;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;
//取得页面传递过来的用户资料
public class addListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");

		String card=request.getParameter("card");
		String num=request.getParameter("num");
		String model=request.getParameter("model");
		String photo=request.getParameter("photo");
		String net=request.getParameter("net");
		String price=request.getParameter("price");
		String special=request.getParameter("special");
		String picture=request.getContextPath()+"/image/phone/"+card+"/"+num+".jpg";//request.getParameter("picture");
		String describe=request.getParameter("describe");
		int restNum=Integer.parseInt(request.getParameter("restNum").toString());
		
		//获得当前注册日期
		Calendar nowCalendar=Calendar.getInstance();
		String addDay=nowCalendar.get(Calendar.YEAR)+"/"+
			(nowCalendar.get(Calendar.MONTH)+1)+"/"+
			nowCalendar.get(Calendar.DATE);
		//建立数据库连接并执行数据插入
		DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
		String strSQL="select * from commodity where card=\'"+card+"' and num='"+num+"\'";
		System.out.print(strSQL);
		Hashtable table=dbConnectBean.getOneRecord(strSQL);
	/*	Hashtable aa=new Hashtable();
		if(table!=null){
			System.out.println("table now ");
		}*/
		if(table!=null&&table.get("NUM")!=null){
			application.getRequestDispatcher("/administrator/addListError.htm").forward(request,response);
		}
		else {
		
			strSQL="insert into commodity";
			strSQL+="(card,num,model,photo,net,price,special,picture,describe,addDay,restNum) ";
			strSQL+=" values(";
			strSQL+="'"+card+"',";
			strSQL+="'"+num+"',";
			strSQL+="'"+model+"',";
			strSQL+="'"+photo+"',";
			strSQL+="'"+net+"',";
			strSQL+="'"+price+"',";
			strSQL+="'"+special+"',";
			strSQL+="'"+picture+"',";
			strSQL+="'"+describe+"',";
			strSQL+="'"+addDay+"',";
			strSQL+=restNum+")";
			boolean result=dbConnectBean.updata(strSQL);

	//	HttpSession session=request.getSession();
	//	session.setAttribute("sql",strSQL);
		
			if(result){
				application.getRequestDispatcher("/clientListAction").forward(request,response);
			}else{
				application.getRequestDispatcher("/administrator/addList.jsp").forward(request,response);
			}
		}	
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}