一、准备工作:
1.建立数据库think,建立数据表user,里面有两个字段name和pwd,均为varchar类型。
2.在eclipse中创建SH工程,在lib目录下导入相关包:
二、Hibernate的相关准备工作
1.建立com.zt包,在包下建立持久化类User.java:
package com.zt;
import java.io.Serializable;
public class User implements Serializable {
private String name;//姓名
private String pwd;//密码
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd=pwd;
}
}
2.配置这个持久化类,在com.zt包下建立User.hbm.xml文件:
<?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.zt.User" table="user">
<composite-id>
<key-property name="name" type="java.lang.String">
<column name="name" length="200" />
</key-property>
<key-property name="pwd" type="java.lang.String">
<column name="pwd" length="200" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>
三、将hibernate与Spring整合:
1.在com.zt包下建立UserDAO.java类,并在src目录下编写总的配置文件bean.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<!-- 配置数据源 -->
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/think
</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>****</value>
</property>
</bean>
<!-- 定义Hibernate的sessionFactory -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<!-- 数据库连接方言 -->
<prop key="dialect">org.hibernate.dialect.SQLServerDialect</prop>
<!-- 在控制台输出SQL语句 -->
<prop key="hibernate.show_sql">true</prop>
<!-- 格式化控制台输出的SQL语句 -->
<prop key="hibernate.format_sql">true</prop>
</props>
</property>
<!--Hibernate映射文件 -->
<property name="mappingResources">
<list>
<value>com/zt/User.hbm.xml</value>
</list>
</property>
</bean>
<!-- 注入SessionFactory -->
<bean id="userDAO" class="com.zt.UserDAO">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
</beans>
2.在UserDAO中编写具体的增删改查方法:
3.编写AddUser.java类实现增:
package com.zt;
import org.springframework.beans.factory.BeanFactory;
import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;
import org.springframework.core.io.Resource;
import com.zt.UserDAO;
import com.zt.User;
public class AddUser {
//添加用户信息
public static void main(String[] args) {
Resource resource = new ClassPathResource("bean.xml");//获取配置文件
BeanFactory factory = new XmlBeanFactory(resource);
UserDAO userDAO = (UserDAO)factory.getBean("userDAO");//获取UserDAO
User user = new User();
user.setName("爬爬");//设置姓名
user.setPwd("123");//设置密码
userDAO.insert(user);//执行用户添加的方法
System.out.println("添加成功!");
}
}
4.编写DeleteUser.java实现删:
5.编写UpdateUser.java实现改:
6.编写FindUser.java实现查: