package conn;

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

public class DataBaseConnection
{
	
	String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    String dabaseurl =
             "jdbc:sqlserver://localhost:1433;DatabaseName=xsglDatabase";
    String dbUser = "sa";
    String dbPassword = "";
    Connection con = null;
    ResultSet rs = null;
    PreparedStatement prepStmt = null;
    
    public DataBaseConnection() {
        try {
         Class.forName(drivrename);
     } catch (java.lang.ClassNotFoundException e) {
         System.err.println(e);
     }


    }
    
    
	public   Connection getConnection() {
        Connection con;
        try {
            Class.forName(drivrename);
            con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
            return con;
        } catch (java.lang.ClassNotFoundException e) { 
            System.err.println(e);
        } catch (SQLException er) {
            System.err.println(er.getMessage());
        }

        return null;
    }
}