Package org.apache.commons.dbutils

Examples of org.apache.commons.dbutils.ResultSetHandler

89
90
91
92
93
94
95
96
97
98
99
      final QueryRunner runner = new QueryRunner();
      final ArrayList<String> stores = new ArrayList<String>();

      Hermes.ui.getDefaultMessageSink().add("Getting message stores....");

      runner.query(connection, statements.getStoresStatement(), new ResultSetHandler()
      {
         public Object handle(ResultSet rs) throws SQLException
         {
            while (rs.next())
            {
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
      final QueryRunner runner = new QueryRunner();

      Hermes.ui.getDefaultMessageSink().add("Getting message store destinations....");

      runner.query(connection, "select distinct destination, domain from stores where storeId=? ", new Object[] { storeId },
            new ResultSetHandler()
            {
               public Object handle(ResultSet rs) throws SQLException
               {
                  while (rs.next())
                  {
View Full Code Here
344
345
346
347
348
349
350
351
352
353
354
   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
79
80
81
82
83
84
85
86
87
88
89
                qr.update(con, "insert into ArticleTag(tag, articleId) values(?, ?)", tag, article.id);
            }
            StringBuilder sb = new StringBuilder();
            sb.append(qr.query("select count(*) from Article where authorId=?", new ScalarHandler<Number>(), getLoginUser().id));
            final Map<String, Integer> tagMap = new HashMap<String, Integer>();
            qr.query(con, "select at.tag, count(at.tag) from Article a join ArticleTag at on a.id=at.articleId where a.authorId=? group by at.tag", new ResultSetHandler() {
                @Override
                public Object handle(ResultSet rs) throws SQLException {
                    while (rs.next()) {
                        tagMap.put(rs.getString(1), rs.getInt(2));
                    }
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
    *           Class to bind object to.
    * @return List
    */
   public List getList(final String sql, final Class clazz) {
      try{
         final ResultSetHandler bean = new BeanListHandler(clazz);
         return (List) runner.query(conn, sql, null, bean);
      }catch (final SQLException e){
         if(GlobalSettings.logActive)
            new LogEngine().logMessage(e.getStackTrace().toString(), GlobalSettings.logPath, "ERROR");
         throw new RuntimeException(e);
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    *
    * @return Object
    */
   public Object getObject(final String sql, final Class clazz) {
      try{
         final ResultSetHandler bean = new BeanHandler(clazz);
         return runner.query(conn, sql, null, bean);
      }catch (final SQLException e){
         if(GlobalSettings.logActive)
            new LogEngine().logMessage(e.getStackTrace().toString(), GlobalSettings.logPath, "ERROR");
         throw new RuntimeException(e);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
        assertEquals("1", results.get(0));
        assertEquals("4", results.get(1));
    }

    public void testColumnIndexHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler(2);
        List results = (List) h.handle(this.rs);

        assertNotNull(results);
        assertEquals(ROWS, results.size());

        assertEquals("2", results.get(0));
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
        assertEquals("2", results.get(0));
        assertEquals("5", results.get(1));
    }

    public void testColumnNameHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler("Three");
        List results = (List) h.handle(this.rs);

        assertNotNull(results);
        assertEquals(ROWS, results.size());

        assertEquals("3", results.get(0));
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
        assertEquals("3", results.get(0));
        assertEquals("6", results.get(1));
    }

    public void testEmptyResultSetHandle() throws SQLException {
        ResultSetHandler h = new ColumnListHandler();
        List results = (List) h.handle(this.emptyResultSet);

        assertNotNull(results);
        assertTrue(results.isEmpty());
    }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
    public ScalarHandlerTest(String name) {
        super(name);
    }

    public void testHandle() throws SQLException {
        ResultSetHandler h = new ScalarHandler();
        Object results = h.handle(this.rs);
        assertNotNull(results);
        assertEquals("1", results);
    }
View Full Code Here
TOP

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

  • hermes.store.schema.DefaultJDBCAdapter
  • nz.co.transparent.client.controller.GenericController
  • nz.co.transparent.client.controller.GenericTransactionController
  • nz.co.transparent.client.controller.LoginController
  • nz.co.transparent.client.controller.SpecificController
  • nz.co.transparent.client.controller.SystemDBController
  • nz.co.transparent.client.util.Parameter
  • org.apache.commons.dbutils.handlers.ArrayHandlerTest
  • org.apache.commons.dbutils.handlers.ArrayListHandlerTest
  • org.apache.commons.dbutils.handlers.BeanHandlerTest
    • 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.