java.sql.SQLException: no such table: Boke Query: select id,title,brief,content,author,date,bokeid from Boke Parameters: []
封装的查询方法在用main测试时可以查询到数据,但在web服务开启之后它就始终报这个异常,不知道哪的问题,大神help
发出来看看呢,是不是你的路径写的不对
@Override
public List findAll() throws SQLException {
String sql = "select id,title,brief,content,author,date,bokeid from Boke";
QueryRunner q = new QueryRunner();
List list = q.query(DBUtils.getConnection(), sql, new BeanListHandler(Boke.class));
return list;
}
这是查询方法
BokeDao bd = new BokeImpl();
try {
List list = bd.findAll();
request.setAttribute("Boke", list);
request.getRequestDispatcher("BokeAll.jsp").forward(request, response);
} catch (SQLException e) {
e.printStackTrace();
}
在这里报异常
if(list != null && "".equals(list)){
request.setAttribute("Boke", list);
request.getRequestDispatcher("BokeAll.jsp").forward(request, response);
}
不妨检查一下数据库路径是否正确。。。。