package?com.java1234.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

import?com.java1234.model.Auth;
import?com.java1234.model.User;
import?com.java1234.util.StringUtil;

public?class?AuthDao?{

	public?JSONArray?getAuthByParentId（Connection?conString?parentIdString?authIds）throws?Exception{
		JSONArray?jsonArray=new?JSONArray（）;
		String?sql=“select?*?from?t_auth?where?parentId=??and?authId?in?（“+authIds+“）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?parentId）;
		ResultSet?rs=pstmt.executeQuery（）;
		while（rs.next（））{
			JSONobject?jsonobject=new?JSONobject（）;
			jsonobject.put（“id“?rs.getInt（“authId“））;
			jsonobject.put（“text“?rs.getString（“authName“））;
			if（!hasChildren（con?rs.getString（“authId“）?authIds））{
				jsonobject.put（“state“?“open“）;
			}else{
				jsonobject.put（“state“?rs.getString（“state“））;				
			}
			jsonobject.put（“iconCls“?rs.getString（“iconCls“））;
			JSONobject?attributeobject=new?JSONobject（）;
			attributeobject.put（“authPath“?rs.getString（“authPath“））;
			jsonobject.put（“attributes“?attributeobject）;
			jsonArray.add（jsonobject）;
		}
		return?jsonArray;
	}
	
	private?boolean?hasChildren（Connection?conString?parentIdString?authIds）throws?Exception{
		String?sql=“select?*?from?t_auth?where?parentId=??and?authId?in?（“+authIds+“）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?parentId）;
		ResultSet?rs=pstmt.executeQuery（）;
		return?rs.next（）;
	}
	
	public?JSONArray?getAuthsByParentId（Connection?conString?parentIdString?authIds）throws?Exception{
		JSONArray?jsonArray=this.getAuthByParentId（con?parentIdauthIds）;
		for（int?i=0;i			JSONobject?jsonobject=jsonArray.getJSONobject（i）;
			if（“open“.equals（jsonobject.getString（“state“）））{
				continue;
			}else{
				jsonobject.put（“children“?getAuthsByParentId（conjsonobject.getString（“id“）authIds））;
			}
		}
		return?jsonArray;
	}
	
	public?JSONArray?getCheckedAuthByParentId（Connection?conString?parentIdString?authIds）throws?Exception{
		JSONArray?jsonArray=new?JSONArray（）;
		String?sql=“select?*?from?t_auth?where?parentId=??“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?parentId）;
		ResultSet?rs=pstmt.executeQuery（）;
		while（rs.next（））{
			JSONobject?jsonobject=new?JSONobject（）;
			int?authId=rs.getInt（“authId“）;
			jsonobject.put（“id“?authId）;
			jsonobject.put（“text“?rs.getString（“authName“））;
			jsonobject.put（“state“?rs.getString（“state“））;
			jsonobject.put（“iconCls“?rs.getString（“iconCls“））;
			if（StringUtil.existStrArr（authId+““?authIds.split（““）））{
				jsonobject.put（“checked“?true）;
			}
			JSONobject?attributeobject=new?JSONobject（）;
			attributeobject.put（“authPath“?rs.getString（“authPath“））;
			jsonobject.put（“attributes“?attributeobject）;
			js

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????4347??2014-01-09?08:37??基于角色的權限系統\源碼及文檔\db_rbps.sql

?????文件????????725??2013-12-10?07:48??基于角色的權限系統\源碼及文檔\Rbps\.classpath

?????文件???????1037??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.project

?????文件????????503??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\.jsdtscope

?????文件????????364??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\org.eclipse.jdt.core.prefs

?????文件????????466??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\org.eclipse.wst.common.component

?????文件????????305??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2013-12-10?07:33??基于角色的權限系統\源碼及文檔\Rbps\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6674??2014-01-09?08:06??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\dao\AuthDao.class

?????文件???????4147??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\dao\RoleDao.class

?????文件???????4781??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\dao\UserDao.class

?????文件???????1945??2014-01-07?07:41??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\model\Auth.class

?????文件????????813??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\model\PageBean.class

?????文件???????1619??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\model\Role.class

?????文件???????2106??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\model\User.class

?????文件????????982??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\util\DateUtil.class

?????文件???????1633??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\util\DbUtil.class

?????文件???????1483??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\util\JsonUtil.class

?????文件????????951??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\util\ResponseUtil.class

?????文件????????814??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\util\StringUtil.class

?????文件???????7029??2014-01-09?08:11??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\web\AuthServlet.class

?????文件???????6731??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\web\RoleServlet.class

?????文件???????8097??2014-01-07?07:25??基于角色的權限系統\源碼及文檔\Rbps\build\classes\com\java1234\web\UserServlet.class

?????文件???????6913??2014-01-09?08:06??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\dao\AuthDao.java

?????文件???????3202??2014-01-01?08:39??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\dao\RoleDao.java

?????文件???????4027??2013-12-27?08:29??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\dao\UserDao.java

?????文件???????1513??2014-01-07?07:41??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\model\Auth.java

?????文件????????533??2013-12-20?08:01??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\model\PageBean.java

?????文件???????1227??2014-01-01?08:41??基于角色的權限系統\源碼及文檔\Rbps\src\com\java1234\model\Role.java

............此處省略657個文件信息