javawebmysql
报错信息：java.sql.sqlexception: cannot create bean.privilege: bean.privilege query: select p.* from privilege p,privilege_role pr where p.id=pr.p_id and pr.r_id=? parameters: [007]
at org.apache.commons.dbutils.abstractqueryrunner.rethrow(abstractqueryrunner.java:392)
at org.apache.commons.dbutils.queryrunner.query(queryrunner.java:351)
at org.apache.commons.dbutils.queryrunner.query(queryrunner.java:180)
at dao.privilegedao.getroleprivileges(privilegedao.java:80)
at service.bussinessservice.getroleprivileges(bussinessservice.java:89)
at servlet.showrolepriuiservlet.dopost(showrolepriuiservlet.java:64)
at servlet.showrolepriuiservlet.doget(showrolepriuiservlet.java:46)
at javax.servlet.http.httpservlet.service(httpservlet.java:624)
at javax.servlet.http.httpservlet.service(httpservlet.java:731)at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:303)at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208)at filter.characterfilter.dofilter(characterfilter.java:28)at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241)at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208)at filter.rolefilter.dofilter(rolefilter.java:50)at org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:241)at org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:208)at org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:220)at org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:122)at org.apache.catalina.authenticator.authenticatorbase.invoke(authenticatorbase.java:505)at org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:170)at org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:103)at org.apache.catalina.valves.accesslogvalve.invoke(accesslogvalve.java:957)at org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:116)at org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:423)at org.apache.coyote.http11.abstracthttp11processor.process(abstracthttp11processor.java:1079)at org.apache.coyote.abstractprotocol$abstractconnectionhandler.process(abstractprotocol.java:620)at org.apache.tomcat.util.net.aprendpoint$socketprocessor.dorun(aprendpoint.java:2516)at org.apache.tomcat.util.net.aprendpoint$socketprocessor.run(aprendpoint.java:2505)at java.util.concurrent.threadpoolexecutor$worker.runtask(threadpoolexecutor.java:886)at java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor.java:908)at org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run(taskthread.java:61)at java.lang.thread.run(thread.java:619)
dao查询语句 public list getroleprivileges(string rid){ try{ queryrunner qr = new queryrunner(); string sql = select p.* from privilege p,privilege_role pr where p.id=pr.p_id and pr.r_id=? ; return (list) qr.query(jdbcutils.getconnection(),sql,rid,new beanlisthandler(privilege.class)); } catch(exception e){ e.printstacktrace(); throw new runtimeexception(); } }
privilegebean