JSP simple connection method of SQL Server2000 database _jsp programming

This article illustrates a simple way for JSP to connect to a SQL Server2000 database. Share to everyone for your reference. Specifically as follows:

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 ("link succeeded");
 } catch (Exception e) {
  e.printstacktrace ();
 }
 return con;
 }
 public static void Main (string[] args) {
 conndb.getconnection ();
 }
}

I hope this article will help you with the JSP program design.