easyUI之datagrid（数据表格）使用

public class Book {

private int bid;

private String bname;

private float price;

public int getBid() {

return bid;

}

public void setBid(int bid) {

this.bid = bid;

}

public String getBname() {

return bname;

}

public void setBname(String bname) {

this.bname = bname;

}

public float getPrice() {

return price;

}

public void setPrice(float price) {

this.price = price;

}

@Override

public String toString() {

return “Book [bid=” + bid + “, bname=” + bname + “, price=” + price + “]”;

}

}

建立BookDao

package com.zking.dao;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import com.fasterxml.jackson.databind.ObjectMapper;

import com.zking.entity.Book;

import com.zking.util.BaseDao;

import com.zking.util.PageBean;

import com.zking.util.StringUtils;

public class BookDao extends BaseDao {

public List list(Book book, PageBean pageBean) throws Exception {

String bname = book.getBname();

String sql = “select * from t_mvc_book where 1=1”;

if (StringUtils.isNotBlank(bname)) {

sql += “and bname like '%” + bname + “%'”;

}

return super.executeQuery(sql, Book.class, pageBean);