Package Util;
Import java.sql.*;
Public class DBUtil {
Public static Connection getConnection() {
Connection conn = null;
Try {
Class.forName("oracle.jdbc.driver.OracleDriver"); //Load database driver
System.out.println ("database driver loaded successfully!"); / / output information
String url = "jdbc:oracle:thin:@localhost:1521:orcl"; //Get the connection URL
String user = "TEACHER"; //Connect username
String password = "***"; //Connection password
Connection con = DriverManager.getConnection(url, user, password); //Get the database connection
If (con != null) {
System.out.println("Successful connection to Oracle database!!");
}
} catch (Exception e) {
e.printStackTrace();
}
Return conn; / / return Connection instance
}
/ / Close the resource method
Public static void close(Connection connection ) {
Try {
If (connection != null) {
Connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Public static void close(PreparedStatement preparedStatement ) {
Try {
If (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
Public static void close(ResultSet resultSet ) {
Try {
If (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
Java Connection Oracle Code