Package org.apache.commons.dbutils

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

109
110
111
112
113
114
115
116
117
118
119
        long t0 = System.currentTimeMillis();
        while (System.currentTimeMillis() - t0 < 20000)
        {
            Object[] rs =
                (Object[]) qr.query(jdbcConnector.getConnection(), "SELECT COUNT(*) FROM TEST WHERE TYPE = 2", new ArrayHandler());
            assertNotNull(rs);
            assertEquals(1, rs.length);
            if (((Number)rs[0]).intValue() > 0)
            {
                break;
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
            }
            Thread.sleep(100);
        }

        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 + " Received", obj2[0]);
    }
}
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
        + id;
    QueryRunner qr = DbHelper.getQueryRunner();
    List list = null;
    Comment comment = null;
    try {
      list = (List) qr.query(sql, new BeanListHandler(Comment.class));
      comment = (Comment) list.get(0);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    request.setAttribute("comment", comment);
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    String sql = "select comment_id as id,comment_username as username,comment_content as content ,comment_created_time as createdTime from comment order by comment_id desc";
    QueryRunner qr = DbHelper.getQueryRunner();
    List list = null;
    try {
      list = (List) qr.query(sql, new BeanListHandler(Comment.class));
    } catch (SQLException e) {
      e.printStackTrace();
    }
    request.setAttribute("list", list);
    request.getRequestDispatcher("/admin/adminCommentList.jsp").forward(
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
    QueryRunner qr = DbHelper.getQueryRunner();
    List list = null;
    User user = null;
    // 获取用户信息
    try {
      list = (List) qr
          .query(sql, new BeanListHandler(User.class), params);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    // 判断是否合法用户 并把User对象放入Session中
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
            String sql = "select category_id as id,category_name as name,category_level as level from category order by category_level desc, category_id desc";
            QueryRunner qr = DbHelper.getQueryRunner();
            List list = null;
            try {
                list = (List) qr.query(sql, new BeanListHandler(Category.class));
            } catch (SQLException e) {

                e.printStackTrace();
            }
            request.setAttribute("list", list);
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
                        + id;
                String categorySql = "select category_id as id,category_name as name,category_level as level from category";
                QueryRunner qr = DbHelper.getQueryRunner();

                // 分别从两张表中读取数据 分类表中用于下拉菜单
                List blogList = (List) qr.query(blogSql, new BeanListHandler(
                        Blog.class));
                List categoryList = (List) qr.query(categorySql,
                        new BeanListHandler(Category.class));
                Blog blog = (Blog) blogList.get(0);
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
                QueryRunner qr = DbHelper.getQueryRunner();

                // 分别从两张表中读取数据 分类表中用于下拉菜单
                List blogList = (List) qr.query(blogSql, new BeanListHandler(
                        Blog.class));
                List categoryList = (List) qr.query(categorySql,
                        new BeanListHandler(Category.class));
                Blog blog = (Blog) blogList.get(0);

                request.setAttribute("blog", blog);
                request.setAttribute("list", categoryList);
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
            String categorySql = "select category_id as id,category_name as name from category order by category_level,category_id desc";
            String commentSql = "select comment_id as id,comment_username as username,comment_content as content,comment_created_time as createdTime from comment";
            // DBUTIL的核心类 生成对象时 传递数据源对象
            QueryRunner qr = DbHelper.getQueryRunner();
            // 使用BeanList构建对象List
            List blogList = (List) qr.query(blogSql, new BeanListHandler(
                    Blog.class));
            List categoryList = (List) qr.query(categorySql,
                    new BeanListHandler(Category.class));
            List commentList = (List) qr.query(commentSql, new BeanListHandler(
                    Comment.class));
View Full Code Here
220
221
222
223
224
225
226
227
228
229
230
            // DBUTIL的核心类 生成对象时 传递数据源对象
            QueryRunner qr = DbHelper.getQueryRunner();
            // 使用BeanList构建对象List
            List blogList = (List) qr.query(blogSql, new BeanListHandler(
                    Blog.class));
            List categoryList = (List) qr.query(categorySql,
                    new BeanListHandler(Category.class));
            List commentList = (List) qr.query(commentSql, new BeanListHandler(
                    Comment.class));
            // 向JSP页面发送对象list
            request.setAttribute("blogList", blogList);
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.