第一次使用jqgrid问题

maoye

2011-02-28

从网上找了N个例子试用，每次都是在前台firebug中都已经可以看到传过来josn数据了，但是在jqgrid中就是没有数据。

今天把josn数据中的单引号，全部替换成双引号，数据终于显示出来了。

jqgrid居然不识别单引号！！！！！！

这个足足搞了三天，居然是因为这个。。。郁闷！

<%@ page contentType="text/html;charset=utf-8"%>

<link rel="stylesheet" type="text/css" href="public/lib/jquery/css/ui.jqgrid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="public/lib/jquery/css/ui-lightness/jquery-ui-1.8.9.custom.css" />
<script src="public/lib/jquery/js/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="public/lib/jquery/js/i18n/grid.locale-cn.js" type="text/javascript"></script>  
<script src="public/lib/jquery/js/jquery.jqGrid.min.js" type="text/javascript"></script>


<html>
<head>
<title>ALOES</title>

<script type="text/javascript">  
$(document).ready(function(){      
 jQuery("#jsonmap").jqGrid({       
	   url : 'eventAction.do?method=getEvents',
	   datatype : "json",
	   colNames:['EventID','CUID', 'Date', 'Severity','EventType','Description'],
		 colModel:[
			{name:'eventID',index:'eventID', width:60},
			{name:'cuid',index:'cuid', width:90},
			{name:'eventTime',index:'eventTime', width:100},
			{name:'severity',index:'severity', width:80, align:"right"},
			{name:'eventType',index:'eventType', width:80, align:"right"},		
			{name:'description',index:'description', width:80,align:"right"}
		 ],
     imgpath: '/public/images',    
     rowNum:10,  
     rowList:[10,20,30],  
     pager: "pjmap",  
     multiselect: false,    
     sortname: 'eventID',    
     viewrecords: true,    
     sortorder: "desc",    
     jsonReader: {    
      	root: "events",  
      	repeatitems : false    
     },    
     caption: "jqGrid test",     
     
		loadComplete:function(){ //根据内容的值 更换行的背景色
        var n = $('#gridTable').getGridParam('records');  //取得现在表格中显示的数据条数
        //alert(n);
     },  
     width:800,
     height: 220    
    }).navGrid('pjmap',  
                {view:true,edit:true,add:false,del:false},  
                {closeOnEscape:true}  
    );   
             
});   
 </script>  
</head>
<body>
 <table id="jsonmap"  ></table>
 <div id="pjmap"  ></div>
</body>
</html>

java后台代码如下：

随便写的测试代码，比较乱。。。

public void getEvents(ActionMapping mapping,
			ActionForm form, HttpServletRequest request,
			HttpServletResponse response) throws Exception {
			StringBuffer str = new StringBuffer();
			//定义时间格式
			DateFormat format1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
			try {
				List eventList = eventService.getEvents();
				str.append("{\"events\":[");
				if (eventList != null && eventList.size()> 0) {
					//for(Iterator iter = eventList.iterator();iter.hasNext();){
					for(int i=0;i<10;i++){	
						Event event = (Event)eventList.get(i);
						str.append("{\"eventID\":"+"\""+event.getEventID()+"\",");
						str.append("\"cuid\":"+"\""+event.getCuid()+"\",");
						str.append("\"eventTime\":"+"\""+format1.format(event.getEventTime())+"\",");
						str.append("\"severity\":"+"\""+event.getSeverity()+"\",");
						str.append("\"eventType\":"+"\""+event.getEventType()+"\",");
						String dec = stringFilter(event.getDescription());
						str.append("\"description\":"+"\""+dec+"\"}");
/*						if(iter.hasNext()){
							str.append(",");
						}*/
						if(i<9){
							str.append(",");
						}
					}
				}
				//str.substring(0,str.length()-1);
				str.append("],\"page\":1,\"rows\":10,\"total\":10}");
				
		} catch(Exception e){
			logger.error("获取告警事件发生异常！",e);
		}
		response.setContentType(" text/josn;charset=utf-8 ");
		PrintWriter out = response.getWriter();  
		out.println(str);  
		out.flush(); 
	}

接收到的josn数据：

{
"events":[
                {"eventID":"1298878203692","cuid":"HP-3.125","eventTime":"2011-02-28 15:30:03","severity":"3","eventType":"Probe","description":" Connection refused"},
                {"eventID":"1298878202225","cuid":"HP-3.125","eventTime":"2011-02-28 15:30:02","severity":"3","eventType":"Probe","description":"Connection refused"},
                {"eventID":"1298878201201","cuid":"HP-3.125","eventTime":"2011-02-28 15:30:01","severity":"3","eventType":"Probe","description":" Connection refused"},
                {"eventID":"1298877903783","cuid":"HP-3.125","eventTime":"2011-02-28 15:25:03","severity":"3","eventType":"Probe","description":"Connection refused"},
                {"eventID":"1298877902365","cuid":"HP-3.125","eventTime":"2011-02-28 15:25:02","severity":"3","eventType":"Probe","description":" Connection refused"},
               {"eventID":"1298877901326","cuid":"HP-3.125","eventTime":"2011-02-28 15:25:01","severity":"3","eventType":"Probe","description":"Connection refused"},
               {"eventID":"1298867776540","cuid":"HP-3.125","eventTime":"2011-02-28 12:36:16","severity":"3","eventType":"Probe","description":"No route to host"},
               {"eventID":"1298867776521","cuid":"Dell-31","eventTime":"2011-02-28 12:36:16","severity":"3","eventType":"Probe","description":"Connection timed out"},
               {"eventID":"1298867776463","cuid":"HP-3.125","eventTime":"2011-02-28 12:36:16","severity":"3","eventType":"Probe","description":"Connection timed out"},
               {"eventID":"1298867774532","cuid":"HPGroup","eventTime":"2011-02-28 12:36:14","severity":"3","eventType":"Probe","description":"Connection timed out"}],
"page":1,"rows":10,"total":10
}

把这里边的双引号换成单引号数据就会无法显示！！！诡异。

jqgrid jquery