Hibernate自定义查询

 public void addCarmera(Carmera carmera)throws SystemException , CommPlatException{        //获取一个id号        	Session session=null;        	//        	//            long equipmentId = CounterLocalServiceUtil.increment(Carmera.class.getName());             String sql="SELECT top 1 * FROM res_carmera order by picNum desc";            session = HibernateUtil.openSession();            SQLQuery q=session.createSQLQuery(sql);            q.addEntity("res_carmera", CarmeraImpl.class);            Carmera ca=(Carmera) q.list().get(0);            long picnum = Long.parseLong(ca.getPicNum())+1; // picNum :图像编号            long placeNum=Long.parseLong(ca.getPlaceNum())+1;//placeNum : 点位编号            carmera.setPicNum(String.valueOf(picnum));            carmera.setPlaceNum(String.valueOf(placeNum));            carmera.setNew(true);            carmera.setPrimaryKey(equipmentId);            CarmeraUtil.update(carmera,true);    }