数据库连接实例（JDBC连接SQLSERVER 2000）

package com.join.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {

Connection con = null;

Statement stmt = null;

ResultSet rs = null;

public void test() {
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLserverDriver");
   String url = "jdbc:mircosoft:sqlserver:localhost:1433;database=dataName";
   con = DriverManager.getConnection(url, "login", "password");
   stmt = con.createStatement();
   rs = stmt.executeQuery("SQL Query");
  } catch (SQLException e) {
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   System.out.println("没有找到驱动类");
   e.printStackTrace();
  } finally {
   if (rs != null) {
    try {
     rs = null;
     rs.close();
    } catch (SQLException e) {
     e.printStackTrace();
    }
    if (stmt != null) {

     try {
      stmt = null;
      stmt.close();
     } catch (SQLException e) {
      e.printStackTrace();
     }
     if (con != null) {
      try {
       con = null;
       con.close();
      } catch (SQLException e) {
       e.printStackTrace();
      }
     }
    }

   }
  }
}
}