`
jay11777
  • 浏览: 19063 次
  • 性别: Icon_minigender_1
  • 来自: 深圳
社区版块
存档分类
最新评论

jqGrid从servlet读取数据

    博客分类：
  • web
jqGrid从servlet读取数据 
阅读更多
JQGrid从java Servlet读取数据
2008-10-24 10:32
新建Servlet如下
package org.crystal.jqgrid;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.crystal.mapping.*;

import java.io.PrintWriter;
import java.util.*;

public class Jqgrid extends HttpServlet {
    private String defaultEncoding = "ISO-8859-1";

    @Override
    public void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        // TODO Auto-generated method stub
        response.setContentType("application/json;charset=" + getEncoding());
        PrintWriter out = response.getWriter();
        String json="";
        /*System.out.println(request.getQueryString());
        System.out.println(request.getMethod());
        System.out.println(request.getParameter("name"));
        System.out.println(request.getParameter("mem"));
        */
        System.out.println("*******************************************");
        System.out.println("Out Print all Post & Get getParameter...");
        Map map=request.getParameterMap();
        Iterator it = map.entrySet().iterator();

        while (it.hasNext()) {
            Map.Entry entry = (Map.Entry) it.next();
            Object key = entry.getKey();
            Object value = entry.getValue();
            System.out.println("key:"+key.toString()+" value:"+request.getParameter(key.toString()));
        }
        System.out.println("End Out Print all Post & Get getParameter");
        System.out.println("*******************************************");
        //System.out.println("org.crystal.jqgrid.doGet");        String json="";
        json +="{ total: '200', page: '2', records: '30',rows : [ ";
        json +="{id:'1', cell:['cell11', 'cell12', 'cell13']}";
        json +=", {id:'2', cell:['cell21', 'cell22', 'cell23']}";
        json +=" ] }";
        out.print(""+json+"");
        //
    }

    @Override
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);

    }

    /**
    * Retrieve the encoding <p/>
    *
    * @return The encoding associated with this template (defaults to the value
    *         of 'struts.i18n.encoding' property)
    */
    protected String getEncoding() {
        String encoding = this.defaultEncoding;

        if (encoding == null) {
            encoding = System.getProperty("file.encoding");
        }

        if (encoding == null) {
            encoding = "UTF-8";
        }
        return encoding;
    }

}

在web.xml中配置访问上下文
    <servlet>
        <servlet-name>Jqgrid</servlet-name>
        <servlet-class>org.crystal.jqgrid.Jqgrid</servlet-class>
    </servlet>

    <servlet-mapping>
        <servlet-name>Jqgrid</servlet-name>
        <url-pattern>/servlet/Jqgrid</url-pattern>
    </servlet-mapping>

编辑客户端的jsp
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>


<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://"
            + request.getServerName() + ":" + request.getServerPort()
            + path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <base href="<%=basePath%>">

        <title>jqGrid</title>

        <meta http-equiv="pragma" content="no-cache">
        <meta http-equiv="cache-control" content="no-cache">
        <meta http-equiv="expires" content="0">
        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
        <meta http-equiv="description" content="This is my page">
      
        <link rel="stylesheet" type="text/css" media="screen" href="jquery/jqGrid/themes/basic/grid.css" />
        <link rel="stylesheet" type="text/css" media="screen" href="jquery/jqGrid/themes/jqModal.css" />

        <script src="jquery/jquery.js" type="text/javascript"></script>
        <script src="jquery/jqGrid/jquery.jqGrid.js" type="text/javascript"></script>
        <script src="jquery/jqGrid/js/jqModal.js" type="text/javascript"></script>
        <script src="jquery/jqGrid/js/jqDnR.js" type="text/javascript"></script>
    </head>

    <body>
        <script type="text/javascript">
        jQuery(document).ready(function(){
            jQuery("#list").jqGrid({
                url:'servlet/Jqgrid',
                editurl:'servlet/Jqgrid', 
                datatype: "json",
                loadtext:'正在加载...',
                height: 250,
                   colNames:['id,'invdate', 'name'],
                   colModel:[
                       {name:'id',index:'id', width:70, sorttype:"int", editable: true},
                       {name:'invdate',index:'invdate', width:90, sorttype:"date", editable: true},
                       {name:'name',index:'name', width:100, editable: true}
                   ],
                pager: jQuery('#pager'),
                rowNum:4,
                rowList:[3,6,9,12],
                sortname: 'id',
                sortorder: "desc",
                viewrecords: true,
                   imgpath: 'jquery/jqGrid/themes/basic/images',
                   caption: '测试实例'
                }).navGrid('#pager',
                    {edit:true,add:true,del:true,search:false }
                    );
                  
});
  
//

    </script>
        <table id="list" class="scroll"></table>
        <div id="pager" class="scroll" style="text-align: center;"></div>

    </body>
</html>

发布程序并访问客户端的jsp页面
分享到：
| Oracle
评论
发表评论

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

相关推荐

Magicbox
Global site tag (gtag.js) - Google Analytics