学步园

下面的是java类代码，用法与 上上篇的代码一样。package org.ycfshop.pub;</p> <p>import java.lang.reflect.InvocationTargetException;<br /> import java.lang.reflect.Method;<br /> import java.util.List;<br /> import java.util.Set;</p> <p>import org.hibernate.Query;<br /> import org.hibernate.Session;<br /> import org.hibernate.SessionFactory;<br /> import org.json.JSONArray;<br /> import org.json.JSONException;<br /> import org.json.JSONObject;<br /> import org.springframework.orm.hibernate3.support.HibernateDaoSupport;</p> <p>/**<br /> * hibernate分页<br /> * @author Administrator<br /> *<br /> */<br /> public class YCFHPage extends HibernateDaoSupport{<br /> /**<br /> * 返回JSON数据<br /> * 第一条为页面对象<br /> * @param hql<br /> * 如from table<br /> * @param currpag<br /> * 当前页<br /> * @param page<br /> * 每页显示数目<br /> * @return<br /> * 返回字符串<br /> */<br /> public String executeQuery(String hql,int currpag,int page){<br /> JSONArray jsonEmployeeArray = new JSONArray();<br /> SessionFactory sessionFactory = this.getHibernateTemplate().getSessionFactory();<br /> Session session = sessionFactory.openSession();<br /> if(page<=0){<br /> page=10;<br /> }<br /> try {<br /> Query query = session.createQuery(hql);<br /> int counts= query.list().size();<br /> int pages=(counts-1)/page+1;<br /> try {<br /> pages = (counts-1)/page+1;<br /> } catch (Exception ex) {<br /> pages = 0;<br /> }<br /> if(currpag>pages)<br /> currpag=pages;<br /> else if(currpag<=0)<br /> currpag=1;<br /> JSONObject jsObject = new JSONObject();<br /> jsObject.put("page", page);<br /> jsObject.put("sql", hql);<br /> jsObject.put("currpag", currpag);<br /> jsObject.put("counts", counts);<br /> jsObject.put("pages", pages);<br /> jsonEmployeeArray.put(jsObject);<br /> query.setFirstResult((currpag-1)*page);<br /> query.setMaxResults(page);<br /> query.getNamedParameters();<br /> List tmp = query.list();<br /> for (Object o : tmp) {<br /> JSONObject json=object2JSONObject(o);<br /> jsonEmployeeArray.put(json);<br /> }<br /> } catch (Exception e) {<br /> // TODO: handle exception<br /> }<br /> return jsonEmployeeArray.toString();<br /> }<br /> /**<br /> * 将PO转成JSONObject对象<br /> * @param o<br /> * @return<br /> */<br /> private JSONObject object2JSONObject(Object o){<br /> JSONObject jsObject = new JSONObject();<br /> Method[] methods = o.getClass().getMethods();<br /> for (int i = 0; i < methods.length; i++) {<br /> Method method = (Method) methods[i];<br /> if (method.getName().startsWith("get")) {<br /> String pName=getMethodName(method.getName());<br /> Object obj = null;<br /> try {<br /> obj=method.invoke(o, null);<br /> if (obj instanceof Set) {<br /> jsObject.put(pName, object2JSONArray(obj));<br /> }<br /> else<br /> jsObject.put(pName, obj);<br /> } catch (IllegalArgumentException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> } catch (IllegalAccessException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> } catch (InvocationTargetException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> } catch (JSONException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> }<br /> }<br /> }<br /> return jsObject;<br /> }<br /> /**<br /> * 将set转成JSONArray对象<br /> * @param o<br /> * @return<br /> */<br /> private JSONArray object2JSONArray(Object o){<br /> Set set = (Set) o;<br /> JSONArray jsonEmployeeArray = new JSONArray();<br /> for (Object object : set) {<br /> JSONObject json=object2JSONObject(object);<br /> jsonEmployeeArray.put(json);<br /> }<br /> return jsonEmployeeArray;<br /> }<br /> /**<br /> * 获得PO属性名<br /> * @param mName<br /> * @return<br /> */<br /> private String getMethodName(String mName){<br /> String s = "";<br /> s = mName.substring(3, 4).toLowerCase() + mName.substring(4);<br /> return s;<br /> }<br /> /**<br /> * 返回第一页数据<br /> * @param sql<br /> * 如 from table<br /> * @param page<br /> * 每页记录数<br /> * @return<br /> * JSON数据<br /> */<br /> public String firstExecute(String hql,int page){<br /> return executeQuery(hql, 1, page);<br /> }<br /> }<br />