149 |
|
|
150 |
List<Adresse> list = hentAdresseListe( stmt ); |
List<Adresse> list = hentAdresseListe( stmt ); |
151 |
return list.toArray( new Adresse[ list.size() ] ); |
return list.toArray( new Adresse[ list.size() ] ); |
|
|
|
152 |
} |
} |
153 |
|
|
154 |
|
|
155 |
|
public Adresse[] hentAlleDaekkedeAdresser() throws SQLException { |
156 |
|
String sql = "SELECT id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute " + |
157 |
|
"FROM fulddaekning.adressetabel " + |
158 |
|
"WHERE rute IS NOT NULL " + |
159 |
|
"AND latitude IS NOT NULL " + |
160 |
|
"AND longitude IS NOT NULL " + |
161 |
|
"AND distributor = ? "; |
162 |
|
|
163 |
|
// Forward only + concur_read_only + fetchsize tvinger driver til at hente en række af gangen (bedre performance ved store result sets) |
164 |
|
// Se http://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html |
165 |
|
//PreparedStatement stmt = conn.prepareStatement(sql); |
166 |
|
PreparedStatement stmt = conn.prepareStatement(sql, java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY); |
167 |
|
stmt.setFetchSize(Integer.MIN_VALUE); |
168 |
|
|
169 |
|
stmt.setString(1, Lookup.distributor); |
170 |
|
|
171 |
|
List<Adresse> list = hentAdresseListe( stmt ); |
172 |
|
return list.toArray( new Adresse[ list.size() ] ); |
173 |
|
} |
174 |
|
|
175 |
|
|
176 |
|
|
177 |
public synchronized void gemResultat(Adresse orgAdresse, Adresse bedsteAdresse, double bedsteAfstand) throws SQLException { |
public synchronized void gemResultat(Adresse orgAdresse, Adresse bedsteAdresse, double bedsteAfstand) throws SQLException { |
178 |
/*String sql = "INSERT INTO fulddaekning.afstand_anden_rute_thn (orgId,orgPostnr, orgAdresse,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ |
/*String sql = "INSERT INTO fulddaekning.afstand_anden_rute_thn (orgId,orgPostnr, orgAdresse,orgGadeid,orgHusnr,orgHusnrBogstav,orgLatitude,orgLongitude,orgRute,id,postnr,adresse,gadeid,husnr,husnrbogstav,latitude,longitude,rute,afstand,`timestamp`) "+ |