各种注解用法 @GeneratedValue（1）为一个实体生成一个唯一标识的主键、提供了主键的生成策略。（2）有两个属性,分别是strategy和generator,generator属性：的值是一个字符串,默认为"",其声明了主键生成器的名称(对应于同名的主键生成器@SequenceGenerator和@TableGenerator)。strategy属性：-AUTO 主键由程序控制, 是默认选项 ,不设置就是这个-IDENTITY 主键由数据库生成, 采用数据库自增长, Oracle不支持这种方式-SEQUENCE 通过数据库的序列产生主键, MYSQL 不支持-Table 提供特定的数据库产生主键, 该方式更有利于数据库的移植@Column注解用来标识实体类中属性与数据表中字段的对应关系，@Column可以标注在属性前或getter方法前；name 定义了被标注字段在数据库表中所对应字段的名称； unique 表示该字段是否为唯一标识，默认为false。如果表中有一个字段需要唯一标识，则既可以使用该标记，也可以使用@Table标记中的@UniqueConstraint。 nullable 表示该字段是否可以为null值，默认为true。 insertable 表示在使用“INSERT”脚本插入数据时，是否需要插入该字段的值。 updatable 表示在使用“UPDATE”脚本插入数据时，是否需要更新该字段的值。insertable和updatable属性一般多用于只读的属性，例如主键和外键等。这些字段的值通常是自动生成的。 columnDefinition（大多数情况，几乎不用） 表示创建表时，该字段创建的SQL语句，一般用于通过Entity生成表定义时使用。（也就是说，如果DB中表已经建好，该属性没有必要使用。） table 表示当映射多个表时，指定表的表中的字段。默认值为主表的表名。 length 表示字段的长度，当字段的类型为varchar时，该属性才有效，默认为255个字符。 precision和scale precision属性和scale属性表示精度，当字段类型为double时，precision表示数值的总长度，scale表示小数点所占的位数。

