private void createHouse(Connection connection, String test){
        try {
            final PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO housepurchase VALUES ?, ?, ?, ?, ?, ?, ?");
            preparedStatement.setString(1, test);
            preparedStatement.setString(2, test);
            preparedStatement.setString(3, test);
            preparedStatement.setString(4, test);
            preparedStatement.setString(5, test);
            preparedStatement.setString(6, test);
            preparedStatement.setString(7, test);

            preparedStatement.executeUpdate();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }