upload.jsp

大学JSP课程大作业

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="my.shop.db.*"%>
<%@ page import="org.lxh.smart.*"%>
<%-- 会话过滤 --%>
<%@ include file="sessionfilter.jsp"%>

<%
	
		//定义转发提示信息
		List msg = new ArrayList();
		//设置编码格式
		request.setCharacterEncoding("GB18030") ;
		SmartUpload mySmartUpload = new SmartUpload() ;
		//初始化
	    mySmartUpload.initialize(pageContext);
	    //设置上载的最大值
	    mySmartUpload.setMaxFileSize(1024*1024);
	    //准备文件
	    mySmartUpload.upload();	
		//取得上载的文件
	    File myFile = mySmartUpload.getFiles().getFile(0);
	    if (!myFile.isMissing())
	    {
		    //取得当前时间做为上传的文件名,加上取得的后缀名,构成完整的文件名称
		    String myFileName=new java.text.SimpleDateFormat("yyyyMMddHHmmssSSS").format(new java.util.Date(System.currentTimeMillis()))+"."+mySmartUpload.getFiles().getFile(0).getFileExt() ;
		    //保存路径
		    String aa=getServletContext().getRealPath("/")+"productimage\\";
		    String trace=aa+myFileName;
		    //取得别的参数
		    Request req = mySmartUpload.getRequest() ;
			String cateid = req.getParameter("cateid") ;
			String name = req.getParameter("name") ;
			String price = req.getParameter("price") ;
			if("-1".equals(cateid)){
				msg.add("请选择产品所属的类别");
			}else if("".equals(name) || null==name){
				msg.add("请填写产品的名称") ;
			}else if("".equals(price) || null==price){
				msg.add("请填写产品的价格") ;
			}else{
			    //将文件保存在服务器端 
			    myFile.saveAs(trace,mySmartUpload.SAVE_PHYSICAL);
			    Connection conn = DBConnection.getInstance().getConnection() ;
			    String sql = "insert into product(name,price,picture,cateid) values(?,?,?,?)" ;
			    PreparedStatement pstmt = conn.prepareStatement(sql) ;
			    pstmt.setString(1,name) ;
			    pstmt.setString(2,price) ;
			    pstmt.setString(3,myFileName) ;
			    pstmt.setInt(4,Integer.parseInt(cateid)) ;
			    pstmt.executeUpdate() ;
			    pstmt.close() ;
			    conn.close() ;
			    msg.add("产品添加成功") ;
			}
		}else{
			msg.add("请选择你要上传的文件") ;
		}
		request.setAttribute("msg",msg) ;
		request.getRequestDispatcher("addProduct.jsp").forward(request,response); 
%>