/* SQLite Demo
 */
package sqlitedemo3;

public class SQLiteDemo3UI {

    public static void main(String[] args) {
        
        SQLiteManager sm = new SQLiteManager();
        sm.displayAll();
        System.out.println("SQLite Demo 3");
    }
    
}
====================================================

/* SQLite Manager containing all the methods
 */
package sqlitedemo3;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLiteManager {
    
    private static Connection con;
    private static Statement state = null;
    private static ResultSet rs = null;
    
private void getConnection(){
    try {
        Class.forName("org.sqlite.JDBC");
        con = DriverManager.getConnection("jdbc:sqlite:LearnersDonations.db");
        System.out.println("Connection success");
    } catch (ClassNotFoundException | SQLException e) {
        System.out.println("Error");
        System.out.println(e.getMessage());
    }
} // end getConnection

public void displayAll() {
    if (con == null) {
        getConnection();
    }
    try {
        state = con.createStatement();
        rs = state.executeQuery("SELECT firstName, Surname, Grade FROM tblLeaners");
        while (rs.next()){
           System.out.println(rs.getString("firstName") + " " + rs.getString("Surname") + " " +  rs.getString("Grade"));
        }
 
    } catch (SQLException ex) {
        System.out.println("Error");
		System.out.println(ex.getMessage());
    }
    
} // end displayAll

} // end class