easyui的datagrid之查询功能

datagrid查询案例

src

实体类 Book.java

package com.tang.entity;

import java.sql.Timestamp;

public class Book {
   
	
	private long id;
	private String name;
	private String pinyin;
	private long cid;
	private String author;
	private float price;
	private String image;
	private String publishing;
	private String description;
	private int state;
	private Timestamp deployTime;
	private int sales;
	public long getId() {
   
		return id;
	}
	public void setId(long id) {
   
		this.id = id;
	}
	public String getName() {
   
		return name;
	}
	public void setName(String name) {
   
		this.name = name;
	}
	public String getPinyin() {
   
		return pinyin;
	}
	public void setPinyin(String pinyin) {
   
		this.pinyin = pinyin;
	}
	public long getCid() {
   
		return cid;
	}
	public void setCid(long cid) {
   
		this.cid = cid;
	}
	public String getAuthor() {
   
		return author;
	}
	public void setAuthor(String author) {
   
		this.author = author;
	}
	public float getPrice() {
   
		return price;
	}
	public void setPrice(float price) {
   
		this.price = price;
	}
	public String getImage() {
   
		return image;
	}
	public void setImage(String image) {
   
		this.image = image;
	}
	public String getPublishing() {
   
		return publishing;
	}
	public void setPublishing(String publishing) {
   
		this.publishing = publishing;
	}
	public String getDescription() {
   
		return description;
	}
	public void setDescription(String description) {
   
		this.description = description;
	}
	public int getState() {
   
		return state;
	}
	public void setState(int state) {
   
		this.state = state;
	}
	public Timestamp getDeployTime() {
   
		return deployTime;
	}
	public void setDeployTime(Timestamp deployTime) {
   
		this.deployTime = deployTime;
	}
	public int getSales() {
   
		return sales;
	}
	public void setSales(int sales) {
   
		this.sales = sales;
	}
	@Override
	public String toString() {
   
		return "Book [id=" + id + ", name=" + name + ", pinyin=" + pinyin + ", cid=" + cid + ", author=" + author
				+ ", price=" + price + ", image=" + image + ", publishing=" + publishing + ", description="
				+ description + ", state=" + state + ", deployTime=" + deployTime + ", sales=" + sales + "]";
	}
	
	

}

BookDao.java

package com.tang.dao;

import java.sql.SQLException;
import java.util.List;

import com.tang.entity.Book;
import com.tang.util.BaseDao;
import com.tang.util.PageBean;
import com.tang.util.StringUtils;

public class BookDao extends BaseDao<Book> {
   
	
	public List<Book> list(Book book,PageBean pageBean) throws InstantiationException, IllegalAccessException, SQLException{
   
		String name = book.getName();
		String sql = "select * from t_easyui_book where true";
		if(StringUtils.isNotBlank(name)) {
   
			sql += " and name like '%"+name+"%'";
		}
		return super.executeQuery(sql, Book.class, pageBean);
	}
	
	//测试是否有数据
	public static void main(String[] args) throws InstantiationException, IllegalAccessException, SQLException {
   
		BookDao bookDao = new BookDao();
		Book book = new Book();
		List<Book> list = bookDao.list(book, null);
		for (Book b : list) {
   
			System.out.println(b);
		}
	}

}

DataGridRedult.java

package com.tang.util;

public class DataGridRedult<T> {
   
	
	private String total;
	private T rows;
	public String getTotal() {
   
		return total;
	}
	public void setTotal(String total) {
   
		this.total = total;
	}
	public T getRows() {
   
		return rows;
	}
	public void setRows(T rows) {
   
		this.rows &