53 |
public Database(Connection conn) throws SQLException,IOException { |
public Database(Connection conn) throws SQLException,IOException { |
54 |
this.conn = conn; |
this.conn = conn; |
55 |
|
|
56 |
String sql = "INSERT INTO fulddaekning.afstand_anden_rute_ny (orgId,orgPostnr, orgAddress,orgGadeid,orgHusnr,orgHusnrBogstav,orgRute,id,postnr,Address,gadeid,husnr,husnrbogstav,rute,afstand,`timestamp`) "+ |
String sql = "INSERT INTO fulddaekning.afstand_anden_rute_ny (orgId,orgPostnr, orgAdresse,orgGadeid,orgHusnr,orgHusnrBogstav,orgRute,id,postnr,adresse,gadeid,husnr,husnrbogstav,rute,afstand,`timestamp`) "+ |
57 |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
"VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, now() )"; |
58 |
|
|
59 |
saveStmt = conn.prepareStatement(sql); |
saveStmt = conn.prepareStatement(sql); |
115 |
logger.info("Henter alle IKKE-daekkede Addressr"); |
logger.info("Henter alle IKKE-daekkede Addressr"); |
116 |
|
|
117 |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + |
118 |
"FROM fulddaekning.Addresstabel a " + |
"FROM fulddaekning.adressetabel a " + |
119 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
120 |
"WHERE ruteMa IS NULL " + //Ingen dækning |
"WHERE ruteMa IS NULL " + //Ingen dækning |
121 |
"AND a.postnr BETWEEN ? AND ? " + |
"AND a.postnr BETWEEN ? AND ? " + |
178 |
|
|
179 |
if ( alleAddressr == null ) { |
if ( alleAddressr == null ) { |
180 |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + |
String sql = "SELECT id,a.postnr,vejnavn,gadeid,husnr,husnrbogstav,latitude,longitude,ruteMa,p.distributor as ho " + |
181 |
"FROM fulddaekning.Addresstabel a " + |
"FROM fulddaekning.adressetabel a " + |
182 |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
"LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " + |
183 |
"WHERE ruteMa IS NOT NULL " + |
"WHERE ruteMa IS NOT NULL " + |
184 |
"AND latitude IS NOT NULL " + |
"AND latitude IS NOT NULL " + |