upload.jsp

基于JSP＋MYSQL的教学资源库系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<jsp:useBean class="com.jspsmart.upload.SmartUpload" id="myUpload" scope="page"/>
<jsp:useBean class="multiMedia.multiMediaUp" id="myMultiMediaUp" scope="page"/>
<jsp:useBean class="database.managerDB" id="myManagerDB" scope="page"/>	
<%
String getMultiMediaType="";
String getSubjectType="";
String getObjectType="";
String getKeyWords="";
String getWriter="";
String getDescription="";
String getSavePath="";

String getID="";
String getWriteTime="";
String getFileType="";
int getSize=0;
myUpload.initialize(pageContext);
myUpload.setTotalMaxFileSize(30000000);
myUpload.upload();

java.util.Enumeration e = myUpload.getRequest().getParameterNames();
String key="";
String[] values;
while (e.hasMoreElements())
{
      key = (String)e.nextElement();
      values = myUpload.getRequest().getParameterValues(key);
      for(int i = 0; i < values.length; i++)
	  {
          if(key.equals("multiMediaType"))   getMultiMediaType = values[i]; 		
          if(key.equals("subjectType"))   getSubjectType = values[i];
          if(key.equals("objectType"))   getObjectType = values[i];  			
		  if(key.equals("keyWords"))  	 getKeyWords = values[i]; 
		  if(key.equals("writer"))   	 getWriter = values[i]; 
		  if(key.equals("description"))  getDescription = values[i];   			  
      }
}
getID=myMultiMediaUp.makeID(getMultiMediaType);  //调用makeID方法产生ID,并且用作文件名
getWriteTime=myMultiMediaUp.makeTime();          //调用makeTime方法产生编辑日期
												 //根据不同的媒体类型选择不同的数据表
if(getMultiMediaType.equals("t"))  getMultiMediaType="text";
if(getMultiMediaType.equals("i"))  getMultiMediaType="image";
if(getMultiMediaType.equals("s"))  getMultiMediaType="sound";
if(getMultiMediaType.equals("v"))  getMultiMediaType="video";
if(getMultiMediaType.equals("a"))  getMultiMediaType="animate";



try
{
	for (int i=0;i<myUpload.getFiles().getCount();i++)
	{
		com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(i);
		if(!myFile.isMissing())
		{
			getFileType=myFile.getFileExt();
			getSize=myFile.getSize();
			getSavePath="multiMedia/"+getMultiMediaType+"/"+getID+"."+getFileType;
			myFile.saveAs(getSavePath);
		}
		else
		{
			out.print("没有选择要上传的文件.<a href=signup.jsp>返回</a>");
			out.close();
		}
	}
}
catch (Exception fileE) 
{ 
	out.print("<script>alert('素材上传失败!');location.href='uploadPage.jsp';</script>");
}

String sql="";
sql+="insert into "+getMultiMediaType;
sql+="(ID,SubjectType,ObjectType,KeyWords,Description,WriteTime,Writer,FileType,Size,SavePath,Download)";
sql+=" values('"+getID+"','"+getSubjectType+"','"+getObjectType+"','"+getKeyWords;
sql+="','"+getDescription+"','"+getWriteTime+"','"+getWriter+"','"+getFileType+"',"+getSize;
sql+=",'"+getSavePath+"',"+0+") ";
out.println(sql);
if(myManagerDB.connectDB())
{
	myManagerDB.executeSQL(sql);
	myManagerDB.closeDB();
	out.print("<script>alert('素材提交成功!');location.href='uploadPage.jsp';</script>");	
}
else
{
	out.println("数据库接连失败,请稍候再试!");
}
%>