import java.sql.*;

public class SQLiteTest public static void main(String[] args) try Class.forName("org.sqlite.JDBC"); Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db"); Statement stmt = conn.createStatement(); stmt.execute("CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT)"); ResultSet rs = stmt.executeQuery("SELECT * FROM test"); while (rs.next()) System.out.println(rs.getInt("id") + " " + rs.getString("name")); conn.close(); catch (ClassNotFoundException

https://repo1.maven.org/maven2/org/xerial/sqlite-jdbc/3.7.2/sqlite-jdbc-3.7.2.jar

This program creates a new SQLite database file called "test.db", creates a table called "test", and then queries the table to print out its contents.