java连接sql server数据库示例

     从微软官网上下载 sql server jdbc driver 3.0然后解压
     接着配置classpath，把jdbc驱动添加进classpath中
     我下载的这个驱动里有两个驱动类，sqljdbc.jar 和sqljdbc4.jar
     如果使用sqljdbc.jar则必须用
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
注册驱动
如果使用sqljdbc4.jar则不需要，但是sqljdbc4.jar需要jre6以上运行环境

连接字符串是：String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
   "databaseName=AdventureWorks;user=MyUserName;password=*****;";
下面是一个完成的示例：
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=AdventureWorks;user=UserName;password=*****";

      // 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) {}
      }
   }
}

 

sql server jdbc 3.0 driver 下载