UC知道这样写preparedstatment的sql语句有什么毛病
来源：百度知道 编辑：UC知道 时间：2024/06/03 01:31:50
String sql = "SELECT fID ,title,fpassword,fdescription,lID,dept,createTime,beginTime,overTime FROM ARfile WHERE '?' like '?' ORDER BY fID desc ";
where 后面赋值是title，可是老是报错，
where 后面赋值是title，可是老是报错，
把单引号去掉
问号不加''的
String sql = "SELECT fID ,title,fpassword,fdescription,lID,dept,createTime,beginTime,overTime FROM ARfile WHERE ? is like %?% ORDER BY fID desc ";