Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * This Method delete all data currently exist in database table
- */
- public static void deleteDatabaseTable() {
- String deleteT1 = "DELETE FROM `InvoiceProducts`;";
- String deleteT2 = "DELETE FROM `Invoices`;";
- String deleteT3 = "DELETE FROM `Refreshments`;";
- String deleteT4 = "DELETE FROM `ParkingPasses`;";
- String deleteT5 = "DELETE FROM `MovieTickets`;";
- String deleteT6 = "DELETE FROM `SeasonPasses`;";
- String deleteT7 = "DELETE FROM `Products`;";
- String deleteT8 = "DELETE FROM `Customers`;";
- String deleteT9 = "DELETE FROM `Emails`;";
- String deleteT10 = "DELETE FROM `Persons`;";
- String deleteT11 = "DELETE FROM `Addresses`;";
- String deleteT12 = "DELETE FROM `StateCountries`;";
- String deleteT13 = "DELETE FROM `Countries`;";
- Connection conn = ConnectionFactory.getOne();
- PreparedStatement ps = null;
- try {
- // delete table- execute query
- ps = conn.prepareStatement(deleteT1);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT2);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT3);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT4);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT5);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT6);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT7);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT8);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT9);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT10);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT11);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT12);
- ps.executeUpdate();
- ps = conn.prepareStatement(deleteT13);
- ps.executeUpdate();
- ConnectionFactory.release(conn);
- ps.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment