@Test
@Transactional
public void shouldNotCreateAddressInSecondCustomer() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// first customer is ok, second has wrong data too long address name so there will be
// exception
customerService.createCustomerComplexProxyBasedExample(okCustomer, customerWithTooLongCity);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
System.out.println("Address vol =" + addressVol + " personVol=" + personVol);
// first person from okCustomer, second person from customerWithTooLongCity
assertEquals(new Integer(2), personVol);
// first address from okCustomer, second not exists because of exception and rollback in this
// step
assertEquals(new Integer(1), addressVol);
/**
* This assertion shows that in second customer creation there is no transactional because
* person was created - only addres was rolledback
*/
}
}
@Test
public void testNeverTransactionalShouldPassThrough() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// customer is wrong - it is going to be exception
customerService.createCustomerComplexInsideNevetTrans_NoTransOutside(
customerWithTooLongCity, okRole);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
Integer roleVol = roleDAO.getRolesVol();
// records created by insertCustomer method - no transactional so address is created and
// commited and then exception and rollback on person
assertEquals(new Integer(0), addressVol);
assertEquals(new Integer(1), personVol);
// record created by createRoleNeverTransaction method - no transactional so role is commited
// - as a first line of execution inside
// customerService.createCustomerComplexInsideNevetTrans_NoTransOutside method
assertEquals(new Integer(1), roleVol);
}
}
/**
* In this example method is not transactional
*
* @throws Exception
*/
@Test
public void shouldRollbackOnlyAddress() throws Exception {
try {
// customer is wrong - it is going to be exception
customerService.createCustomerNoTransactional(customerWithTooLongCity);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
assertEquals(new Integer(0), addressVol);
assertEquals(new Integer(1), personVol);
}
}
public void orderTest3() {
Customer customer = customerDAO.getCustomerById(2);
List list = orderService.getOrdersByUsername(customer.getUsername());
System.out.println("List size :" + list.size());
for (Object obj : list) {
System.out.println(obj);
}
}
/**
* Please compare it with test shouldNotCreateAddressInSecondCustomer(). Here you can see that
* inside body executed method are transactional. Creation second customer is transactional, so
* when rollback is executed in second step then whole actions inside
* createCustomerComplexProxyBasedExampleAllTransactional() are rolledback
*/
@Test
@Transactional
public void shouldNotCreateAnyItemsDuringExecution() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// first customer is ok, second has wrong data (too long city), rollback is executed in second
// step
// here whole method is rolledback
customerService.createCustomerComplexProxyBasedExampleAllTransactional(
okCustomer, customerWithTooLongCity);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
assertEquals(new Integer(0), personVol);
assertEquals(new Integer(0), addressVol);
}
}
/**
* In this example there is transaction during execution createCustomerComplexInsideSupport_Trans,
* exception is thrown during customer creation
*/
@Test
public void shouldRollbackAllCreationRoleAddressAndPerson() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// customer is wrong - it is going to be exception - first roles are created
customerService.createCustomerComplexInsideSupport_WithTransOutside(
customerWithTooLongCity, okRole);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
Integer roleVol = roleDAO.getRolesVol();
// records created by insertCustomer method
assertEquals(new Integer(0), addressVol);
assertEquals(new Integer(0), personVol);
// record created by createRoleTransactionSupport method
assertEquals(new Integer(0), roleVol);
}
}
/**
* Exception is thrown during customer creation, no transation and no support transaction inside
* role creation
*/
@Test
public void shouldCreatePersonAndRolesButNoAddress() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// customer is wrong - it is going to be exception
customerService.createCustomerComplexInsideNotSupported_NoTransOutside(
customerWithTooLongCity, okRole);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
Integer roleVol = roleDAO.getRolesVol();
// records created by insertCustomer method - no transaction so executed independently but in
// address insertion no because of exception - in this case is rollback
assertEquals(new Integer(0), addressVol);
assertEquals(new Integer(1), personVol);
// record created by createRoleTransactionNotSupported method - no transaction so commited
assertEquals(new Integer(1), roleVol);
}
}
/** In this case */
@Test
@Transactional
public void shouldCreateNewTransactionForCreateRoles() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// customer is OK, but wrongRole has too long name
customerService.createCustomerComplexNewRequired_NoTransOutside(
okCustomer, okRole, wrongRole);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
Integer roleVol = roleDAO.getRolesVol();
// address and person are commited independently (because of no transactional) but commited
assertEquals(new Integer(1), addressVol);
assertEquals(new Integer(1), personVol);
// here second role was to long and exception was thrown but bacause of transaction required
// (and created) all steps in this method are rolledback
assertEquals(new Integer(0), roleVol);
}
}
/**
* Exception is thrown during customer creation, no transation and no support transaction inside
* role creation
*/
@Test
public void shouldCreatePersonAndRolesButNoAddress2() {
customerService.cleanDatabase();
roleService.cleanDatabase();
try {
// customer is wrong - it is going to be exception
customerService.createCustomerComplexInsideNotSupported_WithTransOutside(
customerWithTooLongCity, okRole);
} catch (Exception e) {
Integer addressVol = customerDAO.getAddressVol();
Integer personVol = customerDAO.getPersonVol();
Integer roleVol = roleDAO.getRolesVol();
// records created by insertCustomer method - transactional so rollback all inserts in this
// method, rollback because of problem during inserting address
assertEquals(new Integer(0), addressVol);
assertEquals(new Integer(0), personVol);
// record created by createRoleTransactionNotSupported method - transaction is not supported
// even if outside method is transactional - so in this example role record is commited
assertEquals(new Integer(1), roleVol);
}
}
public void orderTest() {
Customer customer = customerDAO.getCustomerById(3);
List<Commodity> commodityList = commoDAO.getCommoditiesByIdString("2;3;4");
List<OrderCommodityRel> relationLsit = CommodityListTools.commoToRel(commodityList);
Order order = new Order(customer, relationLsit, 100);
Map<Integer, Integer> map = new HashMap<Integer, Integer>();
map.put(2, 2);
map.put(3, 4);
map.put(4, 4);
order.setBuyNum(map);
Date date = new Date();
order.setOrderTime(new Timestamp(date.getTime()));
orderDAO.createOrder(order);
System.out.println(order.getOrderId());
}
public void testGetCustomerById() {
List list = (List) customerDAO.getCustomerById(1);
Customer cus = (Customer) list.get(0);
assertEquals("赵小明", cus.getUsername());
}
public void partialObjectQuery3() {
List<GenderStatDTO> dtoList = customerDAO.getGenderStat();
for (GenderStatDTO purchaseDTO : dtoList) {
System.out.println(purchaseDTO);
}
}
public void partialObjectQuery2() {
List<CityStatDTO> dtoList = customerDAO.getCityStat();
for (CityStatDTO purchaseDTO : dtoList) {
System.out.println(purchaseDTO);
}
}
