doattachadd.jsp

tomcat最新安装程序

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="cn.com.aheadsoft.database.DBConnection,cn.com.aheadsoft.util.ObjectID" %>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<%
	  myUpload.initialize(pageContext);	 
	  myUpload.setDeniedFilesList("exe,bat,jsp,js");
	  myUpload.setMaxFileSize(3248000);	
	  myUpload.upload();
	
	  String A_Serial = myUpload.getRequest().getParameter("A_Serial");
	  String P_Serial = myUpload.getRequest().getParameter("P_Serial");
	  String D_Serial = myUpload.getRequest().getParameter("D_Serial");
	  System.out.println("d_serial:"+D_Serial);
	  String P_Code   = myUpload.getRequest().getParameter("P_Code");
	  
	  //attach
	  	
	  //String path = "D:\\tomcat24\\webapps\\krm\\jsp\\tskmanage\\detail\\upload";	
	  String path = request.getRealPath("\\jsp\\tskmanage\\detail\\upload");
	  System.out.println("path:"+path);
	  java.util.Date now2 = new java.util.Date();
	  String uploadpath = path+"\\"+now2.getTime() +"\\";
	  java.io.File dir = new  java.io.File(uploadpath);
	  dir.mkdir();
	  
	  try { 
   		int count = 0;
   		String[] strFileName = new String[1];
   	
   		for(int i = 0;i < myUpload.getFiles().getCount();i++){
   			com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(i);
   		
   			if(!myFile.isMissing()){
   				myFile.saveAs(uploadpath + myFile.getFileName());
   				strFileName[i] = myUpload.getFiles().getFile(i).getFileName();
   				count++;
   			}
   		
   			if(strFileName[i] == null){
   		        	strFileName[i] = "";
   			}
   		}
	  	DBConnection con = new DBConnection(); 
	        java.sql.Connection conn = con.getCon();

		String sql = " insert into TA_DEAttach (A_ID,A_Name,A_Content,A_Size,A_Date,A_Serial,P_Serial,P_Code,D_Serial,A_Delete) values (?,?,?,?,?,?,?,?,?,?) "; 
		
		java.sql.PreparedStatement pstmt = conn.prepareStatement(sql);
		for(int i=0 ;i<count;i++)
		{ 
		    pstmt.setString(1,  ObjectID.getID());
		    pstmt.setString(2,  new String(strFileName[0].getBytes("gb2312"), "iso8859_1"));
		    pstmt.setString(3,  ""+now2.getTime());
		    pstmt.setString(4,  "0");
		    pstmt.setString(5,  ""+new java.text.SimpleDateFormat("yyyy-MM-dd").format(new java.util.Date()));
		    pstmt.setString(6,  A_Serial);
		    pstmt.setString(7,  P_Serial);
		    pstmt.setString(8,  P_Code);
		    pstmt.setString(9,  D_Serial);
		    pstmt.setString(10, "n");
		    pstmt.execute();
		}	

	        pstmt.close();
	        conn.close();

	  }
	  catch (SecurityException  se) { 
		out.println("不允许该扩展名的附件");
	  }

	  catch (Exception e) { 
		out.println(e.toString());
	  }	  	
//上传结束 
%>
<%response.sendRedirect("/krm/servlet/DetailServlet?module=deattach&&status=q&&queryterm=all&&D_Serial="+D_Serial);%>