Example usage for org.apache.commons.dbutils QueryRunner QueryRunner

Introduction

In this page you can find the example usage for org.apache.commons.dbutils QueryRunner QueryRunner.

Prototype

public QueryRunner() 

Source Link

Document

Constructor for QueryRunner.

Usage

From source file:name.marcelomorales.siqisiqi.bonecp.DataSourceProviderTest.java

@Test
public void testStatistics() throws Exception {
    Config config = ConfigFactory.parseString("bonecp.url=\"jdbc:derby:memory:dbstats;create=true\"")
            .withFallback(ConfigFactory.load());

    DataSourceProvider dsp = new DataSourceProvider(config);

    assertNull(dsp.getStatistics());//from w w w. jav  a 2  s.  c  om

    DataSource dataSource = dsp.get();

    Connection connection = dataSource.getConnection();

    connection.createStatement().execute("CREATE TABLE TABLETEST1 (ACOLUMN VARCHAR(10))");
    connection.commit();

    QueryRunner queryRunner = new QueryRunner();
    queryRunner.update(connection, "INSERT INTO TABLETEST1 VALUES ('AAA')");
    queryRunner.update(connection, "INSERT INTO TABLETEST1 VALUES (?)", "BBB");
    queryRunner.update(connection, "INSERT INTO TABLETEST1 VALUES (?)", "CCC");
    connection.commit();

    List<String> values = queryRunner.query(connection, "SELECT * FROM TABLETEST1 ORDER BY ACOLUMN ASC",
            new ColumnListHandler<String>());

    connection.commit();

    connection.close();

    assertEquals("AAA", values.get(0));
    assertEquals("BBB", values.get(1));
    assertEquals("CCC", values.get(2));

    Statistics statistics = dsp.getStatistics();
    assertTrue(statistics.getCacheHits() > 0);
    assertTrue(statistics.getCacheMiss() > 0);
    assertEquals(1, statistics.getConnectionsRequested());
    assertEquals(4, statistics.getStatementsPrepared());

    dsp.close();
}

---

From source file:epgtools.epgdbbean.bean.Programme.ProgrammeGetterTest.java

private ProgrammeChannelNo_ReadOnly chooseAppropriately(Connection con) throws SQLException {
    //?????????1??
    QueryRunner runner = new QueryRunner();
    List<ProgrammeChannelNo> Programmes;
    Programmes = runner.query(con, SELECT_ALL_CHANNEL_VIEW,
            new BeanListHandler<ProgrammeChannelNo>(ProgrammeChannelNo.class));
    Iterator<ProgrammeChannelNo> j = Programmes.iterator();

    Random rnd = new Random();
    int ran = rnd.nextInt(Programmes.size()) + 1;
    ProgrammeChannelNo p = null;/*from w  ww. ja  v  a  2s. c om*/

    int i = 1;
    while (j.hasNext()) { //Iterator????? 
        p = j.next();
        if (ran == i) {
            break;
        }
        i++;
    }
    return p;
}

---

From source file:it.attocchi.db.DbUtilsConnector.java

public <T> List<T> execute(boolean keepConnOpen, String aQuery, Class<T> clazz, Object... params)
        throws Exception {
    List<T> result = new ArrayList<T>();

    // No DataSource so we must handle Connections manually
    QueryRunner run = new QueryRunner();

    try {/*from  ww w  . j  a va  2  s  .co  m*/

        /*
         * Sembra che il like con i parametri ufficiali non funzioni, forse
         * dovuto al fatto che son tutti object
         */
        logger.debug(aQuery);
        result = run.query(getConnection(), aQuery, getResultSetHandler(clazz), params);

    } finally {
        if (!keepConnOpen)
            close();
    }

    return result;
}

---

From source file:com.ouc.cpss.dao.BaseDao.java

/**
 * ?//from   ww w  .  j  a v a 2 s  .  c  om
 *
 * @param sql
 * @param clazz
 * @return
 */
