分类 中间件软件 下的文章

视频信息如何作为物联网管理的一部分,一直是我们公司比较关注的一项内容,哪些内容应该被纳入物联网管理范畴?通过这篇文章,我们一起来探讨一下。

准备工作

  • 视频直播设备,比如:IPC 网络摄像机,或者可以模拟推流的ffmpeg,IPC 拍摄视频,自定义码流(比如500kbit/s),自定义分辨率(1080P),标准协议(RTMP);
  • Wi-Fi 或 有线网络是比较容易的选择,有4G当然更加灵活,这个根据具体需求来确定选择哪类传输方式;
  • 流媒体服务器,比如:YiMEDIA,可以实现流媒体服务支持,推流/拉流,状态查询;
  • 物联网插件,具备从流媒体服务器获取IPC信息,流信息,并且与物联网服务器交互,比如:YiCONNECT;

过程剖析

IPC 端

  • 首先,必须是 IPC,这样才能通过网络推流;
  • 其次,具备 RTMP 推流协议,如果只是支持 RTSP,需要一个转换器把 RTSP流 转换成 RTMP流 推送出去;
  • 再次,编码类型H264,分辨率看摄像头,一般都可以1080P,码流至少要达到 500kbps 以上,否则不一定能推流成功,且视频不清晰;
  • 再一次,如果需要音频上传,需要用 aac 编码;
  • 最后,成功推流。如果不行,建议咨询 IPC 厂家。

YiMEDIA 端

流媒体服务器,这里以我司 YiMEDIA 为基础,简单介绍一些。

  • 流媒体服务器开启 RTMP 通道,一般是 TCP 1935 端口号;
  • 开启推流验证,如果验证不通过,就断开推流客户端的连接,可以用随机数的方式,YiMEDIA 才有回调应用服务器确认连接安全性;
  • 推流/拉流 URL 建议采用: rtmp://[IPADDRESS]/[IPC]/[auth_key],或 rtmp://[IPADDRESS]/[IPC]/[MAIN/SUB]?key=[auth_key] ;
  • YiMEDIA 开启 NVR/DVR 功能,记录所有的视频信息;

YiCONNECT 端

为了将视频流数据状态和信息发送到 YiCONNECT,需要开发一个插件,获取 流信息 后,以 Thingsboard 能接收的方式发送。

  • 编写 Thingsboard gateway 应用程序,以便支持 视频流 信息的转发和解析;
开启 rest.json 服务
编写 YiMEDIA 丢过来的回调请求回应信息
  • 解析 [IPC] 和 [auth_key] 字段,并验证 auth_key 是否满足要求;
  • YiCONNECT 端新建 Gateway 网关设备,保持验证码一致;

结果预览

YiMEDIA 状态查看

  • 客户端状态
    clients.png
  • 流状态
    streams.png

YiCONNECT

  • 设备列表表
    devices.png
  • 视频流列表
    videos.png

图像预览

