public static Connection getConnection() throws ClassNotFoundException, SQLException {

    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection con=DriverManager.getConnection(
            "jdbc:oracle:thin:@host:port:sid","username","password");

    return con;
}