A Java class for SQLite conection Helper.

ConnectionManager.java

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

public class ConnectionManager {

  private static Connection connection;
  
  // path to the database file 
	private static final String dbPath = "tips.db";

	private ConnectionManager() {
		try {
			Class.forName("org.sqlite.JDBC");
			connection = DriverManager.getConnection("jdbc:sqlite:" + dbPath);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	public static Connection getInstance() {
		if (connection == null)
			new ConnectionManager();
		return connection;
	}

}