可以通过 VLC 播放器播放:

    1. rtmp 流: rtmp://ipaddress/ON400H16DM0FZ20210308002/high,基本处于实时播放,1-3秒
    2. flv 格式: http://ipaddress/ON400H16DM0FZ20210308002/high.flv,准实时播放,3-5秒
    3. m3u8 格式:http://ipaddress/ON400H16DM0FZ20210308002/high.m3u8,延时比较大,几秒到几十秒
    • 4G 摄像头抓图
      4g.png
    • 半夜红外线开启抓图
      midnight.jpg

    方案详解

    YiCAMERA-solution.png

    前期,发表过多个系列文章关于如何无缝扩展 ThingsBoard 功能,其实在实施过程中,还是遇到很多问题,需要提前注意!

    独立于 ThingsBoard 外的功能模块注意要点

    • 功能模块需要能够独立运行,不管是服务也好,controller 也罢,都要能够正常运行,就类似单元测试跑通,才可以融入到 ThingsBoard 中;
    • 数据表要独立成 sql 文件,便于移植到 ThingsBoard 库中,最好不要跟原有数据表有关联或冲突,尤其不能冲突;

      • 调用系统库表,新建的 Entity 要注意 column 名字于原有一样,使用 @Column(name = "foo_bar"),否则 Bean 建立失败;
      • 如果 Entity 有嵌套调用 POJO,需要将 Entity 设置成 @Proxy(lazy = false),关闭懒加载,否则无法查询数据;
    • 打包功能模块,需要将 Spring Boot 项目 target 中的 .original 文件安装到本地 maven 库,或者修改 pom.xml 文件来改变 maven 打包规则;
    • 功能模块中的附件,图片,pdf 模板,直接在功能模块 jar 包中,不需要单独导入 ThingsBoard 中;
    • Controller 要单独命名,不能与 ThingsBoard 冲突,API 路径可以复用原有路径,比如:原有是 /api/report/foo,可以增加新的 /api/report/bar;
    • Domain/POJO/Repository等,要独立命名,因为我们以 maven jar 包方式融入 ThingsBoard,都交给 spring 来管理,所以命名要独立;

    众所周知,Kubernetes(k8s)太火了,太牛了,咱们把部署在 ThingsBoard 上更是理所当然。一句话总结:步骤很简单,过程很艰辛!

    准备 Docker 和 Kubernetes 环境

    安装 Docker Desktop CE 版本

    • 笔者使用的老版本 MacBook Pro 13,下载安装 Docker Desktop CE 版本,这个比较简单,官方下载,安装即可完成,启动。
      docker.png
    • 启用 Docker Desktop 中 Kubernetes
      kubernetes-in-docker.png

    哇塞,是不是太简单了?当然不会那么容易搞定,你会一直出现 “Starting” 的状态,别傻等,要去 Google 一下。关键字:如何成功启动 Docker 自带的 Kubernetes? 总之,你一定要找到办法解决你的 Kubernetes 成功启动。

    安装 Kubenetes 本地版本

    • 安装 Kubernetes,就是简单,本地安装搞定
    # brew install kubernetes-cli
    
    # kubectl version --client
    Client Version: version.Info{Major:"1", Minor:"19", GitVersion:"v1.19.4", GitCommit:"d360454c9bcd1634cf4cc52d1867af5491dc9c5f", GitTreeState:"clean", BuildDate:"2020-11-12T01:09:16Z", GoVersion:"go1.15.4", Compiler:"gc", Platform:"darwin/amd64"}
    • 为了让 Docker Desktop 启动 k8s,需下载相关的 docker images,需要通过一个脚本 docker-images-k8s.sh,然后运行,从 aliyun 下载 docker image 比较快。
    #!/bin/bash
    
    set -e
    KUBE_VERSION=v1.19.3
    KUBE_PAUSE_VERSION=3.2
    ETCD_VERSION=3.4.13-0
    COREDNS_VERSION=1.7.0
    GCR_URL=k8s.gcr.io
    ALIYUN_URL=registry.cn-hangzhou.aliyuncs.com/google_containers
    
    # get images
    images=(kube-proxy:${KUBE_VERSION}
        kube-scheduler:${KUBE_VERSION}
        kube-controller-manager:${KUBE_VERSION}
        kube-apiserver:${KUBE_VERSION}
        pause:${KUBE_PAUSE_VERSION}
        etcd:${ETCD_VERSION}
        coredns:${COREDNS_VERSION})
    
    for imageName in ${images[@]} ; do
        docker pull $ALIYUN_URL/$imageName
        docker tag $ALIYUN_URL/$imageName $GCR_URL/$imageName
        docker rmi $ALIYUN_URL/$imageName
    done
    
    # show images
    docker images
    
    • 为了查看 k8s 运行状态,web 管理工具 kubernetes dashboard 自然少不了,新建 docker-images-dashboard.sh,运行
    #!/bin/bash
    
    set -e
    KUBE_DASHBOARD_VERSION=v2.0.3
    METRICS_SCRAPER=v1.0.4
    KUBENETESUI_URL=kubernetesui
    ALIYUN_KUBENETESUI_URL=registry.cn-hangzhou.aliyuncs.com/kubernetes_ns
    
    # get images (ui)
    imagesui=(dashboard:${KUBE_DASHBOARD_VERSION}
        metrics-scraper:${METRICS_SCRAPER})
    
    for imageName in ${imagesui[@]} ; do
        docker pull $ALIYUN_KUBENETESUI_URL/$imageName
        docker tag $ALIYUN_KUBENETESUI_URL/$imageName $KUBENETESUI_URL/$imageName
        docker rmi $ALIYUN_KUBENETESUI_URL/$imageName
    done
    
    # show images
    docker images
    
    • 再去看 Docker Desktop 中已经启动 k8s了,耐心一点,这个时间比较长,验证一下,发现 Server Version 出现了证明服务器安装成功,且客户端可以连接上
    # kubectl version
    Client Version: version.Info{Major:"1", Minor:"19", GitVersion:"v1.19.4", GitCommit:"d360454c9bcd1634cf4cc52d1867af5491dc9c5f", GitTreeState:"clean", BuildDate:"2020-11-12T01:09:16Z", GoVersion:"go1.15.4", Compiler:"gc", Platform:"darwin/amd64"}
    Server Version: version.Info{Major:"1", Minor:"19", GitVersion:"v1.19.3", GitCommit:"1e11e4a2108024935ecfcb2912226cedeafd99df", GitTreeState:"clean", BuildDate:"2020-10-14T12:41:49Z", GoVersion:"go1.15.2", Compiler:"gc", Platform:"linux/amd64"}
    # kubectl apply -f k8s-dashboard.yaml
    
    namespace/kubernetes-dashboard created
    serviceaccount/kubernetes-dashboard created
    service/kubernetes-dashboard created
    secret/kubernetes-dashboard-certs created
    secret/kubernetes-dashboard-csrf created
    secret/kubernetes-dashboard-key-holder created
    configmap/kubernetes-dashboard-settings created
    role.rbac.authorization.k8s.io/kubernetes-dashboard created
    clusterrole.rbac.authorization.k8s.io/kubernetes-dashboard created
    rolebinding.rbac.authorization.k8s.io/kubernetes-dashboard created
    clusterrolebinding.rbac.authorization.k8s.io/kubernetes-dashboard created
    deployment.apps/kubernetes-dashboard created
    service/dashboard-metrics-scraper created
    deployment.apps/dashboard-metrics-scraper created
    
    # kubectl proxy                    
    Starting to serve on 127.0.0.1:8001
    • 启动成功后,打开浏览器,就可以登陆 Dashboard
      要么证书登陆,要么 token 登陆,先执行:
    TOKEN=$(kubectl -n kube-system describe secret default| awk '$1=="token:"{print $2}')
    kubectl config set-credentials docker-desktop --token="${TOKEN}"
    echo $TOKEN

    显示的内容就是 token

    1. 证书登陆时,选择 ~/.kube/config
    2. token 登陆就是上面那串
      k8s-dashbaord.png

    登陆成功后
    k8s-dashbaord-home.png

    安装 ThingsBoard 到 k8s

    安装 ThingsBoard

    根据官方文档,照着执行就好:https://github.com/thingsboard/thingsboard/tree/master/k8s

    • 保证网络畅通,因为需要从 docker hub 下载 images,建议用国内的镜像地址
    • 过程比较麻烦,不好监控,只能不停的刷 docker images 命令查看是不是把镜像拉下来了
    REPOSITORY                            TAG                                              IMAGE ID            CREATED             SIZE
    zookeeper                             3.5                                              ce6733a90146        3 days ago          245MB
    postgres                              12                                               386fd8c60839        3 days ago          314MB
    k8s.gcr.io/ingress-nginx/controller   <none>                                           81d7cdfa4169        9 days ago          280MB
    jettech/kube-webhook-certgen          v1.5.0                                           344297e197b6        3 weeks ago         44.7MB
    docker/desktop-kubernetes             kubernetes-v1.19.3-cni-v0.8.5-critools-v1.17.0   7f85afe431d8        5 weeks ago         285MB
    k8s.gcr.io/kube-proxy                 v1.19.3                                          cdef7632a242        5 weeks ago         118MB
    k8s.gcr.io/kube-apiserver             v1.19.3                                          a301be0cd44b        5 weeks ago         119MB
    k8s.gcr.io/kube-scheduler             v1.19.3                                          aaefbfa906bd        5 weeks ago         45.7MB
    k8s.gcr.io/kube-controller-manager    v1.19.3                                          9b60aca1d818        5 weeks ago         111MB
    thingsboard/tb-coap-transport         latest                                           5635dd5c4fe6        2 months ago        865MB
    thingsboard/tb-http-transport         latest                                           7f60b6a3bd83        2 months ago        864MB
    thingsboard/tb-mqtt-transport         latest                                           8dfe9a5bc20d        2 months ago        864MB
    thingsboard/tb-node                   latest                                           a66803235c46        2 months ago        1.09GB
    thingsboard/tb-web-ui                 latest                                           e215f4aa841a        2 months ago        426MB
    thingsboard/tb-js-executor            latest                                           7c4fdfa00e27        2 months ago        494MB
    k8s.gcr.io/etcd                       3.4.13-0                                         0369cf4303ff        2 months ago        253MB
    kubernetesui/dashboard                v2.0.3                                           503bc4b7440b        5 months ago        225MB
    k8s.gcr.io/coredns                    1.7.0                                            bfe3a36ebd25        5 months ago        45.2MB
    redis                                 4.0                                              191c4017dcdd        7 months ago        89.3MB
    kubernetesui/metrics-scraper          v1.0.4                                           86262685d9ab        8 months ago        36.9MB
    docker/desktop-storage-provisioner    v1.1                                             e704287ce753        8 months ago        41.8MB
    docker/desktop-vpnkit-controller      v1.0                                             79da37e5a3aa        8 months ago        36.6MB
    k8s.gcr.io/pause                      3.2                                              80d28bedfe5d        9 months ago        683kB
    wurstmeister/kafka                    2.12-2.2.1                                       86a9c7e5fd97        11 months ago       422MB
    • 过了很长一段时间,有可能几个小时后,你查看 docker ps
    CONTAINER ID        IMAGE                           COMMAND                  CREATED             STATUS              PORTS               NAMES
    a9d8b9a28efc        e704287ce753                    "/storage-provisione…"   6 minutes ago       Up 6 minutes                            k8s_storage-provisioner_storage-provisioner_kube-system_50005a87-62d2-45a0-a39e-c34af43d24c9_3
    83e1a62bb612        aaefbfa906bd                    "kube-scheduler --au…"   6 minutes ago       Up 6 minutes                            k8s_kube-scheduler_kube-scheduler-docker-desktop_kube-system_ee4c94eb845abf1878fb3c4c489b1365_7
    b4e4d52ae0bc        thingsboard/tb-node             "start-tb-node.sh"       7 hours ago         Up 7 hours                              k8s_server_tb-node-5b47bb8bd6-x8g8b_thingsboard_532519fd-7441-4a10-a0b3-3458bb9784a3_5
    462b9a657c4f        thingsboard/tb-node             "start-tb-node.sh"       7 hours ago         Up 7 hours                              k8s_server_tb-node-5b47bb8bd6-vqrvb_thingsboard_3f25d857-1624-4d27-90a5-2c54c35747ee_5
    4f3a74233acd        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-vvb9v_thingsboard_46063547-8f06-4e81-85b4-00cb4b2a5f42_7
    211329243cdd        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-l5gmw_thingsboard_29f294c1-5fd0-44a5-98a0-3880b6fe7126_7
    3a6f946e86be        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-h8zqk_thingsboard_82bc9e2b-5db7-409a-9be5-4e7c21f481b8_6
    28085da4bbae        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-ftwf8_thingsboard_0c3f60a2-fd08-4951-9d98-80d08bfa439c_6
    ed33cf23175c        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-h2vkl_thingsboard_990be16d-12d8-4f7d-8ce4-1ef4a83ac31b_7
    6b7fc0bd2fbb        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-pwc4z_thingsboard_28c0106c-9587-466f-90b3-b3af6eaed7ea_7
    520ed4711677        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-gvx2g_thingsboard_afeb8b5c-ab53-48ba-927f-2d20b5fc6c3b_6
    5baeda96c4a3        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-2z89t_thingsboard_d7ec851c-8648-465a-a855-0a23575e3c3b_6
    81f692bc2768        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-7rl82_thingsboard_08864e79-2af0-42b5-b592-4c1a2db1d5cd_6
    cb8bf860467a        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-ljwz8_thingsboard_92de7aab-fca3-4e0c-ac3e-02213603d359_7
    917ba1ee6732        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-c27qd_thingsboard_0c79ed1e-1d65-4d46-a7b1-08de77402549_6
    0ada7d6b48b9        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-k4ncf_thingsboard_cdd283fc-d0a2-45b6-b533-00dd4d38e782_7
    ffc91b31b24c        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-5p9tg_thingsboard_87e80c57-0f84-43eb-bf24-13cc309e4cec_7
    13b6d7dfb387        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-zvgrp_thingsboard_1fad5bb8-5793-48e7-8dcc-7cbaf0475192_6
    0f63ffec3cbb        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-fvvrx_thingsboard_88c65221-c5d3-419d-a155-21cfee3b7157_7
    29c432f70609        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-zvd2t_thingsboard_e0315452-8b8f-4c0a-9488-d56e296ec962_7
    58a2f29e2f6a        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-gpndh_thingsboard_99c29bd4-cb0f-4fb8-8061-ebdda21359de_7
    637a32ae8d4d        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-r2r5b_thingsboard_6ba2cc34-d6bb-4c14-96c8-0c11e20fd051_7
    0d49592908fd        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-j756s_thingsboard_0be1997a-4d1b-4d01-a3ab-55d6e468f39d_7
    5e342a30e5c6        thingsboard/tb-js-executor      "start-js-executor.sh"   7 hours ago         Up 7 hours                              k8s_server_tb-js-executor-56bbb8f446-9mmf2_thingsboard_97fc3fa7-ad20-4ffc-a34a-cda7aba93305_7
    044277041f7a        thingsboard/tb-mqtt-transport   "start-tb-mqtt-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-mqtt-transport-fb5f5d5cd-xkwcn_thingsboard_d91bc9c9-de41-4866-8fe1-03831af3a58c_3
    e7b427121ff2        thingsboard/tb-http-transport   "start-tb-http-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-http-transport-64f6f66bc7-zzvqb_thingsboard_520ed11c-239e-4083-919b-fec38277f233_3
    a2a4da430f0d        thingsboard/tb-http-transport   "start-tb-http-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-http-transport-64f6f66bc7-ztmng_thingsboard_0e628481-0398-4ddd-ad97-31c5987796f9_3
    2749cf276c80        wurstmeister/kafka              "start-kafka.sh"         7 hours ago         Up 7 hours                              k8s_server_tb-kafka-78957b6557-fc8js_thingsboard_2a3d3e60-0b40-45ba-91da-70f29f270a04_5
    f296ce350482        thingsboard/tb-mqtt-transport   "start-tb-mqtt-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-mqtt-transport-fb5f5d5cd-bs4tw_thingsboard_ef25b3b1-658e-4e4c-bd1c-a0ca2ab20ce4_3
    d7ebb30d2fc7        postgres                        "docker-entrypoint.s…"   7 hours ago         Up 7 hours                              k8s_postgres_postgres-5cf775766f-clf89_thingsboard_599ecf9f-068c-416e-ab73-95760f1099db_1
    2ad0a6662ca9        thingsboard/tb-coap-transport   "start-tb-coap-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-coap-transport-59cc8bd7bc-82zfk_thingsboard_73404a55-e170-4441-b733-5417db6461ad_1
    33c4da97f3d7        thingsboard/tb-coap-transport   "start-tb-coap-trans…"   7 hours ago         Up 7 hours                              k8s_server_tb-coap-transport-59cc8bd7bc-g8jdw_thingsboard_a48518d7-c929-4a1f-bcc8-c16fdf903fbf_1
    3f8d5b8e9d9f        thingsboard/tb-web-ui           "start-web-ui.sh"        7 hours ago         Up 7 hours                              k8s_server_tb-web-ui-5958f67cc-lg974_thingsboard_5de819ae-f832-4ab6-bdce-0f29daf037ff_1
    beb462957a30        redis                           "docker-entrypoint.s…"   7 hours ago         Up 7 hours                              k8s_server_tb-redis-7fb674db9-pzndj_thingsboard_6ff6ba21-933d-4366-89eb-3d815f5282c9_1
    e24d2ea2e00a        thingsboard/tb-web-ui           "start-web-ui.sh"        7 hours ago         Up 7 hours                              k8s_server_tb-web-ui-5958f67cc-4k4cj_thingsboard_6f3795e9-ded9-46b8-8067-b4afd63f2571_1
    c2161ce93009        zookeeper                       "/docker-entrypoint.…"   7 hours ago         Up 7 hours                              k8s_server_zookeeper-547c6ffb99-bq42m_thingsboard_11a1e06d-bbf1-4b55-bab5-7d4e4b876f20_1
    4e02d9bde8ab        79da37e5a3aa                    "/kube-vpnkit-forwar…"   7 hours ago         Up 7 hours                              k8s_vpnkit-controller_vpnkit-controller_kube-system_6fa3177c-f779-414d-8acb-1342dd87849b_1
    30f7af7ffa00        kubernetesui/dashboard          "/dashboard --insecu…"   7 hours ago         Up 7 hours                              k8s_kubernetes-dashboard_kubernetes-dashboard-5dbf55bd9d-bcc2v_kubernetes-dashboard_1e414605-d8c1-4918-8e9b-18bc2c01efe6_1
    517bc1b7ac3e        81d7cdfa4169                    "/usr/bin/dumb-init …"   7 hours ago         Up 7 hours                              k8s_controller_ingress-nginx-controller-c4f944d4d-wcqxv_ingress-nginx_329aa6a7-2ee5-4747-b77d-82182d9a872f_1
    d674f87354ca        86262685d9ab                    "/metrics-sidecar"       7 hours ago         Up 7 hours                              k8s_dashboard-metrics-scraper_dashboard-metrics-scraper-7b59f7d4df-5dkwl_kubernetes-dashboard_3235eff1-3822-4138-8d0e-d45de95d3cbf_1
    faf05611eaa3        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-gvx2g_thingsboard_afeb8b5c-ab53-48ba-927f-2d20b5fc6c3b_1
    1a1956a65635        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-coap-transport-59cc8bd7bc-82zfk_thingsboard_73404a55-e170-4441-b733-5417db6461ad_1
    d5a382ca986e        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-pwc4z_thingsboard_28c0106c-9587-466f-90b3-b3af6eaed7ea_1
    c80049396050        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-kafka-78957b6557-fc8js_thingsboard_2a3d3e60-0b40-45ba-91da-70f29f270a04_1
    7b192ede32e5        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-coap-transport-59cc8bd7bc-g8jdw_thingsboard_a48518d7-c929-4a1f-bcc8-c16fdf903fbf_1
    c33e9576e5a9        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-http-transport-64f6f66bc7-zzvqb_thingsboard_520ed11c-239e-4083-919b-fec38277f233_1
    6e90c5e851b7        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-h2vkl_thingsboard_990be16d-12d8-4f7d-8ce4-1ef4a83ac31b_1
    e74011796607        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-ftwf8_thingsboard_0c3f60a2-fd08-4951-9d98-80d08bfa439c_1
    8e7b08eaf0e4        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-7rl82_thingsboard_08864e79-2af0-42b5-b592-4c1a2db1d5cd_1
    fd3c552a04ee        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-vvb9v_thingsboard_46063547-8f06-4e81-85b4-00cb4b2a5f42_1
    d3dc754a1f71        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-l5gmw_thingsboard_29f294c1-5fd0-44a5-98a0-3880b6fe7126_1
    372fd6514108        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-gpndh_thingsboard_99c29bd4-cb0f-4fb8-8061-ebdda21359de_1
    caf096a5bf42        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-node-5b47bb8bd6-x8g8b_thingsboard_532519fd-7441-4a10-a0b3-3458bb9784a3_1
    a80bbd2267ec        bfe3a36ebd25                    "/coredns -conf /etc…"   7 hours ago         Up 7 hours                              k8s_coredns_coredns-f9fd979d6-ff45j_kube-system_df1c5b8b-26f5-48cc-a853-c050090e69ef_1
    1f1b01587d81        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-redis-7fb674db9-pzndj_thingsboard_6ff6ba21-933d-4366-89eb-3d815f5282c9_1
    992b5afa6aa1        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-web-ui-5958f67cc-lg974_thingsboard_5de819ae-f832-4ab6-bdce-0f29daf037ff_1
    271ad2fced2b        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-fvvrx_thingsboard_88c65221-c5d3-419d-a155-21cfee3b7157_1
    344ddec06f1e        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-h8zqk_thingsboard_82bc9e2b-5db7-409a-9be5-4e7c21f481b8_1
    6ad3af03d452        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_vpnkit-controller_kube-system_6fa3177c-f779-414d-8acb-1342dd87849b_1
    413d3e3fef5f        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-http-transport-64f6f66bc7-ztmng_thingsboard_0e628481-0398-4ddd-ad97-31c5987796f9_1
    b42279032251        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-zvd2t_thingsboard_e0315452-8b8f-4c0a-9488-d56e296ec962_1
    472cd017176e        bfe3a36ebd25                    "/coredns -conf /etc…"   7 hours ago         Up 7 hours                              k8s_coredns_coredns-f9fd979d6-k54r2_kube-system_9355c0e5-b8fc-4c3c-9644-89749adeee97_1
    3e0fe843bcbe        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_postgres-5cf775766f-clf89_thingsboard_599ecf9f-068c-416e-ab73-95760f1099db_1
    e199dac37dec        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-mqtt-transport-fb5f5d5cd-xkwcn_thingsboard_d91bc9c9-de41-4866-8fe1-03831af3a58c_1
    e72505d9d064        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-ljwz8_thingsboard_92de7aab-fca3-4e0c-ac3e-02213603d359_1
    43362e2031d8        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-2z89t_thingsboard_d7ec851c-8648-465a-a855-0a23575e3c3b_1
    9c876bbc23be        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-c27qd_thingsboard_0c79ed1e-1d65-4d46-a7b1-08de77402549_1
    11b89fccd02d        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-node-5b47bb8bd6-vqrvb_thingsboard_3f25d857-1624-4d27-90a5-2c54c35747ee_1
    9a047136e01b        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-k4ncf_thingsboard_cdd283fc-d0a2-45b6-b533-00dd4d38e782_1
    c13f8513edf1        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-zvgrp_thingsboard_1fad5bb8-5793-48e7-8dcc-7cbaf0475192_1
    0fada7a20fe0        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-j756s_thingsboard_0be1997a-4d1b-4d01-a3ab-55d6e468f39d_1
    3e8bd573933b        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-5p9tg_thingsboard_87e80c57-0f84-43eb-bf24-13cc309e4cec_1
    936695bf38e1        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-web-ui-5958f67cc-4k4cj_thingsboard_6f3795e9-ded9-46b8-8067-b4afd63f2571_1
    15bc2206a101        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_ingress-nginx-controller-c4f944d4d-wcqxv_ingress-nginx_329aa6a7-2ee5-4747-b77d-82182d9a872f_1
    9fb9bcc3f42e        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-mqtt-transport-fb5f5d5cd-bs4tw_thingsboard_ef25b3b1-658e-4e4c-bd1c-a0ca2ab20ce4_1
    e5ff72d6497d        cdef7632a242                    "/usr/local/bin/kube…"   7 hours ago         Up 7 hours                              k8s_kube-proxy_kube-proxy-4fx4m_kube-system_61c86591-198c-4bcc-ac9a-756ba949c71c_1
    e8b88981ec37        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_zookeeper-547c6ffb99-bq42m_thingsboard_11a1e06d-bbf1-4b55-bab5-7d4e4b876f20_1
    2366f0c673fc        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-r2r5b_thingsboard_6ba2cc34-d6bb-4c14-96c8-0c11e20fd051_1
    dc3c77cd895b        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_tb-js-executor-56bbb8f446-9mmf2_thingsboard_97fc3fa7-ad20-4ffc-a34a-cda7aba93305_1
    7cef6c1b6fd8        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_coredns-f9fd979d6-ff45j_kube-system_df1c5b8b-26f5-48cc-a853-c050090e69ef_1
    7f3bf1c89eef        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_dashboard-metrics-scraper-7b59f7d4df-5dkwl_kubernetes-dashboard_3235eff1-3822-4138-8d0e-d45de95d3cbf_1
    cedd269cda38        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_coredns-f9fd979d6-k54r2_kube-system_9355c0e5-b8fc-4c3c-9644-89749adeee97_1
    1ff5b8974607        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_kubernetes-dashboard-5dbf55bd9d-bcc2v_kubernetes-dashboard_1e414605-d8c1-4918-8e9b-18bc2c01efe6_1
    38c2265588a8        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_storage-provisioner_kube-system_50005a87-62d2-45a0-a39e-c34af43d24c9_1
    47dfcf754624        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_kube-proxy-4fx4m_kube-system_61c86591-198c-4bcc-ac9a-756ba949c71c_1
    2410f48b0dcb        0369cf4303ff                    "etcd --advertise-cl…"   7 hours ago         Up 7 hours                              k8s_etcd_etcd-docker-desktop_kube-system_c7cc6a3c3118f127f5fd469ef69477e0_1
    8282e8feb792        a301be0cd44b                    "kube-apiserver --ad…"   7 hours ago         Up 7 hours                              k8s_kube-apiserver_kube-apiserver-docker-desktop_kube-system_2085f5be68201a12aeffb940f7ba4272_1
    a8d6bd3cc82a        9b60aca1d818                    "kube-controller-man…"   7 hours ago         Up 7 hours                              k8s_kube-controller-manager_kube-controller-manager-docker-desktop_kube-system_07d42b7bf3823b30f57219558fcb55e2_1
    acebbb6ddd18        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_kube-scheduler-docker-desktop_kube-system_ee4c94eb845abf1878fb3c4c489b1365_1
    d395721ce499        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_kube-controller-manager-docker-desktop_kube-system_07d42b7bf3823b30f57219558fcb55e2_1
    ff1cfd6ae1b2        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_kube-apiserver-docker-desktop_kube-system_2085f5be68201a12aeffb940f7ba4272_1
    2060020e4bc4        k8s.gcr.io/pause:3.2            "/pause"                 7 hours ago         Up 7 hours                              k8s_POD_etcd-docker-desktop_kube-system_c7cc6a3c3118f127f5fd469ef69477e0_1

    好多个 container 在跑,好壮观

    这时,你以为可以成功访问 ThingsBoard 主页吗?不行,真的不行,因为还差一个步骤,非常重要,那就是你的机器还没有 ingress ,建议你去好好读一读这个知识点。

    安装 Ingress Nginx

    # kubectl apply -f https://raw.githubusercontent.com/kubernetes/ingress-nginx/controller-v0.41.2/deploy/static/provider/cloud/deploy.yaml
    想办法把这个文件搞下来,因为这是部署 Ingress Nginx 的配置文件

    我提供一个备份: ingress-nginx.yaml,启动:

    # kubectl apply -f ingress-nginx.yaml
    namespace/ingress-nginx unchanged
    serviceaccount/ingress-nginx unchanged
    configmap/ingress-nginx-controller configured
    clusterrole.rbac.authorization.k8s.io/ingress-nginx unchanged
    clusterrolebinding.rbac.authorization.k8s.io/ingress-nginx unchanged
    role.rbac.authorization.k8s.io/ingress-nginx unchanged
    rolebinding.rbac.authorization.k8s.io/ingress-nginx unchanged
    service/ingress-nginx-controller-admission unchanged
    service/ingress-nginx-controller unchanged
    deployment.apps/ingress-nginx-controller configured
    validatingwebhookconfiguration.admissionregistration.k8s.io/ingress-nginx-admission configured
    serviceaccount/ingress-nginx-admission unchanged
    clusterrole.rbac.authorization.k8s.io/ingress-nginx-admission unchanged
    clusterrolebinding.rbac.authorization.k8s.io/ingress-nginx-admission unchanged
    role.rbac.authorization.k8s.io/ingress-nginx-admission unchanged
    rolebinding.rbac.authorization.k8s.io/ingress-nginx-admission unchanged
    job.batch/ingress-nginx-admission-create unchanged
    job.batch/ingress-nginx-admission-patch unchanged
    
    • 下载 ingress-nginx 镜像
    # docker pull k8s.gcr.io/ingress-nginx/controller:v0.41.2@sha256:1f4f402b9c14f3ae92b11ada1dfe9893a88f0faeb0b2f4b903e2c67a0c3bf0de

    因为系统提示,这个镜像无法下载,或这很慢,你需要手动执行。看看有没有成功:

    # kubectl get pods -n ingress-nginx -l app.kubernetes.io/name=ingress-nginx --watch
    
    NAME                                       READY   STATUS      RESTARTS   AGE
    ingress-nginx-admission-create-sd5zj       0/1     Completed   0          16m
    ingress-nginx-admission-patch-pfjhp        0/1     Completed   2          16m
    ingress-nginx-controller-c4f944d4d-wcqxv   0/1     Running     0          16m
    
    ingress-nginx-controller-c4f944d4d-wcqxv   1/1     Running     0          16m
    • 查看本地是否已经成功监听 80 和 443 端口,如果存在,那就是跑通了
    netstat -na  |grep LIST
    
    tcp46      0      0  *.1883                 *.*                    LISTEN     
    tcp46      0      0  *.443                  *.*                    LISTEN     
    tcp46      0      0  *.80                   *.*                    LISTEN     
    
    • 查看 k8s dashboard 状态
      tb-in-k8s.png
    • ThingsBoard 登陆界面,出现太重要了
      tg-login.png
    • 成功登陆,且新建租户正常
      tb-tenant.png

    最后,不建议在本地跑 k8s,速度太慢了,不如跑 jar 来的方便,调试起来也不方便。开发环境用 mvn spring-boot:run,测试环境直接部署在 CentOS 或 Ubuntu 环境单机跑足够用了,大量数据采集,访问用户数量大,才可以试试 k8s 环境,欢迎大家留言讨论!

    使用 Jaspersoft Studio 设计报表样式

    用你熟悉的环境设计一套最简单的模板,名称定义为: Reports.jrxml
    report_template.png
    下载源文件:report.jrxml

    • 语法比较特殊,需要努力学习
    <?xml version="1.0" encoding="UTF-8"?>
    <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="84feeac3-d1f7-4503-84bf-fc3fa153df55">
        <queryString>
            <![CDATA[]]>
        </queryString>
        <field name="id" class="java.lang.Long"/>
        <field name="price" class="java.math.BigDecimal"/>
        <field name="quantity" class="java.lang.Integer"/>
        <field name="categoryName" class="java.lang.String"/>
        <field name="name" class="java.lang.String"/>
        <background>
            <band splitType="Stretch"/>
        </background>
        <title>
            <band height="36" splitType="Stretch"/>
        </title>
        <pageHeader>
            <band height="49" splitType="Stretch">
                <staticText>
                    <reportElement x="170" y="10" width="230" height="30" uuid="04d35299-5eb0-4a34-b340-3ca5cf8290fc"/>
                    <textElement>
                        <font fontName="宋体" size="20"/>
                    </textElement>
                    <text><![CDATA[Product List | 产品列表]]></text>
                </staticText>
            </band>
        </pageHeader>
        <columnHeader>
            <band height="37" splitType="Stretch">
                <staticText>
                    <reportElement x="0" y="10" width="70" height="20" uuid="bcaf85c0-57ff-4a34-af27-cbf1330125ae"/>
                    <textElement>
                        <font fontName="宋体" isBold="true"/>
                    </textElement>
                    <text><![CDATA[ID]]></text>
                </staticText>
                <staticText>
                    <reportElement x="90" y="10" width="100" height="20" uuid="faf9b9ee-7cf2-4ea5-80b8-d371c3c753b9"/>
                    <textElement>
                        <font fontName="宋体" isBold="true"/>
                    </textElement>
                    <text><![CDATA[名称]]></text>
                </staticText>
                <staticText>
                    <reportElement x="210" y="10" width="70" height="20" uuid="93727672-9f69-4856-aa26-33837e8dc417"/>
                    <textElement>
                        <font fontName="宋体" isBold="true"/>
                    </textElement>
                    <text><![CDATA[价格]]></text>
                </staticText>
                <staticText>
                    <reportElement x="314" y="10" width="70" height="20" uuid="09b47abe-09b2-479a-bb76-9770e361a23c"/>
                    <textElement>
                        <font fontName="宋体" isBold="true"/>
                    </textElement>
                    <text><![CDATA[数量]]></text>
                </staticText>
                <staticText>
                    <reportElement x="410" y="10" width="100" height="20" uuid="c258f47b-da6a-418d-a5e0-892388ec65c5"/>
                    <textElement>
                        <font fontName="宋体" isBold="true"/>
                    </textElement>
                    <text><![CDATA[类别]]></text>
                </staticText>
            </band>
        </columnHeader>
        <detail>
            <band height="39" splitType="Stretch">
                <textField>
                    <reportElement x="0" y="4" width="70" height="16" uuid="99fa4c16-cfe2-4482-828e-4439abb9e8f0"/>
                    <textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="210" y="4" width="70" height="16" uuid="ba6e9cfa-6d4c-470b-8bc4-eb2e3411c21e"/>
                    <textFieldExpression><![CDATA[$F{price}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="310" y="4" width="70" height="16" uuid="447253d3-d268-4873-b0b7-9c174c6a7c9f"/>
                    <textFieldExpression><![CDATA[$F{quantity}]]></textFieldExpression>
                </textField>
                <textField>
                    <reportElement x="410" y="4" width="100" height="16" uuid="8992d0ad-1f5e-4210-b50b-1e29dc66f119"/>
                    <textFieldExpression><![CDATA[$F{categoryName}]]></textFieldExpression>
                </textField>
                <line>
                    <reportElement x="-3" y="27" width="521" height="1" uuid="9b493a65-a499-4199-90bb-b3fedbe45f85"/>
                </line>
                <textField>
                    <reportElement x="90" y="4" width="100" height="16" uuid="fcdd8979-dc44-46e3-be56-11e5f33b8e0c">
                        <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="73fad7b3-74b5-4436-bd46-d2b9c3c113fd"/>
                    </reportElement>
                    <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
                </textField>
            </band>
        </detail>
        <columnFooter>
            <band height="45" splitType="Stretch"/>
        </columnFooter>
        <pageFooter>
            <band height="54" splitType="Stretch"/>
        </pageFooter>
        <summary>
            <band height="42" splitType="Stretch"/>
        </summary>
    </jasperReport>

    新建 Spring Boot 项目

    • 新建 Spring Boot 项目,不多说
      需包含的内容比较特殊,pom.xml,jasperreports 是依赖包,jasperreports-fonts 是字体支持包
            <dependency>
                <groupId>net.sf.jasperreports</groupId>
                <artifactId>jasperreports</artifactId>
                <version>6.15.0</version>
            </dependency>
            <dependency>
                <groupId>net.sf.jasperreports</groupId>
                <artifactId>jasperreports-fonts</artifactId>
                <version>6.15.0</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-support</artifactId>
                <version>2.0.8</version>
            </dependency>
    • 新建各种类
      controller, domain, repository, service, 其他,大概目录结构如下

    report2.png

    • 创建 Postgresql 数据表
    CREATE TABLE public.product
    (
        id bigint NOT NULL,
        name character varying(255) COLLATE pg_catalog."default",
        price numeric,
        quantity integer,
        category_name character varying(255) COLLATE pg_catalog."default",
        CONSTRAINT product_pkey PRIMARY KEY (id)
    )

    集成 JasperReports 到 Spring Boot 项目

    中文支持文章:Spring Boot 集成 JasperReports,并支持中文PDF

    • Service 服务层处理要求
    @RequestMapping(value = "/report", method = RequestMethod.GET)
        public void report(HttpServletResponse response, @RequestParam(name = "type", defaultValue = "pdf") String type) throws Exception {
    
            JRBeanCollectionDataSource dataSource = new JRBeanCollectionDataSource(productService.report());
            InputStream inputStream = this.getClass().getResourceAsStream("/report_templates/report.jrxml");
            JasperReport jasperReport = JasperCompileManager.compileReport(inputStream);
            JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, dataSource);
    
            switch (type) {
            case "html":
                response.setContentType("text/html;charset=utf-8");
                HtmlExporter exporter = new HtmlExporter(DefaultJasperReportsContext.getInstance());
                exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
                exporter.setExporterOutput(new SimpleHtmlExporterOutput(response.getWriter()));
                exporter.exportReport();
                break;
    
            case "pdf":
    
            default:
                JRPdfExporter exporterPdf = new JRPdfExporter();
                exporterPdf.setExporterInput(new SimpleExporterInput(jasperPrint));
                OutputStream outputStream = response.getOutputStream();
                exporterPdf.setExporterOutput(new SimpleOutputStreamExporterOutput(outputStream));
                exporterPdf.exportReport();
                break;
            }
    
        }
    • 可以是 HTML 版本
      r1.png
    • 也可以是 PDF 版本
      r2.png

    源码下载: https://github.com/jiekechoo/YiqisoftReport

    • 编辑 docker-compose.yml
    version: "3.7"
    services:
      db:
        image: postgres:11.6
        restart: always
        environment:
          POSTGRES_DB: postgres
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: postgres
          PGDATA: /var/lib/postgresql/data
        volumes:
          - db-data:/var/lib/postgresql/data
        ports:
          - "5432:5432"
     
      pgadmin:
        image: dpage/pgadmin4
        restart: always
        environment:
          PGADMIN_DEFAULT_EMAIL: admin@yiqisoft.cn
          PGADMIN_DEFAULT_PASSWORD: talent
          PGADMIN_LISTEN_PORT: 80
        ports:
          - "8088:80"
        volumes:
          - pgadmin-data:/var/lib/pgadmin
        links:
          - "db:pgsql-server"
    volumes:
      db-data:
      pgadmin-data:

    注意:文件保存在本地 volumes 中,如果需要再次使用,请保存!

    • 启动
    docker-compose up -d
    • 登录 pgAdmin 4

    打开本地浏览器 http://localhost:8080 , 使用用户名 admin@yiqisoft.cn 和密码 talent 登录