hibernate执行原生态的sql语句,对于增删改hibernate封装的很好,但是对于查询自身比较喜欢原生态的sql语句,但是如果用hql会很麻烦,可能涉及到一个表对应一个类,但是如果我查询的是一个统计集合
首先来看一下原生态hql:
Users.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2018-9-14 21:22:54 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
<class name="com.zking.pojo.Users" table="t_USERS">
<cache usage="read-write" />
<id name="uid" type="java.lang.String">
<column name="UID" />
<generator class="guid" />
</id>
<property name="uname" type="java.lang.String">
<column name="UNAME" />
</property>
<property name="upwd" type="java.lang.String">
<column name="UPWD" />
</property>
</class>
</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<