陈友华给出的查询语句

Integer code = Integer.parseInt(get("code").toString().trim());
this.getmenu(code, this.getRequest());

String beid = get("beid")==null?"":get("beid").toString();
String bid = get("bid")==null?"":get("bid").toString();

StringBuffer path = new StringBuffer("QueryVersion.action?code=");
path.append(code);
StringBuffer ql = new StringBuffer("1=1");
if(beid!=""&&!"".equals(beid))
{
ql.append(" and beid like '%").append(beid).append("%'");
//ql.append(" and beid lik '%").append(beid);
path.append("&beid=").append(beid);
}
if(bid!=""&&!"".equals(bid))
{
ql.append(" and bid=").append(bid);
path.append("&bid=").append(bid);
}
ql.append(" order by bid");

pageService.getPage(path.toString(), 0, this
.getRequest());
PageEntity entity = pageService.doList("Baseversion", ql.toString());
getRequest().setAttribute("page", entity);

this.getRequest().setAttribute("dic",this.bscs.QueryAllBasespace() );
return "success";