DB

PreparedStatement like 검색시 바인드 방법

에시드 2011. 9. 7. 19:59

[* mysql ]
String query = "select * from tab col like ?";

pstmt.setString(1, "%"+keyword+"%");

 

 

 

[* oracle ]
'%' || ? || '%'

SELECT * FROM mytable where name like '%' || ? || '%'

pstmt.setString(1, name);