administratoreditlistaction.java

电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看

package Administrator;
import java.io.*;
import javax.servlet.*;
import java.text.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;
import com.jspsmart.upload.*;

public class administratorEditListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");
		HttpSession session=request.getSession();
		String card="",num="",model="",photo="",net="",price="",special="",picture="",describe="";
		int restNum=0;

		try{
			SmartUpload su= new SmartUpload();
			//上传初始化
			su.initialize(getServletConfig(),request,response);
			su.upload();
			Request req = su.getRequest();
			if(req.getParameter("id")==null){
				application.getRequestDispatcher("/administrator/addListError.htm").forward(request,response);
			}
			card=req.getParameter("card");
			//System.out.println("1");
			num=req.getParameter("num");
		//	System.out.println("2");
			model=req.getParameter("model");
		//	System.out.println("3");
			photo=req.getParameter("photo");
		//	System.out.println("4");
			net=req.getParameter("net");
			price=req.getParameter("price");
			special=req.getParameter("special");
		//	System.out.println("5");
			picture="";//su.getRequest().getContextPath()+"/image/phone/"+card+"/"+num+".jpg";//request.getParameter("picture");
			describe=req.getParameter("describe");
			restNum=Integer.parseInt(req.getParameter("restNum").toString().trim());
			
			su.setAllowedFilesList("jpg,gif,jpeg");
			su.setMaxFileSize(100000);
		//	System.out.print("?>?????????????");
			DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
			try{
				//先上传图片 再做数据库
				String path=request.getRealPath("");
				path=path + "\\image\\phone"+"\\"+card+"\\"+num;//将要建立的目录路径
				java.io.File dir=new java.io.File(path);//建立代表Sub目录的File对象，并得到它的一个引用
				if(dir.exists()){
				}else{
					dir.mkdirs();
				}
		//		System.out.print("!!!!!!!!!!");
				int count = su.save(path);
					for (int i=0;i<su.getFiles().getCount();i++){
						System.out.print("file "+i);
						com.jspsmart.upload.File file = su.getFiles().getFile(i);
						
						if(file.getFileExt().equals("jpg")||file.getFileExt().equals("gif")||file.getFileExt().equals("jpeg"))
							picture=num+"."+file.getFileExt();
						if(file.getFileExt().equals("txt")||file.getFileExt().equals("htm")||file.getFileExt().equals("html")||file.getFileExt().equals("doc"))
							describe=num+"."+file.getFileExt();	
						////System.out.println("filename is ------------"+picture);
					//	若文件不存在则继续
						file.saveAs(path+"\\"+num+"."+file.getFileExt());
						if (file.isMissing()) continue;
						
					}
				String addDay=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
		/*		////System.out.println("我不知道了");
				Calendar nowCalendar=Calendar.getInstance();
				String addDay=nowCalendar.get(Calendar.YEAR)+"/"+
				(nowCalendar.get(Calendar.MONTH)+1)+"/"+
				nowCalendar.get(Calendar.DATE);
			//建立数据库连接并执行数据插入
		*/		
				String strSQL="update commodity SET ";
				strSQL+="card='"+card+"',num='"+num+"',model='"+model+"',photo='"+photo+"',net='"+net+"',price='"+price+"',special='"+special+"',picture='"+picture+"',describe='"+describe+"',addDay='"+addDay+"' ";
				strSQL+=" where id="+req.getParameter("id").toString();
				////System.out.print(strSQL);
				if(dbConnectBean.updata(strSQL)){
					////System.out.println("\n 啊啊 啊啊啊");
					application.getRequestDispatcher("/administratorListAction").forward(request,response);
				}else{
					////System.out.println("\n哦哦哦哦哦哦哦哦");
					application.getRequestDispatcher("/administrator/administratorAddList.jsp").forward(request,response);
				}	
			}catch(Exception e){
				////System.out.println(e.getMessage());
			}
		}catch(Exception e){
			////System.out.println(e.getMessage());
		}
   }
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	   throws IOException,ServletException
	   {
	   	doGet(request,response);
	   }

}