{"id":691,"date":"2015-12-22T21:09:16","date_gmt":"2015-12-22T14:09:16","guid":{"rendered":"http:\/\/www.sqlitetutorial.net\/?page_id=691"},"modified":"2024-05-11T07:56:53","modified_gmt":"2024-05-11T00:56:53","slug":"sqlite-java-crud","status":"publish","type":"page","link":"https:\/\/www.sqlitetutorial.net\/sqlite-java\/select\/","title":{"rendered":"SQLite Java: Select Data"},"content":{"rendered":"\n

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

To query data from a table, you use the following steps:<\/p>\n\n\n\n

    \n
  1. First, create a Connection<\/code> object to connect to the SQLite database<\/a>.<\/li>\n\n\n\n
  2. Next, create an instance of the Statement<\/code> class from the Connection<\/code> object.<\/li>\n\n\n\n
  3. Then, create an instance of the ResultSet<\/code> class by calling the executeQuery<\/code> method of the Statement<\/code>\u00a0object. The executeQuery()<\/code> method accepts a SELECT statement<\/a>.<\/li>\n\n\n\n
  4. After that, loop\u00a0through the result set using the next()<\/code> method of the ResultSet<\/code> object.<\/li>\n\n\n\n
  5. Finally,\u00a0use the get* method of the ResultSet<\/code> object\u00a0such as getInt()<\/code>, getString()<\/code>, getDouble()<\/code>, etc., to get the data in each iteration.<\/li>\n<\/ol>\n\n\n\n

    Querying all rows from a table<\/h2>\n\n\n\n

    The following program selects all rows from the warehouses<\/code> table.<\/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 = \"SELECT id, name, capacity FROM warehouses\"<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url);\n             var<\/span> stmt = conn.createStatement();\n             var<\/span> rs = stmt.executeQuery(sql)) {\n\n            while<\/span> (rs.next()) {\n                System.out.printf(\"%-5s%-25s%-10s%n\"<\/span>,\n                        rs.getInt(\"id\"<\/span>),\n                        rs.getString(\"name\"<\/span>),\n                        rs.getDouble(\"capacity\"<\/span>)\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
    Output:<\/p>\n\n\n
    1    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
    Querying data with parameters<\/h2>\n\n\n\n
    The following program retrieves the warehouses whose capacity are greater than 3600.<\/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 = \"SELECT id, name, capacity FROM warehouses WHERE capacity > ?\"<\/span>;\n        var<\/span> capacity = 3600<\/span>;\n\n        try<\/span> (var<\/span> conn = DriverManager.getConnection(url);\n             var<\/span> pstmt = conn.prepareStatement(sql)) {\n\n            pstmt.setDouble(1<\/span>, capacity);\n\n            var<\/span> rs = pstmt.executeQuery();\n\n            while<\/span> (rs.next()) {\n                System.out.printf(\"%-5s%-25s%-10s%n\"<\/span>,\n                        rs.getInt(\"id\"<\/span>),\n                        rs.getString(\"name\"<\/span>),\n                        rs.getDouble(\"capacity\"<\/span>)\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
    Output:<\/p>\n\n\n
    2    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
    In this tutorial, you have learned how to query data from the table in the SQLite database from a 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