diff --git a/src/osm/jp/coverage/busstop/DbBusstop.java b/src/osm/jp/coverage/busstop/DbBusstop.java index cc07aae..3842e7f 100644 --- a/src/osm/jp/coverage/busstop/DbBusstop.java +++ b/src/osm/jp/coverage/busstop/DbBusstop.java @@ -248,16 +248,15 @@ latStr = str4Ary[0]; lonStr = str4Ary[1]; - try (PreparedStatement ps6 = con.prepareStatement("INSERT INTO bus_stop (lat,lon,fixed,area,gmlid) VALUES (?,?,?,?,?)")) { + try (PreparedStatement ps6 = con.prepareStatement("INSERT INTO bus_stop (lat,lon,fixed,area,gmlid,up) VALUES (?,?,0,?,?,2)")) { double lat = Double.parseDouble(latStr); double lon = Double.parseDouble(lonStr); - System.out.println("INSERT INTO bus_stop (lat,lon,fixed,area, gmlid) VALUES ('"+ latStr +"','"+ lonStr +"','0',"+ areacode +",'"+ idStr +"')"); + System.out.println("INSERT INTO bus_stop (lat,lon,fixed,area,gmlid,up) VALUES ('"+ latStr +"','"+ lonStr +"',0,"+ areacode +",'"+ idStr +"',2)"); ps6.setDouble(1, lat); ps6.setDouble(2, lon); - ps6.setInt(3, 0); - ps6.setInt(4, areacode); - ps6.setString(5, idStr); + ps6.setInt(3, areacode); + ps6.setString(4, idStr); ps6.executeUpdate(); } }