Encapsulation class for Oracle connected database OracleDB

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.ResultSet;
Import java.sql.SQLException;
Import java.sql.Statement;

public class OracleDB {

Connection string "Jdbc:oracle:thin: @localhost: 1521: DB instance Name"
static String URL = "Jdbc:oracle:thin: @localhost: 1521:database";
static String user = "Scott"; Database login Name
static String password = "Tiger"; Database login Password
static {
try {
Class.forName ("Oracle.jdbc.driver.OracleDriver");//Load driver < need to import driver package >
} catch (ClassNotFoundException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
Methods for database connections
public static Connection Getconn () {
Connection conn = null;
try {
conn = drivermanager.getconnection (URL, user, password);
SYSTEM.OUT.PRINTLN (conn);
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
Return conn;

}
Ways to close a connection
public static void Close (Connection conn, Statement St, ResultSet rs) {

Close connections from small to large
if (rs! = null) {
try {
Rs.close ();
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
if (st! = null) {
try {
St.close ();
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
IF (conn! = null) {
try {
Conn.close ();
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
}
}

}