Hibernate:public List<RcwhB> LoadAllGroupByName(){Session session = HibernateSessionFactoryUtil.getSessionFactory().getCurrentSession();session.beginTransaction();Query query = session.createSQLQuery("select xm,count(xm) count from RcwhB group by xm");List list = query.list();session.getTransaction().commit();return list;}==============Servlet:... ...List list = dao.LoadAllGroupByName();request.setAttribute("rcwh_Load_All_Count", list);request.getRequestDispatcher("/Admin_users/rcwh_tj.jsp").forward(request, response);==============JSP:<c:forEach items="${rcwh_Load_All_Count}" var="r">${r.xm }:${r.count }<br></c:forEach>請問有哪兒沒對嗎?用上面方法會報錯(java.lang.NumberFormatException: For input string: "xm")count在數據庫里沒有這個字段,但是我在javabean里有這個屬性拿來臨時存儲統計值的,把最上面的hibernate實現方法換成jdbcpublic List<RcwhB> loadAllByCount() {Connection conn = DBConnection.getConnection();String sql = "select xm,count(xm) cou from RcwhB group by xm";try{Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){RcwhB r = new RcwhB();r.setXm(rs.getString("xm"));r.setCount(rs.getString("cou"));list.add(r); } }catch(SQLException e){e.printStackTrace(); }return list; }就沒有問題。
不知道程序是哪兒出了錯。請幫忙看一下吧
ibeautiful
2023-03-12 17:13:10