Hibernate执行sql语句，输出结果
??? ??? ??? String sql = "select olt.olt_name,olt.longitude,olt.latitude"+//,olt.longitude,olt.latitude
??? ??? ??? ??? ??? ???? " from nms_res.olt"+
??? ??? ??? ??? ??? ???? " where olt.instanceid=2 or olt.instanceid="+id;
??? ??? ??? Query query = session.createSQLQuery(sql);
??? ??? ??? List<Object[]> lists= query.list();?????????? //lists是一个大的集合,注意lists里面的每个元素是数组类型;
??? ??? ??? OltLocation aa = new OltLocation();
??? ??? ??? for(Object[] aa1:lists){????????????????????? //aa1是对象;
//??? ??? ??? ??? for(int i=0;i<aa1.length;i++)??? ??? ??? ?//这是循环打印;
??? ??? ??? ? if(aa1!=null)
??? ??? ??? ??? {??? ??? ??? ??? //单个对象中放入的是数组;
??? ??? ??? ??? ??? System.out.println("打印第一个值："+aa1[0].toString()+aa1[1]+aa1[2]);
??? ??? ??? ??? }
??? ??? ??? }
??? ??? ???
??? ??? ???
?
?参考网页：
http://zhidao.baidu.com/question/56827332.html
