<%@ page contentType="text/html;charset=gb2312" %>
<%@ include  file="check.jsp" %>
<%@ page import="java.util.*" %>	

<script language=javascript src="mouse.js"></script>

<%	
Calendar now = Calendar.getInstance();
String sj2 = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
String sj = session.getAttribute("Uid")+"_"+now.get(Calendar.YEAR)+(now.get(Calendar.MONTH)+1)+now.get(Calendar.DAY_OF_MONTH)+now.get(Calendar.HOUR_OF_DAY)+now.get(Calendar.MINUTE)+now.get(Calendar.SECOND);
	
String path = request.getRealPath("upfile");
myUpload.setSavePath(path);
myUpload.setNewname(sj);
myUpload.doUpload(request,response);

if(myUpload.isUpload()){

	String filename= myUpload.getNewname()+"."+myUpload.getFileext();
	String ext= myUpload.getFileext();
	long size = myUpload.getFsize();
	
	//out.println(size);	
	if(size >= 16777200 || ext.compareTo("exe")==0 || ext.compareTo("bat")==0 || ext.compareTo("msi")==0){
		out.println(sqlbean.showMsg("addfile.jsp?op=1","因為您上載的文件大于16M！/或者上載的文件不符合要求<br>為系統所不允許，請重新上載！","出錯通知！"));		
	}else{
	
		String typeid = myUpload.getFieldValue("typeid");	
		String name = session.getAttribute("Rname").toString();
		String part = session.getAttribute("Upart").toString();	
		String title= myUpload.getFieldValue("title");	
		String ttext= myUpload.getFieldValue("content");	
		String content= myUpload.getContentType();	
		String fname = path +"\\"+filename;

		String ip= request.getRemoteAddr();
		String tmp = "<a href='upfile/"+filename+"' target=_blank>"+title+"</a>";
		String sql = "insert into learn(type,tname,part,title,ttext,html,IP,filename,time,contenttype)values('"
			+typeid+"','"
			+sqlbean.to_8859_1(name)+"','"
			+sqlbean.to_8859_1(part)+"','"
			+sqlbean.to_8859_1(title)+"','"
			+sqlbean.to_8859_1(ttext)+"','upfile/"
			+filename+"','"+ip+"','"+filename+"','"+sj2+"','"+"upfile/"+filename+"')";	
	
		sqlbean.executeUpdate(sql);	
		//out.println(sql);	

		out.println(sqlbean.showMsg("afileadd.jsp?op=1","您的提交《"+title+"》已經完成","系統提示！"));		
	}
}else{
	String typeid = myUpload.getFieldValue("typeid");	
	String name = session.getAttribute("Rname").toString();
	String part = session.getAttribute("Upart").toString();	
	String title= myUpload.getFieldValue("title");	
	String ttext= myUpload.getFieldValue("content");	
	String ip= request.getRemoteAddr();
	
	String sql = "insert into learn(type,tname,part,title,ttext,IP,time)values('"
		+typeid+"','"
		+sqlbean.to_8859_1(name)+"','"
		+sqlbean.to_8859_1(part)+"','"
		+sqlbean.to_8859_1(title)+"','"
		+sqlbean.to_8859_1(ttext)+"','"
		+ip+"','"+sj2+"')";	
	
	sqlbean.executeUpdate(sql);	
	sqlbean.close();	
	out.println(sqlbean.showMsg("afileadd.jsp?op=1","您的提交《"+title+"》已經完成","系統提示！"));
}
%>