下面是我的代码:
List params = new ArrayList();
StringBuffer sb = new StringBuffer();
//外层查询
sb.append("select * from ( ");
sb.append(" select * from admin_info ");
sb.append(" where 1=1 ");
if(roleId != null){
//拼第一个条件
sb.append(" and id in ( ");
sb.append(" select admin_id from admin_role ar ");
sb.append(" inner join role_info ri on ri.id=ar.role_id ");
sb.append(" where ri.id=? ");
sb.append(" )");
params.add(roleId);
}
if(privilegeId != null){
//拼第二个条件
sb.append(" and id in ( ");
sb.append(" select admin_id from admin_role ar ");
sb.append(" inner join role_info ri on ri.id=ar.role_id ");
sb.append(" inner join role_privilege rp on ri.id=rp.role_id ");
sb.append(" where rp.privilege=? ");
sb.append(" )");
params.add(privilegeId);
}
//拼分页条件
sb.append(" ) admin_info limit ?,? ");
params.add((page-1)*pageSize);
params.add(pageSize);
这是控制台报的错误:
java.sql.SQLException: No value specified for parameter 2
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2578)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2554)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2480)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2234)
at com.dao.admin.AdminDAOImpl.findByCondition(AdminDAOImpl.java:67)
at com.dao.admin.AdminDAOImpl.main(AdminDAOImpl.java:118)
Exception in thread "main" java.lang.Exception: 查询管理员失败!
at com.dao.admin.AdminDAOImpl.findByCondition(AdminDAOImpl.java:93)
at com.dao.admin.AdminDAOImpl.main(AdminDAOImpl.java:118)
Caused by: java.sql.SQLException: No value specified for parameter 2
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2578)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2554)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:2480)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2234)
at com.dao.admin.AdminDAOImpl.findByCondition(AdminDAOImpl.java:67)
... 1 more