一、前言

上次分享了增加书籍信息功能，今天分享点击树形菜单查询书籍状态功能，搜索和上架下架功能还未完善

二、树形菜单跳转

三、结果图

1、未上架

2、已上架

3、已下架

四、实现

首先整个查询书籍状态的Dao类

package com.liubiao.dao;

import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.liubiao.entity.Book;
import com.liubiao.entity.Permission;
import com.liubiao.util.BaseDao;
import com.liubiao.util.BuildTree;
import com.liubiao.util.PageBean;
import com.liubiao.util.PinYinUtil;
import com.liubiao.util.StringUtils;
import com.liubiao.vo.TreeVo;
import com.mysql.fabric.xmlrpc.base.Data;

public class BookDao extends BaseDao<Book> {
	
	/**
	 * 是直接从数据库获取到的数据
	 * @param permission
	 * @param pageBean
	 * @return
	 * @throws InstantiationException
	 * @throws IllegalAccessException
	 * @throws SQLException+
	 */
	public List<Book> list(Book book,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
		int state = book.getState();
		String sql="select * from t_easyui_book where true ";
		//判断state字段（1：未上架，2：已上架，3：已下架）是否为空，不为空拼接查询条件
		if(state != 0) {
			sql += " and state="+state;
		}
		return super.executeQuery(sql, Book.class, pageBean);
	}
	
}

处理查询条件的Action类

package com.liubiao.web;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.liubiao.dao.BookDao;
import com.liubiao.entity.Book;
import com.liubiao.framework.ActionSupport;
import com.liubiao.framework.ModelDriven;
import com.liubiao.util.DataGridResult;
import com.liubiao.util.PageBean;
import com.liubiao.util.ResponseUtil;
import com.liubiao.util.Result;

public class BookAction extends ActionSupport implements ModelDriven<Book> {
	
	private Book book = new Book();
	private BookDao bookDao = new BookDao();
	
	public String datagrid(HttpServletRequest req, HttpServletResponse resp) throws Exception{
		PageBean pageBean = new PageBean();
		pageBean.setRequest(req);
		List<Book> list = this.bookDao.list(book, pageBean);
		ResponseUtil.writeJson(resp, DataGridResult.ok(pageBean.getTotal()+"",list));
		return null;
	}

	@Override
	public Book getModel() {
		// TODO Auto-generated method stub
		return book;
	}
	
}

处理界面数据的函数文件

$(function(){
	
	//获取项目的名称
	var ss = $("#ss").val();
	//获取树形菜单未上架已上架已下架跳转路径的state值（1/2/3）
	var url = window.location.href;
	var s = url.split('=')[1];
	
	$('#dg').datagrid({    
	    url:ss+'/book.action?methodName=datagrid&state='+s, 
	    pagination:true,
	    toolbar: '#tb',
	    columns:[[    
	        {field:'id',title:'id',width:160},
	        {field:'name',title:'书籍名称',width:160},
	        {field:'pinyin',title:'拼音',width:160,align:'right'}   ,
	        {field:'cid',title:'书籍类别',width:160},
	        {field:'author',title:'作者',width:160},
	        {field:'price',title:'价格',width:160},
	        {field:'image',title:'图片',width:100,
	        	formatter: function(value,row,index){
	        		return '<img src="'+ ss + value +'" height="50px" />'
	        	}
	        },
	        {field:'publishing',title:'出版社',width:160},
	        {field:'deployTime',title:'上架时间',width:160} ,
	        {field:'xxx',title:'操作',width:160,
	        	formatter: function(value,row,index){
	        		if(s==1){
	        			return '<a href="javascript:void(0)" οnclick="toNo()">上架</a>&nbsp;&nbsp;&nbsp<a href="javascript:void(0)" οnclick="del()">移除</a>';
	        		}
	        		if(s==2){
	        			return '<a href="javascript:void(0)" οnclick="toNo()">下架</a>&nbsp;&nbsp;&nbsp<a href="javascript:void(0)" οnclick="del()">移除</a>';
	        		}
	        		if(s==3){
	        			return '<a href="javascript:void(0)" οnclick="toNo()">上架</a>&nbsp;&nbsp;&nbsp<a href="javascript:void(0)" οnclick="del()">移除</a>';
	        		}
				}
	        } 
	    ]]
	});
	
})

显示数据的界面

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%-- <%@taglib prefix="l" uri="/liubiao" %> --%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<!-- 全局样式 -->
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/themes/default/easyui.css">   
<!-- 定义图标 -->
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/themes/icon.css">   
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/jquery.min.js"></script>
<!-- 组件库源码的js文件 -->   
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-easyui-1.5.1/jquery.easyui.min.js"></script> 
<-- 界面运行后进入处理界面数据展示的函数方法文件 -->
<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/book1.js"></script>
<title>书籍状态</title>
</head>
<body height="100%">
	
	<input type="hidden" id="ss" value="${pageContext.request.contextPath }" />
	
	<div id="tb" >
		<input id="tex" />
		<input type="button" value="搜索" />
	</div>
	
	<div id=div>
		<table id="dg" style="width: 100%;" ></table>
	</div> 
	
</body>
</html>