public static PreparedStatement createRelationMemberTable ( Connection connection , String relationMemberTable ) throws SQLException { try ( Statement stmt = connection . createStatement ( ) ) { StringBuilder sb = new StringBuilder ( "CREATE TABLE " ) ; sb . append ( relationMemberTable ) ; sb . append ( "(ID_RELATION BIGINT, ID_SUB_RELATION BIGINT, ROLE VARCHAR, RELATION_ORDER INT);" ) ; stmt . execute ( sb . toString ( ) ) ; } return connection . prepareStatement ( "INSERT INTO " + relationMemberTable + " VALUES ( ?,?,?,?);" ) ; }
Store all relation members