连接数据库Oracle

粘到Class.forName(里)；大小写要注意

 

 

 

package com.dhee.db;

import java.sql.DriverManager;
import java.sql.SQLException;

public class TestMySql {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
	//加载数据库驱动类
	//不同数据库厂商提供不同的驱动类
	Class.forName("oracle.jdbc.driver.OracleDriver");
	//创建数据库连接
	String url="jdbc:oracle:thin:@localhost:1521:orcl";
	String username="scott";
	String userpass="tiger";
	System.out.println(DriverManager.getConnection(url, username, userpass));
}
}

 出现过的问题：

Exception in thread "main" java.lang.ClassNotFoundException: //对应类未找到

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver.class
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at com.dhee.db.TestMySql.main(TestMySql.java:10)

 原因：

 .class没删，应该在driver里找