package com.ilp.tsi.um.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import com.ilp.tsi.um.constants.Constant;
public class Daopack {
    public static Connection createconnection() {
        Connection connection = null;
        try {
            Class.forName(Constant.DRIVER).newInstance();
            connection = DriverManager.getConnection(Constant.DBURL,Constant.DBUSER, Constant.DBPASS);

        } catch (ClassNotFoundException ce) {
            ce.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        }
        return connection;
    }

}

package com.ilp.tsi.um.constants;

public class Constant {
        public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
        public static final String DBURL = "jdbc:oracle:thin:@172.24.137.30:1521:ORA10g";
        public static final String DBUSER = "e557520";
        public static final String DBPASS = "tznsiSArf";
        public static final String RID ="RI";
        public static final String MESSAGE="Authentication Failed. Enter valid credentials";
        public static final String CONTEXT="text/html";


}