自己写的缓存类,备份

来源:互联网 发布:莆田耐克高仿鞋淘宝店 编辑:程序博客网 时间:2024/05/29 08:11

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;
  }
  
 }
}

原创粉丝点击