package db;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.lang.String;
import oracle.jdbc.pool.OracleDataSource;
import java.sql.*;
import java.util.Properties;
/**
*This class used to establish the connection between JdbcDriver and DataBase.
*DataSourceName will be created through URL.Connection will be
*created successfully next data will be inserted.Suppose
*connection can not be created then Exception occured.
*
*DriverManager class -- makes a connection with a driver
*/
public class DAO
{
public static Connection con = null;
public Connection getConnection(String path)
{
Properties property;
try
{
property = new Properties();
File f=new File(path);
FileInputStream filein=new FileInputStream(f);
property.load(filein);
String systemname = property.getProperty("SYSTEMNAME");
OracleDataSource ods=new OracleDataSource();
ods.setUser("SYSTEM");
ods.setPassword("REDHAT");
ods.setURL("jdbc:oracle:oci:system@"+systemname+":8088/XE");
con=ods.getConnection();
}
catch(SQLException e)
{
System.out.println("1");
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
return con;
}
public boolean returnConnection(Connection conn)
{
boolean status=true;
try
{
con.close();
}
catch(Exception e)
{
status=false;
}
return status;
}
}