xuserauthadd.jsp

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

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

	Enumeration xenum = request.getParameterNames();
	String tmp = "",xuser="",part="";
	java.util.LinkedList ll = new java.util.LinkedList();
	java.util.LinkedList llx = new java.util.LinkedList();
	java.util.LinkedList llr = new java.util.LinkedList();
	while(xenum.hasMoreElements())
	{
		tmp=(String)xenum.nextElement();
		if(tmp.compareTo("user")==0)
		{
			xuser = request.getParameter("user");
		//	out.println("selected user "+request.getParameter("user")+"..<br>");
		}
		else if(tmp.compareTo("submit")==0)
		{
		//	out.println("selected user "+request.getParameter("user")+"..<br>");
		}
		else if((tmp.indexOf("x_")<0)&&(tmp.indexOf("r_")<0))
		{
			ll.add(tmp);
			llx.add(request.getParameter("x_"+tmp));
			llr.add(request.getParameter("r_"+tmp));
		}
	}
	
	
	
	if(xuser==null)
	{
			response.sendRedirect("../userauthadd.jsp?t=1");
	}
	else
	{
		out.println(ll.size());		
		if((ll.size()>0)&&(ll.size()==llx.size()))
		{
			String user = (String)session.getAttribute("user");
		    part = (String)session.getAttribute("part");
			String pubtime = dateformat.getStringDate();
			String sql="";
	
				dbc.getConnection();
			for(int x=0;x<ll.size();x++)
			{
				tmp = (String)ll.get(x);
				if(dbc.getCount("select count(*) from  userauth where authid='"+tmp+"' and user='"+xuser+"'")>0)
				{
					out.println(","+tmp);
					continue;
				}
				else
				{	 
					sql = "insert into  userauth(user,programname,authid,grantbyuser,part,pubtime,modelname) values('"+xuser+"','"+(String)llx.get(x)+"','"+(String)ll.get(x)+"','"+user+"','"+part+"','"+pubtime+"','"+(String)llr.get(x)+"')";
					//out.println(charset.ISO_2_GBK(sql)+"<br>");
					dbc.update(charset.ISO_2_GBK(sql));
					//dbc.close();
				}
			}
			dbc.close();
			
		}
		response.sendRedirect("../userauthadd.jsp?t=0");
	}	
%>