import java.sql.*;
import java.net.URL;
public class ConnectAccess
{
public static void main(String[] args)
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mydata";
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,"sa","lzk861220");
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());
}
}
}
import java.net.URL;
public class ConnectAccess
{
public static void main(String[] args)
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mydata";
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,"sa","lzk861220");
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());
}
}
}
即将连接数据库
failed to Connect
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Press any key to continue...为什么会出错呢
该怎么改呢