DatabaseConnection.java

package com.riskIt.db;

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


/**
 * This class is used to establish a database connection as well as 
 * close the connection
 * @author Poornima Tantry
 *
 */
public class DatabaseConnection 
{
	private static final String driver = "org.apache.derby.jdbc.ClientDriver";
	 
	private static final String URL = "jdbc:mysql://th101c-4.cs.wm.edu:33061/preist_riskinsurance";	
	private static Connection conn;
	private static boolean created = false;
	
	private DatabaseConnection()
	{	
		
	}
	
	public static Connection  getConnection() throws SQLException
	 {	    
		if(created)
		{
			return conn;
		}
		else
		{
			try 
				{
				    Class.forName(driver).newInstance();
				    conn = DriverManager.getConnection(URL,"root","s3m3rU");
				    created = true;
				    System.out.println("connected using " + URL);
				}
				catch(Exception e)
				{
					System.out.println("Exception in CreateConnection");
					e.printStackTrace();
				}			
		        return conn;
		}
	 }	
	
	public static void closeConnection()
	{
		try
		{
			if(created)
			{
				created = false;
				conn.close();
			}
		}
		catch(Exception e)
		{
			System.out.println("Exception in closeCOnnection");
			e.printStackTrace();
		}
		
	}
	

}