Package org.apache.commons.dbutils

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

26
27
28
29
30
31
32
33
34
35
36
    public static List<Map<String, String>> selectData(String query, DataSource dataSource) throws SQLException
    {
        QueryRunner qr = new QueryRunner(dataSource);

        @SuppressWarnings({"unchecked"})
        List<Map<String, String>> result = (List<Map<String, String>>) qr.query(query, new MapListHandler());

        return result;
    }

    public static void assertExpectedUpdateCount(int expected, int actual)
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    for (Field field : fields) {
      ORMColumn oc = field.getAnnotation(ORMColumn.class);
      if (oc != null && oc.physicalPkFld() && oc.autoIncrement()) {
        // 找到最后一个自增id
        QueryRunner qr = new QueryRunner();
        Object identityVal = qr.query(conn, selectKey.getQuery(), new ScalarHandler<Object>());
        Long identity = NumberUtils.parseNumber(identityVal.toString(), Long.class);
       
        field.setAccessible(true);
        // 填充到所有当中
        for (int i = objs.length - 1; i >= 0; i--) {
View Full Code Here
779
780
781
782
783
784
785
786
787
788
789
   */
  protected <T> T query(String sql, Object[] args, ResultSetHandler<T> resultSetExtractor) throws DataAccessException {
    QueryRunner qr = getQueryRunner();
    logger.debug("Query SQL:{}", sql);
    try {
      return qr.query(sql, resultSetExtractor, pearParams(args));
    } catch (SQLException e) {
      throw new DataAccessException("Query error!", e);
    }
  }
 
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
        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();
        while (true)
        {
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
        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;
            }
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
            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());
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
            }
            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);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        // Send a message to trigger nested query on JDBC outbound endpoint to execute.
        MuleClient client = muleContext.getClient();
        client.send("vm://in", "some test data", null);

        // Assert that query executed correctly.
        List<?> results = (List<?>) queryRunner.query(connection, "SELECT * FROM TEST", new ArrayListHandler());
        assertEquals(1, results.size());

        // Try to dispose gracefully.
        try
        {
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        MuleClient client = muleContext.getClient();
        client.send("jdbc://writeTest?type=2", new DefaultMuleMessage(TEST_MESSAGE, muleContext));

        QueryRunner qr = jdbcConnector.getQueryRunner();
        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, obj2[0]);
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
        map.put("data", TEST_MESSAGE);
        client.send("jdbc://writeMap?type=2", new DefaultMuleMessage(map, muleContext));

        QueryRunner qr = jdbcConnector.getQueryRunner();
        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, obj2[0]);
    }
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.