spring和hibernate整合

applicationContext.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"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:p="http://www.springframework.org/schema/p"
 xsi:schemaLocation="
    http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">
 <context:property-placeholder location="/WEB-INF/config/jdbc.properties"/>

 <bean id="dbcpDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <!-- Connection Info -->
  <property name="driverClassName" value="${jdbc.driverClassName}"/>
  <property name="url" value="${jdbc.url}"/>
  <property name="username" value="${jdbc.username}"/>
  <property name="password" value="${jdbc.password}"/>
  
  <!-- Connection Pooling Info -->
  <property name="initialSize" value="${dbcp.initialSize}"/>
  <property name="maxIdle" value="${dbcp.maxIdle}"/>
  <property name="maxActive" value="${dbcp.maxActive}"/>
  <property name="minEvictableIdleTimeMillis" value="${dbcp.minEvictableIdleTimeMillis}"/>
  <property name="defaultAutoCommit" value="${dbcp.defaultAutoCommit}"/>
  <property name="timeBetweenEvictionRunsMillis" value="${dbcp.timeBetweenEvictionRunsMillis}"/>
 </bean>
 
 
 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.simple.SimpleJdbcTemplate">
  <constructor-arg name="dataSource" ref="dbcpDataSource"/>
 </bean>
 
 
 <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
  <property name="dataSource" ref="dbcpDataSource" />
  <property name="packagesToScan">
   <list>
    <value>com.bbscn.entity</value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">${dialect}</prop>
    <prop key="hibernate.show_sql">${show_sql}</prop>
    <prop key="hibernate.format_sql">${format_sql}</prop>
    <prop key="hibernate.jdbc.batch_size">${jdbc.batch_size}</prop>
    <prop key="hibernate.cache.use_query_cache">${cache.use_query_cache}</prop>
    <prop key="hibernate.hbm2ddl.auto">${hbm2ddl.auto}</prop>
   </props>
  </property>
  
 </bean>
 
 <bean id="transactionMangers" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
  <property name="sessionFactory" ref="sessionFactory" />
 </bean>
 
 <tx:annotation-driven transaction-manager="transactionManager"/>
 
 <context:annotation-config /> 
  
 <context:component-scan base-package="com.bbscn.service,com.bbscn.dao" /> 
 
</beans>

 

 

service.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"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:aop="http://www.springframework.org/schema/aop"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
    http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">
  
  
  
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
     <property name="viewClass" value="org.springframework.web.servlet.view.JstlView"/>
     <property name="prefix" value="/WEB-INF/jsp/"/>
     <property name="suffix" value=".jsp"/>
   </bean>
   
   <context:component-scan base-package="com.bbscn.action" />
   
   <mvc:annotation-driven/>
            
</beans>

 

 

web.xml

 

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 version="2.4"
 xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee   http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
 <!-- 覆盖default servlet的/, springmvc servlet将处理原来处理静态资源的映射 -->
 <description>bbs论坛</description>
 <display-name>bbsOs</display-name>
 
 
 
 <context-param>
  <param-name>contextConfigLocation</param-name>
  <param-value>
   /WEB-INF/config/applicationContext.xml
   /WEB-INF/config/jcaptcha-context.xml
  </param-value>
 </context-param>
 
 
 <listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
 </listener>
 
 
 
 
 
 
 <filter>
  <filter-name>encoding</filter-name>
  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  <init-param>
   <param-name>encoding</param-name>
   <param-value>utf-8</param-value>
  </init-param>
  <init-param>
   <param-name>forceEncoding</param-name>
   <param-value>true</param-value>
  </init-param>
 </filter>
 
 <filter-mapping>
  <filter-name>encoding</filter-name>
  <url-pattern>*.do</url-pattern>
 </filter-mapping>
 
 
 <servlet>
  <servlet-name>bbsOs</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <init-param>
   <param-name>contextConfigLocation</param-name>
   <param-value>/WEB-INF/config/bbsOs-service.xml</param-value>
  </init-param>
  <load-on-startup>1</load-on-startup>
 </servlet>
 
 <servlet-mapping>
  <servlet-name>bbsOs</servlet-name>
  <url-pattern>*.do</url-pattern>
 </servlet-mapping>
 
  <servlet>
    <servlet-name>JcaptchaServlet</servlet-name>
    <servlet-class>com.bbscn.service.JcaptchaServlet</servlet-class>
  </servlet>

  <servlet-mapping>
    <servlet-name>JcaptchaServlet</servlet-name>
    <url-pattern>/jcaptcha.do</url-pattern>
  </servlet-mapping>
 
 <welcome-file-list>
  <welcome-file>index.jsp</welcome-file>
 </welcome-file-list>
</web-app>

 

 

 

 jdbc.properties

 

 

dbcp.initialSize=10
dbcp.maxIdle=5
dbcp.maxActive=50
dbcp.defaultAutoCommit=false
dbcp.minEvictableIdleTimeMillis=3600000
dbcp.timeBetweenEvictionRunsMillis=3600000

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/bbsOs?characterEncoding\=UTF-8
jdbc.username=root
jdbc.password=123456

dialect=org.hibernate.dialect.MySQLDialect
show_sql=true
format_sql=true
jdbc.batch_size=20
cache.use_query_cache=false
hbm2ddl.auto=update