hibernate使用存储过程初识

最新推荐文章于 2024-09-29 19:21:13 发布

图图大耳朵

最新推荐文章于 2024-09-29 19:21:13 发布

阅读量198

点赞数

分类专栏： hibernate学习文章标签： hibernate 存储

本文链接：https://blog.csdn.net/qq_33437513/article/details/54600495

版权

hibernate学习专栏收录该内容

1 篇文章 0 订阅

订阅专栏

package org.tuyfei.dao;


import java.io.FileNotFoundException;
import java.sql.SQLException;
import java.util.List;


import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.runner.RunWith;
import org.springframework.orm.hibernate4.SessionHolder;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.transaction.support.TransactionSynchronizationManager;
import org.tuyifei.model.User;


@SuppressWarnings("unchecked")
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("/beans.xml")
public class BaseDaoTest {
	@Resource
	private SessionFactory sessionFactory;
	@Resource
	private IBaseDao baseDao;


	@Before
	public void setUp() {
		Session s = sessionFactory.openSession();
		TransactionSynchronizationManager.bindResource(sessionFactory, new SessionHolder(s));
	}


	@Test
	public void test01() {
		List us = baseDao.getSession().createSQLQuery("call p_hello").addEntity(User.class).list();
		System.out.println(us);
	}


	@After
	public void tearDown() throws FileNotFoundException, SQLException {
		SessionHolder holder = (SessionHolder) TransactionSynchronizationManager.getResource(sessionFactory);
		Session s = holder.getSession();
		s.flush();
		TransactionSynchronizationManager.unbindResource(sessionFactory);
	}
}