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:DbUtilsUseBeanMySQL.java

public static void main(String[] args) {
    Connection conn = null;/* www . j  a  va 2 s  .  c  o m*/
    String jdbcURL = "jdbc:mysql://localhost/octopus";
    String jdbcDriver = "com.mysql.jdbc.Driver";
    String user = "root";
    String password = "root";

    try {
        DbUtils.loadDriver(jdbcDriver);
        conn = DriverManager.getConnection(jdbcURL, user, password);

        QueryRunner qRunner = new QueryRunner();
        List beans = (List) qRunner.query(conn, "select id, name from animals_table",
                new BeanListHandler(Employee.class));

        for (int i = 0; i < beans.size(); i++) {
            Employee bean = (Employee) beans.get(i);
            bean.print();
        }
    } catch (SQLException e) {
        // handle the exception
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

---

From source file:DbUtilsUseMapMySQL.java

public static void main(String[] args) {
    Connection conn = null;// ww w. j  av a2s.  c  om
    String jdbcURL = "jdbc:mysql://localhost/octopus";
    String jdbcDriver = "com.mysql.jdbc.Driver";
    String user = "root";
    String password = "root";

    try {
        DbUtils.loadDriver(jdbcDriver);
        conn = DriverManager.getConnection(jdbcURL, user, password);

        QueryRunner qRunner = new QueryRunner();

        List mapList = (List) qRunner.query(conn, "select id, name from animals_table", new MapListHandler());

        for (int i = 0; i < mapList.size(); i++) {
            Map map = (Map) mapList.get(i);
            System.out.println("id=" + map.get("id"));
            System.out.println("name=" + map.get("name"));
            System.out.println("-----------------");
        }

        System.out.println("DbUtils_UseMap_MySQL: end.");

    } catch (SQLException e) {
        // handle the exception
        e.printStackTrace();
    } finally {
        DbUtils.closeQuietly(conn);
    }
}

---

From source file:com.mum.edu.cs472.DbConnection.java

public static String resultSetToJson(String word) {
    try {// w ww  .  j a  va 2 s .  c  o  m
        //            Thread.sleep(8000);
    } catch (Exception e) {
    }
    Connection connection = getConnection();
    List<Map<String, Object>> listOfMaps = null;
    String query = "SELECT * FROM entries where lower(word)=Lower(?);";
    try {
        QueryRunner queryRunner = new QueryRunner();

        listOfMaps = queryRunner.query(connection, query, word, new MapListHandler());
    } catch (SQLException se) {
        throw new RuntimeException("Couldn't query the database.", se);
    } finally {
        DbUtils.closeQuietly(connection);
    }
    return new Gson().toJson(listOfMaps);
}

---

From source file:TilesMatchingCriteriaQueryCallable.java

public Tile[] call() throws Exception {

    CSLogger.sharedLogger().fine("Running query for tiles matching criteria (\"" + this.sql + "\")");

    // Run query//from  w  w w . j av a 2 s. co m
    List results = (List) (new QueryRunner().query(connection, "SELECT * FROM tiles WHERE " + this.sql + ";",
            new MapListHandler()));

    // Parse & return results
    Tile[] tiles = new Tile[results.size()];
    for (int i = 0; i < results.size(); i++) {
        tiles[i] = new Tile((HashMap) results.get(i));
    }
    return tiles;
}

---

From source file:azkaban.db.DatabaseTransOperatorImplTest.java

@Before
public void setUp() throws Exception {
    AzkabanDataSource datasource = new AzDBTestUtility.EmbeddedH2BasicDataSource();
    DatabaseTransOperator operator = new DatabaseTransOperatorImpl(new QueryRunner(),
            datasource.getConnection());
}

---

From source file:azkaban.db.DatabaseTransOperatorTest.java

@Before
public void setUp() throws Exception {
    final AzkabanDataSource datasource = new AzDBTestUtility.EmbeddedH2BasicDataSource();
    final DatabaseTransOperator operator = new DatabaseTransOperator(new QueryRunner(),
            datasource.getConnection());
}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.AnnotationProcessorFieldAccessTest.java

@Test
public void testBindPersonAccessByFieldAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());//from   w w w  .j a  va 2  s.com
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.AnnotationProcessorPropertyAccessTest.java

@Test
public void testBindPersonByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new AnnotationProcessor(Person.class));
    ResultSetHandler<List<Person>> prsh = new BeanListHandler<Person>(Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());//from   w w  w  .j  a va2  s .  c om
    assertEquals(new Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Person(3, "Robert", "Bloch"), persons.get(2));

}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.JPA20AnnotationProcessorFieldAccessTest.java

@Test
public void testBindPersonByFieldAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Person.class));
    ResultSetHandler<List<Jpa20Person>> prsh = new BeanListHandler<Jpa20Person>(Jpa20Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Jpa20Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());//from  w w w.  j  av  a2 s  . com
    assertEquals(new Jpa20Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Jpa20Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Jpa20Person(3, "Robert", "Bloch"), persons.get(2));

}

---

From source file:jp.gr.java_conf.ka_ka_xyz.processor.JPA20AnnotationProcessorPropertyAccessTest.java

@Test
public void testBindPersonByPropertyAccess() throws SQLException {
    Connection conn = getConnection();
    QueryRunner run = new QueryRunner();
    RowProcessor rp = new BasicRowProcessor(new JPA20AnnotationProcessor(Jpa20Person.class));
    ResultSetHandler<List<Jpa20Person>> prsh = new BeanListHandler<Jpa20Person>(Jpa20Person.class, rp);
    String sql = "SELECT * from person ORDER BY id ASC";
    List<Jpa20Person> persons = run.query(conn, sql, prsh);
    assertEquals(3, persons.size());/*  w w w . j a va  2 s . co m*/
    assertEquals(new Jpa20Person(1, "Howard", "Lovecraft"), persons.get(0));
    assertEquals(new Jpa20Person(2, "August", "Derleth"), persons.get(1));
    assertEquals(new Jpa20Person(3, "Robert", "Bloch"), persons.get(2));

}

---

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