package com.accpedu.LHcompany.dao;

import java.sql.*;


public class DBAccess {

	Connection con=null;
	
	public Connection DBOpen()
	{
		try
		{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=company","sa","123");
		}catch(ClassNotFoundException ce)
		{
			System.out.println(ce.getMessage());
		}catch(SQLException ce)
		{
			System.out.println(ce.getMessage());
		}
		return con;
	}
	
	public void DBClose()
	{
		try
		{
			if(con!=null)con.close();
		}catch(SQLException ce)
		{
			System.out.println(ce.getMessage());
		}
	}
}