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