In this Code Snippetswe will know how to delete records from database using JDBC (Java Database Connectivity) in console window.
Here we use Type-1 driver (JDBC-ODBC bridge)
Creation of dsn(database source name) for Oracle
Start-Control panel- Administrative Tools- Data Sources (ODBC)-go to system dsn tab-click add button-select a driver for which you want to set up data source (for Oracle- Oracle in XE)-select it and click finish-give any name in data source name textbox-then click ok button.
Note: - Here Username=system, Password=pintu and Dsn name=dsn1
Create table employee (empno int,empname varchar(50),sal int)
Example:- To delete record from a table
/*To delete record from a table by using Statement*/
public class delete
public static void main(String args) throws Exception
Scanner sc=new Scanner(System.in);
System.out.print("Enter lower limit salary: ");
System.out.print("Enter upper limit salary: ");
String sql="delete from employee where sal between "+lb+" and "+ub;
System.out.println(no +" Records Successfully Deleted...");