資料庫單元測試
來源:互聯網
上載者:User
package com.hichina.bc.repository.test;import junit.framework.Assert;import org.hibernate.SessionFactory;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.hichina.bc.domain.Customer;import com.hichina.bc.repository.CustomerRepository; @RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations = {"classpath:dispatcher-servlet.xml"})public class CustomerRepositoryTest {@Autowiredprivate SessionFactory sessionFactory;@Autowiredprivate CustomerRepository customerRepository;@Test public void testInsert() {sessionFactory.openSession().createSQLQuery("truncate table CustomerTest").executeUpdate();sessionFactory.openSession().createSQLQuery("insert into CustomerTest (name,password) values ('aa','bb')").executeUpdate();Customer customer = customerRepository.getById(1);Assert.assertNotNull(customer);}@Testpublic void testSave() {Customer customer = new Customer();customer.setName("xhan");customer.setPassword("13");customerRepository.save(customer);System.out.println(customer.getUserId());Assert.assertTrue(customer.getUserId() != 0);}@Testpublic void testUpdate() {Customer customer = new Customer();customer.setName("xhan");customer.setPassword("13");customerRepository.save(customer);Assert.assertTrue(customer.getUserId() != 0);customer.setName("123");customer.setPassword("xhan");customerRepository.update(customer);Customer customer2 = customerRepository.getById(customer.getUserId());Assert.assertEquals("xhan", customer2.getPassword());Assert.assertNotSame(customer, customer2);}}