Deleting Records using the Prepared Statement

This section helps us for deleting the records from the database table by using the PreparedStatement interface of the java.sql package.

Ads

Tutorials   
Change Column Name in MySQL Java Mysql Connection Example JDBC Example with MySQL Jdbc Mysql Connection String Jdbc Mysql Connection Url Getting Column Names from a database table in Java Count Rows from a Database Table JDBC Example with MySQL Write Text File to Table Inserting Image in Database Table Insert Data in Table Using Stored Procedure Copy One Database Table to Another Copy Table in a MySQL Database Set Timestamp by using the Prepared Statement Set Time by using the Prepared Statement Set Date by using the Prepared Statement Prepared Statement Set Big Decimal Set byte, short and long data types by using the Prepared Statement Set Data Types by using Prepared Statement Using the Prepared Statement Twice Deleting Records using the Prepared Statement Count Records using the Prepared Statement Inserting Records using the Prepared Statement Update Records using Prepared Statement Select Records Using Prepared Statement Prepared Statement With Batch Update Statement Batch Update Prepared Statement Set Object Cross Join Tables in a Specific Database Join tables with the NATURAL RIGHT JOIN operation Join tables with the NATURAL LEFT JOIN operation Join tables in the specific database Delete a Column from a Database Table Delete a Specific Row from a Database Table Deleting All Rows from a Database Table Sum of Column in a Database Table Arrange a Column of Database Table Arrange a Column of Database Table Remove Unique Column in Database Table Make Unique Column in Database Table Change Column Name of a Table Adding a New Column Name in Database Table Retrieving All Rows from a Database Table Inserting values in MySQL database table Retrieving Tables from a Database Deleting a Table from Database Description of Database Table Creating a MySQL Database Table to store Java Types Creating a Database Table Creating a Database in MySQL
Ads

Deleting Records using the Prepared Statement

     

This section helps us for deleting the records from the database table by using the PreparedStatement interface of the java.sql package. Sometimes, some records we have entered becomes useless after sometime so we need to delete those records. We can do it very easily by using the simple Sql query. The given example provides the facility for deleting the records from the database table. Brief description below: Please go through this example very carefully.

Description of program:

In this program we are going to delete the records from the 'movies' table that released in the year 1985. For this, first of all we will establish the connection with MySQL database by using the JDBC driver. After establishing the connection we will pass the SQL statement in the prepareStatemet method which returns the PreparedStatement object and we will set the releases year of movies in the setInt method by using the PreparedStatement object. If it records gets delete then the executeUpdate method will return the number of deleted records. This method will execute the SQL statement that may be INSERT, UPDATE or DELETE statement. If any problems arises with SQL statement then it will display a message  "SQL statement is not executed!".

Here is the code of program:

import java.sql.*;

public class DeleteRecords{
  public static void main(String[] args) {
  System.out.println("Delete records example using prepared statement!");
  Connection con = null;
  try{
  Class.forName("com.mysql.jdbc.Driver");
  con = DriverManager.getConnection
("jdbc:mysql://localhost:3306/jdbctutorial","root","root");
  try{
  String sql = "DELETE FROM movies where year_made = ?";
  PreparedStatement prest = con.prepareStatement(sql);
  prest.setInt(1,1985);
  int del = prest.executeUpdate();
  System.out.println("Number of deleted records: " + del);
  con.close();
  }
  catch (SQLException s){
  System.out.println("SQL statement is not executed!");
  }
  }
  catch (Exception e){
  e.printStackTrace();
  }
  }
} 

Download this program:

Database Table: movies

title year_made
alam ara 1945
Bagal bali 2002
Karan 1996
Bagban 2003
Kuch kuch hota hi 1985
Ham hi tumahare sanam 1985

Output of the program:

C:\vinod\jdbc\jdbc\PreparedStatement>javac DeleteRecords.java

C:\vinod\jdbc\jdbc\PreparedStatement>java DeleteRecords
Delete records example using prepared statement!
Number of deleted records: 2

After executing the program:

Database Table: movies

title year_made
alam ara 1945
Bagal bali 2002
Karan 1996
Bagban 2003

Advertisements

Ads
Share on Google+Share on Google+

Deleting Records using the Prepared Statement

Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Deleting Records using the Prepared Statement  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads