org.xerial sqlite-jdbc 3.7.2 Use code with caution.
String url = "jdbc:sqlite:sample.db"; try (Connection conn = DriverManager.getConnection(url)) Statement st = conn.createStatement(); st.executeUpdate("CREATE TABLE IF NOT EXISTS test(id INTEGER PRIMARY KEY, name TEXT);"); st.executeUpdate("INSERT INTO test(name) VALUES('Alice');"); ResultSet rs = st.executeQuery("SELECT * FROM test;"); while (rs.next()) System.out.println(rs.getInt("id")+": "+rs.getString("name")); download sqlitejdbc372jar install