Spring和Hibernate整合的CRUD操作实例1

实体类User.java

package org.myclover.user;

import java.util.Date;

public class User {
private int userId;
private String userName;
private String userSex;
private String userEmail;
private Date userBirthday;

public int getUserId() {
return userId;
}

public void setUserId(int userId) {
this.userId = userId;
}

public String getUserName() {
return userName;
}

public void setUserName(String userName) {
this.userName = userName;
}

public String getUserSex() {
return userSex;
}

public void setUserSex(String userSex) {
this.userSex = userSex;
}

public String getUserEmail() {
return userEmail;
}

public void setUserEmail(String userEmail) {
this.userEmail = userEmail;
}

public Date getUserBirthday() {
return userBirthday;
}

public void setUserBirthday(Date userBirthday) {
this.userBirthday = userBirthday;
}
}


类映射文件User.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">
<hibernate-mapping package="org.myclover.user">
<class name="User" table="t_user">
<id name="userId" column="user_id">
<generator class="native"></generator>
</id>
<!-- type属性中的类型首字母是小写的 -->
<property name="userName" type="string" not-null="true" />
<property name="userSex" type="string" />
<property name="userEmail" type="string" />
<property name="userBirthday" type="date" />
</class>
</hibernate-mapping>



管理层接口UserManager.java

package org.myclover.user.service;

import java.util.List;

import org.myclover.user.User;

public interface UserManager {
public void addUser(User user);

public User findById(Integer id);

public List getAllUser();

public void deleteUser(Integer id);

public void updateUser(User user);
}


管理层实现UserManagerImpl.java

package org.myclover.user.service.impl;

import java.util.List;

import org.myclover.user.User;
import org.myclover.user.service.UserManager;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class UserManagerImpl extends HibernateDaoSupport implements UserManager {

/*
* private UserManager userManager;
*
* public void setUserManager(UserManager userManager) { this.userManager =
* userManager; }
*/

@Override
public void addUser(User user) {
this.getHibernateTemplate().save(user);
}

@Override
public List getAllUser() {
return this.getHibernateTemplate().find("from User");
}

@Override
public User findById(Integer id) {
return (User) this.getHibernateTemplate().get(User.class, id);
}

@Override
public void deleteUser(Integer id) {
this.getHibernateTemplate().delete(findById(id));
}

@Override
public void updateUser(User user) {
this.getHibernateTemplate().update(user);
}

}


hibernate.cfg.xml的配置文件

<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.url">jdbc:mysql://localhost/spring_hibernate_crud_test</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">fangfang</property>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<!--
<property name="hibernate.current_session_context_class">jta</property>
-->
<mapping resource="org/myclover/user/User.hbm.xml"/>
</session-factory>
</hibernate-configuration>