Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.QueryRunner

246
247
248
249
250
251
252
253
254
255
256
   }

   public QueueBrowser getMessages(Connection connection, String storeId, Destination destination, MessageFactory messageFactory,
         MessageStore.HeaderPolicy headerPolicy) throws SQLException, JMSException
   {
      final QueryRunner runner = new QueryRunner();
      final PreparedStatement stmt = createPreparedStatement(
            connection,
            "select stores.destination, stores.domain, messages.message, messages.messageid from stores, messages where stores.storeId=? and destination=? and stores.messageid = messages.messageid order by messages.messageid",
            new Object[] { storeId, messageFactory.getDestinationName(destination) });
View Full Code Here
259
260
261
262
263
264
265
266
267
268
269
   }

   public QueueBrowser getMessages(Connection connection, String storeId, final MessageFactory messageFactory, MessageStore.HeaderPolicy headerPolicy)
         throws SQLException, JMSException
   {
      final QueryRunner runner = new QueryRunner();
      final PreparedStatement stmt = createPreparedStatement(
            connection,
            "select stores.destination, stores.domain, messages.message, messages.messageid from stores, messages where stores.storeId=? and stores.messageid = messages.messageid order by messages.messageid",
            new Object[] { storeId });
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
         progressMonitor.setMillisToDecideToPopup(100);
         progressMonitor.setMillisToPopup(400);
      }

      final QueryRunner runner = new QueryRunner();

      for (int i = 0; i < statements.length; i++)
      {
         try
         {
            log.debug("executing: " + statements[i]);

            if (progressMonitor != null)
            {
               progressMonitor.setProgress(statements.length);
               progressMonitor.setNote("Executing statement " + i + " of " + statements.length);
            }

            runner.update(connection, statements[i]);
         }
         catch (SQLException ex)
         {
            log.error(ex.getMessage());
         }
View Full Code Here
308
309
310
311
312
313
314
315
316
317
318
319
320
   public void createStore(Connection connection, String storeId) throws SQLException
   {
      try
      {
         final QueryRunner runner = new QueryRunner();

         runner.update(connection, "insert into storeInfo values ( ? )", new Object[] { storeId });
      }
      catch (SQLException ex)
      {
         log.debug("swallowing " + ex.getMessage());
      }
View Full Code Here
341
342
343
344
345
346
347
348
349
350
351
352
353
      Hermes.ui.getDefaultMessageSink().add("Initialising message stores... done.");
   }

   public int getDepth(Connection connection, String storeId, Destination destination) throws SQLException, JMSException
   {
      final QueryRunner runner = new QueryRunner();

      return (Integer) runner.query(connection, statements.getDepthStatement(), new Object[] { storeId, JMSUtils.getDestinationName(destination) },
            new ResultSetHandler()
            {
               public Object handle(ResultSet rs) throws SQLException
               {
                  rs.next();
View Full Code Here
37
38
39
40
41
42
43
44
45
    ServletModule createServletModule() {
        return new ServletModule() {
            @Override
            protected void configureServlets() {
                bind(DataSource.class).toInstance(pool);
                bind(QueryRunner.class).toInstance(new QueryRunner(pool));
            }
        };
    }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
    public QueryRunnerProvider(ServletContext servletContext) throws Exception {
        Class.forName("org.h2.Driver");

        JdbcConnectionPool pool = JdbcConnectionPool.create("jdbc:h2:" + servletContext.getRealPath("/WEB-INF/h2") + ";LOCK_MODE=0", "sa", "");

        qr = new QueryRunner(pool);

        Object obj = qr.query("show tables", new ScalarHandler<Object>());
        if (obj == null) {
            //create tables
            StringBuilder sb = new StringBuilder();
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return (List) new QueryRunner().query(con, sql, new ArrayListHandler());
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return new QueryRunner().update(con, sql);
        }
        finally
        {
            JdbcUtils.close(con);
        }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    {
        Connection con = null;
        try
        {
            con = getConnection();
            return (List)new QueryRunner().query(con, sql, new ArrayListHandler());
        }
        finally
        {
            JdbcUtils.close(con);
        }
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.