Easyui项目之门户功能新书上架、热门书籍

新书上架以及热门书籍

原理：查询已上架的所有书籍，并且以时间降序进行显示

难点：页面的渲染

第一步：dao层方法（BookDao）

新书上架

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

 热门书籍

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

 

第二步：web层（BookAction）

新书上架

public void news(HttpServletRequest req, HttpServletResponse resp) {
		// TODO Auto-generated method stub
		try {
			List<Book> list = bookDao.news(null, null);
			ResponseUtil.writeJson(resp, list);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

热门书籍

public void hots(HttpServletRequest req, HttpServletResponse resp) {
		// TODO Auto-generated method stub
		try {
			List<Book> list = bookDao.hots(null, null);
			ResponseUtil.writeJson(resp, list);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

第三步：修改index页面的ajax

新书上架 

$(function () {
    	//var jsonstr='[{"id":1,"name":"文艺"},{"id":2,"name":"小说"},{"id":3,"name":"青春"},{"id":4,"name":"童书"},{"id":5,"name":"励志"},{"id":6,"name":"生活"},{"id":7,"name":"人文社科"},{"id":8,"name":"经营"},{"id":9,"name":"科技"},{"id":10,"name":"教育"},{"id":11,"name":"工具书"},{"id":12,"name":"期刊"}]';
    	
        //   上架新书
        $.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;
            }
        });

热门书籍

$.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;
            }
        });

结果展示：

 没图片是因为上架的是一些没图片的  这里看着格式这么乱也是没插图