javabeang不行，直接jsp可以,提示'No suitable driver'

freetide 2004-11-29 02:57:07

这一段代码是取自csdn上某位达人的,应该没问题的,我不用javabean直接将代码写在jsp中，tomcat可以通过。
这一段代码我直接用它的main来测试就提示：No suitable driver
我的oracle是9i，　用的jdbc是classes12.jar, 已放入classpath 中，　
到底哪里有问题昵？

如果我用tomcat，　jdbc　driver要放在什么地方tomcat的common\lib下, 还是shared\lib

哪位大哥教我一下。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Database extends Object implements java.io.Serializable {
private String driver=null;
private String url=null;
private String user=null;
private String pass=null;

private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null; //
public Database() {
}

//
public boolean getConnFromPool(String sourceName){
try{
InitialContext ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup(sourceName);
conn=ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return true;
}catch(Exception e){
if (stmt!=null){
try{
stmt.close();
}catch(Exception e1){}
}
if (conn!=null){
try{
conn.close();
}catch(Exception e1){}
}
System.out.println(e.getMessage());
return false;
}
}

//
public void getConnection(){
driver="sun.jdbc.odbc.JdbcOdbcDriver";
String connStr = "jdbc:oracle:thin:@172.10.1.1:1521:svr1"; //thin con
url="";
user="user";
pass="user";

try{
Class.forName(driver);
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){System.out.println("driver error:");}
try{
conn=DriverManager.getConnection(connStr,user,pass);

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
}catch(Exception e){
System.out.println("error:"+e.getMessage());
}

}

//
public boolean closeConnection(){
try{
if(rs!=null)rs.close();
if(stmt!=null)stmt.close();
if(conn!=null)conn.close();
rs=null;
stmt=null;
conn=null;
return true;
}catch(Exception e){
System.out.println(e.getMessage());
}finally{
if (stmt!=null){
try{
stmt.close();
stmt=null;
}catch(Exception e){}
}
if (conn!=null){
try{
conn.close();
conn=null;
}catch(Exception e){}
}
}
return false;
}

//
public ResultSet query(String sql){
try{
rs=stmt.executeQuery(sql);
}catch(Exception e){
System.out.println(e.getMessage());
return null;
}
return rs;
}

//
public void in_query(String sql){
try{
rs=stmt.executeQuery(sql);
}catch(Exception e){
System.out.println(e.getMessage());
}
}

//
public int update(String sql){
int i=0;
try{
i=stmt.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.getMessage());
}
return i;
}

//
public int insert(String sql){
int i=0;
try{
i=stmt.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.getMessage());
}
return i;
}
//
public boolean del(String sql){
try{
stmt.executeUpdate(sql);
}
catch(Exception e){
System.out.println(e.getMessage());
return false;
}
return true;
}

//
public static void main(String[] args){
Database db=new Database();
try{
ResultSet rs=null;
db.getConnection();
String sql="select * from user";
rs=db.query(sql);
while(rs.next()){
System.out.print(rs.getString(1));
System.out.print(" ");
System.out.print(rs.getString(2));
System.out.print(" ");
System.out.print(rs.getString(3));
System.out.println(" ");
}
db.closeConnection();
}catch(Exception e){}
}
}

...全文