首页 > 代码库 > 数据加工处理拼sql

数据加工处理拼sql

  

@Override	public void offonShareBill(Boolean fg, Map<String,String[]> map) throws BusinessException {		System.out.println();		BaseDAO dao = new BaseDAO();		Set<String> set = map.keySet();		for (String key : set) {			String[] ids = map.get(key);			String sql = "update hrwa_washare a set a.isdeal = ‘N‘ , a.csourcebillid = ‘‘ " +					"where a.csourcebillid = ‘"+key+"‘";			if(fg){				StringBuffer aq = new StringBuffer();				aq = aq.append("(");				for(String abs : ids){					abs = "‘"+abs+"‘"+",";					aq.append(abs);									}				String aq_string = aq.substring(0, aq.length()-1);				aq_string = aq_string+")";				sql = "update hrwa_washare a set a.isdeal = ‘Y‘ , a.csourcebillid = ‘"+key+"‘ " +						"where a.pk_washare in "+aq_string+"";			}			try {				dao.executeUpdate(sql);			} catch (DAOException e) {				throw new BusinessException("更新薪资分摊(人力)单据失败!");			}		}		}

 

数据加工处理拼sql