Jfinal数据库基本操作(五) 缓存

ehcache.xml放置于WEB-INF 目录下

<?xml version="1.0" encoding="UTF-8"?>
<defaultCache
name ="stocklist"
maxElementsInMemory="10000"
eternal="false"
timeToIdleSeconds="120"
timeToLiveSeconds="120"
overflowToDisk="true"
maxElementsOnDisk="10000000"
diskPersistent="false"
diskExpiryThreadIntervalSeconds="120"
memoryStoreEvictionPolicy="LRU"

/>

 

public static Page<UserModel> paginate(int page,int pageSize,Integer sex,String name,String address) {
String select = "select * ";
StringBuffer sqlExceptSelect = new StringBuffer("from user");
boolean addWhere = false;
List<Object> parList = new ArrayList<Object>();
addWhere = AppendFiled(sex, "sex",sqlExceptSelect, addWhere, parList);
addWhere = AppendLike(name, "name",sqlExceptSelect, addWhere, parList);
addWhere = AppendLike(address, "address",sqlExceptSelect, addWhere, parList);
//return DAO.paginate(page, pageSize, select , sqlExceptSelect.toString(),parList.toArray());
return DAO.paginateByCache("stocklist", "paginate"+page, page, pageSize, select, sqlExceptSelect.toString(),parList.toArray());
}

 

//清除缓存
public void action4() {
System.out.println(">>>>>>>>>>4>>>>>>>>");
CacheKit.removeAll("stocklist");
renderText("action4");
}