PreparedStatement like 검색시 바인드 방법

[* mysql ] String query = "select * from tab col like ?"; pstmt.setString(1, "%"+keyword+"%");

 

 

[* oracle ] '%' || ? || '%' SELECT * FROM mytable where name like '%' || ? || '%' pstmt.setString(1, name);