package Playground.sqliteTest;
import java.sql.*;


public class sqliteTest {
    public static void main(String[] args){
        String connectionURL = "jdbc:sqlite:src/Playground/sqliteTest/test.db";
        // Connect to Database
        try{
            Connection conn = DriverManager.getConnection("jdbc:sqlite:src/Playground/sqliteTest/test.sqlite");
            Statement stmt = conn.createStatement();
            stmt.execute("CREATE TABLE IF NOT EXISTS test (name TEXT)");
            ResultSet rs = stmt.executeQuery("SELECT * FROM test");
            while(rs.next()){
                System.out.println(rs.getString("name"));
            }
        } catch (SQLException e){
            System.out.println(e.getMessage());
        }

    }
}