xactoradd.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	Enumeration xenum = request.getParameterNames();
	String tmp = "", actorname="",pname="",mname="",cid="";
	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("actorname")==0)
		{
			actorname = request.getParameter("actorname");
			//out.println("actorname  = "+actorname);
		}
		else if(tmp.compareTo("cid")==0)
		{
			cid = request.getParameter("cid");
			//out.println("cid  = "+cid);
		}
		else if(tmp.compareTo("submit")==0)
		{
			
		}
		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));
		}
	}
			//out.println("ll.size()  = "+ll.size());
	if(actorname==null)
	{
			//response.sendRedirect("../actoradd.jsp?t=1");
	}
	else
	{
		
		if((ll.size()>0)&&(ll.size()==llx.size()))
		{			 
			String sql="";	
			dbc.getConnection();
			String cnt = dbc.getSpecialValue("select count(distinct actorname) from actors");
			String actorid= Integer.toString(Integer.parseInt(cnt)+1);
			//out.println(cnt+","+actorid);
			
			if(dbc.getCount("select count(*) from actors where cid="+cid+" and actorname='"+actorname+"'")>0)
			{
					response.sendRedirect("../actoradd.jsp?t=2");//??????
			}
			else
			{
				for(int x=0;x<ll.size();x++)
				{
					tmp = (String)ll.get(x);
					pname = (String)llr.get(x);
					mname = (String)llx.get(x);
					if((pname==null)||(pname.length()<1))
					continue;
				   {	 
						sql = "insert into actors(actorname,programname,modelname,actorid,cid) values('"+actorname+"','"+(String)llx.get(x)+"','"+(String)llr.get(x)+"','"+actorid+"','"+cid+"')";
					//	out.println((sql)+"<br>");
						dbc.update(charset.ISO_2_GBK(sql));	
					}
				 }
			}
			dbc.close();
		}
		response.sendRedirect("../actoradd.jsp?t=0");
	}	


%>