servicelocater.java

Java banking application with GUI add/delete/update new account partially generic GUI

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

public class ServiceLocater
{
	static ServiceLocater sl;
  Connection connection;

	public ServiceLocater()
	{
		String sourceURL ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=bankdb.mdb";
	    try {
	      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	      connection = DriverManager.getConnection(sourceURL, " ", " ");

	    }
	    catch (SQLException sqle) {
	      System.out.println("Error in creating connection " + sqle);
	    }
	    catch (ClassNotFoundException cnfe) {
	      System.out.println(cnfe);
	    }
	}

	public static ServiceLocater getInstance()
	{
		if(sl==null)
			sl=new ServiceLocater();
		return sl;
	}

	public Statement createStatement()
	{
	    try {
			return connection.createStatement();
		}catch (SQLException sqle) {
		System.out.println("Error in creating connection " + sqle);
		}
		return null;
	 }

	  public void closeConnection() {
	    if (connection != null) {
	      try {
		connection.close();
		connection = null;
	      }
	      catch (Exception e) {
		System.out.println("Exception in closeConnection " + e);
	      }
	    }
	  }
}