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;  }

 }