xapplyreg.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	String comment = request.getParameter("fckeditor");
	if(comment!=null){
		comment = comment.replaceAll("\"","&quot;");
		comment = comment.replaceAll("'","&quot;");
	}
	
	//type,title,site,hy,price,connman,address,mail,tel,phone,comment
	
	String type = request.getParameter("type");
	String title = request.getParameter("title");
	String site = request.getParameter("site");
	String hy = request.getParameter("hy");
	String price = request.getParameter("price");
	String connman = request.getParameter("connman");
	String address = request.getParameter("address");
	String mail = request.getParameter("mail");
	String tel = request.getParameter("tel");
	String phone = request.getParameter("phone");
	
	String user = (String)session.getAttribute("user");
	String part = (String)session.getAttribute("part");
	String pubtime = dateformat.getStringDate();
	//out.println(name);
	if((title==null)||(title.length()<1)){
		response.sendRedirect("../applyreg.jsp?t=1");
	}
	else{
		dbc.getConnection();
		String sql="";
		{	 
			sql = "insert into  applyinfo(type,title,site,hy,price,connman,address,mail,tel,phone,comment,recorduser,part,pubtime,cid) values('"+type+"','"+title+"','"+site+"','"+hy+"','"+price+"','"+connman+"','"+address+"','"+mail+"','"+tel+"','"+phone+"','"+comment+"','"+user+"','"+part+"','"+pubtime+"' ,'"+scid+"')";
			//out.println(charset.ISO_2_GBK(sql)+"<br>");
			dbc.update(charset.ISO_2_GBK(sql));
			dbc.close();

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


%>