当前位置: 首页 > 工具软件 > kot-mybatis > 使用案例 >

springBoot中 tk.mybatis的Example使用

燕鸿波
2023-12-01

1. 数据查询

Example example = new Example(CcompareccicModel.class); 
Criteria criteria = example.createCriteria();

        @Override
	public PageList<RiskasesmtComment> findAuditResult(Integer pageIndex, Integer pageSize, String projectName,String companyName,String serialNumber,String urgent,
			String markingTime1,String markingTime2,Integer sortOrder,String[] state) {
		 		
		//将long类型的毫秒数转换成date类型的
		Date markingTimeDate1 = null;
		Date markingTimeDate2 = null;
		if (markingTime1 != null && markingTime2 != null) {
			markingTimeDate1 = new Date(Long.parseLong(markingTime1));
			markingTimeDate2 = new Date(Long.parseLong(markingTime2));
		}
				
		Example exe = new Example(RiskasesmtComment.class); //表示实例化同时传递了一个对象给构造方法, 这个对象是一个Class对象
		Criteria criteria = exe.createCriteria();
		
		List<String> stateList = new ArrayList<String>();
                if (state != null && state.length !=0) {
			for(int i = 0; i < state.length; i++){
		        stateList.add(state[i]);
		    }
			//按照 状态查询
			criteria.andIn("state", stateList);
		}
		
		
		if (projectName != null && projectName != "") {
			//按照 项目名称查询
			//c.andEqualTo("projectName", projectName); 
			criteria.andCondition("  project_name like  "+"'"+'%'+projectName+'%'+"'");
		}
		
		if (companyName != null && companyName != "") {
			//按照  申请单位查询    
			//c.andEqualTo("companyName", companyName);
			criteria.andCondition("  company_name like  "+"'"+'%'+companyName+'%'+"'");
		}
		
		if(serialNumber != null && serialNumber != "") {
			//根据 申请单号 查询
			//c.andEqualTo("serialNumber", serialNumber);
			criteria.andCondition("  serial_number like  "+"'"+'%'+serialNumber+'%'+"'");
		}
		if(urgent != null && urgent != "") {
			//根据 加急文件 查询
			criteria.andIsNotNull("urgent");
		}
		
		
		if (markingTimeDate1 != null && markingTimeDate2 !=null) {
			//查询在一个时间段之内提交的 数据
			criteria.andBetween("markingTime", markingTimeDate1, markingTimeDate2);
		}else if(markingTime1 != null){
			// 按照 时间查询
			criteria.andEqualTo("markingTime", markingTimeDate1);
		}else if (markingTime2 != null) {
			// 按照 时间查询
			criteria.andEqualTo("markingTime",markingTimeDate2);
		}
		
		//按照提交时间倒序排列
		if (sortOrder != null && sortOrder.equals(1)) {
			exe.setOrderByClause("marking_time asc");
		}else if(sortOrder != null && sortOrder.equals(0)) {
			exe.setOrderByClause("marking_time desc");
		}else {
			exe.setOrderByClause("marking_time desc");
		}
				
		return page(exe, pageIndex, pageSize); 
	}

 类似资料: