怎样在bean中连sql2k

[vibra]

我的代码是这样的
import java.sql.*;


public class ConnBean {
private Statement stmt = null;
ResultSet rs = null;
private Connection conn = null;
//构造函数
public ConnBean() {
}

public void OpenConn(String dsn, String uid, String pwd) throws Exception {
try {
dsn = "microsoft:sqlserver://localhost:1433;DatabaseName=" + dsn;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(dsn, uid, pwd);
}
catch (Exception ex) {
System.err.println("aq.executeQuery:" + ex.getMessage());
}
}
但是每次都提示no suitable driver
驱动我装好了，库的路径我也搞好了

[老土豆T]

驱动的参数可能不对...还有.要把jdbc的那个 .jar copy到Tomcat_Home/common/lib目录下

[mim]

import java.io.*;
import java.sql.*;

public class JdbcBean {

public void JdbcBean()
{
}
public ResultSet connect(String sql){
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:DB","uid","pwd");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
return rs;
}
catch(Exception fe)
{
}
return null;
}
}

DB为数据源!

[vibra]

那三个jar已经copy到tomcat里面了
我现在正在用jdbc-odbc,想试一下用sql driver for jdbc,据说会快一点