Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.QueryRunner.update()

58
59
60
61
62
63
64
65
66
67
68
        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 + "')");
        }
        List<?> results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST WHERE TYPE = 1", new ArrayListHandler());
        assertEquals(TEST_ROWS, results.size());

        long t0 = System.currentTimeMillis();
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        {
            DataSource dataSource = getDefaultDataSource();
            connection = dataSource.getConnection();

            QueryRunner qr = new QueryRunner(dataSource);
            qr.update(connection, "DROP TABLE TestDdl");
        }
        catch (SQLException e)
        {
            // Ignore: table does not exist
        }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
    }

    public static void executeDdl(Connection connection, String ddl) throws SQLException
    {
        QueryRunner qr = new QueryRunner();
        qr.update(connection, ddl);
    }

    public void executeUpdate(Connection connection, String updateSql) throws SQLException
    {
        QueryRunner qr = new QueryRunner();
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }

    public void executeUpdate(Connection connection, String updateSql) throws SQLException
    {
        QueryRunner qr = new QueryRunner();
        int updated = qr.update(connection, updateSql);

        if (logger.isDebugEnabled())
        {
            logger.debug(updated + " rows updated");
        }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
    {
        QueryRunner qr = new QueryRunner();

        for (Planet planet : testValues)
        {
            int updated = qr.update(connection, getInsertPlanetSql(planet.getName(), planet.getPosition()));

            if (logger.isDebugEnabled())
            {
                logger.debug(updated + " rows updated");
            }
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
    {
        QueryRunner qr = new QueryRunner();

        for (Alien alien : testValues)
        {
            int updated = qr.update(connection, getInsertAlienSql(alien));

            if (logger.isDebugEnabled())
            {
                logger.debug(updated + " rows updated");
            }
View Full Code Here
796
797
798
799
800
801
802
803
804
805
806
   */
  protected int execute(String sql, Object[] args) throws DataAccessException {
    QueryRunner qr = getQueryRunner();
    logger.debug("Update SQL:{}", sql);
    try {
      return qr.update(sql, pearParams(args));
    } catch (SQLException e) {
      throw new DataAccessException("update sql error! sql:" + sql + ";", e);
    }
  }

View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
        JdbcObjectStore<?> store = muleContext.getRegistry().get("jdbcObjectStore");
        QueryRunner qr = store.getJdbcConnector().getQueryRunner();
       
        try
        {
            qr.update(store.getJdbcConnector().getConnection(), "DELETE FROM IDS");
        }
        catch (Exception e)
        {
        }
       
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
        {
        }
       
        try
        {
            qr.update(store.getJdbcConnector().getConnection(),
                "CREATE TABLE IDS(K VARCHAR(255) NOT NULL PRIMARY KEY, VALUE VARCHAR(255))");
        }
        catch (Exception e)
        {
        }
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
        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 + "')");
        }
        List<?> results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST WHERE TYPE = 1", new ArrayListHandler());
        assertEquals(TEST_ROWS, results.size());

        long t0 = System.currentTimeMillis();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.