Examples of com.eforce.baby.auth.vo.RolePrivilegeVO

   */
  public ArrayList getRoleSelectedPrivileges(String dsName, String dbType, String roleId) 
  throws DAOException, SQLException
  {
    Connection con = super.createConnection(dsName);
    RolePrivilegeVO privilege = null;
    ArrayList privilegeList = new ArrayList();
    PreparedStatement pstmt = null;
    ResultSet rset = null;
      
    try {
      String sql = QueryManager.getInstance().getFindRoleSelectedPrivilegeQuery(dbType);
      pstmt = con.prepareStatement(sql);
      pstmt.setString( 1, roleId );
      log.debug(sql);
      rset = pstmt.executeQuery();


      while(rset.next())
      {
        privilege = new RolePrivilegeVO();
        privilege.setId(rset.getString(1));
        privilege.setPrivilegeName(rset.getString(2));
    
        privilegeList.add(privilege);
      }
  
    }

   */
  public ArrayList getAllPrivileges(String dsName, String dbType)
  throws DAOException, SQLException
  {
    Connection con = super.createConnection(dsName);
    RolePrivilegeVO privilege = null;
    ArrayList privilegeList=new ArrayList();
    PreparedStatement pstmt=null;
    ResultSet rset=null;
      
    try {
      String sql = QueryManager.getInstance().getFindAllPrivilegeQuery(dbType);
      pstmt = con.prepareStatement(sql);
      log.debug(sql);
      rset = pstmt.executeQuery();


      while(rset.next())
      {
        privilege = new RolePrivilegeVO();
        privilege.setId(rset.getString(1));
        privilege.setPrivilegeName(rset.getString(2));
    
        privilegeList.add(privilege);
      }
  
    }

Related Classes of com.eforce.baby.auth.vo.RolePrivilegeVO

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.