jqGrid：三、 remote data(XML)

tanlingcau

浏览: 138021 次
性别:
来自: 北京

最近访客更多访客>>

49616664

blue_hr

周凡1981

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Javascript

XML Servlet HTML XHTML

新建页面jqgrid_xml.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
    <head>
        <title>grid.html</title>
        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3" />
        <meta http-equiv="description" content="this is my page" />
        <meta http-equiv="content-type" content="text/html; charset=UTF-8" />

        <link rel="stylesheet" type="text/css" media="screen"
            href="css/themes/redmond/jquery-ui-1.8.2.custom.css" />
        <link rel="stylesheet" type="text/css" media="screen"
            href="css/themes/ui.jqgrid.css" />
        <link rel="stylesheet" type="text/css" media="screen"
            href="css/themes/ui.multiselect.css" />
        <link rel="stylesheet" type="text/css" media="screen"
            href="css/themes/jquery.searchFilter.css" />
        <style>
html,body {
    --margin: 0; /* Remove body margin/padding */
    padding: 0;
    overflow: hidden; /* Remove scroll bars on browser window */
    font-size: 75%;
}
</style>

        <script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
        <script src="js/jquery-ui-1.8.2.custom.min.js" type="text/javascript"></script>
        <script src="js/src/ui.multiselect.js"
            type="text/javascript"></script>
        <script src="js/src/grid.loader.js" type="text/javascript"></script>
        <script type="text/javascript">
            $.jgrid.no_legacy_api = true;
            $.jgrid.useJSON = true;
        </script>
        <script type="text/javascript">
            $(function(){ 
              var lastSel;
              $("#grid_id").jqGrid({
                url:'/demo2/servlet/JqGridXmlServlet',
                mtype: 'GET',
                datatype: 'xml',
                height: "auto",
                loadui: "disable",
                colNames:['Inv No','Date', 'Amount','Tax','Total','Notes'],
                colModel :[ 
                  {name:'invid', index:'invid', width:70}, 
                  {name:'invdate', index:'invdate', width:120, editable:true}, 
                  {name:'amount', index:'amount', width:90, align:'right', editable:true}, 
                  {name:'tax', index:'tax', width:90, align:'right', editable:true}, 
                  {name:'total', index:'total', width:90, align:'right', editable:true}, 
                  {name:'note', index:'note', width:180, sortable:false, editable:true} 
                ],
                pager: '#pager',
                rowNum:10,
                rowList:[10,20,30],
                sortname: 'invid',
                sortorder: 'asc',
                viewrecords: true,
                caption: 'My first grid'
              });
            }); 
        </script>
    </head>
    <body>
        <table id="grid_id"></table>
        <div id="pager"></div>
    </body>
</html>

和前一个页面的区别主要在

 url:'/demo2/servlet/JqGridXmlServlet',
                mtype: 'GET',
                datatype: 'xml',

servlet代码(源码在下篇给出)

package com.qoma.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.et.ar.exception.ActiveRecordException;
import com.qoma.db.vo.InvHeader;
import com.qoma.service.InvHeaderService;

public class JqGridXmlServlet extends HttpServlet {

    /**
     * 
     */
    private static final long serialVersionUID = 6726805149005750238L;

    private InvHeaderService service = new InvHeaderService();

    /**
     * Constructor of the object.
     */
    public JqGridXmlServlet() {
        super();
    }

    /**
     * Destruction of the servlet. <br>
     */
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    /**
     * The doGet method of the servlet. <br>
     * 
     * This method is called when a form has its tag value method equals to get.
     * 
     * @param request
     *            the request send by the client to the server
     * @param response
     *            the response send by the server to the client
     * @throws ServletException
     *             if an error occurred
     * @throws IOException
     *             if an error occurred
     */
    public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }

    /**
     * The doPost method of the servlet. <br>
     * 
     * This method is called when a form has its tag value method equals to
     * post.
     * 
     * @param request
     *            the request send by the client to the server
     * @param response
     *            the response send by the server to the client
     * @throws ServletException
     *             if an error occurred
     * @throws IOException
     *             if an error occurred
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setContentType("text/xml");
        PrintWriter out = response.getWriter();

        Integer page = Integer.parseInt(request.getParameter("page"));
        Integer limit = Integer.parseInt(request.getParameter("rows"));
        String sidx = request.getParameter("sidx");
        String sord = request.getParameter("sord");

        String s = "";

        if (null == sidx || "".equals(sidx))
            sidx = "1";

        Long count = 0L;
        try {
            count = service.getCount();
        } catch (ActiveRecordException e) {
            e.printStackTrace();
        }
        Integer total_pages = 0;
        if (count > 0 && limit > 0) {
            total_pages = new Long(count / limit).intValue();
                if (count % limit != 0) {
                    total_pages += 1;
                }
        } else {
            total_pages = 0;
        }

        // if for some reasons the requested page is greater than the total
        // set the requested page to total page
        if (page > total_pages)
            page = total_pages;

        // calculate the starting position of the rows
        Integer start = limit * page - limit;

        if (start < 0)
            start = 0;

        s = "<?xml version='1.0' encoding='utf-8'?>";
        s += "<rows>";
        s += "<page>" + page + "</page>";
        s += "<total>" + total_pages + "</total>";
        s += "<records>" + count + "</records>";

        // be sure to put text data in CDATA
        List<InvHeader> list;
        try {
            list = service.getLimitList(start, limit, sidx, sord);
            for (InvHeader vo : list) {
                s += "<row id='" + vo.invId + "'>";
                s += "<cell>" + vo.invId + "</cell>";
                s += "<cell>" + vo.invDate + "</cell>";
                s += "<cell>" + vo.amount + "</cell>";
                s += "<cell>" + vo.tax + "</cell>";
                s += "<cell>" + vo.total + "</cell>";
                s += "<cell><![CDATA[" + vo.note + "]]></cell>";
                s += "</row>";
            }
        } catch (ActiveRecordException e) {
            e.printStackTrace();
        }
        s += "</rows>";

        out.println(s);
        out.flush();
        out.close();
    }

    /**
     * Initialization of the servlet. <br>
     * 
     * @throws ServletException
     *             if an error occurs
     */
    public void init() throws ServletException {
        // Put your code here
    }

}

注意：

response.setContentType("text/xml");

分享到：

jqGrid：四、 remote data(JSON) | jqGrid：二、第一个jqGrid

2010-09-30 15:00
浏览 1411
评论(0)
分类:Web前端
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

jqGrid：三、 remote data(XML)

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

jqGrid：三、 remote data(XML)

评论

发表评论

相关推荐

select box的操作

利用js对象去除数组重复

Javascript Returns Zero For parseInt('08') and parseInt('09')

jqGrid：六、 search

jqGrid：五、 Form Editing

jqGrid：四、 remote data(JSON)

jqGrid：二、 第一个jqGrid

jqGrid：一、 环境搭建

jqGrid问题

鼠标形状样式

禁用IE缓存

Javascript中的命名规范

工作笔记：JsonStore无法正常加载

工作笔记：ExtjsGrid数据拖拽页面无法加载

Ext.form timeout参数

Extjs 开发环境下store不加载数据

检测浏览器是否支持JavaScript功能

页面Size

Ext tbar的多行显示

在IE中使用Extjs出现“拒绝访问”

最近访客更多访客>>

jqGrid：二、第一个jqGrid

jqGrid：一、环境搭建