//代码:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class TestSQL2005
{
private Connection con=null;
private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:microsoft:sqlserver://localhost:1443;databaseName=Master;user=sa;password=888888";
public void testConnection()
{
try
{
Class.forName(DRIVER);
con=DriverManager.getConnection(URL);
if(con!=null)
{
con.close();
}
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public static void main(String[] args)
{
new TestSQL2005().testConnection();
}
}
//异常:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at tsql.TestSQL2005.testConnection(TestSQL2005.java:17)
at tsql.TestSQL2005.main(TestSQL2005.java:35)到底什么原因啊,我在网上查了半天也买找到什么原因,连2000就好好的,但是通过在JBuilder2006中配置可以直接访问sql2005,这里到底什么问题啊?望高手指点!
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class TestSQL2005
{
private Connection con=null;
private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL="jdbc:microsoft:sqlserver://localhost:1443;databaseName=Master;user=sa;password=888888";
public void testConnection()
{
try
{
Class.forName(DRIVER);
con=DriverManager.getConnection(URL);
if(con!=null)
{
con.close();
}
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public static void main(String[] args)
{
new TestSQL2005().testConnection();
}
}
//异常:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at tsql.TestSQL2005.testConnection(TestSQL2005.java:17)
at tsql.TestSQL2005.main(TestSQL2005.java:35)到底什么原因啊,我在网上查了半天也买找到什么原因,连2000就好好的,但是通过在JBuilder2006中配置可以直接访问sql2005,这里到底什么问题啊?望高手指点!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货