msyql 问号 传参

一、

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+"%'";