DataDeleteService.java 657 B

123456789101112131415161718192021222324
  1. package com.data.datarepo.services;
  2. import com.data.datarepo.utils.DataSourceOra;
  3. import oracle.jdbc.pool.OracleDataSource;
  4. import java.sql.Connection;
  5. import java.sql.PreparedStatement;
  6. public class DataDeleteService extends DataSourceOra {
  7. public void DataDelete(String repo_name) {
  8. try {
  9. Connection conn = this.getConn();
  10. String sesql = "delete from " + repo_name;
  11. PreparedStatement ps2 = conn.prepareStatement(sesql);
  12. ps2.executeUpdate();
  13. ps2.close();
  14. conn.close();
  15. } catch (Exception e) {
  16. System.out.println(e.getMessage());
  17. }
  18. }
  19. }