//代码如下:
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.swing.JOptionPane;
public class JDBCServlet1{
public JDBCServlet1(){
try{
Class.forName("Oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mysid","system","manager");
Statement stmt = con.createStatement();
ResultSet rst = stmt.executeQuery("select * from tab");
while(rst.next()){
System.out.println(rst.getString("tname"));
System.out.println("<br>");
}
rst.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
JOptionPane.showMessageDialog(null,e);
System.exit(1);
}
catch(SQLException e)
{
JOptionPane.showMessageDialog(null,e);
System.exit(1);
}
}
public static void main(String[] args){
JDBCServlet1 s = new JDBCServlet1();
}
}备注:
数据库:oracle9i
环境变量:classpath 包含 :E:\oracle\ora92\jdbc\lib\classes12.zip出现问题:运行抛出异常---ClassNotFoundException!请各位XDJM积极发言,言者有分!焦急等待中.....
import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.swing.JOptionPane;
public class JDBCServlet1{
public JDBCServlet1(){
try{
Class.forName("Oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:mysid","system","manager");
Statement stmt = con.createStatement();
ResultSet rst = stmt.executeQuery("select * from tab");
while(rst.next()){
System.out.println(rst.getString("tname"));
System.out.println("<br>");
}
rst.close();
stmt.close();
con.close();
}
catch(ClassNotFoundException e){
JOptionPane.showMessageDialog(null,e);
System.exit(1);
}
catch(SQLException e)
{
JOptionPane.showMessageDialog(null,e);
System.exit(1);
}
}
public static void main(String[] args){
JDBCServlet1 s = new JDBCServlet1();
}
}备注:
数据库:oracle9i
环境变量:classpath 包含 :E:\oracle\ora92\jdbc\lib\classes12.zip出现问题:运行抛出异常---ClassNotFoundException!请各位XDJM积极发言,言者有分!焦急等待中.....
我也在用mysql
特别说明一下
你在引入jdbc包的时候
不要引入那个mysql-connector-java-3.1.8-bin-g.jar一起放进去
只要引入mysql-connector-java-3.1.8-bin.jar包
如果你引入了前面那个包,就有可能出现你所说的异常
你要将你的oracle9i-JDBC工具包注册到你的IDE中,如JBuild、eclipse
new Oracle.jdbc.driver.OracleDriver();
// OracleDriver ,MySQL4 驱动都会自动注册自己给 DriverManger
现在运行一切正常,真是郁闷之极!一直以为自己配置弄错了,虽然已经配置过N遍。