- System.out.println("...."+ count);\r
- ps3.setInt(1, count);\r
- ps3.setString(2, idref);\r
- ps3.executeUpdate();\r
+ if (count > 0) {\r
+ System.out.println("."+ count);\r
+ ps3.setInt(1, count);\r
+ ps3.setString(2, idref);\r
+ ps3.executeUpdate();\r
+ }\r
+ else {\r
+ // 指定の緯度経度を中心とする半径150x4m四方の矩形領域\r
+ System.out.print("***");\r
+ rect = new RectArea(lat, lon, NEER*2); // 600m 四方\r
+ ps4.setDouble(1, rect.minlat);\r
+ ps4.setDouble(2, rect.maxlat);\r
+ ps4.setDouble(3, rect.minlon);\r
+ ps4.setDouble(4, rect.maxlon);\r
+ ps4.setString(5, name);\r
+ ResultSet rset4 = ps4.executeQuery();\r
+ if (rset4.next()) {\r
+ count = rset4.getInt(1);\r
+ System.out.println(".."+ count);\r
+ ps3.setInt(1, count);\r
+ ps3.setString(2, idref);\r
+ ps3.executeUpdate();\r
+ }\r
+ rset4.close();\r
+ }\r