学步园

 做了一个Demo，是java+lcds+spring+json.本来想传项目的，可是在csdn只有5M的权限。

服务端的分页代码：package com.ycf;</p> <p>import java.sql.Connection;<br /> import java.sql.ResultSet;<br /> import java.sql.ResultSetMetaData;<br /> import java.sql.SQLException;<br /> import java.sql.Statement;</p> <p>import javax.sql.DataSource;</p> <p>import org.json.JSONArray;<br /> import org.json.JSONException;<br /> import org.json.JSONObject;</p> <p>public class YCFPage {<br /> private DataSource dataSource;</p> <p> public void setDataSource(DataSource dataSource) {<br /> this.dataSource = dataSource;<br /> }</p> <p> /**<br /> * 获得数据源<br /> * @return<br /> * 返回数据源<br /> */<br /> public DataSource getDataSource() {<br /> return dataSource;<br /> } </p> <p> /**<br /> * 获得连接池连接<br /> * @return<br /> * 返回连接对象<br /> */<br /> public Connection getConn() {<br /> Connection conn = null;<br /> try {<br /> conn=getDataSource().getConnection();<br /> } catch (SQLException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> }<br /> return conn;<br /> }<br /> /**<br /> * 返回JSON数据<br /> * 第一条为页面对象<br /> * @param sql<br /> * 如select * from table<br /> * @param currpag<br /> * 当前页<br /> * @param page<br /> * 每页显示数目<br /> * @return<br /> * 返回字符串<br /> */<br /> public String executeQuery(String sql,int currpag,int page){<br /> String str=null;<br /> JSONArray jsonEmployeeArray = new JSONArray();<br /> int counts=executeCount(sql);<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 /> String ssql=sql;<br /> sql="Select * from (Select t.*,rownum rn from (" + sql<br /> + " ) t where " + "rownum <= " + page + "*" + currpag<br /> + ")" + " t where t.rn >=(" + currpag+ "-1)* " + page<br /> + "+1";<br /> JSONObject jsObject = new JSONObject();<br /> Connection conn = this.getConn();<br /> Statement stm = null;<br /> ResultSet rs = null;<br /> ResultSetMetaData rms = null;<br /> try {<br /> jsObject.put("page", page);<br /> jsObject.put("sql", ssql);<br /> jsObject.put("currpag", currpag);<br /> jsObject.put("counts", counts);<br /> jsObject.put("pages", pages);<br /> jsonEmployeeArray.put(jsObject);<br /> stm = conn.createStatement();<br /> rs = stm.executeQuery(sql);<br /> rms = rs.getMetaData();<br /> while (rs.next()) {<br /> JSONObject jsonEmployee = new JSONObject();<br /> for (int i = 1; i <= rms.getColumnCount(); i++) {<br /> String field = rms.getColumnName(i).toLowerCase();<br /> jsonEmployee.put(field, rs.getString(field));<br /> }<br /> jsonEmployeeArray.put(jsonEmployee);<br /> }<br /> } catch (SQLException e) {<br /> // TODO 自动生成 catch 块<br /> e.printStackTrace();<br /> } catch (JSONException e) {<br /> // TODO Auto-generated catch block<br /> e.printStackTrace();<br /> } finally {<br /> try {<br /> rs.close();<br /> stm.close();<br /> conn.close();<br /> } catch (SQLException e) {<br /> // TODO 自动生成 catch 块<br /> e.printStackTrace();<br /> }</p> <p> }<br /> return jsonEmployeeArray.toString();<br /> }<br /> /**<br /> * 统计sql记录数<br /> * @param sql<br /> * 如select * from table<br /> * @return<br /> * 返回记录数<br /> */<br /> public int executeCount(String sql) {<br /> int n = 0;<br /> Connection conn = null;<br /> Statement stmt = null;<br /> ResultSet rs = null;<br /> try {<br /> conn = this.getConn();<br /> stmt = conn.createStatement(<br /> java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,<br /> java.sql.ResultSet.CONCUR_READ_ONLY);<br /> rs = stmt.executeQuery(sql);<br /> rs.last();<br /> n = rs.getRow();<br /> } catch (Exception ex) {<br /> ex.printStackTrace();<br /> } finally {<br /> try {<br /> rs.close();<br /> stmt.close();<br /> conn.close();<br /> } catch (SQLException e) {<br /> e.printStackTrace();<br /> }<br /> }<br /> return n;<br /> }<br /> /**<br /> * 返回第一页数据<br /> * @param sql<br /> * 如select * from table<br /> * @param page<br /> * 每页记录数<br /> * @return<br /> * JSON数据<br /> */<br /> public String firstExecute(String sql,int page){<br /> return executeQuery(sql, 1, page);<br /> }<br /> }<br />

服务端代码在applicationContext.xml中的配置：<bean id="ycfPage" class="com.ycf.YCFPage"><br /> <property name="dataSource"><br /> <ref bean="dataSource"/><br /> </property><br /> </bean>

服务端代码在remoting-config.xml中的配置：<destination id="YCFPage"><br /> <properties><br /> <factory>spring</factory><br /> <source>ycfPage</source><br /> </properties><br /> </destination>

客户端代码：<?xml version="1.0" encoding="utf-8"?><br /> <mx:Canvas xmlns:mx="http://www.adobe.com/2006/mxml" width="594" height="38" xmlns:ns1="bridge.*"><br /> <mx:Script><br /> <!--[CDATA[<br /> import mx.controls.Alert;<br /> import mx.utils.StringUtil;<br /> import mx.collections.ArrayCollection;<br /> import com.adobe.serialization.json.JSON;<br /> import mx.rpc.events.ResultEvent;<br /> //当前页面数据<br /> [Bindable]<br /> public var datas:ArrayCollection=new ArrayCollection();<br /> //总记录数<br /> [Bindable]<br /> private var counts:int;<br /> //总页数<br /> [Bindable]<br /> private var pages:int;<br /> //页记录数<br /> [Bindable]<br /> private var page:int=2;<br /> //当前页<br /> [Bindable]<br /> private var currpag:int;<br /> //sql语句<br /> [Bindable]<br /> private var sql:String;<br /> //页码<br /> [Bindable]<br /> public var db:Array=new Array();<br /> //第一次数据<br /> [Bindable]<br /> public function set setData(str:String):void{<br /> var array:Array=JSON.decode(str);<br /> if(array[0]!=null){<br /> counts=array[0].counts;<br /> pages=array[0].pages;<br /> page=array[0].page;<br /> currpag=array[0].currpag;<br /> sql=array[0].sql;<br /> }<br /> else<br /> return;<br /> //pages=Math.ceil(counts/this.page);<br /> db.length=0;<br /> for(var i:int=1;i<=pages;i++){<br /> db.push("第"+i+"页");<br /> }<br /> array.shift();<br /> datas=new ArrayCollection(array);<br /> //currpag=1;<br /> //addCurr();<br /> inputpage.text=currpag+"";<br /> }<br /> //页面转换<br /> [Bindable]<br /> public function setSData(str:String):void{<br /> /*countdatas=arr;<br /> counts=arr.length;<br /> pages=Math.ceil(counts/this.page);<br /> db.length=0;<br /> for(var i:int=1;i<=pages;i++)<br /> db.push("第"+i+"页");<br /> //addCurr();<br /> inputpage.text=currpag+"";*/<br /> var array:Array=JSON.decode(str);<br /> if(array[0]!=null){<br /> counts=array[0].counts;<br /> pages=array[0].pages;<br /> page=array[0].page;<br /> currpag=array[0].currpag;<br /> sql=array[0].sql;<br /> }<br /> else<br /> return;<br /> db.length=0;<br /> for(var i:int=1;i<=pages;i++){<br /> db.push("第"+i+"页");<br /> }<br /> array.shift();<br /> datas=new ArrayCollection(array);<br /> inputpage.text=currpag+"";<br /> }<br /> public function set setPag(page:int):void{<br /> if(page>0)<br /> this.page=page;<br /> }<br /> private function setpag(i:int):void{<br /> if(i==-2)<br /> i=currpag-1;<br /> if(i==-3)<br /> i=currpag+1;<br /> if(i==-4)<br /> i=pages;<br /> currpag=i;<br /> if(i<=0){<br /> currpag=1;<br /> }<br /> else if(i>pages){<br /> currpag=pages;<br /> }<br /> ycfPage.executeQuery(sql,currpag,page);<br /> ycfPage.executeQuery.addEventListener(ResultEvent.RESULT,addCurr);</p> <p> }<br /> private function goPage():void{<br /> var pp:String=StringUtil.trim(inputpage.text);<br /> var i:int;<br /> if(pp.length==0)<br /> return;<br /> try{<br /> i=Number(pp);<br /> }<br /> catch(e:Error){<br /> inputpage.text="";<br /> return;<br /> }<br /> setpag(i);<br /> }<br /> private function addCurr(e:ResultEvent):void{<br /> setSData(e.result.toString());<br /> }<br /> ]]--><br /> </mx:Script><br /> <mx:HBox x="15" y="4" width="569"><br /> <mx:Button label="首页" fontSize="12" id="first" click="setpag(1)"/><br /> <mx:Button label="上一页" fontSize="12" id="up" click="setpag(-2)"/><br /> <mx:Button label="下一页" fontSize="12" id="down" click="setpag(-3)"/><br /> <mx:Button label="尾页" id="end" fontSize="12" click="setpag(-4)"/><br /> <mx:ComboBox id="comb" width="58" editable="false" change="setpag(comb.selectedIndex+1)" dataProvider="{db}"></mx:ComboBox><br /> <mx:TextInput width="36" id="inputpage" /><br /> <mx:Button label="GO" click="goPage()"/><br /> <mx:Label width="138" height="21" text="当前{currpag}/{pages};记录数：{counts}" fontSize="12"/><br /> </mx:HBox><br /> <mx:RemoteObject id="ycfPage" destination="YCFPage"></mx:RemoteObject><br /> </mx:Canvas><br />