JDBC connection to Oracle Database

Package com. hhwy. test;

Import java. Io. file;
Import java. Io. fileinputstream;
Import java. Io. fileoutputstream;
Import java. Io. ioexception;
Import java. Io. inputstream;
Import java. Io. outputstream;
Import java. SQL. connection;
Import java. SQL. resultset;
Import java. SQL. sqlexception;
Import java. SQL. statement;
Import java. SQL. drivermanager;

Import javax. Naming. context;
Import javax. Naming. initialcontext;
Import javax. SQL. datasource;

Import org. Apache. commons. DBCP. basicdatasource;

 

Public class dbtools
{
Private connection conn = NULL;
Private resultset rs = NULL;
Private statement stmt = NULL;
Private string temppath = "Temp"; // location where the Blob temporary file is stored
Private Static final basicdatasource;
Static {
Datasource = new basicdatasource ();
Datasource. setdriverclassname ("oracle. JDBC. Driver. oracledriver ");
Datasource. seturl ("JDBC: oracle: thin: @ 192.168.0.90: 1521: bjspdgis ");
Datasource. setusername ("epmmanager ");
Datasource. setpassword ("manager ");
}
 
Public dbtools ()
{
System. Out. println ("--------------------- dbtools enter ----");
Try {
// Conn = This. getconnection ();
// Conn = This. createconnection ();
Conn = dbtools. getdbpoolconnection ("JDBC/dbpool ");
If (Conn! = NULL)
{
This. stmt = conn. createstatement (resultset. type_scroll_insensitive, resultset. concur_updatable );
}
} Catch (exception E)
{
E. printstacktrace ();

}

}
// Tomcat Connection Pool Mode S
Private Static connection getdbpoolconnection (string poolname)
{
Context c_cont = NULL;
Datasource DS = NULL;
Try
{
C_cont = new initialcontext ();
} Catch (exception E)
{
System. Out. println ("couldn't build an initial context:" + E );
Return NULL;
}
Try
{
DS = (datasource) c_cont.lookup ("Java:/COMP/ENV/" + poolname );
} Catch (exception E)
{
E. printstacktrace ();
Return NULL;
}
Try
{
Return Ds. getconnection ();
} Catch (sqlexception E)
{
E. printstacktrace ();
System. Out. println ("sqlexception in databean. getpoolconnection ():"
+ E. getmessage () + "JNDI is:" + poolname );
Return NULL;
}
}
 
// JDBC connection
Public connection createconnection ()
{
Try
{
// Dbpool DBP = new dbpool ();
Connection con = NULL;
String connname = "JDBC: oracle: thin: @ 192.168.0.90: 1521: bjspdgis ";
// System. Out. Print ("connect to getconnect ():" + connname + "...");
Class. forname ("oracle. JDBC. Driver. oracledriver ");
Con = drivermanager. getconnection (connname, "epmmanager ",
"Manager ");

If (con! = NULL)
{
System. Out. println ("------------- connection successful !!! ");
} Else {

System. Out. println ("---------------- Connection Failed !!! ");
}
Return con;
} Catch (exception E)
{
E. printstacktrace ();
}
Return NULL;

}
 
Public connection getconnection ()
{
Connection conn1 = NULL;
Try {
Conn1 = datasource. getconnection ();
} Catch (exception e ){
E. printstacktrace ();
}

Return conn1;

}
 
Public resultset executequery (string SQL) throws sqlexception {
 
Try
{
System. Out. println (SQL );
Rs = stmt.exe cutequery (SQL );
} Catch (exception E)
{
E. printstacktrace ();
}

Return Rs;
}
Public void closedb ()
{
Try
{
Datasource. Close ();
} Catch (exception E)
{
E. printstacktrace ();
}

}

Public static void shutdowndbcp () throws exception {
System. Out. println ("Disconnect datasource. Close ()");
Datasource. Close ();


}
Public void closecon ()
{
Try
{
Conn. Close ();
} Catch (sqlexception E)
{
// Todo auto-generated Catch Block
E. printstacktrace ();
}
}
}