2014-08-01

//Map:遍历

Map fileMap = (Map) map.get("fileMap");List policyNoList = new ArrayList();Set set = fileMap.keySet();for (Iterator iterator = set.iterator(); iterator.hasNext();) {String key= (String) iterator.next();String value = (String) fileMap.get(key);}

Ibatis 批量操作

public void updatep(final List list) throws DAOException {this.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {@Overridepublic Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {executor.startBatch();for (int i = 0, n = list.size(); i < n; i++) {executor.update("updatep", list.get(i));}executor.executeBatch();return null;}});}

sql 两表查询，查询两表中没有匹配的数据

SELECT s.sponsor_code,sc.sponsor_codeFROM sponsor_info s LEFT JOINsponsor_channel_view_sponsor scON     s.sponsor_code =sc.sponsor_code        WHEREsc.sponsor_code IS NULL