The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Deleting Data  [2 examples]

e262. Deleting a Row from a Database Table

    try {
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Prepare a statement to insert a record
        String sql = "DELETE FROM my_table WHERE col_string='a string'";
    
        // Execute the delete statement
        int deleteCount = stmt.executeUpdate(sql);
        // deleteCount contains the number of deleted rows
    
        // Use a prepared statement to delete
    
        // Prepare a statement to delete a record
        sql = "DELETE FROM my_table WHERE col_string=?";
        PreparedStatement pstmt = connection.prepareStatement(sql);
        // Set the value
        pstmt.setString(1, "a string");
        deleteCount = pstmt.executeUpdate();
        System.err.println(e.getMessage());

 Related Examples
e263. Deleting All Rows from a Database Table

See also: Batching    Connections    Database Meta Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle OBJECTs    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Scrollable Result Sets    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.