public List query(String sql, Class clazz, Object[] params) {
    List beans = null;
    Connection conn = null;
    try {
        conn = getConnection();
        QueryRunner qRunner = new QueryRunner();
        beans = (List) qRunner.query(conn, sql, new BeanListHandler(clazz), params);

        //BeanListHandler?ResultSet???List?
        //????ResultSet
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
    return beans;
}

---

From source file:net.orpiske.ssps.common.db.AbstractDao.java

/**
 * Runs an UPDATE/INSERT/DELETE statement
 * @param query The query (statement) to run
 * @param args The arguments to the query
 * @return The number of affected rows//from w  ww  .  ja  va  2 s .c  o  m
 * @throws SQLException If unable to perform the operation
 */
protected int runUpdate(String query, Object... args) throws SQLException {
    Connection conn = databaseManager.getConnection();

    QueryRunner run = new QueryRunner();

    return run.update(conn, query, args);
}

---

From source file:com.odap.server.scheduler.JobManager.java

public synchronized List<Map<String, String>> refreshJobs() {

    logger.info("Entering refreshJobs()");

    try {/*from   www  .  j  av  a2s  . c  o m*/
        QueryRunner qRunner = new QueryRunner();

        List<Map<String, Object>> mapList = (List<Map<String, Object>>) qRunner.query(conn,
                "SELECT jobs.*, servers.account_id,servers.server_name FROM jobs,servers where servers.id = jobs.server_id",
                new MapListHandler());

        processJobs(mapList);

    } catch (Exception e) {
        System.err.println("Cannot connect to database server");
        e.printStackTrace();
    }

    logger.info("Exiting refreshJobs()");
    return null;
}

---

From source file:io.apiman.gateway.engine.jdbc.JdbcRegistry.java

/**
 * @see io.apiman.gateway.engine.IRegistry#publishApi(io.apiman.gateway.engine.beans.Api, io.apiman.gateway.engine.async.IAsyncResultHandler)
 *///from  w  w w . j a va  2s.co m
@Override
public void publishApi(Api api, IAsyncResultHandler<Void> handler) {
    Connection conn = null;
    try {
        conn = ds.getConnection();
        conn.setAutoCommit(false);
        QueryRunner run = new QueryRunner();

        // First delete any record we might already have.
        run.update(conn, "DELETE FROM gw_apis WHERE org_id = ? AND id = ? AND version = ?", //$NON-NLS-1$
                api.getOrganizationId(), api.getApiId(), api.getVersion());

        // Now insert a row for the api.
        String bean = mapper.writeValueAsString(api);
        run.update(conn, "INSERT INTO gw_apis (org_id, id, version, bean) VALUES (?, ?, ?, ?)", //$NON-NLS-1$
                api.getOrganizationId(), api.getApiId(), api.getVersion(), bean);

        DbUtils.commitAndClose(conn);
        handler.handle(AsyncResultImpl.create((Void) null, Void.class));
    } catch (SQLException | JsonProcessingException e) {
        handler.handle(AsyncResultImpl.create(e));
    }
}

---

From source file:azkaban.trigger.JdbcTriggerLoader.java

@Override
public List<Trigger> getUpdatedTriggers(long lastUpdateTime) throws TriggerLoaderException {
    logger.info("Loading triggers changed since " + new DateTime(lastUpdateTime).toString());
    Connection connection = getConnection();

    QueryRunner runner = new QueryRunner();
    ResultSetHandler<List<Trigger>> handler = new TriggerResultHandler();

    List<Trigger> triggers;

    try {/*  w  w w. j av a 2s .com*/
        triggers = runner.query(connection, GET_UPDATED_TRIGGERS, handler, lastUpdateTime);
    } catch (SQLException e) {
        logger.error(GET_ALL_TRIGGERS + " failed.");

        throw new TriggerLoaderException("Loading triggers from db failed. ", e);
    } finally {
        DbUtils.closeQuietly(connection);
    }

    logger.info("Loaded " + triggers.size() + " triggers.");

    return triggers;
}

---

From source file:framework.retrieval.engine.index.all.database.impl.rdAbstract.DefaultRDatabaseIndexAllImpl.java

/**
 * ?SQL??/*from  www. ja va2  s .  c o  m*/
 * @param limitSql         SQL
 * @param params         SQL?
 * @return
 */
@SuppressWarnings("unchecked")
public List<Map> getResult(String limitSql, Object[] params) {
    Connection conn = getConnection();

    QueryRunner qRunner = new QueryRunner();
    ResultSetHandler rsh = new MapListHandler();
    List<Map> result = null;

    try {
        if (params != null && params.length > 0) {
            result = (List<Map>) qRunner.query(conn, limitSql, rsh, params);
        } else {
            result = (List<Map>) qRunner.query(conn, limitSql, rsh);
        }
    } catch (SQLException e) {
        throw new RetrievalIndexException(e);
    } finally {
        close(conn);
    }

    return result;
}

---

From source file:com.itdaoshi.discuz.dao.CdbUcMembersDAObject.java

@Override
protected Long getNextPrimaryID() {
    QueryRunner run = new QueryRunner();
    ResultSetHandler h = new ResultSetHandler() {
        public Object handle(ResultSet rs) throws SQLException {
            if (!rs.next()) {
                return null;
            }//from   w w w.java 2s .  co  m

            ResultSetMetaData meta = rs.getMetaData();
            int cols = meta.getColumnCount();
            Object[] result = new Object[cols];

            for (int i = 0; i < cols; i++) {
                result[i] = rs.getObject(i + 1);
            }

            return result;
        }
    };
    try {
        Object[] result = (Object[]) run.query(conn, "SELECT MAX(uid) FROM CDB_UC_MEMBERS ", h);
        return (Long) result[0] + 1;
        // do something with the result
    } catch (Exception e) {
        e.printStackTrace();

    }

    return null;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• »