{"id":717,"date":"2015-12-23T09:51:13","date_gmt":"2015-12-23T02:51:13","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=717"},"modified":"2024-05-11T08:07:37","modified_gmt":"2024-05-11T01:07:37","slug":"delete","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/delete\/","title":{"rendered":"SQLite Java: Deleting Data"},"content":{"rendered":"\n

Summary<\/strong>: This tutorial walks you through deleting data in a table from a Java program using JDBC.<\/p>\n\n\n\n

To delete one or more rows of a database table from a Java program, you use the following steps:<\/p>\n\n\n\n

    \n
  1. First, create a database connection to the SQLite database<\/a>.<\/li>\n\n\n\n
  2. Next, prepare the DELETE<\/a>\u00a0statement.\u00a0If you want the statement to take parameters, use the question mark (?) placeholder inside the statement.<\/li>\n\n\n\n
  3. Then, create a new\u00a0instance of the \u00a0PreparedStatement<\/code>\u00a0class by calling the prepareStatement()<\/code> method of the Connection<\/code> object.<\/li>\n\n\n\n
  4. After that, supply\u00a0values in place of the question mark placeholder\u00a0using the set* method of the\u00a0PreparedStatement<\/code> object\u00a0e.g.,\u00a0setInt()<\/code>, setString()<\/code>, etc.<\/li>\n\n\n\n
  5. Finally, execute the DELETE<\/code>\u00a0statement by calling the executeUpdate()<\/code> method of the PreparedStatement<\/code> object.<\/li>\n<\/ol>\n\n\n\n

    The following program deletes\u00a0the warehouse with id 3\u00a0in\u00a0the warehouses<\/code> table\u00a0of the my.db<\/code> database\u00a0created in the creating table tutorial<\/a>.<\/p>\n\n\n

    import<\/span> java.sql.DriverManager;\nimport<\/span> java.sql.SQLException;\n\npublic<\/span> class<\/span> Main<\/span> <\/span>{\n    public<\/span> static<\/span> void<\/span> main<\/span>(String[] args)<\/span> <\/span>{\n        var<\/span> url = \"jdbc:sqlite:my.db\"<\/span>;\n        var<\/span> sql = \"DELETE FROM warehouses WHERE id = ?\"<\/span>;\n        var<\/span> id = 3<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url);\n             var<\/span> pstmt = conn.prepareStatement(sql)) {\n\n            pstmt.setInt(1<\/span>, id);\n\n            \/\/ execute the delete statement<\/span>\n            pstmt.executeUpdate();\n\n        } catch<\/span> (SQLException e) {\n            System.err.println(e.getMessage());\n        }\n    }\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Verify the deletion<\/h2>\n\n\n\n
    First, use the following\u00a0SELECT<\/a> statement to check the warehouses<\/code> table before executing\u00a0the\u00a0program:<\/p>\n\n\n
    SELECT<\/span>\n  id<\/span>,\n  name<\/span>,\n  capacity<\/span>\nFROM<\/span>\n  warehouses;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    id<\/span>  name<\/span>                capacity<\/span>\n--<\/span>  ------------------<\/span>  --------<\/span>\n1   Raw<\/span> Materials<\/span>       3000.0<\/span>\n2   Semifinished<\/span> Goods<\/span>  4000.0<\/span>\n3   Finished<\/span> Products<\/span>   5500.0<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    Second, run\u00a0the program.<\/p>\n\n\n\n
    Third, use the same SELECT<\/code> statement above to query data from the warehouses<\/code> table:<\/p>\n\n\n
    SELECT\n  id,\n  name,\n  capacity\nFROM\n  warehouses;<\/code><\/span><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    id<\/span>  name<\/span>                capacity<\/span>\n--<\/span>  ------------------<\/span>  --------<\/span>\n1   Raw<\/span> Materials<\/span>       3000.0<\/span>\n2   Semifinished<\/span> Goods<\/span>  4000.0<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    The output shows that the row with id 2 is deleted.<\/p>\n\n\n\n
    In this tutorial, you have learned how to delete\u00a0data in the SQLite database from the Java program.<\/p>\n
    \n\t
    \n\t\t
    Was this tutorial helpful ?<\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t