jQuery DataTables不显示Unicode字符 [英] jQuery DataTables does not show Unicode characters
本文介绍了jQuery DataTables不显示Unicode字符的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我使用jQuery DataTables来显示来自MySQL数据库的分页数据。
当我在此表中显示正常字符时，它会在表格中显示正确的数据。但是，当我保存Unicode字符时，它只显示？个字符。
以下是我的此页面的html代码：
<％@ page language =javacontentType =text / html; charset = UTF-8
pageEncoding =UTF-8％>
<％@ taglib prefix =formuri =http://www.springframework.org/tags/form％>
<％@ taglib uri =http://java.sun.com/jsp/jstl/coreprefix =c％>
< 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字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
