写了一个java连接oracle数据库,就是连接不上,请教各位高手:
部分(只把连接数据库的代码粘出来了)代码如下:
import java.sql.*;
import java.lang.*;
import java.text.*;
import java.util.*;
public class iDBManager2000 { public String ClassString=null;
public String ConnectionString=null;
public String UserName=null;
public String PassWord=null; public Connection Conn;
public Statement Stmt;
public iDBManager2000() { ClassString="oracle.jdbc.driver.OracleDriver";
ConnectionString="jdbc:oracle:thin:@127.0.0.1:1521:tjy";
UserName="tjy";
PassWord="tjy";
} public boolean OpenConnection()
{
boolean mResult=true;
// System.out.println("Just 1");
try
{
// System.out.println("Just 2");
Class.forName(ClassString).newInstance();/////here is error
// System.out.println("Just 3");
if ((UserName==null) && (PassWord==null))
{
Conn= DriverManager.getConnection(ConnectionString);
}
else
{
Conn= DriverManager.getConnection(ConnectionString,UserName,PassWord);
} Stmt=Conn.createStatement();
mResult=true;
}
catch(Exception e)
{
System.out.println(""+e.getMessage());
// System.out.println("the other infor is :");
e.printStackTrace();
mResult=false;
}
return (mResult);
}
}错误信息是:
oracle.jdbc.driver.OracleDriver
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 iDBManager2000.OpenConnection(iDBManager2000.java:79)
我对oracle数据库不了解,因此不知道是什么错误,请各位大虾指点,
望具体点,谢谢!
部分(只把连接数据库的代码粘出来了)代码如下:
import java.sql.*;
import java.lang.*;
import java.text.*;
import java.util.*;
public class iDBManager2000 { public String ClassString=null;
public String ConnectionString=null;
public String UserName=null;
public String PassWord=null; public Connection Conn;
public Statement Stmt;
public iDBManager2000() { ClassString="oracle.jdbc.driver.OracleDriver";
ConnectionString="jdbc:oracle:thin:@127.0.0.1:1521:tjy";
UserName="tjy";
PassWord="tjy";
} public boolean OpenConnection()
{
boolean mResult=true;
// System.out.println("Just 1");
try
{
// System.out.println("Just 2");
Class.forName(ClassString).newInstance();/////here is error
// System.out.println("Just 3");
if ((UserName==null) && (PassWord==null))
{
Conn= DriverManager.getConnection(ConnectionString);
}
else
{
Conn= DriverManager.getConnection(ConnectionString,UserName,PassWord);
} Stmt=Conn.createStatement();
mResult=true;
}
catch(Exception e)
{
System.out.println(""+e.getMessage());
// System.out.println("the other infor is :");
e.printStackTrace();
mResult=false;
}
return (mResult);
}
}错误信息是:
oracle.jdbc.driver.OracleDriver
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 iDBManager2000.OpenConnection(iDBManager2000.java:79)
我对oracle数据库不了解,因此不知道是什么错误,请各位大虾指点,
望具体点,谢谢!
找不到类
你的Oracle驱动jar包加到环境变量里没有?
如果你用的是eclipse
在项目处点击右键,找到build path选择下面的add external之后在弹出窗口找到你oracle安装路径下的
Oracle92\jdbc\lib中的ojdbc14.jar添加进去就可以!