制作出一个借阅书最多的系的排名
String sql="select top 10 t2.bookName,sum(t1.number) as num"+
" from tb_order_detail t1,tb_book t2,tb_order t3"+
" where t1.bookID=t2.ID "+
" group by t2.bookName "+
" order by num desc";
String sql1="SELECT COUNT(dept) AS num1 "+
" from dbo.tb_order"+
" group by dept";
ResultSet rs = conn.executeQuery(sql);
String bookName = "";
String dept="";
int num = 0;
int num1 = 0;
报错内容是dept列名无效,以及已经在数据库的tb_order中加入了dept新列,并在其他页面运用成功。