public Object mapRow(ResultSet rs, int rowNum) throws SQLException { String kid = rs.getString("key_id"); String fc = rs.getString("from_column"); String tc = rs.getString("target_column"); KeyColumnDesc keyColumnDesc = new KeyColumnDesc(kid, fc, tc); return keyColumnDesc; } }
/** * Creates Lists of KeyColumns with a common Key keyID, then adds the Lists to the Keys. * * @param keyDescs List of Keys. * @param keyColumnDescs List of KeyColumns. */ private void addKeyColumnsToKeys(List<KeyDesc> keyDescs, List<KeyColumnDesc> keyColumnDescs) { for (KeyColumnDesc keyColumnDesc : keyColumnDescs) { for (KeyDesc keyDesc : keyDescs) { if (keyColumnDesc.getKeyID().equals(keyDesc.getKeyID())) { keyDesc.getKeyColumnDescs().add(keyColumnDesc); break; } } } }
private Element toXmlElement(KeyDesc kd) { Element ret = new Element("foreignKey"); addChild(ret, "targetTable", kd.getTargetTable()); for (KeyColumnDesc kc : kd.getKeyColumnDescs()) { Element fkc = new Element("fkColumn"); addChild(fkc, "fromColumn", kc.getFromColumn()); addChild(fkc, "targetColumn", kc.getTargetColumn()); ret.addContent(fkc); } addChild(ret, "description", kd.description); addChild(ret, "utype", kd.utype); return ret; }
KeyColumnDesc kcd = new KeyColumnDesc(keyID, fc, tc); kd.getKeyColumnDescs().add(kcd);