Examples of com.workingdogs.village.QueryDataSet

com.workingdogs.village.QueryDataSet
h the first 10 records for ( int i = 0; i < qds.size(); i++ ) { Record rec = qds.getRecord(i); int value = rec.getValue("column").asInt(); System.out.println ( "The value is: " + value ); } qds.close(); It is important to always remember to close() a QueryDataSet in order to free the allocated resources.
@author Jon S. Stevens @version $Revision: 564 $

            // Get a connection to the db.
            db = TurbineDB.getConnection(dbName);
            Connection connection = db.getConnection();


            // Execute the query.
            qds = new QueryDataSet( connection, query );


            // Continue getting rows until the memory limit is
            // reached, all results have been retrieved, or the rest
            // of the results have been determined to be irrelevant.
            while( !killThread &&

View Full Code Here

                                      DBConnection dbCon)
        throws Exception
    {
        Connection connection = dbCon.getConnection();


        QueryDataSet qds = null;
        Vector results = new Vector();
        try
        {
            // execute the query
            qds = new QueryDataSet( connection, queryString );
            results = getSelectResults( qds, start, numberOfResults,
                                        singleRecord);
        }
        finally
        {
            if (qds != null) qds.close();
        }
        return results;
    }

View Full Code Here

                {
                    stmt.setString(i + 1, param.toString());
                }
            }
        
            QueryDataSet qds = null;
            try
            {
                qds = new QueryDataSet( stmt.executeQuery() );
                v = getSelectResults(qds);
            }
            finally
            {
                if (qds != null)
                {
                    qds.close();
                }
            }
        }
        finally
        {

View Full Code Here

            // Get a connection to the db.
            db = TurbineDB.getConnection(dbName);
            Connection connection = db.getConnection();


            // Execute the query.
            qds = new QueryDataSet( connection, query );


            // Continue getting rows until the memory limit is
            // reached, all results have been retrieved, or the rest
            // of the results have been determined to be irrelevant.
            while( !killThread &&

View Full Code Here

        throws Exception
    {
        String idSql = dbAdapter.getIDMethodSQL(keyInfo);


        // Execute the query.
        QueryDataSet qds = new QueryDataSet( connection, idSql );
        Record rec;
        try
        {
            qds.fetchRecords(1);
            rec = qds.getRecord(0);  // Records are 0 based.
        }
        finally
        {
            if (qds != null) qds.close();
        }
        return rec.getValue(1); // Values are 1 based.
    }

View Full Code Here

                                      Object keyInfo)
        throws Exception
    {
        String idSQL = dbAdapter.getIDMethodSQL(keyInfo);
        Value id = null;
        QueryDataSet qds = null;
        try
        {
            qds = new QueryDataSet(connection, idSQL);
            qds.fetchRecords(1);
            Record rec = qds.getRecord(0);
            id = rec.getValue(1);
        }
        finally
        {
            if (qds != null)
            {
                qds.close();
            }
        }
        return id;
    }

View Full Code Here

                                      DBConnection dbCon)
        throws Exception
    {
        Connection connection = dbCon.getConnection();


        QueryDataSet qds = null;
        Vector results = new Vector();
        try
        {
            // execute the query
            qds = new QueryDataSet( connection, queryString );
            results = getSelectResults( qds, start, numberOfResults,
                                        singleRecord);
        }
        finally
        {
            if (qds != null) qds.close();
        }
        return results;
    }

View Full Code Here

                {
                    stmt.setString(i + 1, param.toString());
                }
            }


            QueryDataSet qds = null;
            try
            {
                qds = new QueryDataSet( stmt.executeQuery() );
                v = getSelectResults(qds);
            }
            finally
            {
                if (qds != null)
                {
                    qds.close();
                }
            }
        }
        finally
        {

View Full Code Here

    public static List<TurbineUser> resultSet2Objects(java.sql.ResultSet results)
            throws TorqueException
    {
        try
        {
            QueryDataSet qds = null;
            List<Record> rows = null;
            try
            {
                qds = new QueryDataSet(results);
                rows = getSelectResults(qds);
            }
            finally
            {
                if (qds != null)
                {
                    qds.close();
                }
            }


            return populateObjects(rows);
        }

View Full Code Here

    public static List<TurbineRolePermission> resultSet2Objects(java.sql.ResultSet results)
            throws TorqueException
    {
        try
        {
            QueryDataSet qds = null;
            List<Record> rows = null;
            try
            {
                qds = new QueryDataSet(results);
                rows = getSelectResults(qds);
            }
            finally
            {
                if (qds != null)
                {
                    qds.close();
                }
            }


            return populateObjects(rows);
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.workingdogs.village.QueryDataSet

org.apache.jetspeed.om.apps.coffees.BaseCoffeesPeer

org.apache.jetspeed.om.apps.email.BaseEmailInboxPeer

org.apache.jetspeed.om.dbpsml.BaseJetspeedGroupProfilePeer

org.apache.jetspeed.om.dbpsml.BaseJetspeedRoleProfilePeer

org.apache.jetspeed.om.dbpsml.BaseJetspeedUserProfilePeer

org.apache.jetspeed.om.dbregistry.BaseMediatypePeer

org.apache.jetspeed.om.dbregistry.BasePortletCategoryPeer

org.apache.jetspeed.om.dbregistry.BasePortletDbEntryPeer

org.apache.jetspeed.om.dbregistry.BasePortletMediatypePeer

org.apache.jetspeed.om.dbregistry.BasePortletParameterPeer

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.