{"id":707,"date":"2015-12-23T09:11:09","date_gmt":"2015-12-23T02:11:09","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=707"},"modified":"2024-05-11T07:47:42","modified_gmt":"2024-05-11T00:47:42","slug":"insert","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/insert\/","title":{"rendered":"SQLite Java: Inserting Data"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to insert data into a table in an SQLite database using the Java JDBC.<\/p>\n\n\n\n

To insert data into a table using the INSERT<\/a> statement, you use the following steps:<\/p>\n\n\n\n

    \n
  1. First, connect to the SQLite database<\/a>.<\/li>\n\n\n\n
  2. Next, prepare the INSERT<\/code> statement. Use a question mark (?) for each parameter if you have parameters in the statement.<\/li>\n\n\n\n
  3. Then, create an instance of the PreparedStatement<\/code> from the Connection<\/code> object.<\/li>\n\n\n\n
  4. After that, set the\u00a0corresponding values for each placeholder using the set method of the\u00a0PreparedStatement<\/code> object such as setInt()<\/code>, setString()<\/code>, etc.<\/li>\n\n\n\n
  5. Finally, call the executeUpdate()<\/code> method of the PreparedStatement<\/code> object to execute the statement.<\/li>\n<\/ol>\n\n\n\n

    The following program inserts three rows into the table warehouses<\/code> that we created 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\n    public<\/span> static<\/span> void<\/span> main<\/span>(String[] args)<\/span> <\/span>{\n\n        String url = \"jdbc:sqlite:my.db\"<\/span>;\n\n        var<\/span> names = new<\/span> String[] {\"Raw Materials\"<\/span>, \"Semifinished Goods\"<\/span>, \"Finished Goods\"<\/span>};\n        var<\/span> capacities = new<\/span> int<\/span>[] {3000<\/span>,4000<\/span>,5000<\/span>};\n\n        String sql = \"INSERT INTO warehouses(name,capacity) VALUES(?,?)\"<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url);\n             var<\/span> pstmt = conn.prepareStatement(sql)) {\n\n            for<\/span>(int<\/span> i = 0<\/span>; i < 3<\/span>; i++){\n                pstmt.setString(1<\/span>, names[i]);\n                pstmt.setDouble(2<\/span>, capacities[i]);\n                pstmt.executeUpdate();\n            }\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
    How it works.<\/p>\n\n\n\n
    First, initialize a connection string to the my.db<\/code> sqlite database file:<\/p>\n\n\n
    String url = \"jdbc:sqlite:my.db\"<\/span>;<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Second, declare two arrays that store warehouse names and their capacities:<\/p>\n\n\n
    var<\/span> names = new<\/span> String[] {\"Raw Materials\"<\/span>, \"Semifinished Goods\"<\/span>, \"Finished Goods\"<\/span>};\nvar<\/span> capacities = new<\/span> int<\/span>[] {3000<\/span>,4000<\/span>,5000<\/span>};<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Third, construct an INSERT statement that inserts a row into the warehouses<\/code> table:<\/p>\n\n\n
    String sql = \"INSERT INTO warehouses(name,capacity) VALUES(?,?)\"<\/span>;<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    In this statement, the question marks (?<\/code>) will be replaced with the corresponding name and capacity.<\/p>\n\n\n\n
    Fourth, create a connection to the sqlite database by calling the getConnection() method of the DriverManager class:<\/p>\n\n\n
    var<\/span> conn = DriverManager.getConnection(url);<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Fifth, create a PreparedStatement object from the Connection object with the INSERT statement:<\/p>\n\n\n
    var<\/span> pstmt = conn.prepareStatement(sql)<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Sixth, iterate over the names and capacities arrays. In each iteration, bind the name and capacity and call the executeUpdate() statement to run the INSERT statement:<\/p>\n\n\n
    for<\/span> (int<\/span> i = 0<\/span>; i < 3<\/span>; i++) {\n  pstmt.setString(1<\/span>, names[i]);\n  pstmt.setDouble(2<\/span>, capacities[i]);\n  pstmt.executeUpdate();\n}<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    We use the try-with-resources statement to close the statement and database connection properly.<\/p>\n\n\n\n
    Seventh, display the error message in the catch block if any SQL exception occurs:<\/p>\n\n\n
    System.err.println(e.getMessage());<\/code><\/span>Code language:<\/span> Java<\/span> (<\/span>java<\/span>)<\/span><\/small><\/pre>\n\n\n
    Verifying the inserts<\/h2>\n\n\n\n
    After running the program, you can check the warehouses<\/code> table in the test.db<\/code> database using the following SELECT<\/a> statement:<\/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> Goods<\/span>      5000.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 insert data into a table 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