package com.tsi.dao;
import java.sql.*;
import com.tsi.constants.*;
    public class DaoPack {
        public static Connection conn = null;
        public static Connection createConnection() {

            try {
                Class.forName(Constant.DRIVER).newInstance();
                conn= DriverManager.getConnection(Constant.DBURL,Constant.DBUSER, Constant.DBPASSWORD);
                System.out.println("Database connection is established");
            }
            catch (ClassNotFoundException ce) {
                System.out.println("exception occured");
            } catch (SQLException se) {
                System.out.println("exception occured");
            } catch (InstantiationException ie) {
                ie.printStackTrace();
            } catch (IllegalAccessException iae) {
                iae.printStackTrace();
            }
            return conn;
        }


            }