コード例 #1
0
 public static String getVertexAnnotations(Config config) {
   return "SELECT TO_TIMESTAMP(V.TIME_A,'SSSSS') ARRIVAL_TIME, TO_TIMESTAMP(V.TIME_D,'SSSSS') DEPARTURE_TIME, R.ROUTE_SHORT_NAME, R.ROUTE_TYPE FROM "
       + config.getDestinationVertexAnnotatedTableEntry().getTableName()
       + " V, "
       + config.getRouteTable()
       + " R WHERE V.ROUTE_ID=R.ROUTE_ID";
 }
コード例 #2
0
 /**
  * Method getInsertVertexAnnotationString
  *
  * @param config
  * @return
  */
 public static String getInsertVertexAnnotationString(Config config) {
   return "INSERT INTO "
       + config.getDestinationVertexAnnotatedTableEntry().getTableName()
       + " (\"ID\", \"ROUTE_ID\",\"TIME_A\",\"TIME_D\") VALUES (?,?,?,?)";
 }