Package org.apache.commons.dbutils.handlers

Examples of org.apache.commons.dbutils.handlers.BeanListHandler

154
155
156
157
158
159
160
161
162
163
164
165
166
167
                        + 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);

                request.setAttribute("blog", blog);
                request.setAttribute("list", categoryList);
                request.getRequestDispatcher("/admin/editBlog.jsp").forward(
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
            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));
            // 向JSP页面发送对象list
            request.setAttribute("blogList", blogList);
            request.setAttribute("categoryList", categoryList);
            request.setAttribute("commentList", commentList);
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
                String sql = "select blog_id as id ,blog_title as title,blog_content as content ,blog_created_time as createdTime from blog order by blog_id desc";

                QueryRunner qr = DbHelper.getQueryRunner();
                // 使用BeanList构建对象List
                List list = (List) qr.query(sql,
                        new BeanListHandler(Blog.class));

                // 向JSP页面发送对象list

                request.setAttribute("list", list);
                request.getRequestDispatcher("/admin/adminBlogList.jsp").forward(request, response);
View Full Code Here
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
        List commentsList = null;
        List categoryList = null;
        try {

            // 使用BeanList构建对象List 存放一个博文信息
            blogContent = (List) qr.query(blogSql, new BeanListHandler(Blog.class));
            blog = (Blog) blogContent.get(0);

            blogList = (List) qr.query(blogListSql, new BeanListHandler(
                    Blog.class));
            commentList = (List) qr.query(commentSql, new BeanListHandler(
                    Comment.class));
            commentsList = (List) qr.query(commentsSql, new BeanListHandler(
                    Comment.class));
            categoryList = (List) qr.query(categorySql, new BeanListHandler(
                    Category.class));
        } catch (SQLException e) {
            e.printStackTrace();
        }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
        + id;
    QueryRunner qr = DbHelper.getQueryRunner();
    Category category = null;
    try {
      List list = (List) qr.query(sql,
          new BeanListHandler(Category.class));
      category = (Category) list.get(0);
    } catch (SQLException e) {
      e.printStackTrace();
    }
    request.setAttribute("category", category);
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
    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
TOP

Related Classes of org.apache.commons.dbutils.handlers.BeanListHandler

  • cn.chen.core.DBhelp
  • com.eatle.db.QueryHelper
  • com.firefly.db.QueryHelper
  • com.firefly.schedule.db.QueryHelper
  • com.marknv.blog.BlogServlet
  • com.marknv.blog.CategoryServlet
  • com.marknv.blog.CommentServlet
  • com.marknv.blog.UserServlet
  • com.pe.pgn.clubpgn.dao.hibernate.GenericDaoHibernate
  • org.boxsql.persistenceEngine.PersistenceEngine
    • 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.