xuseraddactor.jsp

来自「1.安装配置tomcat+mysql5环境； 2.执行sql.sql； 3.」· JSP 代码 · 共 48 行

<%@ 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");
	}	
%>