# spring-boot-starter-finereport

**Repository Path**: devlop/spring-boot-starter-finereport

## Basic Information

- **Project Name**: spring-boot-starter-finereport
- **Description**: 帆软报表项目
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 2
- **Created**: 2020-07-29
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

报表访问地址
----------
[http://localhost:8080/WebReport/ReportServer?op=fs](http://localhost:8080/WebReport/ReportServer?op=fs "报表访问地址") 

报表服务超级管理员账户
--------------------
| USERNAME | PASSWORD |
| :------: | :------: |
|sysadmin|jqkj5350880|


#### 1.帆软授权代理（VM options）

    -javaagent:./lib/JCrack-1.2.8-RELEASE.jar=fr9

    ${TOMCAT_HOME}: Tomcat 目录
    ${FILE_PATH}: 授权代理文件绝对或相路径目录
    
    ${TOMCAT_HOME}\bin 目录 catalina.* 文件有效命令第一行前追加有效命令
①. catalina.bat

        SET TITLE=WebReport
        SET CATALINA_HOME=D:\home\apache-tomcat-8.5.32-report
        SET JAVA_OPTS=-javaagent:${FILE_PATH}\JCrack-1.2.8-RELEASE.jar=fr9

②. catalina.sh

        TITLE="WebReport"
        CATALINA_HOME="D:\home\apache-tomcat-8.5.32-report"
        JAVA_OPTS="-javaagent:${FILE_PATH}/JCrack-1.2.8-RELEASE.jar=fr9"
        
#### 2.Tomcat 服务器映射配置
    
在${TOMCAT_HOME}\conf\Catalina\localhost\下新建文件WebReport.xml（文件名WebReport是指对应于BS访问时的报表应用名），内容如下：
    
    <Context path="/WebReport" docBase="D:\home\data\app\report" debug="0" reloadable="true"/> 
    <Context path="/WebReport" docBase="/home/data/app/report" debug="0" reloadable="true"></Context>     
    
#### 3. FR 报表相关查询

    -- MySQL
    SELECT * FROM FR_FOLDERENTRY f WHERE f.name = 'Demo';
    SELECT * FROM FR_REPORTLETENTRY r WHERE r.parent = '1';
    
    -- Oracle 帆软生成数据库好坑啊，小写的太多，查询使用时需要加双引号，否则会报错
    SELECT * FROM FR_FOLDERENTRY f WHERE f."name" = '测试';
    SELECT * FROM FR_REPORTLETENTRY r WHERE r."parent" = '1';
    
#### 4. 数据库迁移 Oracle 建库语句

①. 查看表空间的名称、数据文件路径及大小

    select t.tablespace_name
          ,d.file_name
          ,round(sum(bytes / (1024 * 1024)), 0) ts_size
    from dba_tablespaces t, dba_data_files d
    where t.tablespace_name = d.tablespace_name
    group by t.tablespace_name, d.file_name;
    select * from dba_data_files;
    
②. 创建帆软报表数据表空间
其中'FR_REPORT'是自定义的数据表空间名称，'D:\HOME\ORACLE\ORADATA\FR_REPORT_DATA.DBF'是数据文件的存放位置,

    create tablespace FR_REPORT 
    logging datafile 'D:\HOME\ORACLE\ORADATA\FR_REPORT_DATA.DBF' 
    size 32m autoextend on next 32m maxsize unlimited extent management local;

③. 为'FR_REPORT'的表空间创建用户

    create user FR_REPORT identified by report_jqkj_123 account unlock default tablespace FR_REPORT;
    select * from dba_users u where u.username = upper('fr_report');

④. 用户赋权

    grant connect, resource to fr_report;
    grant create any sequence to fr_report;
    grant create any table to fr_report;
    grant delete any table to fr_report;
    grant insert any table to fr_report;
    grant select any table to fr_report;
    grant unlimited tablespace to fr_report;
    grant execute any procedure to fr_report;
    grant update any table to fr_report;
    grant create any view to fr_report;
    grant create any trigger to fr_report;

    -- 查看用户权限
    select privilege
    from dba_sys_privs
    where grantee = upper('fr_report');
    
    select * from dba_role_privs r order by r.grantee;
    
⑤.其他

    -- 修改用户名
    select * from user$ u where u.name = upper('report');
    update user$ set name = upper('fr_report') where user# = 95;
    commit;
    
    -- 强制刷新
    alter system checkpoint;
    alter system flush shared_pool;
    
    -- 再修改用户名对应的密码（否则无法登录）
    alter user fr_report identified by report_jqkj_369;
    
⑥. 启用数据迁移
    
    -- 在 PlatformConnection 标签下追加内容如下
    
    <PlatformConnection>
    <DatabaseAttr/>
    <JDBCDatabaseAttr url="jdbc:oracle:thin:@192.168.44.246:1521:gdws" driver="oracle.jdbc.driver.OracleDriver" user="fr_report" password="___0061002b007a0060001600a10074007d0062002500600050005700e30012" encryptPassword="true">
    <DBCPAttr maxActive="300"/>
    </JDBCDatabaseAttr>
    </PlatformConnection>

⑦. 其他用户使用帆软数据的权限

    -- 帆软自带数据表的查询权限赋给指定用户
    select 'GRANT SELECT ON ' || tablespace_name || '."' || table_name ||
           '" TO &TO_USER;' as grant_sql
    from user_tables t
    where t.tablespace_name = 'FR_REPORT';
    
    -- 回收查询权限
    select 'REVOKE SELECT ON ' || tablespace_name || '."' || table_name ||
           '" FROM &TO_USER;' as revoke_sql
    from user_tables t
    where t.tablespace_name = 'FR_REPORT';