<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->

 <dependency>

     <groupId>org.springframework</groupId>

     <artifactId>spring-orm</artifactId>

     <version>5.0.9.RELEASE</version>

 </dependency>

  <dependency>

     <groupId>org.hibernate</groupId>

     <artifactId>hibernate-core</artifactId>

     <version>5.3.2.Final</version>

 </dependency>

 <dependency>

     <groupId>mysql</groupId>

     <artifactId>mysql-connector-java</artifactId>

     <version>5.1.4</version>

 </dependency>

 <dependency>

     <groupId>org.hibernate</groupId>

     <artifactId>hibernate-c3p0</artifactId>

     <version>5.3.2.Final</version>

 </dependency>

 <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

     <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test"></property>

     <property name="driverClass" value="com.mysql.jdbc.Driver"></property>

     <property name="user" value="root"></property>

     <property name="password" value="123456"></property>

 </bean>

 <bean name="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">

     <property name="dataSource" ref="dataSource"></property>

     <property name="mappingDirectoryLocations" value="classpath:mapping"></property>

     <property name="hibernateProperties">

         <props>

             <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

             <prop key="hibernate.c3p0.min_size">5</prop> <!--在连接池中可用数据库连接的最小数目-->

             <prop key="hibernate.c3p0.max_size">30</prop> <!--在连接池中所有数据库连接的最大数目-->

             <prop key="hibernate.c3p0.time_out">1800</prop> <!--设定数据库连接的超时时间-->

             <prop key="hibernate.c3p0.max_statement">50</prop> <!--可以被缓存的PreparedStatement的最大数目-->

             <prop key="hibernate.show_sql">true</prop>

         </props>

     </property>

 </bean>

 package com.ice.service;

 import com.ice.model.Customer;

 import org.hibernate.Session;

 import org.hibernate.SessionFactory;

 import org.hibernate.Transaction;

 import org.springframework.stereotype.Component;

 import javax.annotation.Resource;

 @Component

 public class CustomerService {

     @Resource

     private SessionFactory sessionFactory;

     public void save(Customer customer){

         Session  session=sessionFactory.openSession();

         //可以根据情况决定是否用事务

         //Transaction tx = session.beginTransaction();

         session.save(customer);

         //tx.commit();

     }

 }

 package com.ice.controller;

 import com.ice.model.Customer;

 import com.ice.service.CustomerService;

 import org.springframework.beans.factory.annotation.Autowired;

 import org.springframework.stereotype.Controller;

 import org.springframework.web.bind.annotation.RequestMapping;

 import org.springframework.web.bind.annotation.ResponseBody;

 @RequestMapping("/")

 @Controller

 public class HomeController {

     @Autowired

     private CustomerService customerService;

     @RequestMapping("/")

     @ResponseBody

     public String index(){

         Customer customer = new Customer();

         customer.setId(5);

         customer.setName("hello!");

         customerService.save(customer);

         return "ok";

     }

 }