SqlProvider使用
public class MemberRewardSqlProvider {
private static final Logger log = LoggerFactory.getLogger(EappShpstoreSqlProvider.class);
public String selectByPage(MemberReward memberReward) {
StringBuffer sb = new StringBuffer();
sb.append("select * from member_reward where 1=1 and status != 'D'");
if(memberReward.getShopstoreId() != null){
sb.append(" and shopstore_id = "+memberReward.getShopstoreId());
}
log.debug("selectByPage:" + sb.toString());
return sb.toString();
}
}
public interface XXXXMapper{
@SelectProvider(type = MemberRewardSqlProvider.class, method = "selectByPage")
List<MemberReward> selectByPage(MemberReward memberReward, PageBounds pageBounds);
}