import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.duckdb.DuckDBConnection;


DuckDBConnection connection = (DuckDBConnection) DriverManager.getConnection("jdbc:duckdb:");
try (PreparedStatement s = connection.prepareStatement("""
    select
        position(? in ?),
        position(? in 'abc'),
        position('b' in ?),
        position('b' in 'abc')
    """)) {
    s.setString(1, "b");
    s.setString(2, "abc");
    s.setString(3, "b");
    s.setString(4, "abc");

    try (ResultSet rs = s.executeQuery()) {
        while (rs.next()) {
            System.out.println(rs.getInt(1));
            System.out.println(rs.getInt(2));
            System.out.println(rs.getInt(3));
            System.out.println(rs.getInt(4));
        }
    }
}