mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据
来源:动视网
责编:小采
时间:2020-11-09 16:48:13
mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据
mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据:mysqllinux服务器 String sql = SELECT Area.* FROM area AS Area,district AS d WHERE Area.districtid=d.districtid AND Area.areaname= ' + areaname + ' AND d.districtname=' + cityn
导读mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据:mysqllinux服务器 String sql = SELECT Area.* FROM area AS Area,district AS d WHERE Area.districtid=d.districtid AND Area.areaname= ' + areaname + ' AND d.districtname=' + cityn

mysqllinux服务器
String sql = "SELECT Area.* FROM area AS Area,district
AS d WHERE Area.districtid
=d.districtid
AND Area.areaname
= '"
+ areaname + "' AND d.districtname
='" + cityname + "'";
@SuppressWarnings("unchecked")
List as = (List) getCurrentSession()
.createSQLQuery(sql).addEntity("Area",Area.class).list();
mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据
mysql-Hibernate原生sql多表查询在Linux服务器上查询不到数据:mysqllinux服务器 String sql = SELECT Area.* FROM area AS Area,district AS d WHERE Area.districtid=d.districtid AND Area.areaname= ' + areaname + ' AND d.districtname=' + cityn