/**
  * @param loginStub LoginStub
  * @return AccountStub
  * @throws Exception
  */
 protected static AccountStub getAccountStub(JParamObject loginStub) throws Exception {
   java.util.List accountSetList =
       (List) ConfigManager.getDefault().getCfgData("AccountSet", null);
   if (accountSetList == null || accountSetList.size() == 0) return null;
   AccountStub accountStub = null;
   for (int i = 0; i < accountSetList.size(); i++) {
     accountStub = (AccountStub) accountSetList.get(i);
     if (accountStub.getDataStorageId().equals(loginStub.GetValueByEnvName("DataBaseName", null))
         && accountStub.getAccountId().equals(loginStub.GetValueByEnvName("DBNO", null))) {
       return accountStub;
     }
   }
   return null;
 }
 boolean lookDataSource(JConnection jconn, JParamObject PO) throws Exception {
   boolean hasDataSource = false;
   if (jconn != null) {
     String dataSource = PO.GetValueByEnvName("DataSource");
     if (dataSource != null && !"".equals(dataSource)) {
       DataSource ds = null;
       //        try {
       //          ds = (DataSource) jconn.getDBContext().lookup("jdbc/" +
       //              dataSource);
       //        }
       //        catch (Exception e) {
       //          Context context = new InitialContext();
       //          Context envContext = (Context) context.lookup(
       //              "java:/comp/env");
       //          ds = (DataSource) envContext.lookup("jdbc/" + dataSource);
       //
       //        }
       if (ds != null) {
         jconn.getInstance(ds.getConnection());
         hasDataSource = true;
       }
     }
   }
   return hasDataSource;
 }
 /**
  * @param paramObject JParamObject
  * @return JConnection
  * @throws Exception
  */
 public JConnection getConnection(
     JParamObject paramObject, Object Data, Object CustomObject, Object AdditiveObject)
     throws Exception {
   JConnection conn = null;
   AccountStub accountStub = getAccountStub(paramObject);
   if (accountStub == null) return null;
   // 设置dbOwner
   paramObject.SetValueByEnvName("dbOwner", accountStub.getUserId());
   DataStorageStub dataStorageStub = getDataStorageStub(accountStub);
   if (dataStorageStub == null) return null;
   JDataSourceStub dataSourceStub = (JDataSourceStub) getDataSourceStub(dataStorageStub);
   conn = createConnection(dataSourceStub);
   return initConnection(conn, paramObject, dataSourceStub, accountStub, dataStorageStub);
 }
 /**
  * @param ParamObject Object
  * @param DataObject Object
  * @param CustomObject Object
  * @param AdditiveObject Object
  * @return Object
  * @throws Exception
  */
 public Object CheckDBDataSource(
     Object ParamObject, Object DataObject, Object CustomObject, Object AdditiveObject)
     throws Exception {
   JParamObject PO;
   String DBType;
   JDataSourceStub DSS;
   JConnection jconn = null;
   boolean hasDataSource = false;
   PO = (JParamObject) ParamObject;
   DBType = PO.GetValueByEnvName("DataBaseType");
   for (int i = 0; i < DBList.size(); i++) {
     DSS = (JDataSourceStub) DBList.get(i);
     if (DSS.DataBaseType.toLowerCase().equals(DBType.toLowerCase()) == true) {
       if (DSS.DBClass == null) {
         DSS.DBClass = Class.forName(DSS.classname);
       }
       if (DSS.NAClass == null) {
         DSS.NAClass = Class.forName(DSS.dbclass);
       }
       if (DSS.NAClass != null) {
         jconn = (JConnection) DSS.NAClass.newInstance();
         try {
           hasDataSource = lookDataSource(jconn, PO);
         } catch (Exception e) {
           e.printStackTrace();
         }
         if (hasDataSource) break;
       }
     }
   }
   if (!hasDataSource) {
     throw new Exception("ϵͳû���ṩ" + DBType + "������ݿ�������!");
   }
   if (hasDataSource) return jconn;
   return null;
 }
 /**
  * @param conn JConnection
  * @param PO JParamObject
  * @param DSS JDataSourceStub
  * @param custObj Object
  * @return JConnection
  * @throws Exception
  */
 protected static JConnection initConnection(
     JConnection conn,
     JParamObject PO,
     JDataSourceStub dataSourceStub,
     AccountStub accountStub,
     DataStorageStub dataStorageStub)
     throws Exception {
   if (conn.InitConnection(PO, dataSourceStub, accountStub, dataStorageStub) == null) return null;
   //    if (PO.isAutoConnection()) {
   //      PO.addConn(conn);
   //    }
   // 写入日志
   writeLoginfo(conn, PO);
   // add by fsz
   List sqlList = (List) PO.getValue("$$SQL_VIEWLIST", null);
   if (sqlList != null) {
     //      conn.setSqlLogList(sqlList);
   }
   return conn;
 }