Spring配置数据源以及hibernate

<?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"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/beans 
　　　　http://www.springframework.org/schema/beans/spring-beans-3.1.xsd 
　　　　http://www.springframework.org/schema/tx 
    http://www.springframework.org/schema/tx/spring-tx.xsd
    http://www.springframework.org/schema/aop 
    http://www.springframework.org/schema/aop/spring-aop-3.1.xsd"
    xmlns:tx="http://www.springframework.org/schema/tx">

    <bean id="datasource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">    
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />    
        <property name="url" value="jdbc:mysql://localhost:3306/flower??useUnicode=true&amp;characterEncoding=UTF-8"></property>    
        <property name="username" value="root" />  
         <property name="password" value="1213265442" />        
        <!-- 数据库连接池保持的最小连接数 -->    
        <property name="minIdle" value="5" /> <property name="maxIdle" value="30" /> 
         <property name="testOnBorrow" value="true" />    
        <!-- 返回连接时是否进行有效性验证 -->    
        <property name="testOnReturn" value="true" />    
        <!-- 连接空闲时是否进行有效性验证 -->    
        <property name="testWhileIdle" value="true" /> 
    </bean>    
    
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
           <property name="dataSource" ref="datasource"/>  
        <property name="hibernateProperties">
                <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                </props>
                </property>         
        <property name="mappingResources">  
            <list>  
                 <value>com/jikexueyuan/entity/Assess.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/Catalog.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/ConsumeDetaileInfo.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/ConsumeOrder.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/Flower.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/OrderForm.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/ShoppingCart.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/User.hbm.xml</value>  
                 <value>com/jikexueyuan/entity/UserDetail.hbm.xml</value>  
            </list>  
           </property>
    </bean>
</beans>

 

转载于:https://www.cnblogs.com/HardRockVersion/p/6605549.html