ibatis 和 hiberante 组合使用 动态查询

 hiberante接口

package com.xiaomaha.hibernate.dao; import java.io.Serializable; import java.util.Collection; import java.util.List; public interface HibernateDao { public void save(Object obj); public void delete(Object obj); public void update(Object obj); public void saveOrUpdate(Object obj); public void saveOrUpdateAll(Collection collection); public void deleteAll(Collection collection); public Object getHqlById(Class c, Serializable id); public List findHqlAll(Class c); }

hibernate实现类

package com.xiaomaha.hibernate.dao; import java.io.Serializable; import java.util.Collection; import java.util.List; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; public class HibernateDaoImpl extends HibernateDaoSupport implements HibernateDao { private static final String FROM = "from "; public void delete(Object obj) { getHibernateTemplate().delete(obj); } public void deleteAll(Collection collection) { getHibernateTemplate().deleteAll(collection); } public List findHqlAll(Class c) { return getHibernateTemplate().find(new StringBuilder(FROM).append(c.getName()).toString()); } public Object getHqlById(Class c, Serializable id) { return getHibernateTemplate().get(c, id); } public void save(Object obj) { getHibernateTemplate().save(obj); } public void saveOrUpdateAll(Collection collection) { getHibernateTemplate().saveOrUpdateAll(collection); } public void saveOrUpdate(Object obj) { getHibernateTemplate().saveOrUpdate(obj); } public void update(Object obj) { getHibernateTemplate().update(obj); } }

ibatis接口

package com.xiaomaha.ibatis.dao; import java.util.List; public interface IbatisDao { public List findSql(String sqlMapping); public List findSql(String sqlMapping , Object parameters); }

实现类

package com.xiaomaha.ibatis.dao; import java.util.List; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; public class IbatisDaoImpl extends SqlMapClientDaoSupport implements IbatisDao { public List findSql(String sqlMapping) { return getSqlMapClientTemplate().queryForList(sqlMapping); } public List findSql(String sqlMapping, Object parameter) { return getSqlMapClientTemplate().queryForList(sqlMapping, parameter); } }

自定义接口

package com.xiaomaha.dao; import com.xiaomaha.hibernate.dao.HibernateDao; import com.xiaomaha.ibatis.dao.IbatisDao; public interface DatabaseDao extends HibernateDao,IbatisDao{ }

自定义接口实现类

package com.xiaomaha.dao; import java.io.Serializable; import java.util.Collection; import java.util.List; import com.xiaomaha.hibernate.dao.HibernateDao; import com.xiaomaha.ibatis.dao.IbatisDao; public class DatabaseDaoImpl implements DatabaseDao { private HibernateDao hiberanteDao; private IbatisDao ibatisDao; public HibernateDao getHiberanteDao() { return hiberanteDao; } public void setHiberanteDao(HibernateDao hiberanteDao) { this.hiberanteDao = hiberanteDao; } public IbatisDao getIbatisDao() { return ibatisDao; } public void setIbatisDao(IbatisDao ibatisDao) { this.ibatisDao = ibatisDao; } public void delete(Object obj) { hiberanteDao.delete(obj); } public void deleteAll(Collection collection) { hiberanteDao.deleteAll(collection); } public List findHqlAll(Class c) { return hiberanteDao.findHqlAll(c); } public Object getHqlById(Class c, Serializable id) { return hiberanteDao.getHqlById(c, id); } public void save(Object obj) { hiberanteDao.save(obj); } public void saveOrUpdate(Object obj) { hiberanteDao.saveOrUpdate(obj); } public void saveOrUpdateAll(Collection collection) { hiberanteDao.saveOrUpdateAll(collection); } public void update(Object obj) { hiberanteDao.update(obj); } public List findSql(String sqlMapping) { return ibatisDao.findSql(sqlMapping); } public List findSql(String sqlMapping, Object parameters) { return ibatisDao.findSql(sqlMapping, parameters); } }

service

