SQLServer数据库连接（一）

属性文件db.properties

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433;DatabaseName=addressBook
username=sa
password=accp

 

读取属性文件

public class ReadProperties extends Properties {

 // 静态的私有的静态变量
 private static ReadProperties readPro = null;

 // 私有构造函数
 private ReadProperties() {
  try {
   InputStream is = getClass().getResourceAsStream("/db.properties");
   load(is);
  } catch (IOException e) {
   e.printStackTrace();
  }
 }

 // 获取本类实例的方法(同步锁,只能创建一个实例)
 public static  ReadProperties getInstance() {
  if (readPro == null) {
   readPro=new ReadProperties();
   
  }
  return readPro;
 }
}

Servlet控制器

public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  try {
   // 获取数据完整路径
   String path = request.getServletPath();
   // 截取完整路径
   path = path.substring(1, path.indexOf("."));
   // 得到数据类型(类)
   String straction = pro.getProperty(path);
   // 加载数据(类)
   Class classaction = Class.forName(straction);
   // 实例化(类)对象
   IAction action = (IAction) classaction.newInstance();
   // 获取目的地
   String dest = action.execute(request, response);
   // 进行转发
   request.getRequestDispatcher(dest).forward(request, response);
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (InstantiationException e) {
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   e.printStackTrace();
  }
 }

@Override
 public void init(ServletConfig config) throws ServletException {
  InputStream is = this.getClass().getResourceAsStream(
    config.getInitParameter("pro"));
  try {
   pro.load(is);
  } catch (IOException e) {
   e.printStackTrace();
  }
 }