NamedParameterJdbcTemplate 传LIST

	/**
	 * 查询除节约以处所有的单位
	 */
	@Override
	public List<JyOrg> queryOrgOnJy() {
		List<JyOrg> jyOrg = new ArrayList<JyOrg>();
		//查询节约单位LIST
		Map<String, String> paramMap = Maps.newHashMap();
		String jy0rg = "select * from jy_org";
		jyOrg=db2Dao.query(jy0rg, paramMap, ParameterizedBeanPropertyRowMapper.newInstance(JyOrg.class));
		//取出orgcode LIST
		List<String> jyOrgList = Lists.transform(jyOrg, new Function<JyOrg, String>(){
			@Override
			public String apply(JyOrg input) {
				return input.getOrgcode();
			}});
		
		//查询除节约以外的单位
		List<JyOrg> onJyOrg = new ArrayList<JyOrg>();
		HashMap<String, Object> orgMap = new HashMap<String, Object>(1); 
		SqlParameterSource parameterSource = new MapSqlParameterSource().addValue("jyOrgList",jyOrgList);
		String sql = "SELECT distinct t1.dydm AS orgcode, t2.mc AS orgname FROM z_qtdygx t1 INNER JOIN z_qtgb t2 ON t1.dydm = t2.dm where t1.dylx='08' and t1.dydm not in(:jyOrgList) order by t1.dydm ";
		onJyOrg = jdbcDao.query(sql,parameterSource, ParameterizedBeanPropertyRowMapper.newInstance(JyOrg.class));
		return onJyOrg;
	}