mybatis的查询操作

1.关于mybatis配置文件中的>=,<=等符号的使用:
<         	&lt;	
<=		&lt;=		
>		&gt;		
>=		&gt;=
&		&amp;
'		&apos;
"		 &quot;
2.分组排序的方法:
select  @group_row:=CASE when @parent_code=a.fid then  @group_row+1 else 1 end as rank,@parent_code:=a.fid as fid,a.tid  FROM jrun_threads a,( select @group_row:=1, @parent_code:='') as b order by a.fid,a.dateline desc

3.排序的方法:
select * from table t where t.a=1 order by t.id desc limit 1,10;
取出符合条件下的前十条数据

4.关于springboot在普通类中调用mybatis的查询
@MapperScan(basePackages = {"com.dylan.cands.mapper"})
a.先编写springutiles类，用于获取容器内的bean
@Component  
public class SpringUtils implements ApplicationContextAware {  
    private static ApplicationContext applicationContext = null;  
    @Override  
    public void setApplicationContext(ApplicationContext applicationContext) throws BeansException {  
        if(SpringUtils.applicationContext == null){  
            SpringUtils.applicationContext  = applicationContext;  
        }  
    }  
    //获取applicationContext  
    public static ApplicationContext getApplicationContext() {  
        return applicationContext;  
    }  
    //通过name获取 Bean.  
    public static Object getBean(String name){  
        return getApplicationContext().getBean(name);  
    }  
    //通过class获取Bean.  
    public static <T> T getBean(Class<T> clazz){  
        return getApplicationContext().getBean(clazz);  
    }  
    //通过name,以及Clazz返回指定的Bean  
    public static <T> T getBean(String name,Class<T> clazz){  
        return getApplicationContext().getBean(name, clazz);  
    }  }
b.在普通类中加载applicationContext之后创建可使用的加载对象
private ApplicationContext applicationContext=SpringUtils.getApplicationContext();
//mongoDB
private MongoTemplate mongoTemplate = applicationContext.getBean(MongoTemplate.class);
//设备信息的Info加载动态bean
private DeviceInfoMapper deviceInfoMapper = applicationContext.getBean(DeviceInfoMapper.class);