samedi 12 septembre 2015

Java-How Do I Rerefrence Sqlite Database in the Same Folder With My Project Files?

am working on a certain java Management System where am using sqlite as my primary database. Am using netbeans gui builder to work on my project. I have googled and stack overflowed how to reference sqlite database in the same dir with my project files without including full path like c://filepath but nothing promising yet. I don't want to include the full path to my database, I want to use sqlite file from the project files so that everything will work smoothly even after distributing my project...

My Connection Class currently Looks like this;

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

public class Connect {
    private static Connection con = null; 

    public static Connection connecting(){

        try{
            Class.forName("org.sqlite.JDBC"); 
            con = DriverManager.getConnection("jdbc:sqlite:programming.sqlite");
            JOptionPane.showMessageDialog(null, "Working", null, JOptionPane.INFORMATION_MESSAGE);

        }catch(Exception e){
            JOptionPane.showMessageDialog(null, e.getMessage(), null, JOptionPane.ERROR_MESSAGE); 
        }
        return con; 
    }

}

However that's seems not to work.. Remember Connection class and database are saved in the same dir...

Please note am avoiding absolute path like c://users/programming.sqlite

Anything to help please???

Aucun commentaire:

Enregistrer un commentaire