栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

List分页处理

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

List分页处理

package cn.com.tobosoft.epolicy.task;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.log4j.Logger;
import com.alibaba.fastjson.JSON;

import cn.com.tobosoft.epolicy.customer.model.StatusUpdateInfo;
import cn.com.tobosoft.epolicy.policycheck.common.SpringCfgPropHelper;
import cn.com.tobosoft.epolicy.policycheck.rechargeable.biz.action.SendConfirmSignStatusToDMS;
import cn.com.tobosoft.epolicy.report.biz.service.ReportService;


public class PolicyReSendRouteTask {

protected static Logger logger = Logger.getLogger(PolicyReSendRouteTask.class);

ReportService reportService;

public ReportService getReportService() {
	return reportService;
}

public void setReportService(ReportService reportService) {
	this.reportService = reportService;
}

public void getReSendRouteJob() throws Exception {
	
	//String sql = "select policy_info_id as policyInfoId,policy_no as policyNo,sign_status as signStatus,sign_status_updated_time as signStatusUpdatedTime from policy_info where import_time>'2022-06-07 20:00' and confirmSign='Y' and vipFlag='3' and signSendResult='1' and sign_status in ('0','1')";
	String sql = "select policy_info_id as policyInfoId,policy_no as policyNo,sign_status as signStatus,sign_status_updated_time as signStatusUpdatedTime from policy_info where import_time>'2022-06-07 20:00' and confirmSign='Y' and vipFlag='3' and signSendResult='1' and sign_status in ('0','1')";
	List> result = reportService.getDataByJDBCTemplate(sql, new Object[] {});
	
	SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
	List dmsList = new ArrayList();
	
	if (result != null && result.size() > 0) {
		for(Map obj :result){
			String policyInfoId =(String) obj.get("policyInfoId");
			String policyNo =(String) obj.get("policyNo");
			String signStatus =(String) obj.get("signStatus");
			String signStatusUpdatedTime =(String) obj.get("signStatusUpdatedTime");
			
			StatusUpdateInfo sInfo = new StatusUpdateInfo();
			sInfo.setCreateTime(new Date());
			sInfo.setStatus(signStatus);
			sInfo.setPolicyInfoId(policyInfoId);	
			sInfo.setPolicyNo(policyNo);
			sInfo.setContractSignDate(sdf.format(signStatusUpdatedTime));
			sInfo.setArticleCheckDate(sdf.format(signStatusUpdatedTime));
			sInfo.setSendOutDate("");
			dmsList.add(sInfo);
		}
		
		List newList =new ArrayList();
		if (dmsList != null && dmsList.size() > 0) {

			int pageSize=100;
			int start=0;
			int end =0;
			while(start 0) {

		int pageSize=10;
		int start=0;
		int end =0;
		while(start 

}

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/981559.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号