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:jp.gr.java_conf.ka_ka_xyz.processor.JPA20AnnotationProcessorPropertyAccessTest.java

@Test
public void testBindEmployeeByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Employee.class));
    ResultSetHandler<List<Jpa20Employee>> ersh = new BeanListHandler<Jpa20Employee>(Jpa20Employee.class, rp);
    String sql = "SELECT * from person INNER JOIN employee ON person.id = employee.person_id ORDER BY id ASC";
    List<Jpa20Employee> employees = run.query(conn, sql, ersh);
    assertEquals(3, employees.size());//from   w w w .j  a  va2  s . co  m
    assertEquals(new Jpa20Employee(1, "Howard", "Lovecraft", "EMP001", "Weird Tales Div."), employees.get(0));
    assertEquals(new Jpa20Employee(2, "August", "Derleth", "EMP002", "Arkham House Div."), employees.get(1));
    assertEquals(new Jpa20Employee(3, "Robert", "Bloch", "EMP003", "Weird Tales Div."), employees.get(2));
}

---

From source file:com.gs.obevo.dbmetadata.impl.dialects.Db2MetadataDialect.java

@Override
public ImmutableCollection<DaRoutine> searchExtraRoutines(final DaSchema schema, String procedureName,
        Connection conn) throws SQLException {
    QueryRunner query = new QueryRunner(); // using queryRunner so that we can reuse the connection

    String procedureClause = procedureName == null ? "" : " AND R.ROUTINENAME = '" + procedureName + "'";
    final String sql = "SELECT ROUTINENAME, SPECIFICNAME, TEXT FROM SYSCAT.ROUTINES R WHERE R.ROUTINETYPE = 'F'\n"
            + "AND R.ROUTINESCHEMA = '" + schema.getName() + "'\n" + procedureClause;
    LOG.debug("Executing function metadata query SQL: {}", sql);

    ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn, sql, new MapListHandler()))
            .toImmutable();//from   w  ww  .  j  a  v  a2s  .  co m

    if (LOG.isDebugEnabled()) {
        LOG.debug("Results:");
        for (Map<String, Object> map : maps) {
            LOG.debug("ROW: {}", map.toString());
        }
    }

    return maps.collect(new Function<Map<String, Object>, DaRoutine>() {
        @Override
        public DaRoutine valueOf(Map<String, Object> map) {
            return new DaRoutinePojoImpl((String) map.get("ROUTINENAME"), schema, DaRoutineType.function,
                    (String) map.get("SPECIFICNAME"), clobToString((Clob) map.get("TEXT")));
        }
    });
}

---

From source file:com.softberries.klerk.dao.GenericDao.java

/**
 * Initializes connection to the database
 * //from w  w  w .j a  v a  2  s  .  c o  m
 * @throws ClassNotFoundException
 * @throws SQLException
 */
public void init() throws ClassNotFoundException, SQLException {
    run = new QueryRunner();
    Class.forName("org.h2.Driver");
    conn = DriverManager.getConnection("jdbc:h2:" + this.filePath, "sa", "");
    conn.setAutoCommit(false);
}

---

From source file:dbutils.ExampleJDBC.java

/**
 * BeanListHandler ResultSet??ListList/*from   w ww .jav  a2s  .c  o  m*/
 */
public static void getBeanListData() {
    Connection conn = getConnection();
    QueryRunner qr = new QueryRunner();
    try {
        ResultSetHandler<Student> rsh = new BeanHandler(Student.class);
        Student usr = qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student WHERE id=1", rsh);
        System.out.println(StringUtils.center("findById", 50, '*'));
        System.out.println("id=" + usr.getId() + " name=" + usr.getName() + " gender=" + usr.getGender());

        List<Student> results = (List<Student>) qr.query(conn,
                "SELECT id, name, gender, age, team_id as teamId FROM test_student LIMIT 10",
                new BeanListHandler(Student.class));
        System.out.println(StringUtils.center("findAll", 50, '*'));
        for (Student result : results) {
            System.out.println(
                    "id=" + result.getId() + "  name=" + result.getName() + "  gender=" + result.getGender());
        }
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

---

From source file:com.pinterest.deployservice.db.DBUtilDAOImpl.java

@Override
public void releaseLock(String id, Connection connection) {
    try {/*from www  .  j  a  v a  2s .  co m*/
        new QueryRunner().query(connection, String.format(RELEASE_LOCK_TEMPLATE, id),
                SingleResultSetHandlerFactory.<Long>newObjectHandler());
    } catch (Exception e) {
        LOG.error("Failed to call releaseLock on id {}.", id, e);
    }
    DbUtils.closeQuietly(connection);
}

---

From source file:cn.itcast.bbs.dao.TopicDao.java

public void deleteTopicByTypeId(int typeId) throws SQLException {
    QueryRunner runner = new QueryRunner();
    String sql = "delete from topic where type_id = ?;";
    runner.update(JdbcUtil.getConnection(), sql, typeId);
}

---

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

/**
 * Runs a (SELECT) query that returns many results
 * @param query The query to run//from www .  ja  v  a 2 s.c  om
 * @param rs The result set handler to use
 * @param args The arguments to the query
 * @return A list of previously specified (generic) DTO types
 * @throws SQLException
 */
protected <T> List<T> runQueryMany(String query, AbstractListHandler<T> rs, Object... args)
        throws SQLException {
    Connection conn = databaseManager.getConnection();

    QueryRunner run = new QueryRunner();

    return run.query(conn, query, rs, args);

}

---

From source file:azkaban.executor.JdbcExecutorLoaderTest.java

@BeforeClass
public static void setupDB() {
    DataSource dataSource = DataSourceUtils.getMySQLDataSource(host, port, database, user, password,
            numConnections);/*  w ww. j a v  a  2 s  .c  o m*/
    testDBExists = true;

    Connection connection = null;
    try {
        connection = dataSource.getConnection();
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    CountHandler countHandler = new CountHandler();
    QueryRunner runner = new QueryRunner();
    try {
        runner.query(connection, "SELECT COUNT(1) FROM active_executing_flows", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    try {
        runner.query(connection, "SELECT COUNT(1) FROM execution_flows", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    try {
        runner.query(connection, "SELECT COUNT(1) FROM execution_jobs", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    try {
        runner.query(connection, "SELECT COUNT(1) FROM execution_logs", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    try {
        runner.query(connection, "SELECT COUNT(1) FROM executors", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    try {
        runner.query(connection, "SELECT COUNT(1) FROM executor_events", countHandler);
    } catch (SQLException e) {
        e.printStackTrace();
        testDBExists = false;
        DbUtils.closeQuietly(connection);
        return;
    }

    DbUtils.closeQuietly(connection);
}

---

From source file:com.versatus.jwebshield.securitylock.SecurityLockService.java

public SecurityLock processSecurityLock(int userId, String ip) throws SecurityLockException {
    QueryRunner run = new QueryRunner();
    Connection conn = null;/*from  w w w . j ava  2 s  .  c  om*/
    SecurityLock al = null;

    List<Object> params = new ArrayList<Object>(3);

    try {
        conn = dbHelper.getConnection();

        al = checkSecurityLock(userId, ip);

        logger.debug("lockAccount: TriesToLock=" + getTriesToLock());

        int r = 0;

        if (al.getTryCounter() >= getTriesToLock() && !al.isLock()) {
            params.add(true);
            params.add(userId);
            params.add(ip);
            r = run.update(conn, setlockSql, params.toArray());
        } else {
            params.add(userId);
            params.add(ip);
            // params.add(false);
            r = run.update(conn, insertlockSql, params.toArray());
        }

        al = checkSecurityLock(userId, ip);

        logger.debug("lockAccount: response=" + r);

    } catch (SQLException e) {
        logger.error("lockAccount", e);
        logger.debug("lockAccount: ErrorCode=", e.getErrorCode());
        throw new SecurityLockException("Unable to access security lock database", e);
    } finally {

        try {
            DbUtils.close(conn);
        } catch (SQLException e) {
            // ignore
        }
    }
    return al;
}

---

From source file:hermes.store.schema.DefaultJDBCAdapter.java

public Collection<String> getStores(Connection connection) throws SQLException {
    final QueryRunner runner = new QueryRunner();
    final ArrayList<String> stores = new ArrayList<String>();

    Hermes.ui.getDefaultMessageSink().add("Getting message stores....");

    runner.query(connection, statements.getStoresStatement(), new ResultSetHandler() {
        public Object handle(ResultSet rs) throws SQLException {
            while (rs.next()) {
                stores.add(rs.getString(1));
            }//from w w  w  .j a v  a  2s.c  o m
            return stores;
        }
    });

    Hermes.ui.getDefaultMessageSink().add("Getting message stores.... done.");

    return stores;
}

---

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