CentOS中离线安装ffmpeg 1.下载安装包 ffmpeg-4.1.tar.xz 2.解压安装包：tar -xvJf ffmpeg-4.1.tar.xz3.编译安装： /programFiles/soft/ffmpeg 为自己指定的安装目录./configure --enable-shared --prefix=/programFiles/soft/ffmpeg提示错误：nasm/yasm not found or too old. Use --disable-x86asm for a crippled build. If you think configure made a mistake, make sure you are using the latest version from Git. If the latest version fails, report the problem to the ffmpeg-user@ffmpeg.org mailing list or IRC #ffmpeg on irc.freenode.net. Include the log file "ffbuild/config.log" produced by configure as this will help solve the problem.安装gcc编译器centos 执行yum install gccubuntu 执行apt install gcc安装yasm编译器：centos 执行yum install -y yasmubuntu 执行apt install -y yasm离线安装yasm：{card-describe title="安装步骤"}离线包： yasm-1.3.0.tar.gzwget http://www.tortall.net/projects/yasm/releases/yasm-1.3.0.tar.gztar zxvf yasm-1.3.0.tar.gzcd yasm-1.3.0./configuremake && make install{/card-describe}4.编译（编译时间比较长）和安装：make && make install5.遇到问题 -bash: make: command not found 的解决办法 一般出现这个提示，是因为安装系统的时候使用的是最小化mini安装，系统没有安装make、vim等常用命令，直接yum安装下即可。yum -y install gcc automake autoconf libtool make安装g++:yum install gcc gcc-c++6.修改文件/etc/ld.so.confvim /etc/ld.so.confinclude ld.so.conf.d/*.conf将安装目录的lib包路径 /{make install的目录}/ffmpeg/lib 加入最后/programFiles/soft/ffmpeg/lib/使修改生效：ldconfig7.查看版本/programFiles/soft/ffmpeg/bin/ffmpeg -version8.配置环境变量vim /etc/profile在最后PATH添加环境变量（ /programFiles/soft/ffmpeg/bin 为安装目录）：#set ffmpeg environment PATH=$PATH:/programFiles/soft/ffmpeg/bin export PATH或者这么写：#set ffmpeg env export FFMPEG_HOME=/usr/bin/ffmpeg export PATH=$PATH:${FFMPEG_HOME}/bin使配置生效：source /etc/profile 9.查看环境变量是否配置成功ffmpeg -version参考资料：https://www.cnblogs.com/wpjamer/p/ffmpeg.htmlhttps://www.cnblogs.com/wintercloud/p/11162962.html转码时候遇到问题 Unknown encoder 'libx264'即，缺少libx264解码库，需要安装该库：git clone http://git.videolan.org/git/x264.git && cd x264./configure --enable-static --enable-sharedmake && make installFFMPEG使用NVIDIA的GPU硬件转码（使用N卡加速解码）下载ffmpeg源码sudo apt-get install build-essential yasm cmake libtool libc6 libc6-dev unzip wget libnuma1 libnuma-dev正常编译配置（防止报错，根据提示加上--disable-x86asm）./configure --prefix=/usr/local/ffmpeg --enable-shared --enable-yasm --enable-libx264 --enable-gpl --enable-pthreads --extra-cflags=-I/usr/local/x264/include --extra-ldflags=-L/usr/local/x264/lib --disable-x86asmN卡加速编译配置./configure --enable-nonfree -–enable-cuda-sdk –enable-libnpp --extra-cflags=-I/usr/local/cuda/include --extra-ldflags=-L/usr/local/cuda/lib64编译和安装make && make install同分辨率转码, gpu加速转码，ddr在线模式ffmpeg -y -vsync 0 -hwaccel cuvid -c:v h264_cuvid -i input.mp4 -c:a copy -c:v h264_nvenc -b:v 5M output.mp4变分辨率转码：ffmpeg -y -vsync 0 -hwaccel cuvid –resize 1280x720 -c:v h264_cuvid -i input.mp4 -c:a copy -c:v h264_nvenc -b:v 5M output.mp4corp转码 (-crop (top)x(bottom)x(left)x(right))ffmpeg -y -vsync 0 -hwaccel cuvid –crop 16x16x32x32 -c:v h264_cuvid -i input.mp4 -c:a copy -c:v h264_nvenc -b:v 5M output.mp4scale_cuda filter 转码ffmpeg -y -vsync 0 -hwaccel cuvid -c:v h264_cuvid -i input.mp4 -vf scale_cuda=1280:720 -c:a copy -c:v h264_nvenc -b:v 5M output.mp4scale_npp filter 转码ffmpeg -y -vsync 0 -hwaccel cuvid -c:v h264_cuvid -i input.mp4 -vf scale_npp=1280:720 -c:a copy -c:v h264_nvenc -b:v 5M output.mp41:N 转码ffmpeg -y -vsync 0 -hwaccel cuvid -c:v h264_cuvid -i input.mp4 -vf scale_npp=1920:1080 -c:a copy -c:v h264_nvenc -b:v 5M output1.mp4 -vf scale_npp=1280:720 -c:a copy -c:v h264_nvenc -b:v 8M output2.mp4yuv编码, 1:N 编码ffmpeg -y -vsync 0 -pix_fmt yuv420p -s 1920x1080 -i input.yuv -filter_complex "[0:v]hwupload_cuda,split=4[o1][o2][o3][o4]" -map "[o1]" -c:v h264_nvenc -b:v 8M output1.mp4 -map "[o2]" -c:v h264_nvenc -b:v 10M output2.mp4 -map "[o3]" -c:v h264_nvenc -b:v 12M output3.mp4 -map "[o4]" -c:v h264_nvenc -b:v 14M output4.mp4转码, 1:N 编码ffmpeg -y -hwaccel cuvid –c:v h264_cuvid -i input1.mp4 -hwaccel cuvid –c:v h264_cuvid -i input2.mp4 -map 0:0 -vf scale_npp=640:480 –c:v h264_nvenc -b:v 1M output11.mp4 -map 0:0 -vf scale_npp=320:240 –c:v h264_nvenc -b:v 500k output12.mp4 -map 1:0 -vf scale_npp=1280:720 –c:v h264_nvenc -b:v 3M output21.mp4 -map 1:0 -vf scale_npp=640:480 –c:v h264_nvenc -b:v 2M output22.mp4软解码，gpu resize，gpu编码ffmpeg -y -init_hw_device cuda=foo:bar -filter_hw_device foo -i input1.mp4 -i input2.mp4 -map 0:0 -vf hwupload,scale_npp=640:480 –c:v h264_nvenc -b:v 1M output11.mp4 -map 0:0 -vf hwupload,scale_npp=320:240 –c:v h264_nvenc -b:v 500k output12.mp4 -map 1:0 -vf hwupload,scale_npp=1280:720 –c:v h264_nvenc -b:v 2M output21.mp4 -map 1:0 -vf hwupload,scale_npp=640:480 –c:v h264_nvenc -b:v 1M output22.mp4更多配置通过ffmpeg查看NVIDIA编码器和解码器属性配置更多参考：https://developer.nvidia.com/ffmpegh264_nvenc 编码器配置参考Using_FFmpeg_with_NVIDIA_GPU_Hardware_Acceleration_v01.4.pdf

