Question

在JSP中实现模糊查询，这样写SQL行吗select * from emp where empno between ? and ? and ename like %？%

Answer 1

不要忘了加引号
select * from emp where empno between ? and ? and ename like ’ %？% ‘

Answer 2

select * from gg_b_province where charindex(ProvinceName ,'新疆库尔勒',0)>0

追问

看不明白，我要用preparedstatement 忘SQL语句传值，拼接之后再在后台执行

Answer 3

select * from gg_b_province where charindex(ProvinceName ,'新疆库尔勒',0)>0