Java连接Sql server 2000示例

import java.sql.*;
public class SqlConnectionTest
{

 private static String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

// private static String dbURL="jdbc:odbc:sqlTest"; //数据源连接方式 DSN：sqlTest
 
 private static String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";

 private static Connection dbConn = null;
 /**
  * @param args
  */
 public static void main(String[] args)
 {
  try
  {

   Class.forName(driverName);
   dbConn = DriverManager.getConnection(dbURL,"sa","");
   Statement sql = dbConn.createStatement();
   ResultSet set = sql.executeQuery("select * from jobs");
   while(set.next())
   {
    System.out.println(set.getString("job_id")+"\t"+
      set.getString("job_desc"));
   }
   System.out.println("Success");
   dbConn.close();
  } catch (ClassNotFoundException e)
  {
   e.printStackTrace();
  } catch (SQLException e)
  {
   e.printStackTrace();
  }
  
 }

}