Easyui and mvc 项目05——新书上架及门户首页

一、 新书上架

dao和Action

dao  根据时间降序：

//新书上架
    public List<Book> news(Book book,PageBean pageBean) throws Exception {
        String sql="select * from t_easyui_book where state=2 order by deployTime desc limit 8";
        return super.executeQuery(sql, Book.class, pageBean);
    }

Action：

public void news(HttpServletRequest req, HttpServletResponse resp) {
        try {
            List<Book> list = bookDao.news(book, null);
            ResponseUtil.writeJson(resp, list);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

index.jsp界面：

调用news方法进行跳转 
$(function () {
    	
        //   上架新书
        $.ajax({
            url: '${pageContext.request.contextPath}/book.action?methodName=news',
            dataType: "json",
            data: "rows=18",
            success: function (data) {
                // data = eval(data);
                // $(".c-category").next().append("444");
                console.log(data);
                single_item($(".c-category:eq(0)"), data, 0, "");
 
                // debugger;
            }
        });

 二、热门书籍

dao和Action

dao：

//热门书籍
        public List<Book> hots(Book book,PageBean pageBean) throws Exception {
            String sql="select * from t_easyui_book where state=2 order by sales desc limit 8";
            return super.executeQuery(sql, Book.class, pageBean);
        }

Action：

public void hots(HttpServletRequest req, HttpServletResponse resp) {
        try {
            List<Book> list = bookDao.hots(book, null);
            ResponseUtil.writeJson(resp, list);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

 index.jsp界面进行跳转：

//   热销书籍
        $.ajax({
            url: '${pageContext.request.contextPath}/book.action?methodName=hots',
            dataType: "json",
            data: "rows=18",
            success: function (data) {
                // data = eval(data);
                // $(".c-category").next().append("444");
                console.log(data);
                single_item($(".c-category:eq(1)"), data, 0, "");
 
                // debugger;
            }
        });