Advertisement
Guest User

testcreate()

a guest
Apr 29th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. public void testCreate() throws SQLException, Exception{
  2.  
  3.  
  4.  
  5.  
  6. for (int x = 1; x < 11; x++)
  7. addProductUses();
  8.  
  9.  
  10. BigDecimal nextProductId;
  11. BigDecimal nextMaterialId;
  12. Connection conn;
  13.  
  14.  
  15. conn = DBConnect.getConnection(hostname, port, sid, id, pwrd);
  16. UsesDAO UsesDAO = new UsesDAO();
  17. nextProductId = UsesDAO.findMaxProductId();
  18. nextMaterialId = UsesDAO.findMaxMaterialId();
  19. nextProductId = nextProductId.subtract(increment);
  20. Uses info = new Uses();
  21. info.setProductId(nextProductId);
  22. info.setMaterialId(nextMaterialId);
  23. info.setIntoQuant(new BigDecimal(1));
  24.  
  25. Uses test = new Uses(info.getProductId(),info.getMaterialId(),info.getIntoQuant().add(new BigDecimal(3)));
  26. UsesDAO.createUses(info);
  27. UsesDAO.updateUses(test);
  28. UsesDAO.deleteUses(info.getProductId(),info.getMaterialId());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement