|
mysql> use modbus; Database changed mysql> DELIMITER $ mysql> drop procedure if exists p4; -> create procedure p4() -> begin -> select user_name from user_info where indexflag = 0000000001; -> end; Service断 @Transactional public List<Object> getBsmuDataByMonth(String startDate, String endDate) { String sql = "{call p4()}"; List<Object> list = entityDao.createSQLQuery(sql); System.out.println("查询结果:"+list.size()); return list; } // 执行SQL查询-注意 queryString是SQL语句 @SuppressWarnings("unchecked") public List<Object> createSQLQuery(final String queryString) { return (List<Object>) getHibernateTemplate().execute( new HibernateCallback<Object>() { public Object doInHibernate(Session session) throws HibernateException, SQLException { SQLQuery query = (SQLQuery) session.createSQLQuery( queryString).setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP); List<Object> rows = query.list(); return rows; } }); } (责任编辑：IT) |