excelout.java

java swing源码 欢迎下载 有问题请联系 我一定负责到底

		sql.append("(select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '93'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) d,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '94'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) e,");
		sql.append("(select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '95'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) f,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '99'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) g,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '100'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) h,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '101'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) i,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '102'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) j,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '103'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) k,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '178'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) l,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '105'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) m,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '107'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) n,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '109'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) o,");
		sql.append(" (select count(*) from insurancewill where insurancewill.productchannel = '86'and makedate < add_months(to_date( ? || '-' || months.nu,'yyyy-MM') ,1) and makedate >= to_date(? || '-' || months.nu,'yyyy-MM') ) p");
		sql.append(" from  (select nu from months where cast(nu as int) <13) months");		
		DBAccess SQL = new DBAccess();
		List result = new ArrayList();
		result = SQL.mulparseSQL(sql.toString(),this.strList);
		strList.clear();
		return result;		
	}
	/**
	 * 投保意向查询-月报
	 * @return
	 */
	public List insuranceWillDayFind(){	
		StringBuffer sql = new StringBuffer("select months.nu month, ");
		sql.append("(select count(*) from (select producttype, makedate from insurancewill ");
        sql.append(" where insurancewill.productchannel = '84')  where producttype = '90' and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) a,");
        sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '91'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) b,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '92'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) c,");
		sql.append("(select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '93'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) d,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '94'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) e,");
		sql.append("(select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '84')  where producttype = '95'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) f,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '99'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) g,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '100'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) h,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '101'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) i,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '102'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) j,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '103'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) k,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill"); 
		sql.append(" where insurancewill.productchannel = '85')  where producttype = '178'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) l,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '105'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) m,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '107'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) n,");
		sql.append(" (select count(*) from (select producttype, makedate from insurancewill");
		sql.append(" where insurancewill.productchannel = '87')  where producttype = '109'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) o,");
		sql.append(" (select count(*) from insurancewill where insurancewill.productchannel = '86'and makedate <to_date(? || '-' || months.nu, 'yyyy-MM-dd')+1 and makedate >= to_date(? || '-' || months.nu, 'yyyy-MM-dd') ) p");
		sql.append(" from  (select nu from months where cast(nu as int) <=cast(? as int)) months");			
		DBAccess SQL = new DBAccess();
		List result = new ArrayList();
		result = SQL.mulparseSQL(sql.toString(),this.strList);
		strList.clear();
		return result;		
	}
	/**
	 * 根据城市查询
	 * @return
	 */
	public List cityFind(){
		StringBuffer sql = new StringBuffer("select ");
		sql.append(" (select count(*) from consultationmessage c where c.makedate >= to_date(?,'yyyy-MM-dd') and c.makedate <= to_date(?,'yyyy-MM-dd') and c.citycode = w.placecode and c.type = '购买前产品咨询') a, ");
		sql.append(" (select count(*) from consultationmessage c where c.makedate >= to_date(?,'yyyy-MM-dd') and c.makedate <= to_date(?,'yyyy-MM-dd') and c.citycode = w.placecode and c.type = '售后咨询') b,");
		sql.append(" (select count(*) from consultationmessage c where c.makedate >= to_date(?,'yyyy-MM-dd') and c.makedate <= to_date(?,'yyyy-MM-dd') and c.citycode = w.placecode and c.type = '意见建议') c,");
		sql.append(" (select count(*) from consultationmessage c where c.makedate >= to_date(?,'yyyy-MM-dd') and c.makedate <= to_date(?,'yyyy-MM-dd') and c.citycode = w.placecode and c.type = '网站功能咨询') d,");
		sql.append(" w.placename month");
		sql.append(" from (select t.placecode, t.placename");
		sql.append(" from placecode t where t.placetype = '02') w");
		sql.append(" order by w.placecode");
		DBAccess SQL = new DBAccess();
		List result = new ArrayList();
		result = SQL.mulparseSQL(sql.toString(),this.strList);
		strList.clear();
		return result;
	}
	/**
	 * 根据机构组织查询
	 * @return
	 */
	public List orgFind(){
		StringBuffer sql = new StringBuffer("select ");
		sql.append("(select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '90'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) a,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '91'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) b,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '92'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) c,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '93'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) d,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '94'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) e,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '84') i where ");
		sql.append(" producttype = '95'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) f,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append(" producttype = '99'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) g,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append(" producttype = '100'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) h,");
		sql.append("(select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append("producttype = '101'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) i,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append("producttype = '102'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) j,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append(" producttype = '103'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) k,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '85') i where ");
		sql.append(" producttype = '178'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) l,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '87') i where"); 
		sql.append(" producttype = '105'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) m,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '87') i where"); 
		sql.append(" producttype = '107'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) n,");
		sql.append(" (select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '87') i where"); 
		sql.append(" producttype = '109'and i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) o,");
		sql.append("(select count(*) from (select producttype,makedate,serviceorg from insurancewill i where i.productchannel = '86') i where"); 
		sql.append(" i.serviceorg = l.comcode and makedate>=to_date(?,'yyyy-MM-dd') and makedate<=to_date(?,'yyyy-MM-dd')) p,");
		sql.append("l.comcode, l.name month from (select l.comcode, l.name from ldcom l where length(l.comcode) = 4 order by l.comcode) l");
		DBAccess SQL = new DBAccess();
		List result = new ArrayList();
		result = SQL.mulparseSQL(sql.toString(), this.strList);
		strList.clear();
		return result;
	}
	
	public static void main(String[] args) {
	}
}