Help classes that connect to Oracle

Package util;

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;

Import java.sql.SQLException;

public class Dbconn {

public static Connection getconnection () {
Define a Connection object
Connection Conn=null;
To define a URL resource for a connection database
String url= "JDBC:ORACLE:THIN:@127.0.0.1:1521:ORCL";
Define the user name and password to connect to the database
String username= "System";
String password= "123456";
Load Database Connection Driver
String classname= "Oracle.jdbc.driver.OracleDriver";
try {
Class.forName (ClassName);
} catch (ClassNotFoundException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
Gets the connection object for the database
try {
Conn=drivermanager.getconnection (Url,username,password);
SYSTEM.OUT.PRINTLN ("Database connection established successfully ...");
} catch (SQLException e) {
TODO auto-generated Catch block
E.printstacktrace ();
}
Return Connection object
Return conn;
}
public static void Closedb (Connection conn,preparedstatement PS, ResultSet rs) throws sqlexception{
if (conn!=null) {
Conn.close ();
}
if (ps!=null) {
Ps.close ();
}
if (rs!=null) {
Rs.close ();
}
}
}

Help classes that connect to Oracle