1,首先建立映射实体的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" xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
<bean id="userService" class="cn.entity.User" />
<bean id="service" class="cn.service.impl.UserServiceBean">
<property name="user" ref="userService" /><!-- name的值必须与。。。一致 -->
</bean>
<!-- 将hibernate加到spring -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="configLocation" value="classpath:hibernate.cfg.xml">
</property>
</bean>
</beans>
2,建立hibernate配置文件，hibernate.cfg.xml
代码如下:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>
<session-factory>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.url">jdbc:mysql://localhost:3306/image</property>
<property name="connection.username">root</property>
<property name="connection.password">123456</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="myeclipse.connection.profile">image</property>
<mapping resource="cn/entity/imgAddress.xml" />
<mapping resource="cn/entity/image.xml" />
</session-factory>
</hibernate-configuration>
3,建立测试类
代码如下:
Session s = HibernateUtil.getSession();
String hql = "from ImageBean where lanmu='" + 2 + "'";
Query query = s.createQuery(hql);
List<ImageBean> list = query.list();
if (list.size() > 0) {
for (ImageBean imageBean : list) {
System.out.println("title:" + imageBean.getTitle());
System.out.println("Username:" + imageBean.getUsername());
}
} else {
System.out.println("这是空的！");
}