命令行下编译,用JDBC连microsoft sql server 2000时,总是找不到com.microsoft这个包
先说一下我的配置:
JDK--〉C:\JBuilder9\jdk1.4
JRE--〉已经升级到1.5了
驱动--〉C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC
JAVA_HOME:C:\JBuilder9\jdk1.4
PATH:SET PATH=C:\JBuilder9\jdk1.4\bin;%PATH%
CLASSPATH:.;C:\JBuilder9\jdk1.4\lib\tools.jar;C:\JBuilder9\jdk1.4\jre\rt.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
我在import时用了一下语句:
import com.microsoft.*;
我的编译命令:
javac xxx.java
javac -classpath . xxx.java
javac -classpath %CLASSPATH% xxx.java
javac -classpath ".;C:\JBuilder9\jdk1.4\lib\tools.jar;C:\JBuilder9\jdk1.4\jre\rt.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;c:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar" xxx.java
结果:
都找不到com.microsoft这个包
我自己的解决方案:
1。把msbase.jar、msutil.jar、mssqlserver.jar三个包拷贝到C:\JBuilder9\jdk1.4\lib目录和C:\JBuilder9\jdk1.4\jre\exc目录
2。把msbase.jar、msutil.jar、mssqlserver.jar三个包拷贝到xxx.java文件的同一目录下
结果还是不行,但我在JB9里面却完全没有问题,郁闷阿
各位大虾,谁给支个招阿,万分感谢