用于获得数据库连接的通用类

import java.sql.*;

public class DatabaseConn {

 public static Connection getConnection()
 {
  Connection con=null;
 // String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  String CLASSFORNAME="com.mysql.jdbc.Driver";
 // String SERVANDDB="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jspdev";
  String SERVANDDB="jdbc:mysql://localhost:3306/test";
  String USER="root";
  String PWD="123";
  
  try {
   Class.forName(CLASSFORNAME);
   con=DriverManager.getConnection(SERVANDDB,USER,PWD);
     }
     catch (Exception ex) {
      ex.printStackTrace();
     }
     return con;
 }