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();}}