xnewsadd.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	String fckeditor = request.getParameter("fckeditor");
	if(fckeditor!=null){
		fckeditor = fckeditor.replaceAll("\"","&quot;");
		fckeditor = fckeditor.replaceAll("'","&quot;");
	}
	
	String type = request.getParameter("type");
	String title = request.getParameter("title");
	String xvisible = request.getParameter("xvisible");
	String user = (String)session.getAttribute("user");
	String zhiding =request.getParameter("zhiding");
	String part = (String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	
	//out.println(zhiding);
		
	if(zhiding==null){
		zhiding="0";
	}
	else if(zhiding.compareTo("1")==0){
		
	}
	else
	zhiding="0";

	if((title==null)||(title.length()<2)){
			response.sendRedirect("../newsadd.jsp?t=1");
	}
	else{
		dbc.getConnection();
		String sql="";
		{	 
			sql = "insert into  news(type,title,content,user,part,pubtime,xvisible,zhiding,cid) values('"+type+"','"+title+"','"+fckeditor+"','"+user+"','"+part+"','"+pubtime+"','"+xvisible+"','"+zhiding+"','"+scid+"')";
			out.println(charset.ISO_2_GBK(sql)+"<br>");
			dbc.update(charset.ISO_2_GBK(sql));
			dbc.close();

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


%>