jsp連接配接SQL Server 2000資料庫代碼

package util;

import java.sql.connection;

import java.sql.drivermanager;

public class conndb {

 public static string driver="com.microsoft.jdbc.sqlserver.sqlserverdriver";

 public static string url="jdbc:microsoft:sqlserver://localhost:1433;databasename=temp";

 public static string username="sa";

 public static string password="";

 public static connection con=null;

 public static connection getconnection()

 {

  try {

   class.forname(driver);

   con=drivermanager.getconnection(url,username,password);

   system.err.println("連結成功");

  } catch (exception e) {

   e.printstacktrace();

  }

  return con;

 }

 public static void main(string[] args) {

  conndb.getconnection();

}