我现在把jive中数据库连接池这么功能独立出来做了一个简单的测试

package com.jivesoftware.forum.database;

import com.jivesoftware.forum.*;

import java.io.PrintStream;

import java.sql.*;

public class DbTest {

private static final String TESTSQL ="SELECT * FROM jiveUser";

//private static void ExecuteQuery(String username) throws TestException {

public static void ExecuteQuery() {

Connection con = null;

PreparedStatement pstmt = null;

try{

con = ConnectionManager.getConnection();

pstmt = con.prepareStatement(TESTSQL);

ResultSet rs = pstmt.executeQuery();

while (rs.next()){

System.out.println(rs.getString(1));

System.out.println(rs.getString(2));

}

}catch(SQLException sqle){

sqle.printStackTrace();

}

finally

{

try

{

pstmt.close();

}

catch(Exception e)

{

e.printStackTrace();

}

try

{

con.close();

}

catch(Exception e)

{

e.printStackTrace();

}

}

}

public static void main(String args[]){

ExecuteQuery();

}

}

在jsp中去调这个javabean测试成功

在javabean测试就出现如下错误,sql server的驱动已正确安装了为什么会出错?

开发这一类程序该如何进行单元测试，如果每次用jsp调javabean测试不是太麻烦了. 谢了!

java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

at java.net.URLClassLoader$1.run(URLClassLoader.java:198)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:186)

at java.lang.ClassLoader.loadClass(ClassLoader.java:299)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)

at java.lang.ClassLoader.loadClass(ClassLoader.java:255)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:140)

at com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.createConn(DefaultConnectionProvider.java:738)

at com.jivesoftware.forum.database.DefaultConnectionProvider$ConnectionPool.<init>(DefaultConnectionProvider.java:438)

at com.jivesoftware.forum.database.DefaultConnectionProvider.start(DefaultConnectionProvider.java:78)

at com.jivesoftware.forum.database.ConnectionManager.setConnectionProvider(ConnectionManager.java:185)

at com.jivesoftware.forum.database.ConnectionManager.getConnection(ConnectionManager.java:86)

at com.jivesoftware.forum.database.DbTest.ExecuteQuery(DbTest.java:30)

at com.jivesoftware.forum.database.DbTest.main(DbTest.java:68)