class UserGroupDao extends BaseDao {

    public List<MemberView> getUserListByLikeUserName(String userName) throws SQLException {
        StringBuffer sql = new StringBuffer("SELECT id as user_id, user_no, user_name, user_real_name, user_email FROM login_users ");
        if (StringUtils.isNotBlank(userName)) {
            sql.append("WHERE (user_name like '" + userName + "%' or user_real_name like '" + userName + "%') and id != " + PermissionService.getSUPERID() + " limit 10");
        } else {
            sql.append("WHERE id != " + PermissionService.getSUPERID() + " limit 10");
        }
        System.out.println(sql.toString());
        return this.queryBySql(sql.toString(), MemberView.class);
    }

}