Spring与Hibernate的配置

《！-----------------------------------------HibernateApplicationContext.xml---------------------

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="DataIndexDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/ycc?useUnicode=true&characterEncoding=utf8" /> <property name="user" value="root" /> <property name="password" value="root"/> </bean> <bean id="DataIndexFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"> <property name="dataSource" ref="DataIndexDataSource" /> <property name="hibernateProperties"> <props> <!-- 设置数据库方言 --> <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop> <!-- 在控制台输出SQL语句 --> <prop key="hibernate.show_sql">false</prop> </props> </property> <!-- 配置映射文件 --> <property name="mappingResources"> <list> <value>Student.hbm.xml</value> </list> </property> </bean> <bean id="DataIndexHibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"> <property name="sessionFactory" ref="DataIndexFactory" /> </bean> </beans> 

 

《！---------------------------------------Student.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.ms.hibernate.User" table="user"> <id name="name" type="java.lang.String"> <column name="name" length="10" /> <generator class="assigned" /> </id> <property name="password" type="java.lang.String"> <column name="password" length="10" not-null="true" /> </property> </class> </hibernate-mapping>  

《！ ---------------------------------------BaseDao.java------------------------------------------------

 

package com.ms.hibernate; import org.springframework.beans.BeansException; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.orm.hibernate3.HibernateTemplate; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.ms.exception.DBException; public class BaseDao extends HibernateDaoSupport { public static ApplicationContext factory; public static final String DataIndex = "DataIndexHibernateTemplate"; static { try { factory = new ClassPathXmlApplicationContext("HibernateApplicationContext.xml"); } catch (BeansException e) { throw new DBException(e.getMessage(), e); } } private BaseDao(){} public BaseDao(String dbName){ HibernateTemplate template = (HibernateTemplate)factory.getBean(dbName); setHibernateTemplate(template); } }  

 

《！-------------------------------------DataIndexDao.java-------------------------------------------------

 

package com.ms.ibatis; import java.sql.SQLException; import java.util.HashMap; import java.util.List; import java.util.Map; import com.ibatis.sqlmap.client.event.RowHandler; public class DataIndexDao extends BaseDao { public DataIndexDao(){ super(BaseDao.DataIndex); } public void queryInsert() throws SQLException{ Map m = new HashMap(); m.put("name", "haha"); m.put("sex", "1"); getSqlMapClient().insert("insertSecurity", m); } public void querySelect() throws SQLException{ List<Map> l = (List<Map>)getSqlMapClient().queryForList("getSecurity"); System.out.println(l.size()); } /** * public interface RowHandler( * void handleRow(object valueObject); * ) * 作用: 允许你在某个已映射语句的结构集的处理中插入自己的动作 * @throws SQLException */ public void querySelect2() throws SQLException{ getSqlMapClient().queryWithRowHandler("getSecurity", new RowHandler(){ public void handleRow(Object valueObject) { System.out.println(((HashMap)valueObject).get("name")); } }); } public static void main(String[] args) throws SQLException{ //new DataIndexDao().queryInsert(); new DataIndexDao().querySelect(); new DataIndexDao().querySelect2(); } }