jdbc连接Sql Server 2008

 

public class SQLUtil { private static final String CLASSNAME = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL = "jdbc:sqlserver://"; private static final String SERVERNAME = "LOCALHOST//SQLEXPRESS"; private static final String PORTNUMBER = "3048"; private static final String DBNAME = "DB1"; private static final String USERNAME = "sa"; private static final String PASSWORD = "sa"; private static final String conStr = URL+SERVERNAME+":"+PORTNUMBER+";DatabaseName="+DBNAME ; public static void main(String[] args) throws ClassNotFoundException, SQLException{ Connection conn = null; Class.forName(CLASSNAME); conn = DriverManager.getConnection(conStr,USERNAME,PASSWORD); } }

1. 驱动程序的类名为：com.microsoft.sqlserver.jdbc.SQLServerDriver

2. 连接的URL为： " jdbc:sqlserver://@(ServerName):@(PortNumber);DatabaseName=@(DBNAME) "

3. 注意：@(ServerName)处一般为 localhost//@(Instance)， 2008在server处都需要有一个Instance实例。

4. PortNumber： 2008默认情况下是一个动态端口，可以关闭动态端口改用其它端口，但要注意，修改后需要重启SQL的服务。

    修改在Microsoft SQL Server 2008 --> Configuration Tools --> Sql Server Configuration Manager

     --> SQL Server Network Configuration --> Protocol --> TCP/IP --> Properties