sqliteconnection.java

来自「JGraph扩展应用。自定义Renderer,自定义视图View实现自定义工作流」· Java 代码 · 共 52 行

/**
 * 
 */
package flow.graph.db;

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

/**
 * @author Administrator
 *
 */
public class SQLiteConnection {
	public static final String SQLite_DATABASE = "workflow.db";
	private Connection con = null;
	
	public SQLiteConnection() throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{
		Class.forName("SQLite.JDBCDriver").newInstance();
		String datapath=System.getProperties().get("user.dir")+"/"+SQLite_DATABASE;
		con = DriverManager.getConnection("jdbc:sqlite:/"+datapath,"","");
	}
	
	public static Connection getConnection(){
		SQLiteConnection sql = null;
		boolean ok = false;
		try {
			sql = new SQLiteConnection();
			ok = true;
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			//e.printStackTrace();
		} finally{
			if(ok){
				return sql.con;
			}
			else {
				return null;
			}
		}
	}
}