Package org.jallinone.system.gridmanager.server

Examples of org.jallinone.system.gridmanager.server.JAIODbPermissionsDescriptor


      try {
        conn = ConnectionManager.getConnection(null);
        stmt = conn.createStatement(); // used for secondary query on SYS02...
        ResultSet rset = null;

        JAIODbPermissionsDescriptor dbPermissionsDescriptor = new JAIODbPermissionsDescriptor();
        String sql =
          "select "+
          dbPermissionsDescriptor.getFunctionIdFieldNameInGridPermissionsTable()+","+
          dbPermissionsDescriptor.getColumnsAttributeFieldNameInGridPermissionsTable()+","+
          dbPermissionsDescriptor.getEditableColumnsInInsertFieldNameInGridPermissionsTable()+","+
          dbPermissionsDescriptor.getEditableColumnsInEditFieldNameInGridPermissionsTable()+","+
          dbPermissionsDescriptor.getColumnsMandatoryFieldNameInGridPermissionsTable()+","+
          dbPermissionsDescriptor.getColumnsVisibilityFieldNameInGridPermissionsTable()+" "+
          "from "+dbPermissionsDescriptor.getGridPermissionsTableName()+" where ";
        String functionId = null;
        for(int j=0;j<userRoles.size();j++) {
          sql += " (";
          for(int i=0;i<dbPermissionsDescriptor.getRoleIdFieldNamesInGridPermissionsTable().length;i++)
            sql += dbPermissionsDescriptor.getRoleIdFieldNamesInGridPermissionsTable()[i]+"=? or ";
          sql = sql.substring(0,sql.length()-3);
          sql += ") and ";
        }
        sql = sql.substring(0,sql.length()-4);
        sql += " order by "+dbPermissionsDescriptor.getFunctionIdFieldNameInGridPermissionsTable();
        pstmt = conn.prepareStatement(sql);
        Object roleId =null;
        int count = 1;
        Iterator it = userRoles.keySet().iterator();
        while(it.hasNext()) {
View Full Code Here

TOP

Related Classes of org.jallinone.system.gridmanager.server.JAIODbPermissionsDescriptor

Copyright © 2018 www.massapicom. All rights reserved.
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.