1 <?xml version="1.0" encoding="UTF-8"?> 2 <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" 3     version="3.0"> 4     <display-name>My-SSH</display-name> 5      6     <welcome-file-list> 7         <welcome-file>index.html</welcome-file> 8         <welcome-file>index</welcome-file> 9     </welcome-file-list>10     11       <!-- 配置启动IOC容器的Listener -->12     <!-- needed for ContextLoaderListener -->13     <context-param>14         <param-name>contextConfigLocation</param-name>15         <param-value>classpath:applicationContext.xml</param-value>16     </context-param>17 18     <!-- Bootstraps the root web application context before servlet initialization -->19     <listener>20         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>21     </listener>22 </web-app>

 1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE hibernate-configuration PUBLIC 3         "-//Hibernate/Hibernate Configuration DTD 3.0//EN" 4         "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> 5 <hibernate-configuration> 6     <session-factory> 7         <!-- 8         把一下配置信息转移到jdbc.properties中。 9         <property name="hibernate.connection.username">root</property>10         <property name="hibernate.connection.password">123456</property>11         <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>12         <property name="hibernate.connection.url">jdbc:mysql://localhost/my_ssh</property>13         -->14 15         <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>16         <property name="hibernate.show_sql">true</property>17         <property name="hibernate.format_sql">true</property>18         <property name="hibernate.hbm2ddl.auto">update</property>19         <property name="hibernate.current_session_context_class">thread</property>20     </session-factory>21 </hibernate-configuration>

#-----------------------------------------------------# \u6570\u636E\u5E93\u914D\u7F6E#-----------------------------------------------------#\u670D\u52A1\u5668\u5730\u5740host=127.0.0.1dbName=my_sshjdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://${host}:3306/${dbName}jdbc.username=rootjdbc.password=123456#-----------------------------------------------------# \u9002\u7528\u4E8Ec3p0\u7684\u914D\u7F6E#-----------------------------------------------------#-----------------------------------------------------# c3p0\u53CD\u7A7A\u95F2\u8BBE\u7F6E\uFF0C\u9632\u6B628\u5C0F\u65F6\u5931\u6548\u95EE\u989828800#-----------------------------------------------------#idleConnectionTestPeriod\u8981\u5C0F\u4E8EMySQL\u7684wait_timeoutjdbc.c3p0.testConnectionOnCheckout=falsejdbc.c3p0.testConnectionOnCheckin=truejdbc.c3p0.idleConnectionTestPeriod=3600#-----------------------------------------------------# c3p0\u8FDE\u63A5\u6C60\u914D\u7F6E#-----------------------------------------------------#initialPoolSize, minPoolSize, maxPoolSize define the number of Connections that will be pooled.#Please ensure that minPoolSize <= maxPoolSize.#Unreasonable values of initialPoolSize will be ignored, and minPoolSize will be used instead.jdbc.c3p0.initialPoolSize=10jdbc.c3p0.minPoolSize=10jdbc.c3p0.maxPoolSize=100#maxIdleTime defines how many seconds a Connection should be permitted to go unused before being culled from the pool.jdbc.c3p0.maxIdleTime=3600#-----------------------------------------------------# hibernate\u8FDE\u63A5\u6C60\u914D\u7F6E#-----------------------------------------------------hibernate.connection.driverClass=com.mysql.jdbc.Driverhibernate.connection.url=jdbc:mysql://${host}:3306/${dbName}hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialecthibernate.show_sql=truehibernate.format_sql=truehibernate.hbm2ddl.auto=update

<?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:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"    xmlns:tx="http://www.springframework.org/schema/tx"    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">    <!-- 加载配置文件 -->    <context:property-placeholder location="classpath:jdbc.properties" file-encoding="utf-8" ignore-unresolvable="true" />    <!-- 配置数据源 -->    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">        <property name="driverClass" value="${jdbc.driverClassName}"></property>        <property name="jdbcUrl" value="${jdbc.url}"></property>        <property name="user" value="${jdbc.username}"></property>        <property name="password" value="${jdbc.password}"></property>        <property name="testConnectionOnCheckout" value="${jdbc.c3p0.testConnectionOnCheckout}"></property>        <property name="testConnectionOnCheckin" value="${jdbc.c3p0.testConnectionOnCheckin}"></property>        <property name="idleConnectionTestPeriod" value="${jdbc.c3p0.idleConnectionTestPeriod}"></property>        <property name="initialPoolSize" value="${jdbc.c3p0.initialPoolSize}"></property>        <property name="minPoolSize" value="${jdbc.c3p0.minPoolSize}"></property>        <property name="maxPoolSize" value="${jdbc.c3p0.maxPoolSize}"></property>        <property name="maxIdleTime" value="${jdbc.c3p0.maxIdleTime}"></property>    </bean>    <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">        <!-- 数据源dataSource -->        <property name="dataSource" ref="dataSource" />        <!-- hibernate的配置方案一  -->        <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>        <!-- hibernate的配置方案二  -->        <!--         <property name="hibernateProperties">             <props>                 <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>                 <prop key="hibernate.dialect">${hibernate.dialect}</prop>                 <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>                 <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>                 <prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>             </props>         </property>         -->        <!-- 持久化类的位置方案一，通过包进行扫描 -->        <property name="mappingLocations" value="classpath:com/dx/ssh/entities/*.hbm.xml"></property>        <!-- spring的spring.jar的jar包内，在org.springframework.orm.hibernate3.annotation下，             有一个AnnotationSessionFactoryBean类，其中有一个属性叫做"packagesToScan"， 有个方法叫setpackagesToScan()，        也就是说我可以再spring里面将这个属性给设定上。             packagesToScan是"包扫描"的意思，哪些包spring可以给我们扫描一下，看看有哪些实体类，        这一项在我们在配置文件中配置hibernate的实体类的时候可以这么配，只要给出具体的扫描范围就可以了，         不需要将实体类一个一个的写出来         -->        <!-- 持久化类的位置方案二，通过包进行扫描 -->        <!--         <property name="packagesToScan">             <list>                 <value>com.dx.ssh.entities</value>             </list>         </property>         -->        <!-- 持久化类的位置方案三，通过类进行扫描 -->        <!--         <property name="annotatedClasses">             <list>                 <value>com.dx.ssh.entities.Member</value>                 <value>com.dx.ssh.entities.Log</value>             </list>         </property>         -->    </bean>    <!-- 配置Hibernate事务管理器 -->    <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager">        <property name="sessionFactory" ref="sessionFactory" />    </bean>    <!-- 配置事务异常封装 -->    <bean id="persistenceExceptionTranslationPostProcessor" class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />    <!-- 基于数据源的事务管理器 -->    <!--     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource"></property>    </bean>      -->                <!-- 第一种方式: 注解方式配置事物 -->    <tx:annotation-driven transaction-manager="transactionManager" /></beans>

 1 <?xml version="1.0"?> 2 <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 3 "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> 4 <!-- Generated 2017-5-5 23:51:42 by Hibernate Tools 3.5.0.Final --> 5 <hibernate-mapping> 6     <class name="com.dx.ssh.entities.Member" table="MEMBER"> 7         <id name="id" type="java.lang.Integer"> 8             <column name="ID" /> 9             <generator class="native" />10         </id>11         <property name="name" type="java.lang.String">12             <column name="NAME" />13         </property>14     </class>15 </hibernate-mapping>