Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver‘与not currently know of SID given in

 1.出现

org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver'

 是没有导入Oracle安装包路径C:\Database\WINDOWS.X64_193000_db_home\jdbc\lib下面的ojdbc8.jar包，导致驱动找不到对应的Class。

2.出现

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

是由下图 SID(即xe)错误导致的，可以通过select instance_name from V$instance;查询自己Oracle的SID,替换掉xe就OK了。