jsp servlet连接sql2005数据库

DBBean.java

//数据库连接，防止重复代码，更换数据库更加方便，方便维护

public static Connection getConnection()
 {
  String classforname="com.microsoft.sqlserver.jdbc.SQLServerDriver";   
  String url = "jdbc:sqlserver://localhost:1433;databaseName=ecard";
  String dbname = "数据库用户名";
  String password = "密码";
  Connection con;
  
  try
  {
   Class.forName(classforname);
   
   con = DriverManager.getConnection(url,dbname,password);
   
   return con;
  }
  catch(Exception e)
  {
   e.printStackTrace();
   
   return null;
  }

 }