List of ExecuteSQL() Examples

Examples of ExecuteSQL()

com.cosmo.data.DataAgent.executeSql()
Ejecuta una sent�ncia SQL que puede devolver un conjunto de datos o no. @param sql Una cadena que contiene la sent�ncia SQL a ejecutar. @return Una instancia de {@link ResultSet} con los datos obtenidos (s�lo si la tent�ncia es de consulta). @throws DataException
net.sourceforge.jivalo.cnfmgr.persistent.client.PersistentConnectorClient.executeSql()
Executes the query which updates the database. The PreparedStatementParameter array will be used for setting values in the prepared statement. @param sqlString a SQL statement that updates the database. @param parameters parameters passed to the prepared statement. @param resourceName name of resource. @return the number of rows affected by the query. @exception Exception if error occurs.
net.sourceforge.jivalo.cnfmgr.persistent.impl.PersistentConnectorImpl.executeSql()
Executes the query which updates the database. The PreparedStatementParameter array will be used for setting values in the prepared statement. @param sqlString a SQL statement that updates the database. @param parameters parameters passed to the prepared statement. @param resourceName name of resource. @return the number of rows affected by the query. @exception PersistentStorageException if error occurs.
org.apache.empire.samples.spring.db.SampleDB.executeSQL()
org.eclipse.persistence.sessions.DatabaseSession.executeSQL()
org.gdal.ogr.DataSource.ExecuteSQL()
org.objectstyle.wolips.eomodeler.core.sql.IEOSQLGenerator.executeSQL()

Examples of com.cosmo.data.DataAgent.executeSql()


         // Obtiene la lista de roles
         sql = "SELECT * " +
               "FROM " + TABLE_ROLES + " " +
               "ORDER BY roleid";
         ResultSet rs = conn.executeSql(sql);
         while (rs.next())
         {
            roles.add(readRole(rs));
         }
      }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

         // Obtiene la lista de roles del usuario
         sql = "SELECT * " +
               "FROM     " + TABLE_ROLES + " Inner Join " + TABLE_USER_ROLES + " On (" + TABLE_ROLES + ".roleid=" + TABLE_USER_ROLES + ".roleid) " +
               "WHERE    " + TABLE_USER_ROLES + ".usrlogin='" + DataAgent.sqlFormatTextValue(login) + "' " + 
               "ORDER BY " + TABLE_ROLES + ".roleid";
         ResultSet rs = conn.executeSql(sql);
         while (rs.next())
         {
            roles.add(readRole(rs));
         }
      }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()


         // Obtiene la lista de actividades
         sql = "SELECT * " +
               "FROM " + TABLE_ACTIVITIES + " " +
               "ORDER BY actid";
         ResultSet rs = conn.executeSql(sql);
         while (rs.next())
         {
            activities.add(readActivity(rs));
         }
      }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

         sql = "SELECT   " + TABLE_ACTIVITIES + ".* " +
               "FROM     " + TABLE_ROLES + " Inner Join " + TABLE_ROLE_ACTIVITIES + " On (" + TABLE_ROLES + ".roleid=" + TABLE_ROLE_ACTIVITIES + ".roleid) " +
               "                             Inner Join " + TABLE_ACTIVITIES + " On (" + TABLE_ROLE_ACTIVITIES + ".actid=" + TABLE_ACTIVITIES + ".actid) " +
               "WHERE    " + TABLE_ROLES + ".roleid = '" + DataAgent.sqlFormatTextValue(roleId) + "' " +
               "ORDER BY " + TABLE_ACTIVITIES + ".actid";
         ResultSet rs = conn.executeSql(sql);
         while (rs.next())
         {
            activities.add(readActivity(rs));
         }
      }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

               "                                  Inner Join " + TABLE_ROLE_ACTIVITIES + " On (" + TABLE_ROLES + ".roleid = " + TABLE_ROLE_ACTIVITIES + ".roleid) " +
               "                                  Inner Join " + TABLE_ACTIVITIES + "      On (" + TABLE_ROLE_ACTIVITIES + ".actid = " + TABLE_ACTIVITIES + ".actid) " +
               "WHERE    " + TABLE_USER_ROLES + ".usrlogin = '" + DataAgent.sqlFormatTextValue(login) + "' " +
               "ORDER BY " + TABLE_ROLE_ACTIVITIES + ".actid";


         ResultSet rs = conn.executeSql(sql);
         while (rs.next())
         {
            permissions.add(new Permission(readActivity(rs), true));
         }
      }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()


         conn = DataFactory.getInstance(workspace);
         // ds = this.workspace.getProperties().getDataProperties().getDataSource();
         // conn = new DataConnection(ds);
         // conn.connect();
         ResultSet rs = conn.executeSql(sql);
         if (rs.next())
         {
            user = new User();
            user.setLogin(rs.getString("usrlogin"));
            user.setMail(rs.getString("usrmail"));

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()


         conn = DataFactory.getInstance(workspace);
         // ds = this.workspace.getProperties().getDataProperties().getDataSource();
         // conn = new DataConnection(ds);
         // conn.connect();
         rs = conn.executeSql(sSQL);
         if (rs.next() && rs.getInt(1) > 0)
         {
            throw new UserAlreadyExistsException();
         }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

         sSQL = "SELECT   * " +
                "FROM     " + TABLE_NAME + " " +
                "ORDER BY usrlogin Asc";


         conn = DataFactory.getInstance(workspace);
         rs = conn.executeSql(sSQL);
         while (rs.next())
         {
            users.add(readUser(rs));
         }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

                "      usrname  LIKE '%" + DataAgent.sqlFormatTextValue(filter) + "%' Or " +
                "      usrmail  LIKE '%" + DataAgent.sqlFormatTextValue(filter) + "%' " +
                "ORDER BY usrlogin Asc";


         conn = DataFactory.getInstance(workspace);
         rs = conn.executeSql(sSQL);
         while (rs.next())
         {
            users.add(readUser(rs));
         }

View Full Code Here

Examples of com.cosmo.data.DataAgent.executeSql()

                "         usrcreated As Creat " +
                "FROM " + TABLE_NAME + " " +
                "ORDER BY usrlogin Asc";


         conn = DataFactory.getInstance(workspace);
         return conn.executeSql(sSQL);
      }
      catch (Exception ex)
      {
         throw new AuthenticationException(ex.getMessage(), ex);
      }

View Full Code Here

0 1 2

TOP

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.