jdbc问题!
我安装了的MS-SQL2000的JDBC驱动程序
调试如下程序:
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
class Test extends Frame {
public Test() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://202.200.100.100:1433","sa","111");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from a");
while (rs.next())
{
System.out.println(rs.getInt(1)+""+rs.getString(2));
}
stmt.close();
conn.close();
System.exit(0);
}
catch (Exception e) {
e.printStackTrace();
System.out.println("error: "+ e.getMessage());
System.exit(0);
}
}
public static void main(String args[]) {
System.out.println("start testing ...");
Test mainFrame = new Test();
}
}
jdk1.4下调试
报
java.lang.classNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
......
.
.
.
.
.
error:com.microsoft.jdbc.sqlserver.SQLServerDriver
不知道是classpath配置的不对还是怎么回事总是调不对
在classpath里也试了(当然下面的包含是在一行里)
set classpath=C:\J2SDK1.4.0\JRE\LIB\RT.JAR; C:\J2SDK1.4.0\LIB\TOOLS.JAR;
C:\J2SDK1.4.0\LIB\mssqlserver.jar;
C:\J2SDK1.4.0\LIB\msutil.jar;
C:\J2SDK1.4.0\LIB\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 JDBC\lib;
C:\Program Files\Microsoft SQL Server 2000 JDBC\lib\mssqlserver.jar;
C:\Program Files\Microsoft SQL Server 2000 JDBC\lib\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 JDBC\lib\msbase.jar;
set path=C:\J2SDK1.4.0\BIN;
还是有问题,!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!