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