administratoraddlistaction.java

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

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

//取得页面传递过来的用户资料
public class administratorAddListAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");
		HttpSession session=request.getSession();
		if(session.getAttribute("identify".toUpperCase())==null || !session.getAttribute("identify".toUpperCase()).toString().equals("administrator")){
			application.getRequestDispatcher("/clientListAction").forward(request,response);
		}
		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();
			
			card=req.getParameter("card");
			////System.out.println("card111"+card);
			num=req.getParameter("num");
			model=req.getParameter("model");
			photo=req.getParameter("photo");
			net=req.getParameter("net");
			price=req.getParameter("price");
			special=req.getParameter("special");
			picture="";//su.getRequest().getContextPath()+"/image/phone/"+card+"/"+num+".jpg";//request.getParameter("picture");
			describe=req.getParameter("describe");
			restNum=Integer.parseInt(req.getParameter("restNum").toString());
			
			su.setAllowedFilesList("jpg,gif,jpeg");
			su.setMaxFileSize(100000);
			
			DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
			String strCheck="select * from commodity where card=\'"+card+"' and num='"+num+"\'";
			Hashtable table=dbConnectBean.getOneRecord(strCheck);
			if((table!=null)&&(table.get("NUM"))==null){
				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()){//检查Sub目录是否存在
						////System.out.println("Sub目录存在");
					}else{
						dir.mkdirs();//建立Sub目录
						////System.out.println("Sub目录不存在，已建立");
					}
					////System.out.println(path);
					int count = su.save(path);
					for (int i=0;i<su.getFiles().getCount();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());
	/*				Calendar nowCalendar=Calendar.getInstance();
					String addDay=nowCalendar.get(Calendar.YEAR)+"/"+
					(nowCalendar.get(Calendar.MONTH)+1)+"/"+
					nowCalendar.get(Calendar.DATE);*/
				//建立数据库连接并执行数据插入
					
					String strSQL="";
					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+")";
					////System.out.println(strSQL+"\n 我靠 到底是怎么回师啊");
					if(dbConnectBean.updata(strSQL)){
						//System.out.println("\nto ????怎么回师啊 啊啊 啊啊啊");
						session.setAttribute("identify".toUpperCase(),"administrator");
						application.getRequestDispatcher("/index.jsp").forward(request,response);
					}else{
						////System.out.println("\n哦哦哦哦哦哦哦哦");
						application.getRequestDispatcher("/administrator/administratorAddList.jsp").forward(request,response);
					}
				}catch(Exception e){
					//System.out.println(e.getMessage());
				}
			}			
			else{
				application.getRequestDispatcher("/administrator/administratorAddListError.htm").forward(request,response);
			}
		}catch(Exception e){
			////System.out.println(e.getMessage());
		}
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}