dbconnectionmanager.java

该代码是采用JSP实现的网上家电销售系统

package electric.electricUtils;
import java.sql.*;
import java.io.*;
import java.util.*;

public class DbConnectionManager {

  private static String propFileName = FinalConstants.PATH_DBPROP;
  private static Properties prop = new Properties();
  private static String dbClassName =
      "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private static String dbUrl =
      "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YWW";
  private static String dbUsr = "sa";
  private static String dbPwd = "";
  private static void loadProperty() {
    try {
      prop.load(new FileInputStream(propFileName));
      dbClassName = prop.getProperty("DB_CLASS_NAME");
      dbUrl = prop.getProperty("DB_URL",
          "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YWW");
      dbUsr = prop.getProperty("DB_USR", "sa");
      dbPwd = prop.getProperty("DB_PWD", "");
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static Connection getConnection() {
    Connection con = null;
   loadProperty();
    try {
      Class.forName(dbClassName).newInstance();
      con = DriverManager.getConnection(dbUrl, dbUsr, dbPwd);
    }
    catch (Exception ee) {
      ee.printStackTrace();
    }
   if (con == null) {
      System.err.println(
          "警告: DbConnectionManager.getConnection() 获得数据库链接失败.\r\n\r\n链接类型:" +
          dbClassName + "\r\n链接位置:" + dbUrl + "\r\n用户/密码" + dbUsr + "/" + dbPwd);
    }
    return con;

  }
/*
  public static void main(String[] args) {
    Connection conn = getConnection();
    System.out.println(conn.toString());
    try {


      conn.close();
      conn = null;
    }
    catch (Exception e) {
    }
  }
      */
 }