softaddsave.jsp

GJM-OA网络自动化办公系统 Ver 0.02 (JSP Version)

<%
if(String.valueOf(session.getAttribute("Urule")).compareTo("a")!=0){ 
	response.sendRedirect ("error.jsp?id=admin");
}
%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ include file="check.jsp" %>
<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("upload");
	//out.println(path);
	myUpload.setSavePath(path);
	myUpload.setNewname(sj);
	
	myUpload.doUpload(request,response);
	String filename= myUpload.getNewname();
//	out.println("success!");

	String content = myUpload.getFieldValue("content");	
	String softname= myUpload.getFieldValue("softname");	
	String best= myUpload.getFieldValue("best");	
	long size= myUpload.getFsize();	

	String url = "upload/"+sj+"."+myUpload.getFileext();
	String sql = "insert into soft (upname,name,content,url,size,time,best)values('"
		+session.getAttribute("Uid")+"','"
		+sqlbean.to_8859_1(softname)+"','"
		+sqlbean.to_8859_1(content)+"','"
		+sqlbean.to_8859_1(url)+"','"
		+size+"','"
		+sj2+"','"
		+best+"')";	
	
	sqlbean.executeUpdate(sql);
	sqlbean.close();
	//out.println(sql);

	out.println(sqlbean.showMsg("javascript:window.close();","文件已经上载！即将关闭窗口！","系统提示"));

%>