xuseraddactor.jsp

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

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="check.jsp" %>
<%
	String tmp = "", actorname="",username="";
	actorname = charset.ISO_2_GBK(request.getParameter("xxxx"));
	username= charset.ISO_2_GBK(request.getParameter("user"));
		
	//out.println(actorname+","+username);
		
	if(actorname==null)
	{
			response.sendRedirect("../useraddactor.jsp?t=1");
	}
	else
	{
		String sql="",programname="",modelname="";
		dbc.getConnection();
		sql = "select id,programname,modelname from actors where actorname='"+actorname+"'";
		
		//out.println("sql="+sql);
		
		ResultSet rs = dbc.getRS(sql);
		while(rs.next())
		{
			modelname = charset.ISO_2_GBK(rs.getString(3));
			programname = charset.ISO_2_GBK(rs.getString(2));
			
			//out.println(modelname+","+programname+","+rs.getString(1));
			
			if(dbc.getCount("select count(*) from userauth where programname='"+programname+"' and user='"+username+"'")>0)
			{
				//已经存在该权限
				continue;
			}
			else
			{				
				String sql1="insert into userauth(user,modelname,programname,authid,grantbyuser) values('"+username+"','"+modelname+"','"+programname+"','"+rs.getString(1)+"','admin')";
				//out.println("sql3="+sql1);
				dbc.update(sql1);
			}
		}
		rs = null;
		dbc.close();
		//out.println(">>=============>>>>>");		
		response.sendRedirect("../useraddactor.jsp?t=0");
	}	
%>