一、
sql = "select * from tb_user where user_name like '%'||?'%'";
pstmt.setString(1, userPartName);
二、
sql = "select * from tb_user where user_name like ?";
pstmt.setString(1, "%" + userPartName + "%");
三、
sql = "select * from tb_user where user_name like '%"+userPartName+"%'";
\
本文转自 曦羽 51CTO博客,原文链接:http://blog.51cto.com/exist/1956818