Guest User

Untitled

a guest
Jun 19th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. /**
  2. * This Method delete all data currently exist in database table
  3. */
  4. public static void deleteDatabaseTable() {
  5. String deleteT1 = "DELETE FROM `InvoiceProducts`;";
  6. String deleteT2 = "DELETE FROM `Invoices`;";
  7. String deleteT3 = "DELETE FROM `Refreshments`;";
  8. String deleteT4 = "DELETE FROM `ParkingPasses`;";
  9. String deleteT5 = "DELETE FROM `MovieTickets`;";
  10. String deleteT6 = "DELETE FROM `SeasonPasses`;";
  11. String deleteT7 = "DELETE FROM `Products`;";
  12. String deleteT8 = "DELETE FROM `Customers`;";
  13. String deleteT9 = "DELETE FROM `Emails`;";
  14. String deleteT10 = "DELETE FROM `Persons`;";
  15. String deleteT11 = "DELETE FROM `Addresses`;";
  16. String deleteT12 = "DELETE FROM `StateCountries`;";
  17. String deleteT13 = "DELETE FROM `Countries`;";
  18.  
  19.  
  20. Connection conn = ConnectionFactory.getOne();
  21. PreparedStatement ps = null;
  22.  
  23. try {
  24. // delete table- execute query
  25. ps = conn.prepareStatement(deleteT1);
  26. ps.executeUpdate();
  27.  
  28. ps = conn.prepareStatement(deleteT2);
  29. ps.executeUpdate();
  30.  
  31. ps = conn.prepareStatement(deleteT3);
  32. ps.executeUpdate();
  33.  
  34. ps = conn.prepareStatement(deleteT4);
  35. ps.executeUpdate();
  36.  
  37. ps = conn.prepareStatement(deleteT5);
  38. ps.executeUpdate();
  39.  
  40. ps = conn.prepareStatement(deleteT6);
  41. ps.executeUpdate();
  42.  
  43. ps = conn.prepareStatement(deleteT7);
  44. ps.executeUpdate();
  45.  
  46. ps = conn.prepareStatement(deleteT8);
  47. ps.executeUpdate();
  48.  
  49. ps = conn.prepareStatement(deleteT9);
  50. ps.executeUpdate();
  51.  
  52. ps = conn.prepareStatement(deleteT10);
  53. ps.executeUpdate();
  54.  
  55. ps = conn.prepareStatement(deleteT11);
  56. ps.executeUpdate();
  57.  
  58. ps = conn.prepareStatement(deleteT12);
  59. ps.executeUpdate();
  60.  
  61. ps = conn.prepareStatement(deleteT13);
  62. ps.executeUpdate();
  63.  
  64. ConnectionFactory.release(conn);
  65. ps.close();
  66. } catch (SQLException e) {
  67. // TODO Auto-generated catch block
  68. e.printStackTrace();
  69. }
  70. }
Add Comment
Please, Sign In to add comment