有下面一样一个类,在该类的文件夹下有驱动程序class12.jar,编译运行老是提示找不到驱动程序,请问怎样才能找到驱动程序?
import java.sql.*;public class Conn
{ String sDBDriver;
Connection connect;
Statement stmt;
ResultSet rs;
String URL;
String user;
String password; public Conn()
{
sDBDriver = "oracle.jdbc.driver.OracleDriver";
connect = null;
stmt = null;
rs = null;
URL = "jdbc:oracle:thin:@127.0.0.1:1521:hp";
user = "pll";
password = "ttt";
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println(classnotfoundexception.getMessage());
}
} public ResultSet executeQuery(String s)
{
try
{
connect = DriverManager.getConnection(URL, user, password);
stmt = connect.createStatement();
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return rs;
} public void endconn()
{
try
{
stmt.close();
connect.close();
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
} public String callprocedure(String s)
{
try
{
connect = DriverManager.getConnection(URL, user, password);
String s1 = s;
CallableStatement callablestatement = connect.prepareCall(s1);
callablestatement.executeUpdate();
connect.close();
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return "ok boy";
}
public static void main(String[] args) throws SQLException {
// TODO code application logic here
Conn conn=new Conn();
ResultSet rs =conn.executeQuery("select table_name from all_tables");
while(rs.next())
{
System.out.println(rs.getString(1));
}
conn.endconn();
}
}
import java.sql.*;public class Conn
{ String sDBDriver;
Connection connect;
Statement stmt;
ResultSet rs;
String URL;
String user;
String password; public Conn()
{
sDBDriver = "oracle.jdbc.driver.OracleDriver";
connect = null;
stmt = null;
rs = null;
URL = "jdbc:oracle:thin:@127.0.0.1:1521:hp";
user = "pll";
password = "ttt";
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println(classnotfoundexception.getMessage());
}
} public ResultSet executeQuery(String s)
{
try
{
connect = DriverManager.getConnection(URL, user, password);
stmt = connect.createStatement();
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return rs;
} public void endconn()
{
try
{
stmt.close();
connect.close();
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
} public String callprocedure(String s)
{
try
{
connect = DriverManager.getConnection(URL, user, password);
String s1 = s;
CallableStatement callablestatement = connect.prepareCall(s1);
callablestatement.executeUpdate();
connect.close();
}
catch(SQLException sqlexception)
{
System.err.println(sqlexception.getMessage());
}
return "ok boy";
}
public static void main(String[] args) throws SQLException {
// TODO code application logic here
Conn conn=new Conn();
ResultSet rs =conn.executeQuery("select table_name from all_tables");
while(rs.next())
{
System.out.println(rs.getString(1));
}
conn.endconn();
}
}
进倒这个包也行~~
楼上两位为什么一致认定LZ用的是eclipse?
如果楼主有用IDE的话,把其添加入IDE的这个项目库(Lib)里..如果在命令行下的话,把jar放classpath里或者直接把jar包解压缩出来,里面的文件夹和待编译的java文件放一个同级目录里...