spring+hibernate

 

接口

 

package com.xiaomaha.dao; import java.io.Serializable; import java.util.List; public interface InterfaceDatabaseDao { public void save(Object obj); public void delete(Object obj); public void update(Object obj); public void deleteById(Class c, Serializable id); public List find(String queryString); public Object getById(Class c, Serializable id); public List find(String queryString,Object[] obj); }

抽象类

package com.xiaomaha.dao; import java.io.Serializable; import java.util.List; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; public abstract class HibernateDaoImpl extends HibernateDaoSupport implements InterfaceDatabaseDao { public void delete(Object obj) { getHibernateTemplate().delete(obj); } public void deleteById(Class c, Serializable id) { Object obj = getById(c, id); getHibernateTemplate().delete(obj); } public List find(String queryString) { return getHibernateTemplate().find(queryString); } public Object getById(Class c, Serializable id) { return getHibernateTemplate().get(c, id); } public void save(Object obj) { getHibernateTemplate().save(obj); } public void update(Object obj) { getHibernateTemplate().update(obj); } public List find(String queryString,Object[] obj){ return getHibernateTemplate().find(queryString,obj); } }

实现类

package com.xiaomaha.dao; import java.util.List; import com.xiaomaha.util.PropertySqlMapResource; public class DatabaseDao extends HibernateDaoImpl { private PropertySqlMapResource sqlMap; public PropertySqlMapResource getSqlMap() { return sqlMap; } public void setSqlMap(PropertySqlMapResource sqlMap) { this.sqlMap = sqlMap; } @Override public List find(String sqlMapKey,Object[] parameter) { return super.find(sqlMap.getString(sqlMapKey),parameter); } @Override public List find(String sqlMapKey){ return super.find(sqlMap.getString(sqlMapKey)); } public Object findObject(String sqlMapKey,Object[] parameter){ List list = find(sqlMapKey,parameter); return !list.isEmpty()?list.get(0):null; } }

sqlMapping.properties

getPersonAll = from Person getPersonName = from Person where name=?

 

读取PropertySql

 

package com.xiaomaha.util; import java.util.Enumeration; import java.util.HashMap; import java.util.Locale; import java.util.Map; import java.util.ResourceBundle; public class PropertySqlMapResource { private static PropertySqlMapResource sqlMap; private ResourceBundle rb; private Locale locale; private String resourceName = "sqlMapping"; private Map<String, String> propertyMap = new HashMap<String, String>(); public PropertySqlMapResource(){ } public void init() { if (null == rb) { rb = null == locale ? ResourceBundle.getBundle(resourceName) : ResourceBundle.getBundle(resourceName, locale); Enumeration<String> e = rb.getKeys(); while (e.hasMoreElements()) { String key = e.nextElement(); String value = rb.getString(key); propertyMap.put(key, value); } } } public static PropertySqlMapResource newInstance(){ return null==sqlMap? sqlMap = new PropertySqlMapResource():sqlMap; } public String getString(String key) { init(); return propertyMap.get(key); } public String getResourceName() { return resourceName; } public void setResourceName(String resourceName) { this.resourceName = resourceName; } public Locale getLocale() { return locale; } public void setLocale(Locale locale) { this.locale = locale; } }

模型

package com.xiaomaha.model; /** * Person generated by MyEclipse Persistence Tools */ public class Person implements java.io.Serializable { // Fields /** * */ private static final long serialVersionUID = 8341259801962641918L; private Integer id; private String name; private String password; // Constructors /** default constructor */ public Person() { } /** minimal constructor */ public Person(String name) { this.name = name; } /** full constructor */ public Person(String name, String password) { this.name = name; this.password = password; } // Property accessors public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } public String getName() { return this.name; } public void setName(String name) { this.name = name; } public String getPassword() { return this.password; } public void setPassword(String password) { this.password = password; } }

 

<?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"> <!-- Mapping file autogenerated by MyEclipse Persistence Tools --> <hibernate-mapping> <class name="com.xiaomaha.model.Person" table="person" catalog="xiaomaha"> <id name="id" type="java.lang.Integer"> <column name="id" /> <generator class="native" /> </id> <property name="name" type="java.lang.String"> <column name="name" not-null="true" /> </property> <property name="password" type="java.lang.String"> <column name="password" /> </property> </class> </hibernate-mapping>

spring配置文件

<?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.0.xsd"> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="configLocation" value="classpath:hibernate.cfg.xml"> </property> </bean> <bean id="hibernateDao" class="com.xiaomaha.dao.HibernateDaoImpl" abstract="true"> <property name="sessionFactory" ref="sessionFactory"></property> </bean> <bean id="databaseDao" class="com.xiaomaha.dao.DatabaseDao" parent="hibernateDao"> <property name="sqlMap" ref="propertySqlMapResource"></property> </bean> <bean id="propertySqlMapResource" class="com.xiaomaha.util.PropertySqlMapResource"></bean> </beans>

main

package com.xiaomaha.test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.xiaomaha.dao.DatabaseDao; import com.xiaomaha.model.Person; public class Test { /** * @param args */ public static void main(String[] args) { ApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml"); DatabaseDao dao = (DatabaseDao) app.getBean("databaseDao"); Person person = (Person) dao.findObject("getPersonName", new String[]{"xiaomaha1"}); System.out.println(null!=person?person.getName():"用户不存在"); } }

 

这样写可以只定义一个DAO，service层确认HQL 感觉可以提高效率