JDBC问题
temli 2007-10-01 04:42:08 import java.sql.*;
import java.net.URL;
public class ConnectAccess
{
public static void main(String[] args)
{
String url="jdbc:microsoft:sqlserver://master:1433";
Connection con=null;
Statement sm=null;
ResultSet rs=null;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
System.out.println("Çý¶¯³ÌÐòÒÑ×°ÔØ");
System.out.println("¼´½«Á¬½ÓÊý¾Ý¿â");
}
catch(Exception ex)
{
System.out.println("Can not load jdbc Driver:"+ex.getMessage());
return ;
}
try
{
con=DriverManager.getConnection(url,"PUBLIC","PUBLIC");
DatabaseMetaData dmd=con.getMetaData();
System.out.println("ÒÑÁ¬½Óµ½Êý¾Ý¿â£º"+dmd.getURL());
System.out.println("ËùÓõÄÊý¾Ý¿âÇý¶¯ÊÇ£º"+dmd.getDriverName());
}
catch(Exception ex)
{
System.out.println("failed to Connect");
System.out.println(ex.getMessage());
}
}
}
//结果显示:Can not load jdbc Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
我已经在classpath设置了lib\msdabs.jar;lib\mssqlserver.jar;msutil.jar;
请教下哪出错了,改如何改正呢???