Methods

• getTicketByUser 根据用户名密码验证并返回 ticket(待用户信息)
• getUserInfoByTicket 根据 ticket 获取用户信息
• getRecode 根据 code 重新获取新 code
• getReToken 根据 ticket 重新获取 ticket

// 
export function getExcelStream() {
  let data = [
    {
      name: '工作薄1',
      table: 'select1',
      comPlexHeader: false,
      headers: [
        {
          text: '日志标题'
        },
        {
          text: '日志信息'
        }
      ],
      columns: [
        {
          name: 'logtitle'
        },
        {
          name: 'log_info'
        }
      ]
    }
  ]
  let url = '/ptService/syslog/uselog?useridex=&user_name=&user_ip=&logtypes=0&rq=2024-12-01%2C2024-12-24&begintime=2024-12-01&endtime=2024-12-24&sysid='

  getExcel(url, data, '测试.xls')
}

connStr: "6645398ECB79540DC05BC975463A51698CE52A08E4197628EB338C5185F7F578A4DF0689D20CCFCDC809FECEC563F9C7F2F633915A5154D960F746A4074A339FFE59EE683636FF13A3103D62247BD31C9948ABE83B665FBA9ECC5E44E8899886FCD8BDDB4A359812BF3A4E1F7DEE590985C5847A8FF97A1E505DF3914ABA91EFAB9B5265BD98A5058077E317CF2C5313E5518C5684851A8E925AC5BD0181BB87026D836B5609003F580CB0065278A72BB84E80EB45E18453D04CA2B33940EAD91FFA74F6B48C76C9284EC1F7F61821449D4DC98B9A073F8657C00C83A843DD83550382D34C9950DA1E473C1278D6DB648243CE1994DFB5F612457F6E8357CFED249E8D80D95E4ABFCC8E1B47828965CA4F68339A9E43017722FD28B8B539F48E3F0F2F91D3989E0AC9497D4A005F25A069A209DF704C9BE0D04156D2016A60C0"
dbType: "Oracle"
sqls: ['select * from SYS_TEMPLATE_MODULE']
allParam: {
    "MODULETYPE": "",
    "CATEGORYID": "",
    "FOLDERICON": null,
    "MODULENAME": "",
    "TEMPLATEID": null
}
header: {}
datas: [
    {
        "name": "流程中心",
        "table": "table1",
        "comPlexHeader": true,
        "headers": [
            {
                "text": "模板id",
                "items": []
            },
            {
                "text": "模块",
                "items": [
                    {
                        "text": "模块类型（0：文件夹；1：模块）",
                        "items": []
                    },
                    {
                        "text": "模块名称",
                        "items": []
                    },
                    {
                        "text": "文件夹 图标",
                        "items": []
                    },
                    {
                        "text": "父id",
                        "items": []
                    },
                    {
                        "text": "模块ID",
                        "items": []
                    }
                ]
            },
            {
                "text": "顺序",
                "items": []
            }
        ],
        "columns": [
            {
                "name": "templateid",
                "width": 80
            },
            {
                "name": "moduletype",
                "width": 80
            },
            {
                "name": "modulename",
                "width": 100
            },
            {
                "name": "foldericon",
                "width": 80
            },
            {
                "name": "categoryid",
                "width": 100
            },
            {
                "name": "moduleid",
                "width": 100
            },
            {
                "name": "order_id",
                "width": 80
            }
        ],
        "lockRow": 0,
        "lockColumn": 0
    }
]
fileName: "导出文件.xls"
方法调用
exportDataBaseTable(connStr, dbType, sqls, allParam, header, datas, fileName)
方法
export const exportDataBaseTable = (connStr, dbType, sqls = [], param = {}, header = {}, datas = [], fileName = '导出文件.xls') => {
  let newurl = window.$bd.sjfwUrl
  var r_data = new rabbit.Transit(newurl)
  r_data.connStr = connStr
  r_data.dbType = dbType
  var sqls = sqls 
  var param = param
  var header = header;
  var datas = datas
  var fileName = fileName 
  return new Promise((resolve, reject) => {
    r_data.export(sqls, header, param, datas, fileName,
      function (res) {
        if (res.succeed) {
          resolve(res)
        } else {
          // showError(res)
          reject(res)
        }
      },
      function (res) {
        alert(res)
      }
    )
  })
}

let dbConfig = {
    dbname: "orcl",
    dbport: "11521",
    dbpwd: "",//数据库密码
    dbserver: "123.129.65.205",
    dbtype: "Oracle",
    dbuser: "", // 数据库用户名
}
调用方法（不推荐），推荐获取数据库dbid调用平台接口方式获取数据库连接信息
getConInfo(dbconfig)