import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
protected static void createCommonDaoImpl() {
	try {
		createSessionFactory();
		//
		// dao
		commonDaoImpl = new CommonDaoImpl();

		// 建構HibernateTemplate,因HibernateDaoSupporter需要
		HibernateTemplate hibernateTemplate = new HibernateTemplate();
		hibernateTemplate.setSessionFactory(sessionFactory);
		//
		commonDaoImpl.setHibernateTemplate(hibernateTemplate);
		commonDaoImpl.start();
		System.out.println(commonDaoImpl);
	} catch (Exception e) {
		e.printStackTrace();
	}
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@BeforeClass
public static void setUpBeforeClass() throws Exception {
	// service
	commonServiceImpl = new CommonServiceImpl();
	// dao
	commonDaoImpl = new CommonDaoImpl();

	// 建構HibernateTemplate,因HibernateDaoSupporter需要
	HibernateTemplate hibernateTemplate = new HibernateTemplate();
	Configuration config = new Configuration().configure("hibernate.cfg.xml");
	// SessionFactory sessionFactory = config.buildSessionFactory();

	ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties())
			.buildServiceRegistry();
	SessionFactory sessionFactory = config.buildSessionFactory(serviceRegistry);
	hibernateTemplate.setSessionFactory(sessionFactory);
	commonDaoImpl.setHibernateTemplate(hibernateTemplate);
	//
	commonServiceImpl.setCommonDao(commonDaoImpl);
	commonServiceImpl.start();

}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public void saveGradebook(Gradebook gradebook)
		throws IllegalArgumentException {
	if (gradebook == null) {
		throw new IllegalArgumentException("Null Argument");
	} else {
		HibernateTemplate temp = getHibernateTemplate();
		temp.saveOrUpdate(gradebook);
		/*
		 * Iterator iter = gradebook.getStudents().iterator(); while
		 * (iter.hasNext()) { temp.saveOrUpdate((StudentGradesImpl) iter.next()); }
		 */
	}
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public void updateStudent(StudentGrades student) throws IllegalArgumentException {
	if (student == null) {
		throw new IllegalArgumentException("Null Argument");
	} else {
		HibernateTemplate temp = getHibernateTemplate();
		temp.saveOrUpdate(student);
	}
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
/**
 * @see org.sakaiproject.service.gradebook.shared.GradebookService#removeExternalAssessment(java.lang.String, java.lang.String)
 */
@Override
public void removeExternalAssessment(final String gradebookUid,
           final String externalId) throws GradebookNotFoundException, AssessmentNotFoundException {
       // Get the external assignment
       final GradebookAssignment asn = getExternalAssignment(gradebookUid, externalId);
       if(asn == null) {
           throw new AssessmentNotFoundException("There is no external assessment id=" + externalId + " in gradebook uid=" + gradebookUid);
       }

       // We need to go through Spring's HibernateTemplate to do
       // any deletions at present. See the comments to deleteGradebook
       // for the details.
       HibernateTemplate hibTempl = getHibernateTemplate();

       hibTempl.execute((HibernateCallback<?>) session -> {
           int numDeleted = session.createQuery("delete GradingEvent where gradableObject=:go").setParameter("go", asn).executeUpdate();
           log.debug("Deleted {} records from gb_grading_event_t", numDeleted);

           numDeleted = session.createQuery("delete AssignmentGradeRecord where gradableObject=:go").setParameter("go", asn).executeUpdate();
           log.info("Deleted {} externally defined scores", numDeleted);

           numDeleted = session.createQuery("delete Comment where gradableObject=:go").setParameter("go", asn).executeUpdate();
           log.info("Deleted {} externally defined comments", numDeleted);
           return null;
       });

       // Delete the assessment.
	hibTempl.flush();
	hibTempl.clear();
	hibTempl.delete(asn);

       log.info("External assessment removed from gradebookUid={}, externalId={} by userUid={}", gradebookUid, externalId, getUserUid());
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
/**
 * 直接使用hibernate.cfg.xml, s並非由spring注入
 */
public static void createCommonServiceImpl() {
	try {
		// service
		commonServiceImpl = new CommonServiceImpl();
		// dao
		CommonDaoImpl commonDaoImpl = new CommonDaoImpl();

		// 建構HibernateTemplate,因HibernateDaoSupporter需要
		HibernateTemplate hibernateTemplate = new HibernateTemplate();
		Configuration config = new Configuration().configure("hibernate.cfg.xml");
		// SessionFactory sessionFactory = config.buildSessionFactory();
		ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(config.getProperties())
				.buildServiceRegistry();
		SessionFactory sessionFactory = config.buildSessionFactory(serviceRegistry);
		// System.out.println("sessionFactory: " + sessionFactory);
		//
		hibernateTemplate.setSessionFactory(sessionFactory);
		commonDaoImpl.setHibernateTemplate(hibernateTemplate);
		//
		commonServiceImpl.setCommonDao(commonDaoImpl);

		// listener
		serviceBeanListener = new CommonBeanAdapter();
		commonServiceImpl.addBeanListener(serviceBeanListener);
		assertNotNull(commonServiceImpl);

		commonServiceImpl.start();

		System.out.println("---------------------------");
		System.out.println("createCommonServiceImpl [success]");
		System.out.println("---------------------------");
	} catch (Exception ex) {
		System.out.println("---------------------------");
		System.out.println("createCommonServiceImpl [fail]");
		System.out.println("---------------------------");
		ex.printStackTrace();
	}
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public HibernateTemplate getHibernateTemplate() {
    return hibernateTemplate;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Autowired
public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
    this.hibernateTemplate = hibernateTemplate;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Autowired
public void setTemplate(HibernateTemplate template) {
    this.template = template;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Autowired
public void setSessionFactory(SessionFactory sessionFactory) {
	        hibernateTemplate = new HibernateTemplate(sessionFactory);
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public void setHibernateTemplate(HibernateTemplate hibernateTemplate) {
	this.hibernateTemplate = hibernateTemplate;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public HibernateTemplate getHibernateTemplate() {
	return hibernateTemplate;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public void setTemplate(HibernateTemplate template) {
	this.template = template;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Bean
public HibernateTemplate hibernateTemplate() {
	HibernateTemplate template = new HibernateTemplate();
	template.setSessionFactory(sessionFactory().getObject());
	return template;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public HibernateTemplate getDaoHibernateTemplate() {
return getHibernateTemplate();
   }
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public void deleteGradebook(final String uid)
	throws GradebookNotFoundException {
       if (log.isDebugEnabled()) log.debug("Deleting gradebook uid=" + uid + " by userUid=" + getUserUid());
       final Long gradebookId = getGradebook(uid).getId();

       // Worse of both worlds code ahead. We've been quick-marched
       // into Hibernate 3 sessions, but we're also having to use classic query
       // parsing -- which keeps us from being able to use either Hibernate's new-style
       // bulk delete queries or Hibernate's old-style session.delete method.
       // Instead, we're stuck with going through the Spring template for each
       // deletion one at a time.
       HibernateTemplate hibTempl = getHibernateTemplate();
       // int numberDeleted = hibTempl.bulkUpdate("delete GradingEvent as ge where ge.gradableObject.gradebook.id=?", gradebookId);
       // log.warn("GradingEvent numberDeleted=" + numberDeleted);

       List toBeDeleted;
       int numberDeleted;

       toBeDeleted = hibTempl.findByNamedParam("from GradingEvent as ge where ge.gradableObject.gradebook.id = :gradebookid", "gradebookid", gradebookId);
       numberDeleted = toBeDeleted.size();
       hibTempl.deleteAll(toBeDeleted);
       if (log.isDebugEnabled()) log.debug("Deleted " + numberDeleted + " grading events");

       toBeDeleted = hibTempl.findByNamedParam("from AbstractGradeRecord as gr where gr.gradableObject.gradebook.id = :gradebookid", "gradebookid", gradebookId);
       numberDeleted = toBeDeleted.size();
       hibTempl.deleteAll(toBeDeleted);
       if (log.isDebugEnabled()) log.debug("Deleted " + numberDeleted + " grade records");

       toBeDeleted = hibTempl.findByNamedParam("from GradableObject as go where go.gradebook.id = :gradebookid", "gradebookid", gradebookId);
       numberDeleted = toBeDeleted.size();
       hibTempl.deleteAll(toBeDeleted);
       if (log.isDebugEnabled()) log.debug("Deleted " + numberDeleted + " gradable objects");

       Gradebook gradebook = (Gradebook)hibTempl.load(Gradebook.class, gradebookId);
       gradebook.setSelectedGradeMapping(null);

       toBeDeleted = hibTempl.findByNamedParam("from GradeMapping as gm where gm.gradebook.id = :gradebookid", "gradebookid", gradebookId);
       numberDeleted = toBeDeleted.size();
       hibTempl.deleteAll(toBeDeleted);
       if (log.isDebugEnabled()) log.debug("Deleted " + numberDeleted + " grade mappings");

       hibTempl.delete(gradebook);
       hibTempl.flush();
       hibTempl.clear();
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
protected HibernateTemplate createHibernateTemplate(SessionFactory sessionFactory) {
	return new HibernateTemplate(sessionFactory);
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
public HibernateTemplate getHibernateTemplate() {
	return this.hibernateTemplate;
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Test
public void logHibernateTemplate() {
	HibernateTemplate bean = (HibernateTemplate) applicationContext.getBean("logHibernateTemplate");
	System.out.println(bean);
	assertNotNull(bean);
}
 

import org.springframework.orm.hibernate4.HibernateTemplate; //导入依赖的package包/类
@Test
public void commonHibernateTemplate() {
	HibernateTemplate bean = (HibernateTemplate) applicationContext.getBean("commonHibernateTemplate");
	System.out.println(bean);
	assertNotNull(bean);
}