1.DAO接口 UserDAO
package com.yanek.demo.ssh.dao;
import java.util.List;
import com.yanek.demo.ssh.vo.User;
public interface UserDAO {
public void save(User user);
public List<User> findAll();
}
2.DAO接口实现 UserDAOImpl
package com.yanek.demo.ssh.dao;
import java.util.List;
import org.hibernate.Query;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.yanek.demo.ssh.vo.User;
public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {
public void save(User user) {
this.getHibernateTemplate().save(user);
}
public List<User> findAll()
{
try {
String queryString = "from User";
Query queryObject = getHibernateTemplate().getSessionFactory()
.openSession().createQuery(queryString);
return queryObject.list();
} catch (RuntimeException re) {
throw re;
}
}
}
3. vo: User
package com.yanek.demo.ssh.vo;
public class User implements java.io.Serializable {
private int id;
private String username;
private String password;
private String email;
public User() {
}
public User(int id, String username, String password, String email) {
super();
this.id = id;
this.username = username;
this.password = password;
this.email = email;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}
4. 配置文件： User.hbm.xm
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.yanek.demo.ssh.vo.User" table="t_user" schema="dbo"
catalog="ssh" lazy="false">
<id name="id" type="java.lang.Integer">
<column name="id" />
<generator class="native" />
</id>
<property name="username" type="java.lang.String">
<column name="username" length="50" />
</property>
<property name="password" type="java.lang.String">
<column name="password" length="50" />
</property>
<property name="email" type="java.lang.String">
<column name="email" length="50" />
</property>
</class>
</hibernate-mapping>
