jbuilder与sqlserver连接问题(多谢)
jb中的database pilot已经设置好,可以连接northwind数据库,但是程序就是过不去,刚接触不太熟,请指教!
错误信息:
C:\JBuilder9\jdk1.4\bin\javaw -classpath "D:\java\jb9\kit\classes;C:\jdbc\lib\msbase.jar;C:\jdbc\lib\mssqlserver.jar;C:\jdbc\lib\msutil.jar;C:\JBuilder9\jdk1.4\demo\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\demo\plugin\jfc\Java2D\Java2Demo.jar;C:\JBuilder9\jdk1.4\jre\lib\charsets.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\dnsns.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\ldapsec.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\localedata.jar;C:\JBuilder9\jdk1.4\jre\lib\ext\sunjce_provider.jar;C:\JBuilder9\jdk1.4\jre\lib\im\indicim.jar;C:\JBuilder9\jdk1.4\jre\lib\jaws.jar;C:\JBuilder9\jdk1.4\jre\lib\jce.jar;C:\JBuilder9\jdk1.4\jre\lib\jsse.jar;C:\JBuilder9\jdk1.4\jre\lib\rt.jar;C:\JBuilder9\jdk1.4\jre\lib\sunrsasign.jar;C:\JBuilder9\jdk1.4\lib\dt.jar;C:\JBuilder9\jdk1.4\lib\htmlconverter.jar;C:\JBuilder9\jdk1.4\lib\tools.jar" Text
java.lang.ClassNotFoundException: com/microsoft/jdbc/SQLServer/SQL ServerDriver
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at Text.main(Text.java:11)
-----------------------------------------
代码:
import java.sql.*;
public class Text
{
public Text()
{
}
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.SQL Server.SQL ServerDriver");
System.out.println("sucessful");
Connection conn = DriverManager.getConnection
("jdbc.microsoft:sqlserver://221.57.208.127:1433;DatabaseName=Northwind;User=sa;Password=823");
System.out.println("connect sucessful");
}catch(Exception e)
{
e.printStackTrace();
System.out.println("error");
}
}
}
救命啊!!!