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

Class org.apache.commons.dbutils.QueryRunner

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

org.apache.commons.dbutils.QueryRunner.query()
Execute an SQL SELECT query with a single replacement parameter. The caller is responsible for connection cleanup. @param conn The connection to execute the query in. @param sql The query to execute. @param param The replacement parameter. @param rsh The handler that converts the results into an object. @return The object returned by the handler. @throws SQLException

            // 使用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

                // 查询博文的SQL语句
                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);

View Full Code Here

          updatedAt = Objects.firstNonNull(row.get(REVIEW_UPDATED_AT), ONE_YEAR_AGO);
          if ((Boolean) row.get(REVIEW_MANUAL_VIOLATION)) {
            reporter = referentials.userLogin((Long) row.get(REVIEW_REPORTER_ID));
          }


          List<Map<String, Object>> comments = runner.query(readConnection, ReviewCommentsHandler.SQL + reviewId, new ReviewCommentsHandler());
          for (Map<String, Object> comment : comments) {
            comment.put(ISSUE_KEY, issueKey);
            allComments.add(comment);
          }
        }

View Full Code Here

    Connection con = null;
    Object object = null;
    QueryRunner queryRunner = new QueryRunner();
        try {          
             con = SessionFactoryUtils.getDataSource(getSessionFactory()).getConnection();
             object = queryRunner.query(con, sql, filterKeys, resultSetHandler);
            
        } catch (SQLException e) {
          log.info(e.getMessage());
        } finally{
          try {

View Full Code Here

    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

   */
  protected <T> T queryPaginated(DataSource dataSource, String sql, Object[] args, ResultSetHandler<T> resultSetExtractor) throws DataAccessException {
    QueryRunner qr = getPaginatedQueryRunner(dataSource);
    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

   */
  protected <T> T query(DataSource dataSource, String sql, Object[] args, ResultSetHandler<T> resultSetExtractor) throws DataAccessException {
    QueryRunner qr = getPaginatedQueryRunner(dataSource);
    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

   */
  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

        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(

View Full Code Here


            // 使用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));

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

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.