public static PreparedStatement createWayMemberTable ( Connection connection , String wayMemberTable ) throws SQLException { try ( Statement stmt = connection . createStatement ( ) ) { StringBuilder sb = new StringBuilder ( "CREATE TABLE " ) ; sb . append ( wayMemberTable ) ; sb . append ( "(ID_RELATION BIGINT, ID_WAY BIGINT, ROLE VARCHAR, WAY_ORDER INT);" ) ; stmt . execute ( sb . toString ( ) ) ; } return connection . prepareStatement ( "INSERT INTO " + wayMemberTable + " VALUES ( ?,?,?,?);" ) ; }
Create a table to store all way members .