xstudy.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 content = charset.GBK_2_ISO(req.getParameter("fckeditor")); 
	String filename = "";
	com.jspsmart.upload.File file=null;
 	title=title.replaceAll("'","&quot;");
	title=title.replaceAll("\"","&quot;");
	content=content.replaceAll("'","&quot;");
	content=content.replaceAll("\"","&quot;");
	String user =(String) session.getAttribute("user");
	String part =(String) session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	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);
		}
	}
	catch(Exception e){
		filename="";
	}
	//insert db;
	dbc.getConnection();
	String sql="";
	
		
	{
		sql = "insert into  study(title,content,path,user,part,pubtime,cid) values('"+title+"','"+content+"','"+filename+"','"+user+"','"+part+"','"+pubtime+"','"+scid+"')";
			out.println(charset.ISO_2_GBK(sql));
		dbc.update(charset.ISO_2_GBK(sql)); 
	}
	dbc.close();
	//response.sendRedirect("../study.jsp?t=0");	
%>