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

Introduction

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

Prototype

public int update(String sql, Object... params) throws SQLException 

Source Link

Document

Executes the given INSERT, UPDATE, or DELETE SQL statement.

Usage

From source file:org.mule.transport.jdbc.functional.AbstractJdbcFunctionalTestCase.java

protected void populateTable() throws Exception {
    QueryRunner qr = jdbcConnector.getQueryRunner();
    int updated;/*w w  w  .java  2s. c om*/
    updated = qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA) VALUES (1, '" + TEST_VALUES[0] + "')");
    logger.debug(updated + " rows updated");
    updated = qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA) VALUES (2, '" + TEST_VALUES[1] + "')");
    logger.debug(updated + " rows updated");
    updated = qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA) VALUES (3, '" + TEST_VALUES[2] + "')");
    logger.debug(updated + " rows updated");
}

---

From source file:org.mule.transport.jdbc.functional.IdempotencyTestCase.java

@Override
protected void createTable() throws Exception {
    super.createTable();
    QueryRunner qr = jdbcConnector.getQueryRunner();
    qr.update(jdbcConnector.getConnection(),
            "CREATE TABLE IDS(K VARCHAR(255) NOT NULL PRIMARY KEY, VALUE VARCHAR(255))");
}

---

From source file:org.mule.transport.jdbc.functional.IdempotencyTestCase.java

@Override
protected void deleteTable() throws Exception {
    super.deleteTable();
    QueryRunner qr = jdbcConnector.getQueryRunner();
    qr.update(jdbcConnector.getConnection(), "DELETE FROM IDS");
}

---

From source file:org.mule.transport.jdbc.functional.JdbcBridgeFunctionalTestCase.java

protected void doTestBridge() throws Exception {
    QueryRunner queryRunner = jdbcConnector.getQueryRunner();
    Connection connection = jdbcConnector.getConnection();

    for (int i = 0; i < TEST_ROWS; i++) {
        queryRunner.update(connection, "INSERT INTO TEST(TYPE, DATA) VALUES (1, 'Test " + i + "')");
    }//from   ww w.  j  av  a  2  s  .  c  om
    List<?> results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST WHERE TYPE = 1",
            new ArrayListHandler());
    assertEquals(TEST_ROWS, results.size());

    long t0 = System.currentTimeMillis();
    while (true) {
        results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST_OUT", new ArrayListHandler());
        logger.info("Results found: " + results.size());
        if (results.size() >= TEST_ROWS) {
            break;
        }
        results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST WHERE TYPE = 2",
                new ArrayListHandler());
        logger.info("Locked records found: " + results.size());
        assertTrue(TEST_ROWS >= results.size());

        results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST WHERE TYPE = 1",
                new ArrayListHandler());
        logger.info("Original records found: " + results.size());
        assertTrue(TEST_ROWS >= results.size());

        assertTrue(System.currentTimeMillis() - t0 < 20000);
        Thread.sleep(500);
    }
}

---

From source file:org.mule.transport.jdbc.functional.JdbcFunctionalTestCase.java

@Test
public void testDirectSql() throws Exception {
    MuleClient client = new MuleClient(muleContext);
    MuleMessage message = client.request("jdbc://SELECT * FROM TEST", 1000);
    assertResultSetEmpty(message);/* www .  ja  va 2  s. c  om*/

    QueryRunner qr = jdbcConnector.getQueryRunner();
    int updated = qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA) VALUES (1, '" + TEST_MESSAGE + "')");
    assertEquals(1, updated);
    message = client.request("jdbc://SELECT * FROM TEST", 1000);
    assertResultSetNotEmpty(message);
}

---

From source file:org.mule.transport.jdbc.functional.JdbcFunctionalTestCase.java

@Test
public void testReceive() throws Exception {
    MuleClient client = new MuleClient(muleContext);
    MuleMessage message = client.request("jdbc://getTest?type=1", 1000);
    assertResultSetEmpty(message);//  www . ja  v a2s . c om

    QueryRunner qr = jdbcConnector.getQueryRunner();
    int updated = qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA, ACK, RESULT) VALUES (1, '" + TEST_MESSAGE + "', NULL, NULL)");
    assertEquals(1, updated);

    message = client.request("jdbc://getTest?type=1", 1000);
    assertResultSetNotEmpty(message);
}

---

From source file:org.mule.transport.jdbc.functional.JdbcFunctionalTestCase.java

@Test
public void testReceiveAndSend() throws Exception {
    QueryRunner qr = jdbcConnector.getQueryRunner();
    qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA, ACK, RESULT) VALUES (1, '" + TEST_MESSAGE + "', NULL, NULL)");

    long t0 = System.currentTimeMillis();
    while (System.currentTimeMillis() - t0 < 20000) {
        Object[] rs = (Object[]) qr.query(jdbcConnector.getConnection(),
                "SELECT COUNT(*) FROM TEST WHERE TYPE = 2", new ArrayHandler());
        assertNotNull(rs);/*from w  w w  .  j  ava  2 s .  c o m*/
        assertEquals(1, rs.length);
        if (((Number) rs[0]).intValue() > 0) {
            break;
        }
        Thread.sleep(100);
    }

    Object[] obj2 = (Object[]) qr.query(jdbcConnector.getConnection(), "SELECT DATA FROM TEST WHERE TYPE = 2",
            new ArrayHandler());
    assertNotNull(obj2);
    assertEquals(1, obj2.length);
    assertEquals(TEST_MESSAGE + " Received", obj2[0]);
}

---

From source file:org.mule.transport.jdbc.store.JdbcObjectStoreTestCase.java

@Override
protected void doSetUp() throws Exception {
    super.doSetUp();
    JdbcObjectStore<?> store = muleContext.getRegistry().get("jdbcObjectStore");
    QueryRunner qr = store.getJdbcConnector().getQueryRunner();

    try {//from w ww  .j a  va2s. c  o  m
        qr.update(store.getJdbcConnector().getConnection(), "DELETE FROM IDS");
    } catch (Exception e) {
    }

    try {
        qr.update(store.getJdbcConnector().getConnection(),
                "CREATE TABLE IDS(K VARCHAR(255) NOT NULL PRIMARY KEY, VALUE VARCHAR(255))");
    } catch (Exception e) {
    }

    logger.debug("Table created");
}

---

From source file:org.nmdp.gl.service.id.jdbc.MysqlJdbcIdSupplier.java

private Long nextSequence(final String name) {
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {//from   www.j a  v  a 2  s.  c  o  m
        queryRunner.update(UPDATE_SQL, name);
        return (Long) queryRunner.query(SELECT_SQL, new ScalarHandler(), name);
    } catch (SQLException e) {
        logger.warn("could not select next sequence value for sequence " + name, e);
    }
    // todo:  return random value if fails?
    return null;
}

---

From source file:org.okinawaopenlabs.orientdb.client.ConnectionUtilsJdbcImpl.java

@Override
public int update(Connection conn, String sql) throws SQLException {
    if (logger.isDebugEnabled()) {
        logger.debug(String.format("update(conn=%s, sql=%s) - start ", conn, sql));
    }/*from  w ww.j av  a 2  s  .c o m*/
    QueryRunner qRunner = new QueryRunner();
    int rows = qRunner.update(conn, sql);
    if (logger.isDebugEnabled()) {
        logger.debug(String.format("update(rows=%s) - end ", rows));
    }
    return rows;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• »