Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.QueryRunner

72
73
74
75
76
77
78
79
80
81
82
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return new QueryRunner().update(con, sql);
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
100
101
102
103
104
105
106
107
108
109
110
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return new QueryRunner().update(con, sql);
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return (Object[])new QueryRunner().query(con, sql, new ArrayHandler());
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
65
66
67
68
69
70
71
72
73
        super.doTearDown();
    }

    protected void createTable() throws Exception
    {
        QueryRunner qr = jdbcConnector.getQueryRunner();
        qr.update(jdbcConnector.getConnection(), "CREATE TABLE TEST(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,TYPE INTEGER,DATA VARCHAR(255),ACK TIMESTAMP,RESULT VARCHAR(255))");
        logger.debug("Table created");
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
        logger.debug("Table created");
    }
   
    protected void deleteTable() throws Exception
    {
        QueryRunner qr = jdbcConnector.getQueryRunner();
        int updated = qr.update(jdbcConnector.getConnection(), "DELETE FROM TEST");
        logger.debug(updated + " rows deleted");
    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
91
92
        logger.debug(updated + " rows deleted");
    }
   
    protected void populateTable() throws Exception
    {
        QueryRunner qr = jdbcConnector.getQueryRunner();
        int updated;
        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");
    }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    {
        Connection con = null;
        try
        {
            con = jdbcConnector.getConnection();
            return (List)new QueryRunner().query(con, sql, new ArrayListHandler());
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    {
        Connection con = null;
        try
        {
            con = jdbcConnector.getConnection();
            return new QueryRunner().update(con, sql);
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
    @Override
    protected void doSetUp() throws Exception
    {
        super.doSetUp();
        JdbcObjectStore<?> store = muleContext.getRegistry().get("jdbcObjectStore");
        QueryRunner qr = store.getJdbcConnector().getQueryRunner();
       
        try
        {
            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)
        {
        }
View Full Code Here
89
90
91
92
93
94
95
96
97
        //Does not exist on either
        assertNull(c.getQuery(testJdbcEndpoint, "getTest4"));
        assertEquals("3", testJdbcEndpoint.getProperty("queryTimeout"));
       
        QueryRunner queryRunner = c.getQueryRunnerFor(testJdbcEndpoint);
        assertEquals(ExtendedQueryRunner.class, queryRunner.getClass());
        assertEquals(3, ((ExtendedQueryRunner) queryRunner).getQueryTimeout());
    }
View Full Code Here
TOP

Related Classes of org.apache.commons.dbutils.QueryRunner

  • br.gov.serpro.ouvidoria.util.freechart.data.DBUtilsKit
  • ch.inftec.ju.db.DbConnectionImpl$DbQueryRunnerImpl
  • cn.chen.core.DBhelp
  • cn.org.zeronote.orm.dao.DefaultCommonDao
  • cn.org.zeronote.orm.dao.dialect.AbstractPaginatedRepairer
  • cn.org.zeronote.orm.dao.dialect.MSSqlServerPaginatedRepairer
  • cn.org.zeronote.orm.dao.JdbcTxCommonDao
  • cn.org.zeronote.orm.extractor.IdentityFinder
  • com.bloidonia.vertx.mods.JdbcProcessor$BrokenPMDStatementFiller
  • com.bloidonia.vertx.mods.JdbcProcessor$MaybeBrokenPMDStatementFiller
    • Copyright © 2018 www.massapicom. 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.