兄弟们帮帮我
出错内容:
VisualCafe (16:46:43): Error: F:\OA\oa_程序及工具\java_源程序\ezoa_java\DBdata.java(16): unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
VisualCafe (16:46:43): Error: F:\OA\oa_程序及工具\java_源程序\ezoa_java\DBdata.java(16): unreported exception java.lang.InstantiationException; must be caught or declared to be thrown
下面是源程序:
import java.sql.*;
public class DBdata {
String DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String ConnStr = "jdbc:microsoft:sqlserver://pine;DatabaseName=crm";
public Connection conn = null;
public ResultSet rs = null;
//public DBconn {}
public ResultSet executeQuery(String sql) {
rs = null;
try {
Class.forName(DBDriver).newInstance();//这行出错
conn=DriverManager.getConnection(ConnStr,"sa","sa");
//与DBMS建立链接
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery:"+ ex.getMessage());
}
return rs;
}
}
我在VisualCafe的
Tools---Environment Options...---internal VM---classpath settings下添加了三个SQL驱动文件:
msbase.jar
mssqlserver.jar
msutil.jar