package com.consum.base.service; import com.consum.model.po.SLoginInfo; import com.consum.model.po.SLoginInfo_mapper; import com.walker.db.Sorts; import com.walker.db.page.GenericPager; import com.walker.infrastructure.utils.StringUtils; import com.walker.jdbc.service.BaseServiceImpl; import org.springframework.stereotype.Service; import java.util.HashMap; import java.util.Map; import static com.walker.db.Sorts.DESC; @Service public class SLoginInfoServiceImp extends BaseServiceImpl { public GenericPager list(String userName) { String sql = "select * from s_login_info where 1=1 "; Map param = new HashMap<>(); if (StringUtils.isNotEmpty(userName)) { sql += "and user_name like :userName"; param.put("userName", "%" + userName + "%"); } Sorts.Sort desc = DESC(); desc.setField("login_time"); return this.selectSplit(sql, param, SLoginInfo_mapper.ROW_MAPPER, desc); } }