一个sql语句模糊查询的小问题
oracle数据库中模糊查询一个列表
String sql="select * from question where subjectName like '%'";
pstmt.setString(1,id)
抛异常为：sql语句未正常结束.sql语句该如何写呢？


[解决办法]
String sql="select * from question where subjectName like ？";
pstmt.setString(1,"%" + id + "%")
[解决办法]
看在100%结贴率的份上

String sql="select * from question where subjectName like ？";
pstmt.setString(1,"'%" + id + "%'");

或者
String sql="select * from question where subjectName like '%"+id+"%'";