代码如下:import java.sql.*;public class DBAccess {
private String url="jdbc:oracle:thin:@localhost:1521:ORCL";
private String username="scott";
private String pw="123";
private Connection con=null;
public Connection Conn1()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
try{
con=DriverManager.getConnection(url, username, pw);
}catch(SQLException e)
{
e.printStackTrace();
}
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
}
public static void main(String args[]) throws IllegalAccessException, Throwable
{
DBAccess obj=new DBAccess();
Connection conn=obj.Conn1();
if(conn==null)
{
System.out.print("连接失败!");
}
else
{
System.out.println("连接成功!");
}
}
}
错误如下:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at DBAccess.Conn1(DBAccess.java:12)
at DBAccess.main(DBAccess.java:29)
连接失败!看不懂啊,高手帮下忙!还有就是我在 SQLplus登不上,闪一下就没了,用plsql登的上怎么回事啊?
private String url="jdbc:oracle:thin:@localhost:1521:ORCL";
private String username="scott";
private String pw="123";
private Connection con=null;
public Connection Conn1()
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
try{
con=DriverManager.getConnection(url, username, pw);
}catch(SQLException e)
{
e.printStackTrace();
}
}catch(ClassNotFoundException e)
{
e.printStackTrace();
}
return con;
}
public static void main(String args[]) throws IllegalAccessException, Throwable
{
DBAccess obj=new DBAccess();
Connection conn=obj.Conn1();
if(conn==null)
{
System.out.print("连接失败!");
}
else
{
System.out.println("连接成功!");
}
}
}
错误如下:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at DBAccess.Conn1(DBAccess.java:12)
at DBAccess.main(DBAccess.java:29)
连接失败!看不懂啊,高手帮下忙!还有就是我在 SQLplus登不上,闪一下就没了,用plsql登的上怎么回事啊?
添加到项目中