多表联查,多条件查询
@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'));
}
}
})
})