xreportadd.jsp

我费了好大劲才找到的一款非常全的OA办公自动化软件源码

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%@page import="com.jspsmart.upload.*" %>

<%
	SmartUpload su = new SmartUpload();
	su.initialize(pageContext);
	su.upload();
	com.jspsmart.upload.Request req = su.getRequest();
	
	String title = charset.GBK_2_ISO(req.getParameter("title")); 
	String parts = charset.GBK_2_ISO(req.getParameter("parts")); 
	String content = charset.GBK_2_ISO(req.getParameter("fckeditor")); 
	String filename = "",list= charset.GBK_2_ISO(req.getParameter("list"));
	com.jspsmart.upload.File file=null;
	
	//out.println(list+"<br>");
	
	title=title.replaceAll("'","&quot;");
	title=title.replaceAll("\"","&quot;");
	content=content.replaceAll("'","&quot;");
	content=content.replaceAll("\"","&quot;");
	String user =(String) session.getAttribute("user");
	parts =(String) session.getAttribute("part");
	String pubtime = dateformat.getStringDate();

	if((title==null)||(title.length()<2))
	{
		response.sendRedirect("../reportadd.jsp?t=1");	
	}
	else
	{
	
		try
		{
			for (int i=0;i<su.getFiles().getCount();i++)
			{
				file = su.getFiles().getFile(i);
				filename=file.getFileName();//+"."+file.getFileExt();
				file.saveAs(java.io.File.separator+"reports"+java.io.File.separator+filename);
				//out.println(java.io.File.separator+"reports"+java.io.File.separator+filename+"<br>");
				//}
			}
		}
		catch(Exception e)
		{
			filename="";
		}
		//insert db;
		String sql="";
		if(parts==null)
		response.sendRedirect("../reportadd.jsp");
			
		String tmp=parts;
		if(parts.compareTo("-1")==0)
		{
			int cnt=list.indexOf(",");
			while(cnt>=0)
			{
				tmp = list.substring(0,cnt);
				dbc.getConnection();
				sql = "insert into  reports(title,content,path,rpart,user,part,pubtime,cid) values('"+title+"','"+content+"','"+filename+"',"+tmp+",'"+user+"','"+parts+"','"+pubtime+"','"+scid+"')";
				dbc.update(charset.ISO_2_GBK(sql));
				dbc.close();
 
				list = list.substring(cnt+1);
				//out.println(charset.ISO_2_GBK(sql)+"<br>");
				cnt=list.indexOf(",");
			}
			tmp = list;
			dbc.getConnection();
			sql = "insert into  reports(title,content,path,rpart,user,part,pubtime,cid) values('"+title+"','"+content+"','"+filename+"',"+tmp+",'"+user+"','"+parts+"','"+pubtime+"','"+scid+"')";
				//out.println(charset.ISO_2_GBK(sql));
			dbc.update(charset.ISO_2_GBK(sql));
			dbc.close();
 
	
		}
		else
		{
			dbc.getConnection();
			sql = "insert into  reports(title,content,path,rpart,user,part,pubtime,cid) values('"+title+"','"+content+"','"+filename+"','"+tmp+"','"+user+"','"+parts+"','"+pubtime+"','"+scid+"')";
				//out.println(charset.ISO_2_GBK(sql));
			dbc.update(charset.ISO_2_GBK(sql));
			dbc.close();
 
		}		
		response.sendRedirect("../reportadd.jsp?t=0");	
	}
%>