conndbpara.java

来自「中国移动 provision MISC1.6 接口」· Java 代码 · 共 82 行

package cmd.db;

import java.sql.*;
import java.util.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class ConnDBPara
{

  public String sDBDriver =null;//."com.microsoft.jdbc.sqlserver.SQLServerDriver";
  public String sConnStr = null; //"jdbc:microsoft:sqlserver://202.105.55.168:1433";
  public String sUserName=null;
  public String sPassword=null;
  public String sMOServerPost=null;

  public String sDBDriverOther =null;//."com.microsoft.jdbc.sqlserver.SQLServerDriver";
  public String sConnStrOther = null; //"jdbc:microsoft:sqlserver://202.105.55.168:1433";
  public String sUserNameOther=null;
  public String sPasswordOther=null;


  public ConnDBPara(String sDBNo) throws Exception
  {
    if(sUserName==null)
     {
       ParseXML parsexml = new ParseXML();
       Properties prop = new Properties();

       //请注意配置文件的路径
       parsexml.parse(SysConfig.getConfigFile());
       prop = parsexml.getProps();
       sUserName=prop.get("DBUserName").toString();
       sPassword=prop.get("DBPassword").toString();
       sDBDriver=prop.get("DBDriver").toString();
       sConnStr=prop.get("DBConnStr").toString();
       sUserNameOther=prop.get("sDBUserName").toString();
       sPasswordOther=prop.get("sDBPassword").toString();
       sDBDriverOther=prop.get("sDBDriver").toString();
       sConnStrOther=prop.get("sDBConnStr").toString();
       sMOServerPost=prop.get("sMOServerPost").toString();

       prop=null;
       parsexml=null;
       //sConnStr+=";"+sDBName;
     }
  }

  public ConnDBPara(String sConfigFile,String sDBNo) throws Exception
 {

      ParseXML parsexml = new ParseXML();
      Properties prop = new Properties();

      //请注意配置文件的路径
      parsexml.parse(sConfigFile);
      prop = parsexml.getProps();
      sUserName=prop.get("DBUserName"+sDBNo).toString();
      sPassword=prop.get("DBPassword"+sDBNo).toString();
      sDBDriver=prop.get("DBDriver"+sDBNo).toString();
      sConnStr=prop.get("DBConnStr"+sDBNo).toString();

      sUserNameOther=prop.get("sDBUserName"+sDBNo).toString();
      sPasswordOther=prop.get("sDBPassword"+sDBNo).toString();
      sDBDriverOther=prop.get("sDBDriver"+sDBNo).toString();
      sConnStrOther=prop.get("sDBConnStr"+sDBNo).toString();

      prop=null;
      parsexml=null;
      //sConnStr+=";"+sDBName;

  }

}