extjs grid 分页 java_Extjs Grid分页实例

Extjs-3.2.0版本

1、servlet文件：

package com.xiaopan.servlet;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class NewsListServlet extends HttpServlet {

private static final long serialVersionUID =

1L;

@Override

protected void doGet(HttpServletRequest req,

HttpServletResponse resp)

throws

ServletException, IOException {

super.doGet(req, resp);

}

@Override

protected void doPost(HttpServletRequest req,

HttpServletResponse resp)

throws

ServletException, IOException {

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

try {

conn

= DriverManager.getConnection(

"jdbc:mysql://localhost:3306/d_news",

"root", "123456");

} catch

(SQLException e) {

e.printStackTrace();

}

} catch (ClassNotFoundException

e) {

e.printStackTrace();

}

PreparedStatement

stmt=null;

ResultSet rs=null;

String start =

req.getParameter("start"); String limit = req.getParameter("limit");

String sql = "select * from

t_newsinfo limit "+start+", "+limit; try {

stmt =

conn.prepareStatement(sql);

rs =

stmt.executeQuery(sql);

} catch (SQLException e1)

{

e1.printStackTrace();

} StringBuilder sb = new

StringBuilder(); sb.append("{totalCount:36,bugs:["); try {

while(rs.next()){

sb.append("{"); sb.append("id:" + "\'" + rs.getInt(1) +

"\'"); sb.append(",name:" + "\'" + rs.getString(3) +

"\'"); sb.append(",date:" + "\'" +rs.getString(3) +

"\'"); sb.append(",origin:" + "\'" + rs.getString(5) +

"\'"); sb.append("},");

}

rs.close();

} catch (SQLException e1)

{

e1.printStackTrace();

}

String jsonString = sb.substring(0, sb.length() -

1); jsonString += "]}";

resp.setContentType("text/html"); resp.setCharacterEncoding("UTF-8"); try{

resp.getWriter().write(jsonString);

resp.getWriter().close();

} catch (IOException e) {

e.printStackTrace(); }

System.out.println("执行调用................");

} }

2、前台jsp：

href="/js/resources/css/ext-all.css">

the Data Store var store =

new Ext.data.JsonStore({ root: 'bugs', totalProperty:

'totalCount', idProperty: 'threadid', remoteSort: true, fields: [ 'id', 'name', 'date',

'origin', ], proxy: new

Ext.data.HttpProxy({ url:'/NewsListServlet', method:'post' }) }); var grid =

new Ext.grid.GridPanel({ width:550, height:300, title:'ExtJS.com - Browse

Forums', store: store, trackMouseOver:false, disableSelection:true, loadMask: true, // grid columns columns:[{ header: "Id", dataIndex: 'id',