To delete data from a SQLite database using Java, you can use the JDBC driver provided by the SQLite project. Here’s an example code snippet that demonstrates how to delete data from a SQLite database using Java:
import java.sql.*; public class SQLiteDataDeleter { public static void main(String[] args) { // Database URL String url = "jdbc:sqlite:/path/to/your/database.sqlite"; // SQL query String query = "DELETE FROM your_table WHERE name = ?"; try { // Register JDBC driver Class.forName("org.sqlite.JDBC"); // Open a connection Connection conn = DriverManager.getConnection(url); // Create a prepared statement PreparedStatement stmt = conn.prepareStatement(query); // Set parameter value stmt.setString(1, "John Doe"); // Execute the query int rowsAffected = stmt.executeUpdate(); // Process the result System.out.println(rowsAffected + " row(s) deleted successfully."); // Close the resources stmt.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } }
Replace /path/to/your/database.sqlite with the actual path to your SQLite database file.
Make sure to have the SQLite JDBC driver (e.g., sqlite-jdbc-*.jar) included in your classpath. You can download the driver from the official SQLite website or include it as a Maven/Gradle dependency.
The code connects to the SQLite database, creates a prepared statement, sets the parameter value using setString(), and executes the delete query using executeUpdate(). The method returns the number of rows affected, which can be used for result processing. Finally, it closes the resources to free up memory.
Remember to handle exceptions appropriately in your production code and consider using try-with-resources or a similar mechanism to automatically close the resources.