package com.genersoft.zcgl.pub.xmxz.cache;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.sql.DataSource;
import org.loushang.waf.ComponentFactory;
import org.spring.jdbc.core.JdbcTemplate;
import org.spring.jdbc.core.ResultSetExtractor;
import com.genersoft.zcgl.pub.xmxz.data.ZchTzxmsx;
import com.genersoft.zcgl.pub.xmxz.util.XmxzListBeanResultSet;
/**
* 新增缓存类,缓存投资项目属性信息
* @author guoyankun
*
*/
public class TzxmsxCache {
public static Map ds = null;
public static Map getTzxmsx()
{
if(ds==null){
ds = new HashMap();
StringBuffer sb = new StringBuffer();
sb.append("SELECT ");
sb.append("ZCH_TZXMSX_SXNM,ZCH_TZXMSX_ZZNM,ZCH_TZXMSX_ND,ZCH_TZXMSX_SXBH,ZCH_TZXMSX_SXMC"); // 属性名称
sb.append(",ZCH_TZXMSX_SXLB,ZCH_TZXMSX_JLDW,ZCH_TZXMSX_CD,ZCH_TZXMSX_JD,ZCH_TZXMSX_SJKBCL"); // 数据库列
sb.append(",ZCH_TZXMSX_BCGZ,ZCH_TZXMSX_GZSJ,ZCH_TZXMSX_MRZ,ZCH_TZXMSX_NOTE,ZCH_TZXMSX_BZ"); // 集团标准
sb.append(",ZCH_TZXMSX_VER,ZCH_TZXMSX_QYSJ,ZCH_TZXMSX_SFBX"); // 是否必选
sb.append(" FROM ZCH_TZXMSX where 1=1 ");
ZchTzxmsx zd = new ZchTzxmsx();
JdbcTemplate jt = new JdbcTemplate();
jt.setDataSource((DataSource)ComponentFactory.getBean("dataSource"));
ResultSetExtractor rse = new XmxzListBeanResultSet(zd);
List list = (List) jt.query(sb.toString(), rse);
Map map = new HashMap();
for(int i=0;list!=null&&i<list.size();i++){
ZchTzxmsx xmsx = (ZchTzxmsx)list.get(i);
String sjkl = xmsx.getZCH_TZXMSX_SJKBCL();
map.put(sjkl, xmsx);
}
ds = map;
System.out.println("kao 我是现查询的!");
return map;
}else{
System.out.println("ok直接取到");
return ds;
}
}
}