--- dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/12/10 11:04:49 2246 +++ dao/FuldDaekningWorker/src/dk/daoas/fulddaekning/Database.java 2014/12/15 11:12:21 2247 @@ -7,6 +7,7 @@ import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; +import java.util.HashMap; import java.util.List; import java.util.Properties; import java.util.Queue; @@ -22,6 +23,8 @@ Connection conn; PreparedStatement saveStmt; + + private HashMap bbCache = new HashMap(); public Database(SafeProperties conf) throws SQLException,IOException { this.conn = getConnection( conf ); @@ -56,9 +59,19 @@ logger.info("Executing: " + sql); conn.createStatement().executeUpdate(sql); - } - + } + public BoundingBox getBoundingbox(String postnr) throws SQLException { + BoundingBox bb = bbCache.get(postnr); + if ( bb == null ) { + bb = getBoundingboxFromDb(postnr); + bbCache.put(postnr, bb); + } + + return bb.clone();//never return the original / cached object + } + + private BoundingBox getBoundingboxFromDb(String postnr) throws SQLException { String minPostnr = postnr.replace('x', '0'); String maxPostnr = postnr.replace('x', '9'); @@ -84,6 +97,8 @@ return bbox; } + + public Queue hentIkkedaekkedeAdresser(String postnr) throws SQLException {