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();
<code></code>