java连接SQL server 2005（jdbc）(已测试成功)

static  {
  
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

       String user="sa";
          String pwd="123";
          //JDBC连接方式
    String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=name ";
    //注册驱动
           //DriverManager.registerDriver (new com.microsoft.sqlserver.jdbc.SQLServerDriver());
    
         
    //获得一个连接
    conn = DriverManager.getConnection (url,user,pwd);
    //JOptionPane.showMessageDialog (null, "连接成功");
   
    // 设置自动提交为false
   conn.setAutoCommit (false);
   //建立高级载体
   ste = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
     }
     catch (Exception ex) {
      JOptionPane.showMessageDialog (null, "数据库连接失败...", "错误", JOptionPane.ERROR_MESSAGE);
      ex.printStackTrace();
     }
 }