/** 
 * @Description TODO(采用Spring的注解调试，仅仅支持Spring3.1及以上) 
 * @author Ni Shengwu 
 * 
 */ 
/* 
 * Spring3.1后多了个spring-test-4.2.4.RELEASE.jar包，这个jar包专门用来支持JUnit基于注解的测试的，该jar包在spring-4.2.4-core中 
 * 该jar包里有个SpringJUnit4ClassRunner.class，用@RunWith注解加进来即可 
 * 
 * 注解@ContextConfiguration表示将ApplicationContext对象注入进来，就不用像以往那样在测试程序里先new了，直接使用 
 */ 
@RunWith(SpringJUnit4ClassRunner.class) 
@ContextConfiguration(locations="classpath:beans.xml") 
public class SSHTest { 
 
 @Resource 
 private Date date; 
 
 @Test //测试Spring IOC的开发环境 
 public void springIoc() { 
 System.out.println(date); 
 } 
} 

drop database if exists shop; 
create database shop default character set utf8; 
use shop; 
drop table if exists category; 
create table category 
( 
 /* 类别编号，自动增长 */ 
 id int not null auto_increment, 
 /* 类别名称 */ 
 type varchar(20), 
 /* 类别是否为热点类别，热点类别才有可能显示在首页*/ 
 hot bool default false, 
 /* 设置类别编号为主键*/ 
 primary key (id) 
); 

public class HibernateSessionFactory { 
 
 private static final ThreadLocal<Session> threadLocal = new ThreadLocal<Session>(); //sessionFactory中用的是线程池技术 
 private static org.hibernate.SessionFactory sessionFactory; //sessionFactory：创建session的工厂 
 
 private static Configuration configuration = new Configuration(); 
 private static ServiceRegistry serviceRegistry; 
 
 static { //类加载时初始化sessionFactory 
 try { 
 configuration.configure(); 
 serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry(); 
 sessionFactory = configuration.buildSessionFactory(serviceRegistry); //Hibernate4中创建sessionFactory的方法 
 } catch (Exception e) { 
 System.err.println("%%%% Error Creating SessionFactory %%%%"); 
 e.printStackTrace(); 
 } 
 } 
 private HibernateSessionFactory() { //私有构造方法阻止new出对象，保证sessionFactory的单例 
 } 
 
 public static Session getSession() throws HibernateException { 
 Session session = (Session) threadLocal.get(); //从线程池中拿session 
 
 if (session == null || !session.isOpen()) { //如果线程池是空的，或者session打开失败 
 if (sessionFactory == null) { 
 rebuildSessionFactory(); //如果sessionFactory是空的，那就再创建一次，和static部分一样的 
 } 
 session = (sessionFactory != null) ? sessionFactory.openSession() : null; //sessionFactory不为空就创建一个session 
 threadLocal.set(session); //然后把这个session放到线程池中，下次再拿 
 } 
 
 return session; 
 } 
 
 public static void rebuildSessionFactory() { 
 try { 
 configuration.configure(); 
 serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry(); 
 sessionFactory = configuration.buildSessionFactory(serviceRegistry); 
 } catch (Exception e) { 
 System.err.println("%%%% Error Creating SessionFactory %%%%"); 
 e.printStackTrace(); 
 } 
 } 
 
 public static void closeSession() throws HibernateException { 
 Session session = (Session) threadLocal.get(); 
 threadLocal.set(null); 
 
 if (session != null) { 
 session.close(); 
 } 
 } 
 
 public static org.hibernate.SessionFactory getSessionFactory() {//提供一个公共接口让外界获得这个单例sessionFactory 
 return sessionFactory; 
 } 
 
 public static Configuration getConfiguration() { 
 return configuration; 
 } 
 
} 

public interface CategoryService { 
 public void save(Category category); //用来测试Hibernate环境 
} 
 
public class CategoryServiceImpl implements CategoryService { 
 
 @Override //没有和Spring整合的情况 
 public void save(Category category) { 
 //通过刚刚生成的sessionFactory获取session 
 Session session = HibernateSessionFactory.getSession(); 
 try { 
 //手动事务 
 session.getTransaction().begin(); 
 //执行业务逻辑 
 session.save(category); 
 //手动提交 
 session.getTransaction().commit(); 
 } catch(Exception e) { 
 session.getTransaction().rollback(); 
 throw new RuntimeException(e); 
 } finally { 
 HibernateSessionFactory.closeSession(); 
 } 
 } 
} 

@RunWith(SpringJUnit4ClassRunner.class) 
@ContextConfiguration(locations="classpath:beans.xml") 
public class SSHTest { 
 
 @Resource 
 private Date date; 
 
 @Test //测试Spring IOC的开发环境 
 public void springIoc() { 
 System.out.println(date); 
 } 
 
 @Test //测试Hibernate的开发环境，因为没有整合，可以直接new 
 public void hihernate() { 
 CategoryService categoryService = new CategoryServiceImpl(); 
 Category category = new Category("男士休闲", true); 
 categoryService.save(category); 
 } 
} 

<!-- com.mchange.v2.c3p0.ComboPooledDataSource类在c3p0-0.9.5.1.jar包的com.mchange.v2.c3p0包中 --> 
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> 
 <property name="driverClass" value="com.mysql.jdbc.Driver" /> 
 <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/shop" /> 
 <property name="user" value="root" /> 
 <property name="password" value="root" /> 
</bean> 

<!-- org.springframework.orm.hibernate4.LocalSessionFactoryBean类在spring-orm-4.2.4.RELEASE.jar包的org.springframework.orm.hibernate4包中 --> 
<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> 
 <property name="dataSource" ref="dataSource" /> 
 <property name="configLocation" value="classpath:hibernate.cfg.xml" /> <!-- 加载hibernate配置文件 --> 
</bean> 

<!-- org.springframework.orm.hibernate4.HibernateTransactionManager类spring-orm-4.2.4.RELEASE.jar包的org.springframework.orm.hibernate4包中 --> 
<bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager"> 
 <property name="sessionFactory" ref="sessionFactory" /> 
</bean> 

<tx:advice id="advice" transaction-manager="transactionManager"> 
 <tx:attributes> 
 <tx:method name="save*" propagation="REQUIRED"/> 
 <tx:method name="update*" propagation="REQUIRED"/> 
 <tx:method name="delete*" propagation="REQUIRED"/> 
 <tx:method name="*" propagation="SUPPORTS"/> 
 </tx:attributes> 
</tx:advice> 

<aop:config> 
 <!-- 配置哪些包的类要切入事务 --> 
 <aop:pointcut id="pointcut" expression="execution(* cn.it.shop.service.impl.*.*(..))" /> 
 <aop:advisor advice-ref="advice" pointcut-ref="pointcut"/><!-- 连接了<span style="font-family:Microsoft YaHei;">上</span>面的advice和上面的pointcut --> 
 <!-- aop:pointcut要写在aop:advisor上面，否则会报错 --> 
 </aop:config>