ajax返回多条json数据,多表联查，多条件查询，ajax返回值乱码，前台循环展示json数据...

多表联查,多条件查询

@Data

public class hangyunxingxi {

private int hangyunid;

private int rid;

private int starid;

private int endid;

private int dateid;

private String hangcheng;

private float price;

private String rname;

private String starname;

private String endname;

private String date;

}

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

SELECT hangyunid,hy.rid,r.rname,hy.starid,s.starname,e.endid,e.endname,hy.dateid,sd.date,hangche ng,price FROM hangyunxingxi hy

LEFT JOIN route r ON hy.rid=r.rid

LEFT JOIN star s ON hy.starid=s.starid

LEFT JOIN `end` e ON hy.endid=e.endid

LEFT JOIN stardate sd ON hy.dateid=sd.dateid

SELECT hangyunid,hy.rid,r.rname,hy.starid,s.starname,e.endid,e.endname,hy.dateid,sd.date,hangcheng,price FROM hangyunxingxi hy

LEFT JOIN route r ON hy.rid=r.rid

LEFT JOIN star s ON hy.starid=s.starid

LEFT JOIN `end` e ON hy.endid=e.endid

LEFT JOIN stardate sd ON hy.dateid=sd.dateid

rname=${rname}

AND s.starname=${starname}

AND e.endname=${endname}

AND sd.date=${date}

前台页面展示,解决ajax返回值乱码

使用ajax请求返回前台的时候会出现乱码的情况，需要在@RequestMapping中添加produces = "application/json; charset=utf-8"

//查询并展示所有航运信息

@RequestMapping(value = "hangyunlist",method = RequestMethod.POST , produces = "application/json; charset=utf-8")

@ResponseBody

public String hangyunxingxilist(HttpServletResponse response){

response.setContentType("text/html;charset=utf-8");

List hangyunxingxis = zlxService.queryHangyunxingxi();

Gson gson2=new Gson();

String str=gson2.toJson(hangyunxingxis);

return str;

}

//更具条件查询航运信息

@RequestMapping("reach")

public String reachhangyun(String rname,String starname,String endname,String date){ // hy 参数表示从前台传回的所有查询条件

List hangyunxingxis = zlxService.reachHangyunxingxi(rname,starname,endname,date);

System.out.println("查询信息" + hangyunxingxis);

return "";

}

$(function(){

$.ajax({

url: "hangyunlist",

type:"post",

dataType: "json",

data: {},//传送请求数据

success: function(data) {//登录成功后返回的数据

var list = data;

var $tr=[];

var $td;

for(var i=0; i

$td = $('

');

$('

'+list[i].rname+'').appendTo($td);

$('

'+list[i].starname+'').appendTo($td);

$('

'+list[i].endname+'').appendTo($td);

$('

'+list[i].date+'').appendTo($td);

$('

'+list[i].hangcheng+'').appendTo($td);

$('

'+list[i].price+'').appendTo($td);

$('

快速下单').appendTo($td);

$tr.push($td);

}

for(var j=0;j

$($tr[j]).appendTo($('#hylist'));

}

}

})

})