Back to JDBC Hub

Nearby lessons

32 of 37
JDBC - Select RecordsJDBC - Update RecordsJDBC - Delete RecordsJDBC - Aggregate FunctionsJDBC - Menu Driven CRUD

JDBC - CRUD 4: Delete Records

📌 What You Will Learn
  • The difference between Select and Non-Select operations
  • executeQuery vs executeUpdate — when to use which
  • Reading results with the ResultSet methods
  • Complete CRUD programs: Insert, Select, Update, Delete
  • The ResultSet object and how it works

CRUD 4: Delete Records is a fundamental part of database programming with JDBC. This lesson explains CRUD Program 4 — DELETE (Non-Select) with complete, runnable code examples, clear step-by-step explanations, and common mistakes to avoid with exam-style MCQs at the end.

CRUD Program 4 — DELETE (Non-Select)

Example01
JCode Cell
1import java.sql.*;
2 
3public class DeleteDemo {
4 public static void main(String[] args) throws Exception {
5 Connection con = DriverManager.getConnection(
6 "jdbc:mysql://localhost:3306/company", "root", "password");
7 Statement st = con.createStatement();
8 
9 int rows = st.executeUpdate("DELETE FROM employee WHERE id = 102");
10 System.out.println("Rows deleted: " + rows);
11 con.close();
12 }
13}
Output
Rows deleted: 1
📝 Key Takeaways
  • Select ops (SELECT) use executeQuery() → ResultSet.
  • Non-select ops (INSERT/UPDATE/DELETE) use executeUpdate() → row count.
  • rs.next() moves the cursor; getInt/getString/getDouble read values.
  • CRUD = Create(INSERT), Retrieve(SELECT), Update, Delete.
  • Always close the connection after work.
  • Use PreparedStatement for real applications (SQL injection safety).

🧠 Test Your Knowledge

1 Questions
Progress: 0 / 1