jQuery DataTables不显示Unicode字符 | DataTables不显示Unicode字符

本文介绍了jQuery DataTables不显示Unicode字符的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我使用jQuery DataTables来显示来自MySQL数据库的分页数据。

当我在此表中显示正常字符时，它会在表格中显示正确的数据。但是，当我保存Unicode字符时，它只显示？个字符。

以下是我的此页面的html代码：

 <％@ page language =javacontentType =text / html; charset = UTF-8
 pageEncoding =UTF-8％> 
  < html> 
< head> 
< meta http-equiv =Content-Typecontent =text / html; charset = UTF-8/> 
< title>乡镇< / title> 
< link rel =stylesheethref =< c：url value =/ resources / styles / township.css/>/> 
< link rel =stylesheettype =text / csshref =// cdn.datatables.net/1.10.0/css/jquery.dataTables.css\"> 
  < script type =text / javascriptcharset =utf8> 
 
 //获取页面数据的插件
 jQuery.fn.dataTableExt.oApi.fnPagingInfo = function（oSettings）
 {
 return {
 iStart：oSettings._iDisplayStart，
iEnd：oSettings.fnDisplayEnd（），
iLength：oSettings._iDisplayLength，
iTotal：oSettings.fnRecordsTotal（），
iFilteredTotal：oSettings.fnRecordsDisplay（），
iPage：oSettings._iDisplayLength === -1？ 
 0：Math.ceil（oSettings._iDisplayStart / oSettings._iDisplayLength），
iTotalPages：oSettings._iDisplayLength === -1？ 
 0：Math.ceil（oSettings.fnRecordsDisplay（）/ oSettings._iDisplayLength）
}; 
}; 
 $ b $（document）.ready（function（）{
 
 $（＃example）。dataTable（{
bProcessing：true，
bServerSide：true，
sort：position，
bStateSave：false，
iDisplayLength：10，
iDisplayStart 
fnDrawCallback：function（）{
 
}，
sAjaxSource：springPaginationDataTables.web，
aoColumns：[
 
 {mData：townshipCode}，
 {mData：townshipName}，
 {mData：divisionName}，
 {mData： actionlink}，
] 
}）; 
 
}）; 
 
< / script> 
< / head> 
< body> 
< div id =container> 
< div id =table> 
< form：form action =method =GETalign =center> 
< br> 
< table style =border：3px; background：rgb（243,244,248）; width：90％; margin：20px auto;>< tr>< td> 
< table id =exampleclass =display> 
< thead> 
< tr> 
代码< / th> 
< th>乡镇< / th> 
< th>分部< / th> 
< th>动作< / th> 
< / tr> 
< / thead> 
< / table> 
< / td>< / tr>< / table> 
< br> 
< / form：form> 
 
< / div> 
< / div> 
< / body> 
< / html>

此表的后端Java代码是：

  @RequestMapping（value =/springPaginationDataTables.web，method = RequestMethod.GET，produce =application / json）
 public @ResponseBody String springPaginationDataTables（HttpServletRequest request ）抛出IOException {
 
整型pageNumber = 0; 
 if（null！= request.getParameter（iDisplayStart））
 pageNumber =（Integer.valueOf（request.getParameter（iDisplayStart））/ 10）+1; 
 
整数pageDisplayLength = Integer.valueOf（request.getParameter（iDisplayLength））; 
 
列表< Township> listTownship = townshipDao.getList（pageNumber，pageDisplayLength）; 
 int count = townshipDao.getCount（）; 
 
 JsonObject< Township> townshipJsonObject = new JsonObject< Township>（）; 
 //设置总显示记录
 townshipJsonObject.setiTotalDisplayRecords（count）; 
 //设置总记录
 townshipJsonObject.setiTotalRecords（count）; 
 townshipJsonObject.setAaData（listTownship）; 
 
 Gson gson = new GsonBuilder（）。setPrettyPrinting（）。create（）; 
 String json2 = gson.toJson（townshipJsonObject）; 
 
返回json2; 
 
 $ / code>

我在数据表中得到以下输出，其中显示代替Unicode字符：

 
 
  
 
 请帮我解决这个问题。    
解决方案 
 
  @RequestMapping（value =/springPaginationDataTables.web，method = RequestMethod.GET， produce =application / json; charset = UTF-8） 
I am using jQuery DataTables to show pagination data from MySQL database. 
When I show normal characters in this table, it shows proper data in table. But, when I save Unicode characters it only shows ? characters.
The following is my html codes for this page:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Township</title>
<link rel="stylesheet" href="<c:url value="/resources/styles/township.css" />"/>
<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.0/css/jquery.dataTables.css">
<script type="text/javascript" charset = "utf8" src="//code.jquery.com/jquery-1.10.2.min.js"></script>
<script type="text/javascript" charset = "utf8" src="//cdn.datatables.net/1.10.0/js/jquery.dataTables.js"></script>
<script type="text/javascript" charset = "utf8" >

//Plug-in to fetch page data
jQuery.fn.dataTableExt.oApi.fnPagingInfo = function ( oSettings )
{
    return {
        "iStart":         oSettings._iDisplayStart,
        "iEnd":           oSettings.fnDisplayEnd(),
        "iLength":        oSettings._iDisplayLength,
        "iTotal":         oSettings.fnRecordsTotal(),
        "iFilteredTotal": oSettings.fnRecordsDisplay(),
        "iPage":          oSettings._iDisplayLength === -1 ?
            0 : Math.ceil( oSettings._iDisplayStart / oSettings._iDisplayLength ),
        "iTotalPages":    oSettings._iDisplayLength === -1 ?
            0 : Math.ceil( oSettings.fnRecordsDisplay() / oSettings._iDisplayLength )
    };
};

$(document).ready(function() {

$("#example").dataTable( {
    "bProcessing": true,
    "bServerSide": true,
    "sort": "position",
    "bStateSave": false,
    "iDisplayLength": 10,
    "iDisplayStart": 0,
    "fnDrawCallback": function () {

    },
    "sAjaxSource": "springPaginationDataTables.web",
    "aoColumns": [

        { "mData": "townshipCode" },
        { "mData": "townshipName" },
        { "mData": "divisionName" },
        { "mData": "actionlink"},
    ]
} );

} );

</script>
</head>
<body>
<div id="container">
    <div id="table">
        <form:form action="" method="GET" align="center">
            <br>
            <table style="border: 3px;background: rgb(243, 244, 248); width: 90%; margin:20px auto;"><tr><td>
                <table id="example" class="display">
                    <thead>
                        <tr>
                        <th>Code</th>
                        <th>Township</th>
                        <th>Division</th>
                        <th>Action</th>
                    </tr>
                </thead>
            </table>
            </td></tr></table>
            <br>
        </form:form>

    </div>
</div>
</body>
</html>
My backend Java code for this table is:
@RequestMapping(value = "/springPaginationDataTables.web", method = RequestMethod.GET, produces = "application/json")
public @ResponseBody String springPaginationDataTables(HttpServletRequest  request) throws IOException {

    Integer pageNumber = 0;
    if (null != request.getParameter("iDisplayStart"))
        pageNumber = (Integer.valueOf(request.getParameter("iDisplayStart"))/10)+1;

    Integer pageDisplayLength = Integer.valueOf(request.getParameter("iDisplayLength"));

    List<Township> listTownship = townshipDao.getList(pageNumber, pageDisplayLength);
    int count = townshipDao.getCount();

    JsonObject<Township> townshipJsonObject = new JsonObject<Township>();
    //Set Total display record
    townshipJsonObject.setiTotalDisplayRecords(count);
    //Set Total record
    townshipJsonObject.setiTotalRecords(count);
    townshipJsonObject.setAaData(listTownship);

    Gson gson = new GsonBuilder().setPrettyPrinting().create();
    String json2 = gson.toJson(townshipJsonObject);

    return json2;
}
I got the following output in Data Table which showing ? instead of Unicode characters:
Please help me to solve this problem.
 解决方案 
Try forcing the charset in the produces attribute like so:
@RequestMapping(value = "/springPaginationDataTables.web", method = RequestMethod.GET, produces = "application/json; charset=UTF-8")
                        这篇关于jQuery DataTables不显示Unicode字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！