package com.tukangjava.tutorial;

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


public class DatabaseAccess {
	Connection connection = null;

	public void connect() throws SQLException
	{
		String DRIVER = "oracle.jdbc.driver.OracleDriver";
		String URL = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
		String UserName = "daniel";
		String Password = "daniel";
		try
		{
			Class.forName(DRIVER);
		}
		catch (ClassNotFoundException e)
		{
			e.printStackTrace();
		}
		try
		{
			connection = DriverManager.getConnection(URL,UserName,Password);
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
	}
	public void disconnect() throws SQLException
	{
		connection.close();
	}
}