package com.xiaomaha.service; import java.util.List; import com.xiaomaha.dao.DatabaseDao; import com.xiaomaha.model.Person; public class PersonService { private DatabaseDao dao; public DatabaseDao getDao() { return dao; } public void setDao(DatabaseDao dao) { this.dao = dao; } public List<Person> getPersonAll(){ return dao.findSql("getPersonAll"); } public void save(Person person){ dao.save(person); } public List<Person> getPersonDynamic(Person person){ return dao.findSql("getPersonDynamic"); } }

测试

package com.xiaomaha.test; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.xiaomaha.model.Person; import com.xiaomaha.service.PersonService; public class Main { /** * @param args */ public static void main(String[] args) { ApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml"); PersonService service = (PersonService) app.getBean("personService"); //动态查询 Person p1 = new Person(); p1.setAge(1); List<Person> list = service.getPersonDynamic(p1); for(Person p : list){ System.out.println(p.getUsername()); } // //ibatis查询 List<Person> list2 = service.getPersonAll(); for(Person p2 : list2){ System.out.println(p2.getUsername()); } // // //hiberante保存 Person p3 = new Person(); p3.setUsername("xiaomaha"); p3.setPassword("222"); service.save(p3); } }

spring.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.0.xsd"> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="username" value="root"></property> <property name="password" value="root"></property> </bean> <!-- ibatis --> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:sqlMapConfig.xml"/> </bean> <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate"> <property name="sqlMapClient" ref="sqlMapClient"></property> </bean> <!-- end --> <!-- hiberante --> <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="dataSource"></property> <property name="configLocation" value="classpath:hibernate.cfg.xml"> </property> </bean> <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory" ref="sessionFactory"></property> </bean> <!-- end --> <!-- dao --> <bean id="ibatisDao" class="com.xiaomaha.ibatis.dao.IbatisDaoImpl" parent="sqlMapClientTemplate"/> <bean id="hibernateDao" class="com.xiaomaha.hibernate.dao.HibernateDaoImpl" parent="hibernateTemplate"/> <bean id="databaseDao" class="com.xiaomaha.dao.DatabaseDaoImpl"> <property name="ibatisDao" ref="ibatisDao"></property> <property name="hiberanteDao" ref="hibernateDao"></property> </bean> <!-- end --> <bean id="personService" class="com.xiaomaha.service.PersonService"> <property name="dao" ref="databaseDao"></property> </bean> </beans>

model

package com.xiaomaha.model; /** * Person generated by MyEclipse Persistence Tools */ public class Person implements java.io.Serializable { // Fields private Integer id; private String username; private String password; private Integer age; private Integer sex; // Constructors /** default constructor */ public Person() { } /** minimal constructor */ public Person(String username, String password) { this.username = username; this.password = password; } /** full constructor */ public Person(String username, String password, Integer age, Integer sex) { this.username = username; this.password = password; this.age = age; this.sex = sex; } // Property accessors public Integer getId() { return this.id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return this.username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return this.password; } public void setPassword(String password) { this.password = password; } public Integer getAge() { return this.age; } public void setAge(Integer age) { this.age = age; } public Integer getSex() { return this.sex; } public void setSex(Integer sex) { this.sex = sex; } }

<?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="test"> <id name="id" type="java.lang.Integer"> <column name="id" /> <generator class="native" /> </id> <property name="username" type="java.lang.String"> <column name="username" not-null="true" /> </property> <property name="password" type="java.lang.String"> <column name="password" not-null="true" /> </property> <property name="age" type="java.lang.Integer"> <column name="age" /> </property> <property name="sex" type="java.lang.Integer"> <column name="sex" /> </property> </class> </hibernate-mapping>

sqlMap.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap> <typeAlias alias="person" type="com.xiaomaha.model.Person"/> <select id="getPersonAll" resultClass="person"> select * from Person </select> <select id="getPersonDynamic" resultClass="person" parameterClass="person"> select * from Person <dynamic prepend="where"> <isNotNull prepend="and" property="sex"> sex = #sex# </isNotNull> </dynamic> </select> </sqlMap>

sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <sqlMap resource="com/xiaomaha/model/Person.sqlMap.xml"/> </sqlMapConfig>

 

这样使用的好处在于，只需要实现一个DAO就可以完成全部操作