Advertisement
Guest User

Untitled

a guest
Mar 28th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.94 KB | None | 0 0
  1. public Milestone create(Milestone milestone) throws ClassNotFoundException, SQLException {
  2. String id = UUID.randomUUID().toString();
  3. milestone.setId(id);
  4.  
  5. Class.forName("org.h2.Driver");
  6. Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
  7. PreparedStatement prepareStatement = connection.prepareStatement("INSERT INTO MILESTONE VALUES(?, ?,?)");
  8.  
  9. prepareStatement.setString(1, id);
  10. prepareStatement.setString(2, milestone.getName());
  11. prepareStatement.setString(3, milestone.getDescription());
  12. prepareStatement.executeUpdate();
  13.  
  14. connection.close();
  15. return milestone;}
  16.  
  17. public Milestone update(Milestone milestone) throws ClassNotFoundException, SQLException{
  18.  
  19. Class.forName("org.h2.Driver");
  20. Connection connection = DriverManager.getConnection("jdbc:h2:~/dao_db", "sa", "");
  21. PreparedStatement prepareStatement = connection.prepareStatement("UPDATE MILESTONE SET NAME=?, DESCRIPTION = ? WHERE ID=?");
  22.  
  23. prepareStatement.setString(1, milestone.getName());
  24. prepareStatement.setString(2, milestone.getDescription());
  25. prepareStatement.setString(3, milestone.getId());
  26. prepareStatement.executeUpdate();
  27.  
  28. connection.close();
  29. return milestone;};
  30.  
  31. import static org.junit.Assert.*;
  32. import java.sql.SQLException;
  33. import org.junit.Test;
  34. import model.Milestone;
  35.  
  36. public class MilestoneDAOImplTest {
  37.  
  38. @Test
  39. public void createTest() throws ClassNotFoundException, SQLException {
  40. MilestoneDAOImpl ms = new MilestoneDAOImpl();
  41. Milestone milestone = new Milestone("test","test");
  42. assertNotNull("milestone created", ms.create(milestone)); }
  43.  
  44. @Test
  45. public void updateTest() throws ClassNotFoundException, SQLException {
  46. MilestoneDAOImpl ms = new MilestoneDAOImpl();
  47. Milestone milestone = new Milestone("test","test");
  48. assertNotNull("milestone updated", ms.update(milestone)); }
  49.  
  50. assertNotNull("milestone created", ms.create(milestone));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement