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

public class ConnDB
{
//private static String url = "jdbc:oracle:thin:@192.168.0.1:1521:DBName";
private static String url = "jdbc:oracle:oci:@TNSName";
private static String user = "username";
private static String password = "password";

public ConnDB()
{
}

public static Connection getConnection()
{
Connection conn;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
conn= DriverManager.getConnection(url , user, password);
return conn;
}
catch(Exception e)
{
e.printStackTrace();
return null;
}
}
}