xnotifyadd.jsp

oa系统 JAVA 办公管理系统 含有多项功能 快快下载

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%@page import="com.jspsmart.upload.*" %>
<%
	// 新建一个SmartUpload对象
	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 = "";
	String xvisible = req.getParameter("xvisible");
	com.jspsmart.upload.File file=null;
	
	if((title==null)||(title.length()<2)){
		response.sendRedirect("../notifyadd.jsp?t=1");	
	}
	else{
		
		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);
				
				//if(file!=null){
					filename=file.getFileName();//+"."+file.getFileExt();
					
					file.saveAs(java.io.File.separator+"upload"+java.io.File.separator+filename);
					//out.println(java.io.File.separator+"upload"+java.io.File.separator+filename+"=ppppp");
					
				//}
			}
		}
		catch(Exception e){
			filename="";
		}
		//insert db;
		
		dbc.getConnection();
		String sql = "insert into  notify(title,content,path,user,part,pubtime,xvisible,cid) values('"+title+"','"+content+"','"+filename+"','"+user+"','"+part+"','"+pubtime+"',"+xvisible+",'"+scid+"')";
		out.println(sql);
		dbc.update(charset.ISO_2_GBK(sql));
		dbc.close();

		response.sendRedirect("../notifyadd.jsp?t=0");	

	}	
%>