How to connect to SQLite with IntelliJ Community Version?

[eugenedakin]

@trishaduke

I think you need install a db navigator plugin

Hi Trisha,

I installed Database Navigator plugin, and was not able to find an example on how to run a query with the plugin.

When using the sqlite-jdbc-3.36.0.3.jar JDBC Driver, I was able to perform a successful SQLite query with this code:

            String url = "jdbc:sqlite:D:\\user\\JavaIntelliJ\\InjelliJJavaBeginning\\Chapter13\\Example13-2.sqlite";
            try {
                Connection conn = DriverManager.getConnection(url);
                Statement st = conn.createStatement();
                ResultSet rs = st.executeQuery("Select * from TblBooks");

                while(rs.next()){
                    System.out.println(rs.getString("Title") + rs.getString("Author"));
                }

            } catch (SQLException er) {
                System.out.println(er.getMessage());
                System.out.println("An error occurred while connecting MySQL database");
            }

Do you have any suggestions on how to make it work with Database Navigator, or is there a specific db navigator plugin that is being used that has documentation?

Thank you