Friday, September 18, 2015

Delete Rows

import java.sql.*;
public class DeleteRows {
  public static void main(String [] args) {
    Connection con = null;
    try {

      con = DriverManager.getConnection(
          "jdbc:oracle:thin:@localhost:XE;"
        + "user=sa;password=Hero;"
        + "database=AdventureWorks2014");
      Statement sta = con.createStatement(); 

// deleting multiple rows
      int count = sta.executeUpdate(
        "DELETE FROM Customer WHERE CustomerID in (1, 3, 5, 7)");
      System.out.println("Number of rows deleted: "+count);

// getting the data back
      ResultSet res = sta.executeQuery(
        "SELECT * FROM Customer");
      System.out.println("List of Customers: "); 
      while (res.next()) {
         System.out.println(
           "  "+res.getInt("CustomerID")
           + ", "+res.getString("FirstName")
           + ", "+res.getString("LastName")
           + ", "+res.getDate("ModifiedDate"));
      }
      res.close();

      sta.close();
      con.close();        
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}
The output confirms that 4 rows were deleted:
C:\hero>\Progra~1\java\jdk1.8.0_45\bin\java 
   -cp .;\local\lib\sqljdbc42.jar DeleteRows

Number of rows deleted: 4
List of Customers:
  2, Terri, Duffy, 2008-01-24
  4, Rob, Walters, 2007-11-28
  6, Jossef, Goldberg, 2013-12-16
  8, Diane, Margheim, 2015-04-01
  9, Gigi, Matthew, 2015-04-01
  10, Michael, Raheem, 2015-04-01
  11, Herong, Yang, 2015-04-01

No comments:

Post a Comment