{"id":711,"date":"2015-12-23T09:29:56","date_gmt":"2015-12-23T02:29:56","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=711"},"modified":"2024-05-11T07:48:29","modified_gmt":"2024-05-11T00:48:29","slug":"sqlite-java-update-data","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/update\/","title":{"rendered":"SQLite Java: Update Data"},"content":{"rendered":"\n

Summary<\/strong>: This tutorial shows you how to update data in a table from a Java program using JDBC.<\/p>\n\n\n\n

To update data in a table using JDBC from a Java program, you follow these steps:<\/p>\n\n\n\n

    \n
  1. First, connect to the SQLite database<\/a>.<\/li>\n\n\n\n
  2. Next, prepare the UPDATE<\/a> statement. For the UPDATE<\/code> statement that uses parameters, you use the question marks (?) placeholder in the SET<\/code> and WHERE<\/a> clauses.<\/li>\n\n\n\n
  3. Then, instantiate an object the PreparedStatement<\/code>\u00a0class by calling the prepareStatement() method of the Connection<\/code> object.<\/li>\n\n\n\n
  4. After that, set a value for each placeholder using the set* method of the\u00a0PreparedStatement<\/code> object, for example,\u00a0setString()<\/code>, setInt()<\/code>, etc.<\/li>\n\n\n\n
  5. Finally, execute the UPDATE<\/code> statement by calling the executeUpdate()<\/code> method of the PreparedStatement<\/code> object.<\/li>\n<\/ol>\n\n\n\n

    The following Java program illustrates how to update the name and capacity of the warehouse with id 3:<\/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 = \"UPDATE warehouses SET name = ? , \"<\/span>\n                + \"capacity = ? \"<\/span>\n                + \"WHERE id = ?\"<\/span>;\n\n        var<\/span> name = \"Finished Products\"<\/span>;\n        var<\/span> capacity = 5500<\/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            \/\/ set the parameters<\/span>\n            pstmt.setString(1<\/span>, name);\n            pstmt.setDouble(2<\/span>, capacity);\n            pstmt.setInt(3<\/span>, id);\n            \/\/ update<\/span>\n            pstmt.executeUpdate();\n        } catch<\/span> (SQLException e) {\n            System.err.println(e.getMessage());\n        }\n    }\n}\n<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Verify the update<\/h2>\n\n\n\n
    The following statement retrieves the warehouse with id 3 from the warehouses table in the my.db sqlite database:<\/p>\n\n\n
    SELECT<\/span>\n  id<\/span>,\n  name<\/span>,\n  capacity<\/span>\nFROM<\/span>\n  warehouses\nWHERE<\/span>\n  id<\/span> = 3<\/span>;<\/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>\n3   Finished<\/span> Products<\/span>  5500.0<\/span><\/code><\/span>Code language:<\/span> CSS<\/span> (<\/span>css<\/span>)<\/span><\/small><\/pre>\n\n\n
    In this tutorial, you have learned how to update data 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