java联接SQL Server 2005数据库

java连接SQL Server 2005数据库
1.从微软的网站Microsoft Download Center中上下载所需要用到的jar包 http://download.microsoft.com/download/2/8/9/289dd6a3-eeeb-46dc-9045-d0c6b59bfbc1/sqljdbc_1.1.1501.101_chs.exe

下载并运行此文件后生成的文件夹里面有一个 sqljdbc.jar,用的就是这个jar包。

2.一个连接数据库的java类

import java.sql.*;

public class connectURL {

	public static void main(String[] args) {
		
		// Create a variable for the connection string.
		String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
			"databaseName=db_search;user=fly;password=jordan123456";

		// Declare the JDBC objects.
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		
        	try {
        		// Establish the connection.
        		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            		con = DriverManager.getConnection(connectionUrl);
            
            		// Create and execute an SQL statement that returns some data.
            		String SQL = "SELECT TOP 10 * FROM Person.Contact";
            		stmt = con.createStatement();
            		rs = stmt.executeQuery(SQL);
            
            		// Iterate through the data in the result set and display it.
            		while (rs.next()) {
            			System.out.println(rs.getString(4) + " " + rs.getString(6));
            		}
        	}
        
		// Handle any errors that may have occurred.
		catch (Exception e) {
			e.printStackTrace();
		}

		finally {
			if (rs != null) try { rs.close(); } catch(Exception e) {}
	    		if (stmt != null) try { stmt.close(); } catch(Exception e) {}
	    		if (con != null) try { con.close(); } catch(Exception e) {}
		}
	}
}

以上java类摘自微软的官方文档,自己改动了connectionUrl的值

3.启动SQL Server的TCP/IP协议

从开始菜单栏进入到Microsoft SQL Server 2005 --->配置工具--->SQL Server Configuration Manager

java联接SQL Server 2005数据库

4.其它的说明：SQL Server2005和SQL Server2000的dirver和url字符串是不一样的。
在SQL Server2000中
drivername是 com.microsoft.jdbc.sqlserver.SQLServerDriver
url是 jdbc:sqlserver://127.0.0.1:1433;databasename=database1

java联接SQL Server 2005数据库

相关推荐