在idea连接数据库后,在启动tomcat服务器后出现表不存在的的错误怎么改
java.sql.SQLException: Table 'housestore.orderitem' doesn't exist Query: SELECT house.location,sum(buynum) totalsalnum from orderitem,house ,orders WHERE orderitem.house_id=house.id and orderitem.order_id=orders.id and paystate=1 and YEAR(ordertime)=? and MONTH(ordertime)=? GROUP BY house.location order by totalsalnum DESC Parameters: [2022, 5]
不是已经很明确了吗,刷新下你的数据库看看表是否真的创建好了,还有检查库、表名字别写错了