import java.util.*;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.*;

import org.sqlite.*;

public class DBConnection {
public static Connection conn;
public static String DBPath;

public static Properties prop = new Properties();

	public static Connection SQLiteConnect() throws Exception {
		
		try {   
			
			Class.forName("org.sqlite.JDBC").newInstance();
			DBPath();
			conn = DriverManager.getConnection(DBPath);	

	} 
		catch(Exception e) {
			TCViewer.logWritter.logging(e.toString());
			e.printStackTrace();
	}
	return conn;
	}	
	
	public static void DBPath() {
		
    try {	
    	
 		prop.load(new FileInputStream("config.properties"));
        DBPath = prop.getProperty("database");
        
 	} 
 	catch (IOException e) {
		logWritter.logging(e.toString());
 		e.printStackTrace();
 		
     }		

	}
		
}