正确代码如下:
String sql = "select * from OnSale where medicineno like '%'||?||'%' and storeno like '%'||?||'%' and frameno like'%'||?||'%'";
之前我一直是
String sql = "select * from OnSale where medicineno like '%'?'%' and storeno like '%'?'%' and frameno like'%'?'%'";
然后一直查询不出结果 希望对大家有帮助。