我用JAVA连ORACLE时出错啊

Question

import java.sql.*;
import java.awt.*;
import java.lang.*;public class dbtest
{
public static void main(String []args)
{
String servername="127.0.0.1";
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@"+servername+":1521:TEST";
Connection conn=DriverManager.getConnection(url,"scott","tiger");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select 1 from dual");
while(rs.next()){
System.out.print("deptno:"+rs.getInt(1));
System.out.print("\tdeptname:"+rs.getString(2));
System.out.println("\tloc:"+rs.getString(3));

}

}
catch(Exception e)
{
e.printStackTrace();
}
}
}

Answer 1

不用 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
用 new oracle.jdbc.driver.OracleDriver(); 试试看,

Answer 2

D:\tg\dbtest.java:11: package oracle.jdbc.driver does not exist
                        new oracle.jdbc.driver.OracleDriver(); 
那样编译时就报错

Answer 3

应该是没有把驱动包复制到bin目录下。

Answer 4

Statement stmt=conn.createStatement(参数);