第一种方式:
在dao实现层直接处理,eg:
public Users checkUser(Users users) {
List<Users> list = this.getHibernateTemplate().find("from com.zym.entity.Users where name=? and pwd=?", users.getName(),users.getPwd());
if (list.size()>0) {
return list.get(0);
}
return null;
}
第二种方式:
在映射文件中配置,eg:
Users.hbm.xml文件:
<hibernate-mapping>
<class name="com.zym.entity.Users" table="users" catalog="user">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="identity" />
</id>
<property name="name" type="java.lang.String">
<column name="name" length="20" />
</property>
<property name="pwd" type="java.lang.String">
<column name="pwd" length="50" />
</property>
</class>
<query name="queryUser">
select u from com.zym.entity.Users u where id>?
</query>
</hibernate-mapping>
UserDaoImpl.java文件:
SessionFactory sf = this.getSessionFactory();
Session session = sf.openSession();
Transaction ts = session.getTransaction();
ts.begin();
List<Users> list = session.getNamedQuery("queryUser")
.setParameter(0, 0)
.list();
第三种方式:
在配置文件中配置,eg:
applicationContext.xml文件:
<!-- 登陆DAO类 -->
<bean id="userDao" class="com.zym.dao.UserDaoImpl">
<property name="hibernateTemplate">
<ref bean="hibernateTemplate"/>
</property>
<property name="sqlMap">
<map>
<entry key="getUser">
<value>
from com.zym.entity.Users
</value>
</entry>
</map>
</property>
</bean>
UserDaoImpl.java文件:
private Map<String, String> sqlMap = new HashMap<String, String>();
public void setSqlMap(Map<String, String> sqlMap) {
this.sqlMap = sqlMap;
}
public List<Users> checkUser(String username) {
String hql = sqlMap.get("getUser");
SessionFactory sf = this.getSessionFactory();
Session session = sf.openSession();
Transaction ts = session.getTransaction();
ts.begin();
List<Users> list = session.createQuery(hql).list();
ts.commit();
return list;
}