CentOS安装NodeJS 1.从官网下载最新nodejs安装包https://nodejs.org/zh-cn/download/ 历史版本可从https://nodejs.org/dist/下载2.通过ftp工具上传到linux服务，解压安装包或者在指定目录下执行命令下载：wget https://nodejs.org/dist/v14.17.5/node-v14.17.5-linux-x64.tar.xz解压：tar -xvf node-v14.17.5-linux-x64.tar.xz3、移动并改名文件夹（不改名也行）cd /usr/local/ mv /var/ftp/pub/node-v14.17.5-linux-64 . //后面的.表示移动到当前目录 mv node-v14.17.5-linux-x64 nodejs4、让npm和node命令全局生效方式一：环境变量方式（这种方式似乎只对登录用户有效？）1）、加入环境变量，在 /etc/profile 文件末尾增加配置vi /etc/profile export PATH=$PATH:/usr/local/nodejs/bin2）、执行命令使配置文件生效source /etc/profile方式二：软链接方式（推荐）ln -s /usr/local/nodejs/bin/npm /usr/local/bin/ ln -s /usr/local/nodejs/bin/node /usr/local/bin/5、查看nodejs是否安装成功node -v npm -v

小说站-维护-清理无效小说存储 1.清理指定id的小说所有内容DROP PROCEDURE IF EXISTS clear_invalid_novel; CREATE PROCEDURE clear_invalid_novel() BEGIN DECLARE bookid varchar(255) DEFAULT '1431094810327994368'; DELETE FROM book_content WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content0 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content1 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content2 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content3 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content4 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content5 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content6 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content7 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content8 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_content9 WHERE index_id in (SELECT id FROM book_index WHERE book_id=bookid); DELETE FROM book_index WHERE book_id=bookid; DELETE FROM book WHERE id=bookid; END; call clear_invalid_novel();2.删除无效的小说文本delete from book_content where index_id not in(SELECT id from book_index); delete from book_content0 where index_id not in(SELECT id from book_index); delete from book_content1 where index_id not in(SELECT id from book_index); delete from book_content2 where index_id not in(SELECT id from book_index); delete from book_content3 where index_id not in(SELECT id from book_index); delete from book_content4 where index_id not in(SELECT id from book_index); delete from book_content5 where index_id not in(SELECT id from book_index); delete from book_content6 where index_id not in(SELECT id from book_index); delete from book_content7 where index_id not in(SELECT id from book_index); delete from book_content8 where index_id not in(SELECT id from book_index); delete from book_content9 where index_id not in(SELECT id from book_index);3.整合表内容create table book_content_test as SELECT id, index_id,content from ( SELECT * FROM book_content0 B0 WHERE B0.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content1 B1 WHERE B1.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content2 B2 WHERE B2.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content3 B3 WHERE B3.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content4 B4 WHERE B4.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content5 B5 WHERE B5.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content6 B6 WHERE B6.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content7 B7 WHERE B7.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content8 B8 WHERE B8.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') union all SELECT * FROM book_content9 B9 WHERE B9.index_id in (SELECT id FROM book_index WHERE book_id='1431142380391714816') ) as T1;

mysql执行存储过程 示例1-- 创建存储过程之前需判断该存储过程是否已存在，若存在则删除 DROP PROCEDURE IF EXISTS init_reportUrl; -- 创建存储过程 CREATE PROCEDURE init_reportUrl() BEGIN -- 定义变量 DECLARE s int DEFAULT 0; DECLARE report_id varchar(255); DECLARE report_url varchar(256); -- 定义游标，并将sql结果集赋值到游标中 DECLARE report CURSOR FOR select reportId,reportUrl from patrolReportHistory; -- 声明当游标遍历完后将标志变量置成某个值 DECLARE CONTINUE HANDLER FOR NOT FOUND SET s=1; -- 打开游标 open report; -- 将游标中的值赋值给变量，注意：变量名不要和返回的列名同名，变量顺序要和sql结果列的顺序一致 fetch report into report_id,report_url; -- 当s不等于1，也就是未遍历完时，会一直循环 while s<>1 do -- 执行业务逻辑 update patrolreporthistory set reportUrl = CONCAT('patrolReport.html?monitorId=',substring(report_url,15,1),'&reportId=',report_id) where reportId=report_id; -- 将游标中的值再赋值给变量，供下次循环使用 fetch report into report_id,report_url; -- 当s等于1时表明遍历以完成，退出循环 end while; -- 关闭游标 close report; END;-- 执行存储过程 call init_reportUrl()示例2-- 创建存储过程之前需判断该存储过程是否已存在，若存在则删除 DROP PROCEDURE IF EXISTS sys_config_uniform_price; -- 创建存储过程 CREATE PROCEDURE sys_config_uniform_price() BEGIN -- 定义变量 DECLARE exe_flag int DEFAULT 0; DECLARE _company_no varchar(255); -- 定义游标，并将sql结果集赋值到游标中 DECLARE obj_config CURSOR FOR SELECT DISTINCT company_no from cms_sys_config WHERE is_sys = 0; -- 声明当游标遍历完后将标志变量置成某个值 DECLARE CONTINUE HANDLER FOR NOT FOUND SET exe_flag=1; -- 打开游标 open obj_config; -- 将游标中的值赋值给变量，注意：变量名不要和返回的列名同名，变量顺序要和sql结果列的顺序一致 fetch obj_config into _company_no; -- 当s不等于1，也就是未遍历完时，会一直循环 while exe_flag<>1 do -- 执行业务逻辑 INSERT INTO `cms_sys_config` ( `id`, `company_no`, `IS_SYS`, `is_switch`, `name`, `keyword`, `conf_value`, `available`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`, `del_flag` ) VALUES ( UUID(), _company_no, '0', '1', '是否开启出证统一价', 'is_uniform_price', '0', '0', '1', CURRENT_TIME(), '1', CURRENT_TIME(), '', '0' ); INSERT INTO `cms_sys_config` ( `id`, `company_no`, `IS_SYS`, `is_switch`, `name`, `keyword`, `conf_value`, `available`, `create_by`, `create_date`, `update_by`, `update_date`, `remarks`, `del_flag` ) VALUES ( UUID(), _company_no, '0', '1', '是否开启出证统一价', 'is_uniform_price', '0', '0', '1', CURRENT_TIME(), '1', CURRENT_TIME(), '', '0' ); -- 将游标中的值再赋值给变量，供下次循环使用 fetch obj_config into _company_no; -- 当s等于1时表明遍历以完成，退出循环 end while; -- 关闭游标 close obj_config; UPDATE cms_sys_config SET id = REPLACE(id, '-', ''); END; -- 执行存储过程 call sys_config_uniform_price()