pb导出excel代码,电子表格pb快速导入excel数据
1. pb快速导入excel数据
1、自己打开一个EXCEL点上面的按钮导出试试看。
2、打开一个EXCEL,选择数据〉自网站;或者数据〉导入>自网站;或者工具>数据导入>自网站(版本不同位置不同),
在窗口中粘贴如网站地址,然后动态链接试试看。
2. pb导入excel数据报错
OTIS 电梯GECB 板故障代码
GECB 故障代码 Ⅰ信息 W警告 F 故障
total runs 最后一次上电后的运行次数-
minutes on最后一次上电后的运行时间(单位:分)
0001 S/W Reset W GECB 监控电路触发,软件重启
0002Illegal Int W 非法中断
0003 CanTxFull WCAN 不能发送信息
0004 CanBusOffWCAN 通讯重启
0006 StackCheck F 堆栈错误,重启
0007SCN Error F 软件不正确
0008TimerSync F内部软件定时器没有刷新。
0009 Task Fail F软件运行错误
0010 McbCommErrF 变频器CAN通讯错误
0011 SpbCommErrWSPB通讯错误
0012Power OnI控制板上电
0013 Event FailW
0014 PowerOffOn I 瞬间断电
0016S/W RestartW 未知原因复位
0017Trace ErrorF 事件跟踪缓冲器错误
0019 MissedLvIntF 未得到LV1和LV2信号
Operational Control Sub System
0100OpMode NAV F OCSS因变频器故障不可用,该故障在检修后的复位运行时也会出现。
0101 EPO shutd.W因EPO不能运行 NU (017)NUSD (018) NUSG (019)
0102OpMode DTCW门在规定时间内不能完全关闭(DCL,DFC或DW信号错误) DCL(694)RDCL (695)DOOR, REAR DTC-T
0103 OpMode DTOF门在规定时间内不能完全打开(DOL信号错误)DOL(000)RDOL (544)DOOR,REAR DTO-T
0104 OpMode DCPW轿厢不能响应召唤(例如门被手动打开)DCP-T
0105 DBSS fault 驱动器故障
0106 PDS active I PDD (784) 部分门锁开关未闭合
0107 DS bypass F 因消房员服务屏蔽门锁电路 DDSRC (970)
0108EEC bypassF 因消房员服务屏蔽安全窗电路 DEMERC(971)
0109Stuck DCBF 关门按钮一直动作 DCB (003)
3. pb 导入excel
方法
1
首先是新建一个需要复制拷贝的sheet页。sheet页面里面的内容是需要复制的内容。
2
开始复制。将光标放到sheet页的名称上,点击鼠标右键,可以进行复制和移动,这里是需要进行复制。
3
选择复制或者异动到位置。在弹框中,选择需要复制到哪里位置,可以放到最后也可以放到顶端,记得需要勾选创建副本,否则不会复制。
4
选择需要复制到的sheet位置,这里通过选择放到之后,开始进行复制,点击确定按钮就可以复制sheet页。
5
查看复制的结果,通过sheet名称列,就可以看到复制的sheet页。新复制的名称会有(2)的标识,可以通过重命名的方式该名称。
6
重命名sheet页的名称。通过重命名的方式改名,输入新的sheet页名称。
4. pb怎么导入数据库
在 File 菜单中有一个导入工程的菜单项吧!选择导入“ *.pbw ”的文件进行导入,就可以打开工程了。或者是在库文件中,加入“ *.pbl ”文件,就可以在类文件导航栏中,打开源码了。我都N年没有用过PB了,回答不详细,请谅解。
5. pb导出excel时格式改变
抖音是一款可以拍摄短视频的音乐创意短视频社交软件,也是目前最火的短视频APP,当我们看到那些视频的时候,内心一定有想要创作的想法。
前期筹备
拍摄抖音需要先确定我们的拍摄主题,然后再根据主题来进行脚本创作。一般拍摄主题是根据我们的账号定位来确定的,这两者是息息相关的。
账号定位
如果我们仔细观察就会发现抖音上面的大号都有各自的特色,但内容上却都是统一的。比如抖音账号“虎哥说车”,他的定位就是说车的,所以他发布的内容全部是跟汽车有关系的;比如账号“惠子”,她就是靠颜值吸引粉丝的,所以她发布的就是自己的美颜视频;比如账号“郭聪明”就是唱歌的,那么他发布的都是自己的歌曲。
所以我们才说,拍视频之前需要先明确视频的主题是什么,主题往往是跟账号定位有一定关联的。
短视频的主题要十分具体,才能开始接下来的拍摄工作。具体我们可以从两个方面来考虑。
1、选题是否符合作者的个人领域;
针对创作者本人擅长方向,我们定位的时候就选择适合自己的领域,比如我们擅长做美食,那么抖音视频号定位就可以是专做美食的,我们拍摄的视频内容也要选择同领域。
2、主题的内容选择。
确定主题建议从个人擅长内容以及当下的热点来进行考虑。
拍摄脚本
拍摄抖音视频之前,我们需要先设计好拍摄的脚本,把拍摄的流程先构思好,还有拍摄用到的台词、文案都提前准备好,这样才可以拍出高质量作品。
我们寻找灵感的时候可以通过豆瓣点评、知乎等渠道寻找,最好把每个人物的性格和关系搞清楚,考虑好每个场景、细节和表情,也可以参考借鉴优秀的视频作品来编写脚本。
短视频脚本是故事的发展大纲,是指拍摄视频所依靠的大纲底本。
一个最基本的短视频分镜头脚本主要包含了:摄法、景别、内容、台词等内容,那么我们在撰写短视频脚本时,也可以根据自己制作短视频的需求,酌情添加或者删减,根据脚本模板,填充内容。
短视频脚本创作的6大要素一般包含以下内容:短视频主题、镜头景别、画面内容、台词、时长、运镜。
1、短视频核心内容
抖音短视频脚本撰写的第一步就是根据拍摄主题确定核心内容。
无论你想做一个感人的故事,还是记录生活的一天,都要在脚本中明确,后期的剧情的展开需要围绕核心内容。
2、台词
台词对于抖音短视频而言,是画龙点睛的作用。建议大家在60s的短视频中,尽量不要让文字超过180个字,不然听起来会特别的累。
3、镜头景别
这就是拍摄的时候,选择用远景、全景、中景、近景、特写中的哪一种。
以拍摄人物为例的话:
远景:把整个人和环境拍摄在画面中,常用来表现事件发生的时间、环境等场景。例如:办公室人物。
全景:较远景偏近一点,常用来表现人物的全身动作,或者是人物之间的关系。例如:舞蹈短视频。
中景:拍摄人物膝盖至头顶画面,重点在于显示人物的形体动作。
近景:指拍摄人物胸部以上至头部的部位,常用来表现表情、神态等细微动作。例如:毛光光柜姐形象。
特写:对人物的眼睛、鼻子、嘴、手指等细节进行拍摄,适合用来表现需要突出的细节。例如:美妆产品手部展示。
根据不同的主题要求,抖音短视频脚本中所使用的景别是有所区别的,这方面的内容需要大家有更多的学习经验积累。建议大家上网下载一些教程进行学习。
4、画面内容
内容就是把你想要表达的东西通过各种场景方式进行呈现,即拆分剧本,把内容拆分在每一个镜头里面。
5、拍摄时长
抖音短视频脚本中的时长指的是单个镜头的时长。建议大家提前标注清楚,方便后期剪辑的时候,更快找到重点,提高工作效率。
6、运镜
运镜指的就是镜头的运动方式。
"推"
"推"是最常见的一种运镜技巧。在拍摄的时候,镜头缓慢向前移动,不断地推进,靠近拍摄主体,拍摄主体在画面中的比例逐渐变大。这种运镜技巧能够起到聚焦、突出拍摄主体的作用。比如要拍摄一个人物,镜头向前推进的过程中,人物在画面中的比例逐渐变大,让人物更中突出。
即使是拍摄没有主体的场号,“推”的运镜方式也会让视频更有代入感。
“拉”
“拉”与“推”的运镜方式刚好相反。在拍的过程中,镜头逐渐向后拉远,让镜头远离拍摄主体,成片的视觉效果也与“推”相反。“拉”的运镜技巧能够起到交代环境、突出现场的作用,让看视频的人了解拍摄主体所在的环境特点,增加画面的氛围。
“转”
“转”的运镜技巧,能给视频增加一种独特的视觉效果。其拍摄方法也很简单,常见有两种操作方式。
第一种是站在原地拍摄,在拍摄过程中旋转镜头,旋转角度没有特定的要求,但是在拍摄素材的时候尽量拍摄360度,以方便后期剪辑的时候截取素材。此时如果选择的角度不够。后期就无法增加素材。
第二种是围绕着拍摄主体进行旋转拍摄,这种方式能全方位地展现拍摄主体。旋转拍摄的时候,因为是动态拍摄,所以要控制好移动的速度。
“移”
“移”可以理解为平行移动,移动的方向可以是横向,也可以是纵向,或者倾斜一定的角度。但是移动的轨迹要以直线为主,不要无规则地移动。
单个镜头拍完就停止,然后再拍摄下一个镜头,单个镜头里尽量不要使用多种运镜技巧,因为会造成混乱的视觉效果。
比如拍摄辽阔的自然风光,可以采用横向的水平移动;拍摄高大的主体如建筑、山峰等,可以采用纵向移动;拍摄小场景也可以使用这一运镜技巧。它适用的场景很多,但是一定要注意保证手机是直线移动而不是原地不动的。
“穿”
“穿”可以理解为穿越、穿过的意思,当拍摄的时候,需要在手机和拍摄主体之间寻找一个前景,因为要穿越的就是这个前景。
“穿”的运镜技巧可以让视频画面增加层次感和空间感,因为有了前景的衬托,有了远近的对比,才能让画面有身临其境的代入感。但是前景不能喧宾夺主,它只是起到衬托的作用,比如栏杆的缝隙、门窗、树叶的缝隙等都可以作为前景来使用。拍摄的时候结合“推”和“拉”的运镜技巧,穿过前景,然后聚焦在拍摄主体上。
“跟”
“跟”的运镜技巧可以理解为跟随,拍摄移动的主体时,镜头一直跟随拍摄主体移动。比如在后边跟随拍摄一个向前走动的人,或者在前面拍摄向镜头走过来的人。镜头和主体同步运动,可以保证拍摄主体在画面中的比例是不变的,跟随拍摄也能让画面增加代入感。
“摇”
“摇”的拍摄方法和效果与“移”类似,但是拍摄的时候,摇镜头是指原地不动地旋转手机或者相机,镜头是弧形移动的。比如站在原地拿好手机,镜头从左向右拍摄,手机移动的路径是一个弧形,也可以向上拍摄,记住关键点就是原地不动。“摇”会逐一展示镜头前的场景,让画面更有代入感。
脚本怎么写
写脚本之前需要先了解脚本的结构,这样写出来会比较符合拍摄,下面我们先来介绍下脚本的结构。
脚本的结构
脚本的整体结构分为:开头吸引观众目光、中间进入主题内容、最后深化主题内容三部分。
1、再好的脚本,也需要遵循一定的主题和定位,来明确写作的方向;以30秒为例,当一条视频被人点击之后,如果在开头的5秒种内无法吸引兴趣,这条视频可能就直接被人划过去转向下一条;
所以在脚本的一开头,我们要把吸引观众的内容先呈现出来,这样才能吸引观众看下去。
2、接下来的10秒钟,需要进入主题,包装亮点,继续吸引受众观看;
3、最后的15秒,需要将主题深化,带来一些有意思的见解,并与受众互动、引导点赞、转发和关注等行为。
脚本写作的基本步骤:
1、先介绍故事梗概。
2、写出分集发展大纲。
3、剧情细化到每个场景,人物对话(动作、表情、心理活动、人物之间的关系等提示)。
脚本(偏重于镜头的剧本)的写作格式如下:
第一场 地点 日或夜 内或外
A:(台词)
B:(台词)
创作常用方法
1、嵌套法
嵌套法的目的,是用来解决视频可能出现的3个问题:
1)信息量单薄;
2)用户缺乏吐槽点;
3)视频缺乏耐看性;
那么如何实现嵌套呢?
1)制作一个故事脚本;
2)制作第二个故事脚本;
3)通过一个嵌入点,把第二个故事脚本嵌入第一个脚本;
4)如此循环往复,直至无穷;
2、代入法
先给主题构建一个“代入法”的场景,可以让团队在这个“画框”内,不断带入各种各种元素,实现轻松创意复制。比如主题是“卖车”,大家可以想象,卖车有哪些环节好玩、有趣、有冲突:
1)发传单可以有冲突——花式发传单;
2)顾客电话邀约有冲突——顾客的花式拒绝,顾客的花式勾搭;
3)到店接待有冲突——新来的小姐姐这样接待客人;
3、四维还原法
1)内容还原把热门视频用文字描述一遍,因为在展开过程中,无数细节会被记录并展开出来,信息量得到完整呈现。
2)评论还原看看抖友们,看了这个视频是什么反应。
3)身份还原通过对受众、点赞回复用户的身份反查,找到他们是谁,他们关心什么,他们为什么关心这个爆款视频。
4)策略逻辑还原。这个视频是给谁看的?主流用户是谁?发什么给他们看?
4、模仿法
1)随机模仿看见什么视频火,自己照样子拍一个,比如最近两天比较火的大头、踢瓶盖。
2)系统模仿找到对标的账号、IP,抖音内外都可,分析其经典桥段、套路,不等它在抖音火,就模仿拍摄一个。
如果看了上面的介绍还是不知道脚本怎么写,那么可以看看专门介绍写脚本的课程,这样更加清楚、直接。
脚本分镜头创作方法:https://bilibili/video/BV1QZ4y1r7tQ/?spm_id_from=333.337.search-card.all.click
短视频脚本创作:https://bilibili/video/BV1c3411v7Cw/?spm_id_from=333.337.search-card.all.click
脚本写作技巧
脚本不同于其他写作形式,重点在于如何把平面语言转化为镜头语言,镜头语言不止是看得见的文字,还包括看不见的内容。脚本的写作业需要遵循一定的逻辑和步骤:
1、从无到有的过程中,需要选择一个主题,根据主题来梳理脚本大纲、框架结构
2、脚本需要有贯穿全篇的主线,并且需要有必要的内容来支撑主线的发展
3、场景的包装,人物角色的设定,场景和人物的协调表现
4、视频通常会受到时间长度的限制,需要在有限的时间内,安排上精炼、合适、精准的内容,并需要主要前后的逻辑关系
5、点明主题,深化主题内涵,引起精神共鸣或设置悬念为观众带来思考
矛盾是支撑情节发展的核心要素,视频内容的丰富离不开矛盾的设置。
1、结合场景、人物、情节等因素,设置好冲突和转折,“意料之外情理之中”,可以是人物的冲突、语言的冲突、场景的冲突、肢体的冲突、表情的冲突等等;需要结合联想、谐音、一词多意、双关、旧词新解、反转等手法
2、需要掌握一定的常用题材、场景、拍摄手法
3、来源于生活,反映生活,服务生活
脚本课程推荐
抖音短视频脚本简单几步,小白也能快速上手:https://bilibili/video/BV1Dp4y1h7ve/
短视频制作脚本撰写:https://bilibili/video/av501191474/?p=16
分析同行内容
我们在拍摄短视频之前可以先分析下同行拍摄的内容,学习学习经验,这样会有利于自己拍摄出好的作品。
首先我们要分析他为什么火?
我们可以将点赞量大于10W的视频都收集起来,作为重点分析的对象,带着以下四个问题去分析:
①该视频的视频形式我能做出来吗?
②该视频内容我能否做出来?
③这类账号如何变现?我是否有资源?
④我能否长时间做这类视频?
给大家一个好用的表格,用来分析数据很方便,把标题、点赞量、评论量、转发量、视频链接作为表头,如下所示。
前期拍摄视频的时候,我们如果不知道怎么制作内容,那么就可以借鉴我们的分析成果,模仿这些优质的视频,后期再开始创新。
注册账号并编辑好资料后,就可以上传视频了。
对于新手来说,想要短时间内上热门,最好的方法就是模仿,我要模仿那些点赞量高的视频。
这里有两点给大家说:
①平台的风气就是模仿,大家可以发现,只要有一个梗上了热门,就会出现大量的模仿者,而他们模仿的视频,还依旧能上热门。
②热门视频是经过用户的检测的,模仿的作品,大概率会上热门,能快速试错。
视频拍摄
拍抖音的步骤
1、打开手机软件商店,点击下载,然后下载抖音APP,安装抖音APP。
2、打开抖音App,之后点击抖音下方的加号键;
3、然后点击屏幕左下方的特效或道具,接着选择想要的特效或道具;
4、点击上方选择音乐,可以添加背景音乐;
5、然后点击屏幕中的拍摄按钮,开始拍摄视频;
6、在拍摄完成之后,接着点击下一步;
7、最后再点击发布就可以了,这样就能发布自己拍摄的抖音小视频了。
拍摄方式
远程控制暂停
拍摄视频的时候,如果手机隔得比较远,可以使用拍摄里面的“倒计时”功能。例如我们只要拍摄10s就暂停,可以将暂停拉杆拖到10s的位置处即可。然后点击“开始拍摄”拍摄,当拍摄到第10s的时候就会自动暂停。这样拍摄的时候,自己可以在手机随着自己的需求来拍摄不同的风格。
具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。
远程控制暂停:https://bilibili/video/BV1PB4y1Q743/?spm_id_from=333.337.search-card.all.click
调整播放速度
拍摄视频的时候可以调节播放速度,快慢速度调整就是调整音乐和视频的匹配。如果选择“快”或者“极快”,拍摄的时候音乐就会放慢,相应的视频成品中的画面就会加快;反之,如果选择“慢”或者“极慢”,拍摄时的音乐就会加快,成品中的画面就会放慢。
具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。
调节播放速度:https://bilibili/video/BV1ZK411V778/?spm_id_from=333.337.search-card.all.click
拍摄分段视频
抖音可以拍摄分段视频,拍摄一段视频后点击暂停,然后再拍摄另外一段视频,最后把这两段视频拼接起来成为一个完整的视频,这就是分段视频。
例如很多达人拍摄的“变装视频”用的就是分段视频拍摄手法。但是拍摄分段视频的时候,拍摄内容不要牛头不对马嘴,前面一个视频拍摄的是一个内容,后面的视频拍的又是另一个内容,这样会让用户看起来觉得很乱,不知道你要表达什么内容。
操作方法:
1、进入抖音App后,打开发布视频功能。
2、打开录制长视频
进入发布视频功能后,打开长视频功能。
3、进行分段拍摄
进入录制视频页面后,开始录制视频,录制完成一段视频后点击暂停录制按钮,停止录制视频,然后在选择开始录制,进行录制下一段视频即可。
转场
静态转场:
静态转场的时候参照物不是变的。
如果你想做出秒换服装的效果,就必须是除了服装款式以外,屏幕内其他东西都保持不变,包括本人的动作表情之类的因素也要保持不变。同样的,如果想换背景,就以上一个场景的最后一个动作作为下一个场景的开始继续拍摄,这样动作看起来就是连贯的。
动态转场:
动态转场中动作要保持连贯性,连贯的含义就是上一个场景中的动作要无缝衔接到下一个场景,比如这个场景你正在做向下蹲的动作,蹲到一半暂停了,下一个场景中你也要从刚刚蹲到一半的地方继续往下蹲。
动态转场有三种,第一摄像机不动,主体动作的连贯。第二主体物不动,摄像机拍摄方向的连贯。第三主体物和摄像机都动,且前后连贯。
1、摄像机不动,主体动作的连贯
例:上一个场景中你伸出手拳头盖住摄像头,下一个场景你也要是以同样的姿势收回你的拳头,中间你可以换衣服换背景甚至换另外一个人。你还可以手伸向摄像头,暂停后切换成后置摄像头,开拍的时候手继续向前伸出去,最后看起来就像是你的手穿过了手机屏幕一样。当然了,要想最后成品效果好,除了要改变的东西变化以外,其他元素都要尽量保持不变。
2、主体物不动,摄像机拍摄方向的连贯
所谓拍摄镜头的连贯性就是比如,上一个场景用左手把手机从中间水平移动到左边,下一个场景就要用右手把手机从右边移回中间,这样最终的效果看起来就像是镜头绕了一圈。
3、主体物和摄像机都动,且前后连贯如果有另一个人帮你拍,你可以试试这种。比如你头向右看,摄像机跟着你往右拍。暂停,换另一个人另一个场景,同样让摄像机从左向右拍。最后的成果看起来就像是PPT里面有一个后一帧推走前一帧的转场效果。
操作方法:
1、进入抖音App后,打开发布视频功能。
2、在拍摄页面,点击相册,选择需要的素材。
3、选择视频,点击下一步。
4、接着点击下一步。
5、在选择音乐页面,点击特效。
6、选择转场,接着选中想要的特效,点击保存。
7、返回后,点击下一步,设置好后,点击发布,这样添加转场特效的视频就发布成功。
合拍蹭热门
合拍就是与达人一起合拍一个视频,比如最近很火的“合拍唱歌”,唱热门歌曲,一人唱一句歌词。
具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。
抖音合拍视频:https://jingyan.baidu/article/ff42efa9ee8b0dc19e2202a0.html
拍摄技巧
1、拍摄不能手抖
拍摄视频的时候千万不能手抖,手抖拍出来的视频都是模糊不清的。要时刻保持正确的对焦,这样才能拍摄出清晰的视频效果。
我们可以把手机放在支架上或使用自拍杆拍摄,这样拍摄出来的画面比较稳定。
2、学会利用光线
拍摄短视频时光线十分重要,好的光线布局可以有效提高画面质量。尤其是在拍摄人像时要多用柔光,会增强画面美感,要避免明显的暗影和曝光如果光线不清晰,可以手动打光,灯光打在人物的脸上或用反光板调节。
光线不好的地方,可以开启闪光灯功能拍摄,还可以购买个专业的外置闪光灯,自由调节外置闪光灯的亮度。
在天气好的时候,可以尝试逆光拍摄,在拍摄界面可以对准高光区域进行测光,即可拍出艺术感十足的剪影大片。
3、切换场景
在拍摄视频之前要确定好自己拍摄的主题是什么、内容是什么,根据视频内容来选定拍摄场景,并且,我们可以根据视频的内来换多个拍摄场景。如可以从远处将镜头推近,或者可以从近处将镜头拉远,甚至可以斜着拍,来避免视频过于单调,让视频画面更加生动。根据不同的拍摄手法与拍摄场景来不断丰富自己视频的内容。
4、提高发布作品的清晰度
①使用手机原相机拍摄:
手机相机设置1080P HD,60fps;
用剪映加美颜,调节参数亮度+10、对比度+10、饱和度+10、色温-8、锐化+60;
导出设置调1080P 60fps;
②用抖音相机拍摄:降低曝光、清晰度调到最高;
打开画质增强;
发布设置点击高清发布;
③真人出镜用轻颜相机APP拍摄,补光灯补光。
后期剪辑
拍摄视频的时候有些技巧需要使用视频剪辑软件,我们可以选择剪映进行操作。
比如说视频变速功能,就可以在剪映里面制作出来。
打开剪映,点击页面中的加号按钮。
选择最下方的剪映工具栏对视频素材【剪切、配音和加特效】。
点击视频编辑条使用下方编辑工具箱【分割、变速和添加动画】。
选择视频,点击变速,可以调整视频播放的速度。
点击添加音频,选择自己喜欢的音乐。
剪辑完成后,点击右上角的导出。
点击下方的一键分享到抖音,还可以直接打开抖音发布这个视频。
剪映操作步骤
第一、准备视频素材点击【添加到项目】导入到剪映编辑界面。
第二、选择下方的剪映工具栏对视频素材【剪切、配音和加特效】。
第三、点击视频编辑条使用下方编辑工具箱【分割、变速和添加动画】。
第四、点击【添加音频】选择音乐为视频加入背景音乐。
第五、点击动画设置视频片段转场动画效果。
第六、视频制作完成后设置分辨率点击【导出】按钮即可。
准备视频素材点击【添加到项目导入】到剪映编辑界面。
网上有很多剪映的功能教程,如果想学习更多剪辑方式,可以在网上观看一些网络教程,简单易学。
教程推荐:
剪映基础入门
https://bilibili/video/BV1eP41157vE/?p=2&spm_id_from=pageDriver
一小时学会剪映
https://bilibili/video/BV1Gz4y1Z7ug/?spm_id_from=333.337.search-card.all.click
发布视频
视频拍摄好了之后我们可以观看下视频,然后把不合适的地方剪切掉,把视频剪辑一下,让视频看起来更加完善,这样就可以发布了。
发布视频的时候还可以添加热点标签,在发布视频的页面可以点击“添加标签”,然后根据视频内容选择标签,这样也可以带来一部分流量,最后点击发布就行。
%3Chowto_content%3E[{"type":"paragraph","attrs":{"is_abstract":true},"children":[{"type":"text","text":"抖音是一款可以拍摄短视频的音乐创意短视频社交软件,也是目前最火的短视频APP,当我们看到那些视频的时候,内心一定有想要创作的想法。","id":""}],"text":"","id":"FoWKdc2MmoeKqWxQJjncMzECnQf"},{"type":"heading","attrs":{"level":1},"children":[{"type":"text","text":"前期筹备","id":""}],"text":"","id":"KKKydOkUKowg8oxaeaPcV8fdn7f"},{"type":"paragraph","children":[{"type":"text","text":"拍摄抖音需要先确定我们的拍摄主题,然后再根据主题来进行脚本创作。一般拍摄主题是根据我们的账号定位来确定的,这两者是息息相关的。","id":""}],"text":"","id":"CwQyd602coKGCExnJA2cbEIknwo"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"账号定位","id":""}],"text":"","id":"T0KgduMeKoYcEqxAL6qcbcPDnjb"},{"type":"paragraph","children":[{"type":"text","text":"如果我们仔细观察就会发现抖音上面的大号都有各自的特色,但内容上却都是统一的。比如抖音账号“虎哥说车”,他的定位就是说车的,所以他发布的内容全部是跟汽车有关系的;比如账号“惠子”,她就是靠颜值吸引粉丝的,所以她发布的就是自己的美颜视频;比如账号“","id":""},{"type":"text","text":"郭聪明","id":""},{"type":"text","text":"”就是唱歌的,那么他发布的都是自己的歌曲。","id":""}],"text":"","id":"LUCwdIe48oai8sxaofIcAbbynYe"},{"type":"paragraph","children":[{"type":"text","text":"所以我们才说,拍视频之前需要先明确视频的主题是什么,主题往往是跟账号定位有一定关联的。","id":""}],"text":"","id":"PuGKdCiyioIKq0xIjmFct5FWn2c"},{"type":"paragraph","children":[{"type":"text","text":"短视频的主题要十分具体,才能开始接下来的拍摄工作。具体我们可以从","id":""},{"type":"text","text":"两个方面","id":""},{"type":"text","text":"来考虑。","id":""}],"text":"","id":"E6Oed6om0oKggKxCoYpc61CHn2e"},{"type":"paragraph","children":[{"type":"text","text":"1、选题是否符合作者的个人领域;","id":""}],"text":"","id":"Cus6dWg6SoeOQIxmCNWcCsLfn0d"},{"type":"paragraph","children":[{"type":"text","text":"针对创作者本人擅长方向,我们定位的时候就选择适合自己的领域,比如我们擅长做美食,那么抖音视频号定位就可以是专做美食的,我们拍摄的视频内容也要选择同领域。","id":""}],"text":"","id":"A6EwdsOyOo4ggSxAXk7cr4eznrc"},{"type":"paragraph","children":[{"type":"text","text":"2、主题的内容选择。","id":""}],"text":"","id":"Yk6AdWyIcou20Kx2bpccrb32nRh"},{"type":"paragraph","children":[{"type":"text","text":"确定主题建议从个人擅长内容以及当下的热点来进行考虑。","id":""}],"text":"","id":"HmsMd6oUaoEswExEFEjc241Tnjf"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"拍摄脚本","id":""}],"text":"","id":"Vy0ed2GGqo8OI4xsn64ckRgLnef"},{"type":"paragraph","children":[{"type":"text","text":"拍摄抖音视频之前,我们需要先设计好拍摄的脚本,把拍摄的流程先构思好,还有拍摄用到的台词、文案都提前准备好,这样才可以拍出高质量作品。","id":""}],"text":"","id":"QwW4dYSWGoMCuux8xgGco4NmnGe"},{"type":"paragraph","children":[{"type":"text","text":"我们寻找灵感的时候可以通过豆瓣点评、知乎等渠道寻找,最好把每个人物的性格和关系搞清楚,考虑好每个场景、细节和表情,也可以参考借鉴优秀的视频作品来编写脚本。","id":""}],"text":"","id":"CUIedE6mCo2yuWxE5LZcZ0CFnhd"},{"type":"paragraph","children":[{"type":"text","text":"短视频脚本是故事的发展大纲,是指拍摄视频所依靠的大纲底本。","id":""}],"text":"","id":"QomydiWecoY2W6xc97VcOSEDnYb"},{"type":"paragraph","children":[{"type":"text","text":"一个最基本的短视频分镜头脚本主要包含了:摄法、景别、内容、台词等内容,那么我们在撰写短视频脚本时,也可以根据自己制作短视频的需求,酌情添加或者删减,根据脚本模板,填充内容。","id":""}],"text":"","id":"OYiQdmCugoWOKMxwn6ocwrMgnGc"},{"type":"paragraph","children":[{"type":"text","text":"短视频脚本创作的6大要素一般包含以下内容:短视频主题、镜头景别、画面内容、台词、时长、运镜。","id":""}],"text":"","id":"YEMwdKCgOocoUsxYjAaccinAn8c"},{"type":"paragraph","children":[{"type":"text","text":"1、短视频核心内容","id":""}],"text":"","id":"CYUAdkmSIoygguxcjGpcD8nhn2c"},{"type":"paragraph","children":[{"type":"text","text":"抖音短视频脚本撰写的第一步就是根据拍摄主题确定核心内容。","id":""}],"text":"","id":"Ss6kdc2GUoYoAux0inaclitLn3e"},{"type":"paragraph","children":[{"type":"text","text":"无论你想做一个感人的故事,还是记录生活的一天,都要在脚本中明确,后期的剧情的展开需要围绕核心内容。","id":""}],"text":"","id":"EaYOdguI0oeYcqxymQwcVdOxntc"},{"type":"paragraph","children":[{"type":"text","text":"2、台词","id":""}],"text":"","id":"ZG06dm2aGogGYExO8wjcfxdknVd"},{"type":"paragraph","children":[{"type":"text","text":"台词对于抖音短视频而言,是画龙点睛的作用。建议大家在60s的短视频中,尽量不要让文字超过180个字,不然听起来会特别的累。","id":""}],"text":"","id":"Twayd2ceKoeiwkxuUetcpqS0nXf"},{"type":"paragraph","children":[{"type":"text","text":"3、镜头景别","id":""}],"text":"","id":"QyEgdm44aoa8o6xM88acrJO4niW"},{"type":"paragraph","children":[{"type":"text","text":"这就是拍摄的时候,选择用远景、全景、中景、近景、特写中的哪一种。","id":""}],"text":"","id":"C8eadmwiqoWs0kxxNFUc4ZB3nkl"},{"type":"paragraph","children":[{"type":"text","text":"以拍摄人物为例的话:","id":""}],"text":"","id":"J4aUdIcm8oG4OKxq8AocsNW7nYd"},{"type":"paragraph","children":[{"type":"text","text":"远景:把整个人和环境拍摄在画面中,常用来表现事件发生的时间、环境等场景。例如:办公室人物。","id":""}],"text":"","id":"TkOodWKomocUq4xoLSXcbvQGnkb"},{"type":"paragraph","children":[{"type":"text","text":"全景:较远景偏近一点,常用来表现人物的全身动作,或者是人物之间的关系。例如:舞蹈短视频。","id":""}],"text":"","id":"BuCodyA6coOWO2xi0yjc0W6invd"},{"type":"paragraph","children":[{"type":"text","text":"中景:拍摄人物膝盖至头顶画面,重点在于显示人物的形体动作。","id":""}],"text":"","id":"SS2YdeaqWoUCsGxSqxjcZYS4nff"},{"type":"paragraph","children":[{"type":"text","text":"近景:指拍摄人物胸部以上至头部的部位,常用来表现表情、神态等细微动作。例如:毛光光柜姐形象。","id":""}],"text":"","id":"NMGMd6U6QoA4qKxeuRrcLuQmnye"},{"type":"paragraph","children":[{"type":"text","text":"特写:对人物的眼睛、鼻子、嘴、手指等细节进行拍摄,适合用来表现需要突出的细节。例如:美妆产品手部展示。","id":""}],"text":"","id":"NiIgd62SWoa0uGxAlnDcaEP7nwd"},{"type":"paragraph","children":[{"type":"text","text":"根据不同的主题要求,抖音短视频脚本中所使用的景别是有所区别的,这方面的内容需要大家有更多的学习经验积累。建议大家上网下载一些教程进行学习。","id":""}],"text":"","id":"V8okd0gqwoWMsoxcP4wcQHrQnJh"},{"type":"paragraph","children":[{"type":"text","text":"4、画面内容","id":""}],"text":"","id":"J6i8dEiy2om4m6xgp8HchCBNnfg"},{"type":"paragraph","children":[{"type":"text","text":"内容就是把你想要表达的东西通过各种场景方式进行呈现,即拆分剧本,把内容拆分在每一个镜头里面。","id":""}],"text":"","id":"Hs2EdgwAcoigw6xWeRhcGVO1nWb"},{"type":"paragraph","children":[{"type":"text","text":"5、拍摄时长","id":""}],"text":"","id":"JEEKdagikog2OkxyELYcgNRQnsg"},{"type":"paragraph","children":[{"type":"text","text":"抖音短视频脚本中的时长指的是单个镜头的时长。建议大家提前标注清楚,方便后期剪辑的时候,更快找到重点,提高工作效率。","id":""}],"text":"","id":"POacdQYWCoesq0xisupcaPPTnFc"},{"type":"paragraph","children":[{"type":"text","text":"6、运镜","id":""}],"text":"","id":"Eusqd8MKGoC8mWx3ZehczWTBnCA"},{"type":"paragraph","children":[{"type":"text","text":"运镜指的就是镜头的运动方式。","id":""}],"text":"","id":"GCqqdoawQo2EkAxm0lUcNNdMnWh"},{"type":"paragraph","children":[{"type":"text","text":"\"推\"","id":""}],"text":"","id":"PESodqIE8oISqqxEDHmcSofUnLb"},{"type":"paragraph","children":[{"type":"text","text":"\"推\"是最常见的一种运镜技巧。在拍摄的时候,镜头缓慢向前移动,不断地推进,靠近拍摄主体,拍摄主体在画面中的比例逐渐变大。这种运镜技巧能够起到聚焦、突出拍摄主体的作用。比如要拍摄一个人物,镜头向前推进的过程中,人物在画面中的比例逐渐变大,让人物更中突出。","id":""}],"text":"","id":"NImIdIOcko4QO8xUHTCcWlhnnVc"},{"type":"paragraph","children":[{"type":"text","text":"即使是拍摄没有主体的场号,“推”的运镜方式也会让视频更有代入感。","id":""}],"text":"","id":"H2G0dww6koKKsuxQhXWcR0AHn5g"},{"type":"image","attrs":{"height":334,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/59ab5804423042d2ac43741632779fbf","width":639},"text":"","id":"RAssdWUAWoCsCwxXNWbc3McKnuj"},{"type":"paragraph","children":[{"type":"text","text":"“拉”","id":""}],"text":"","id":"NCgsdieUwoekS4xistqczZZNnxf"},{"type":"paragraph","children":[{"type":"text","text":"“拉”与“推”的运镜方式刚好相反。在拍的过程中,镜头逐渐向后拉远,让镜头远离拍摄主体,成片的视觉效果也与“推”相反。“拉”的运镜技巧能够起到交代环境、突出现场的作用,让看视频的人了解拍摄主体所在的环境特点,增加画面的氛围。","id":""}],"text":"","id":"Zam6d4AkMo2MEuxQP82cPl9Fnmd"},{"type":"paragraph","children":[{"type":"text","text":"“转”","id":""}],"text":"","id":"WUWWdQmQsoSUK0xgboYcjLsmn7b"},{"type":"paragraph","children":[{"type":"text","text":"“转”的运镜技巧,能给视频增加一种独特的视觉效果。其拍摄方法也很简单,常见有两种操作方式。","id":""}],"text":"","id":"KQWcdmmaaoQykKxCsQOcf1Lxnbd"},{"type":"paragraph","children":[{"type":"text","text":"第一种是站在原地拍摄,在拍摄过程中旋转镜头,旋转角度没有特定的要求,但是在拍摄素材的时候尽量拍摄360度,以方便后期剪辑的时候截取素材。此时如果选择的角度不够。后期就无法增加素材。","id":""}],"text":"","id":"Wwo4dMaAoowuYYxiWINcUZLVnff"},{"type":"paragraph","children":[{"type":"text","text":"","id":""}],"text":"","id":"NS4GdiIyooaUq6x0CYNc99Eunmc"},{"type":"image","attrs":{"height":438,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/1ecf50ab4efd4534ade7819d8580ea87","width":606},"text":"","id":"A6S6diOk2oG8SGxYd18cPVeanwb"},{"type":"paragraph","children":[{"type":"text","text":"","id":""}],"text":"","id":"US0sdgScyo8wQ2xmaPycHi2Anhg"},{"type":"paragraph","children":[{"type":"text","text":"第二种是围绕着拍摄主体进行旋转拍摄,这种方式能全方位地展现拍摄主体。旋转拍摄的时候,因为是动态拍摄,所以要控制好移动的速度。","id":""}],"text":"","id":"NQYEdsOiQoUwmsx631hc860bnce"},{"type":"paragraph","children":[{"type":"text","text":"","id":""}],"text":"","id":"TaikdYKWYo0E8axQHwqcFp2encQ"},{"type":"image","attrs":{"height":329,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/2e4c737504eb4009b16bf4cac57bcec4","width":580},"text":"","id":"ZEE4dKKeyoE60cxW6DCcVn8YnIg"},{"type":"paragraph","children":[{"type":"text","text":"“移”","id":""}],"text":"","id":"ScMSdqYAgoaSc2x48D9c1QuKnzA"},{"type":"paragraph","children":[{"type":"text","text":"“移”可以理解为平行移动,移动的方向可以是横向,也可以是纵向,或者倾斜一定的角度。但是移动的轨迹要以直线为主,不要无规则地移动。","id":""}],"text":"","id":"GO26dwQG4oQguwx0m59cnWsEnOe"},{"type":"paragraph","children":[{"type":"text","text":"单个镜头拍完就停止,然后再拍摄下一个镜头,单个镜头里尽量不要使用多种运镜技巧,因为会造成混乱的视觉效果。","id":""}],"text":"","id":"OaoIdkocKowUc0xQfDlcKrxgnHc"},{"type":"paragraph","children":[{"type":"text","text":"比如拍摄辽阔的自然风光,可以采用横向的水平移动;拍摄高大的主体如建筑、山峰等,可以采用纵向移动;拍摄小场景也可以使用这一运镜技巧。它适用的场景很多,但是一定要注意保证手机是直线移动而不是原地不动的。","id":""}],"text":"","id":"OoWWdeQQsoqyYWx8fRocvvSinlh"},{"type":"image","attrs":{"height":303,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/f9b7be581021431a9405fd2e259ade9e","width":571},"text":"","id":"RSyAdyccEoEcOsxrw7ecRCAUngC"},{"type":"paragraph","children":[{"type":"text","text":"“穿”","id":""}],"text":"","id":"EGSOdYqc8oKUMoxFmQrcSMGBnzo"},{"type":"paragraph","children":[{"type":"text","text":"“穿”可以理解为穿越、穿过的意思,当拍摄的时候,需要在手机和拍摄主体之间寻找一个前景,因为要穿越的就是这个前景。","id":""}],"text":"","id":"SSUsd0maWoqKuix8xezc3s8fnOd"},{"type":"paragraph","children":[{"type":"text","text":"“穿”的运镜技巧可以让视频画面增加层次感和空间感,因为有了前景的衬托,有了远近的对比,才能让画面有身临其境的代入感。但是前景不能喧宾夺主,它只是起到衬托的作用,比如栏杆的缝隙、门窗、树叶的缝隙等都可以作为前景来使用。拍摄的时候结合“推”和“拉”的运镜技巧,穿过前景,然后聚焦在拍摄主体上。","id":""}],"text":"","id":"F46ydqiEGo2oc8xWUnxc9Uchn4g"},{"type":"image","attrs":{"height":261,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/675c248e8af34511b31d779c5ee2a2fc","width":640},"text":"","id":"Y6I6d2QooogWoSxsRhHco7rBnNg"},{"type":"paragraph","children":[{"type":"text","text":"“跟”","id":""}],"text":"","id":"TGecdQ400oSi0axUjf4cvqExnFg"},{"type":"paragraph","children":[{"type":"text","text":"“跟”的运镜技巧可以理解为跟随,拍摄移动的主体时,镜头一直跟随拍摄主体移动。比如在后边跟随拍摄一个向前走动的人,或者在前面拍摄向镜头走过来的人。镜头和主体同步运动,可以保证拍摄主体在画面中的比例是不变的,跟随拍摄也能让画面增加代入感。","id":""}],"text":"","id":"LmqEdUuaKouoQ0xIlJAcB1Fcnne"},{"type":"image","attrs":{"height":332,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/edfa1c58565d4652b28ac0fb19b00dbf","width":640},"text":"","id":"HcWqdwyiEoIUi2xsxlBcsLuOnte"},{"type":"paragraph","children":[{"type":"text","text":"“摇”","id":""}],"text":"","id":"AyOedS0oIokWKSx6MUncnAhonvf"},{"type":"paragraph","children":[{"type":"text","text":"“摇”的拍摄方法和效果与“移”类似,但是拍摄的时候,摇镜头是指原地不动地旋转手机或者相机,镜头是弧形移动的。比如站在原地拿好手机,镜头从左向右拍摄,手机移动的路径是一个弧形,也可以向上拍摄,记住关键点就是原地不动。“摇”会逐一展示镜头前的场景,让画面更有代入感。","id":""}],"text":"","id":"BaKOdyouGocmMKxgihwcJ8WSnmr"},{"type":"image","attrs":{"height":346,"note":[{"type":"text","text":"拍摄脚本","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/94a89329977445fd9d1747949be5736c","width":500},"text":"","id":"KESIdICCsogcCqxg76OcX0QInIe"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"","id":""}],"text":"","id":"REwkdGyuQo0OqCxa7fycZkzHnL3"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"脚本怎么写","id":""}],"text":"","id":"N8yAdQy20oKicwxuiXOcCtkInmd"},{"type":"paragraph","children":[{"type":"text","text":"写脚本之前需要先了解脚本的结构,这样写出来会比较符合拍摄,下面我们先来介绍下脚本的结构。","id":""}],"text":"","id":"H4cSdmuEMo2Y8mxCKneceL3lnff"},{"type":"paragraph","children":[{"type":"text","marks":[{"type":"strong"}],"text":"脚本的结构","id":""}],"text":"","id":"So0AdGc0UoIywKx252nc8x4nnuc"},{"type":"paragraph","children":[{"type":"text","text":"脚本的整体结构分为:开头吸引观众目光、中间进入主题内容、最后深化主题内容三部分。","id":""}],"text":"","id":"Io0idG2ugoMeeqx8d2IcfKpgnKg"},{"type":"paragraph","children":[{"type":"text","text":"1、再好的脚本,也需要遵循一定的主题和定位,来明确写作的方向;以30秒为例,当一条视频被人点击之后,如果在开头的5秒种内无法吸引兴趣,这条视频可能就直接被人划过去转向下一条;","id":""}],"text":"","id":"GcAYdwCaWoWs0kxshjlcXIjCnah"},{"type":"paragraph","children":[{"type":"text","text":"所以在脚本的一开头,我们要把吸引观众的内容先呈现出来,这样才能吸引观众看下去。","id":""}],"text":"","id":"XE4Gda468ogE4Mxuy8IcXPIfnDg"},{"type":"paragraph","children":[{"type":"text","text":"2、接下来的10秒钟,需要进入主题,包装亮点,继续吸引受众观看;","id":""}],"text":"","id":"EG4AdesCwowQ6CxuI4qcCRn5nsc"},{"type":"paragraph","children":[{"type":"text","text":"3、最后的15秒,需要将主题深化,带来一些有意思的见解,并与受众互动、引导点赞、转发和关注等行为。","id":""}],"text":"","id":"VeyudAWAyoWoogxQz4xcKmNRnuh"},{"type":"paragraph","children":[{"type":"text","marks":[{"type":"strong"}],"text":"脚本","id":""},{"type":"text","marks":[{"type":"strong"}],"text":"写作的基本步骤:","id":""}],"text":"","id":"OsokdoUSKoeAISxONVVcWPKQnfG"},{"type":"paragraph","children":[{"type":"text","text":"1、先介绍故事梗概。","id":""}],"text":"","id":"TWE4d6GauoK4mQxItXGcrhG0nJh"},{"type":"paragraph","children":[{"type":"text","text":"2、写出分集发展大纲。","id":""}],"text":"","id":"EEoqdwA46oqygaxERsGc9Npjngd"},{"type":"paragraph","children":[{"type":"text","text":"3、剧情细化到每个场景,人物对话(动作、表情、心理活动、人物之间的关系等提示)。","id":""}],"text":"","id":"XA6adgOOuok8SwxXlgDcrZJrnoT"},{"type":"paragraph","children":[{"type":"text","text":"脚本(偏重于镜头的剧本)的写作格式如下:","id":""}],"text":"","id":"HcgWdum2QoEySuxYjWdcsP3LnTe"},{"type":"paragraph","children":[{"type":"text","text":"第一场 地点 日或夜 内或外","id":""}],"text":"","id":"N8q8dmciooEA0kxwdeFcecNqnue"},{"type":"paragraph","children":[{"type":"text","text":"A:(台词)","id":""}],"text":"","id":"GYiudWGO2oGCIexkVBLcPqk3nrf"},{"type":"paragraph","children":[{"type":"text","text":"B:(台词)","id":""}],"text":"","id":"UiQKduYCIoaOGExkXYOc4kFBnWf"},{"type":"image","attrs":{"height":624,"note":[{"type":"text","text":"脚本怎么写","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/2bf6caacb09a4dffb372999e12f68a89","width":1193},"text":"","id":"BskMdoACYoeem0x4uwkcOSxtnpd"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"创作常用方法","id":""}],"text":"","id":"OIsCdum0AoWomOxIridcryRBn2e"},{"type":"paragraph","children":[{"type":"text","text":"1、嵌套法","id":""}],"text":"","id":"OSywdG6sqo00sgxAhipcr35QnEb"},{"type":"paragraph","children":[{"type":"text","text":"嵌套法的目的,是用来解决视频可能出现的3个问题:","id":""}],"text":"","id":"LCIIdEIUso04C0xw5H2cCfQonSc"},{"type":"paragraph","children":[{"type":"text","text":"1)信息量单薄;","id":""}],"text":"","id":"IuEed6oiaoo82oxqOaOcWTEznKg"},{"type":"paragraph","children":[{"type":"text","text":"2)用户缺乏吐槽点;","id":""}],"text":"","id":"TyGadQUAsoUc0ixSIeYcq7mgn0e"},{"type":"paragraph","children":[{"type":"text","text":"3)视频缺乏耐看性;","id":""}],"text":"","id":"V4WGdgaUKowSsix4CG5cpdTSnle"},{"type":"paragraph","children":[{"type":"text","text":"那么如何实现嵌套呢?","id":""}],"text":"","id":"J0EWdsm4QoIYmkxOegBck95Knsh"},{"type":"paragraph","children":[{"type":"text","text":"1)制作一个故事脚本;","id":""}],"text":"","id":"Z0cSdIEaAoQ6kwxme2QcoaN4ngb"},{"type":"paragraph","children":[{"type":"text","text":"2)制作第二个故事脚本;","id":""}],"text":"","id":"YgCUdKMGioCY8cxmuPZch0Bdnzh"},{"type":"paragraph","children":[{"type":"text","text":"3)通过一个嵌入点,把第二个故事脚本嵌入第一个脚本;","id":""}],"text":"","id":"HiM8dGeCOoSMuAxS4FfcAopmnOf"},{"type":"paragraph","children":[{"type":"text","text":"4)如此循环往复,直至无穷;","id":""}],"text":"","id":"HSmYdKK4koA86CxcZZrcJELRnBg"},{"type":"paragraph","children":[{"type":"text","text":"2、","id":""},{"type":"text","text":"代入法","id":""}],"text":"","id":"SKs6dsauuoOmYix8or6cx6nnn5b"},{"type":"paragraph","children":[{"type":"text","text":"先给主题构建一个“代入法”的场景,可以让团队在这个“画框”内,不断带入各种各种元素,实现轻松创意复制。比如主题是“卖车”,大家可以想象,卖车有哪些环节好玩、有趣、有冲突:","id":""}],"text":"","id":"VYOudwouSouA4Yxof7Icq91dnYf"},{"type":"paragraph","children":[{"type":"text","text":"1)发传单可以有冲突——花式发传单;","id":""}],"text":"","id":"LQqkdc4seoggAsxEZo8c0zHMnph"},{"type":"paragraph","children":[{"type":"text","text":"2)顾客电话邀约有冲突——顾客的花式拒绝,顾客的花式勾搭;","id":""}],"text":"","id":"EwO6diWEMoYComxyl3Zc1ycXngd"},{"type":"paragraph","children":[{"type":"text","text":"3)到店接待有冲突——新来的小姐姐这样接待客人;","id":""}],"text":"","id":"Cg0EdgAueocgWAxccILchnYqn4K"},{"type":"paragraph","children":[{"type":"text","text":"3、四维还原法","id":""}],"text":"","id":"WgG2dS8sCoCAgcxcUfXcB2Ndn7d"},{"type":"paragraph","children":[{"type":"text","text":"1)内容还原把热门视频用文字描述一遍,因为在展开过程中,无数细节会被记录并展开出来,信息量得到完整呈现。","id":""}],"text":"","id":"Y6W0da02IoKOYexg0tTc6U7VnOa"},{"type":"paragraph","children":[{"type":"text","text":"2)评论还原看看抖友们,看了这个视频是什么反应。","id":""}],"text":"","id":"NMuCdesqGoiMcgxwVsKcAxg3n5c"},{"type":"paragraph","children":[{"type":"text","text":"3)身份还原通过对受众、点赞回复用户的身份反查,找到他们是谁,他们关心什么,他们为什么关心这个爆款视频。","id":""}],"text":"","id":"ZesudMeCUoY2YkxUsJkcYMmAn9e"},{"type":"paragraph","children":[{"type":"text","text":"4)策略逻辑还原。这个视频是给谁看的?主流用户是谁?发什么给他们看?","id":""}],"text":"","id":"C0g2dC8i4okEwux83I5c63ahnhh"},{"type":"paragraph","children":[{"type":"text","text":"4、","id":""},{"type":"text","text":"模仿法","id":""}],"text":"","id":"NMaIdCsuyoyAcMxCQPLcrrRCnjc"},{"type":"paragraph","children":[{"type":"text","text":"1)随机模仿看见什么视频火,自己照样子拍一个,比如最近两天比较火的大头、踢瓶盖。","id":""}],"text":"","id":"BmwOdKaqioiQoUxsxRWcmPy5nCh"},{"type":"paragraph","children":[{"type":"text","text":"2)系统模仿找到对标的账号、IP,抖音内外都可,分析其经典桥段、套路,不等它在抖音火,就模仿拍摄一个。","id":""}],"text":"","id":"K4QCdQgAgogGqYxMFiFcTFaZnWh"},{"type":"paragraph","children":[{"type":"text","text":"如果看了上面的介绍还是不知道脚本怎么写,那么可以看看专门介绍写脚本的课程,这样更加清楚、直接。","id":""}],"text":"","id":"XmW8dsqScoo6gYx8Pxxcr5hynAg"},{"type":"paragraph","children":[{"type":"text","text":"脚本分镜头创作方法:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1QZ4y1r7tQ/?spm_id_from=333.337.search-card.all.click"},"children":[{"type":"text","text":"https://bilibili/video/BV1QZ4y1r7tQ/?spm_id_from=333.337.search-card.all.click","id":""}],"text":"","id":""}],"text":"","id":"VYG2dw6sSoui0oxAtnQcLiU6npc"},{"type":"paragraph","children":[{"type":"text","text":"短视频脚本创作:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1c3411v7Cw/?spm_id_from=333.337.search-card.all.click"},"children":[{"type":"text","text":"https://bilibili/video/BV1c3411v7Cw/?spm_id_from=333.337.search-card.all.click","id":""}],"text":"","id":""}],"text":"","id":"XWqSdwIcGo0igExO8MxcAy9Hnlh"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"脚本写作技巧","id":""}],"text":"","id":"AMoOdMgcaoG4sKxmie1cj18pnJc"},{"type":"paragraph","children":[{"type":"text","text":"脚本不同于其他写作形式,重点在于如何把平面语言转化为镜头语言,镜头语言不止是看得见的文字,还包括看不见的内容。脚本的写作业需要遵循一定的逻辑和步骤:","id":""}],"text":"","id":"RSYadyMAUoUIiExCwyIc5J0mnVd"},{"type":"paragraph","children":[{"type":"text","text":"1、从无到有的过程中,需要选择一个主题,根据主题来梳理脚本大纲、框架结构","id":""}],"text":"","id":"Oy8WdymkcoYSqKxuiGacxhnTnAc"},{"type":"paragraph","children":[{"type":"text","text":"2、脚本需要有贯穿全篇的主线,并且需要有必要的内容来支撑主线的发展","id":""}],"text":"","id":"IKeSdC2YSo00IYxEJqCcA5LZnqd"},{"type":"paragraph","children":[{"type":"text","text":"3、场景的包装,人物角色的设定,场景和人物的协调表现","id":""}],"text":"","id":"BWm2dEoo2oY48MxyGXrcgTVMnFx"},{"type":"paragraph","children":[{"type":"text","text":"4、视频通常会受到时间长度的限制,需要在有限的时间内,安排上精炼、合适、精准的内容,并需要主要前后的逻辑关系","id":""}],"text":"","id":"MMgCd6QOqoigSGxxBy0clpu1nwR"},{"type":"paragraph","children":[{"type":"text","text":"5、点明主题,深化主题内涵,引起精神共鸣或设置悬念为观众带来思考","id":""}],"text":"","id":"H2esdIIW8oMgmAx4Rrjctb5kn7g"},{"type":"paragraph","children":[{"type":"text","text":"矛盾是支撑情节发展的核心要素,视频内容的丰富离不开矛盾的设置。","id":""}],"text":"","id":"OKwGdUiuioqmKexqUTlcl42PnYf"},{"type":"paragraph","children":[{"type":"text","text":"1、结合场景、人物、情节等因素,设置好冲突和转折,“意料之外情理之中”,可以是人物的冲突、语言的冲突、场景的冲突、肢体的冲突、表情的冲突等等;需要结合联想、谐音、一词多意、双关、旧词新解、反转等手法","id":""}],"text":"","id":"KGScd8QQgoaksmxAHAzc9MItnxe"},{"type":"paragraph","children":[{"type":"text","text":"2、需要掌握一定的常用题材、场景、拍摄手法","id":""}],"text":"","id":"NqOodY8Ewo8IYWxyOuycEJrYntd"},{"type":"paragraph","children":[{"type":"text","text":"3、来源于生活,反映生活,服务生活","id":""}],"text":"","id":"KWcedIc0goQ6MOxDWUgcdp7inIg"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"脚本课程推荐","id":""}],"text":"","id":"T0mqdc6MioYEuwxOkdYcs24Gnbg"},{"type":"paragraph","children":[{"type":"text","text":"抖音短视频脚本简单几步,小白也能快速上手:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1Dp4y1h7ve/"},"children":[{"type":"text","text":"https://bilibili/video/BV1Dp4y1h7ve/","id":""}],"text":"","id":""}],"text":"","id":"WeYidcqoqoW0S0xbhlMcQRkWn7d"},{"type":"paragraph","children":[{"type":"text","text":"短视频制作脚本撰写:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/av501191474/?p=16"},"children":[{"type":"text","text":"https://bilibili/video/av501191474/?p=16","id":""}],"text":"","id":""}],"text":"","id":"Rkm4dCgWqo0ysqxSUA2cuoMInsd"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"分析同行内容","id":""}],"text":"","id":"QEA6dIES0o2ygExM1X6cCYOZnJe"},{"type":"paragraph","children":[{"type":"text","text":"我们在拍摄短视频之前可以先分析下同行拍摄的内容,学习学习经验,这样会有利于自己拍摄出好的作品。","id":""}],"text":"","id":"J2Kedy0Qqoqi42xEt6ncMJtHnRd"},{"type":"paragraph","children":[{"type":"text","text":"首先我们要分析他为什么火?","id":""}],"text":"","id":"AamqdeMmqoO6WQxCW9QczsAnnNh"},{"type":"paragraph","children":[{"type":"text","text":"我们可以将点赞量大于10W的视频都收集起来,作为重点分析的对象,带着以下四个问题去分析:","id":""}],"text":"","id":"KE68daAimo0KimxWojKcz5fxnfd"},{"type":"paragraph","children":[{"type":"text","text":"①该视频的视频形式我能做出来吗?","id":""}],"text":"","id":"AW64dSmKOokIi8x8jJfcTK2Pnmd"},{"type":"paragraph","children":[{"type":"text","text":"②该视频内容我能否做出来?","id":""}],"text":"","id":"NEQudEWKioisGcx80T9cKuDXntc"},{"type":"paragraph","children":[{"type":"text","text":"③这类账号如何变现?我是否有资源?","id":""}],"text":"","id":"E6wyduuwqouWw4xYJv6cZilFnZc"},{"type":"paragraph","children":[{"type":"text","text":"④我能否长时间做这类视频?","id":""}],"text":"","id":"JaiUdMU0Qos2iKxeIGMcaKzkn0e"},{"type":"paragraph","children":[{"type":"text","text":"给大家一个好用的表格,用来分析数据很方便,把标题、点赞量、评论量、转发量、视频链接作为表头,如下所示。","id":""}],"text":"","id":"X8kSdsQCMoy2q0xoBXKcE0BHnmc"},{"type":"image","attrs":{"height":130,"note":[{"type":"text","text":"分析同行内容","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/4a5b9152ed4c46919d772341113269bf","width":896},"text":"","id":"O84GdEkS0oGSaOxe8pecHLKdnmd"},{"type":"paragraph","children":[{"type":"text","text":"前期拍摄视频的时候,我们如果不知道怎么制作内容,那么就可以借鉴我们的分析成果,模仿这些优质的视频,后期再开始创新。","id":""}],"text":"","id":"BGMydkOYMo8QqoxAjCRcQVLtnAg"},{"type":"paragraph","children":[{"type":"text","text":"注册账号并编辑好资料后,就可以上传视频了。","id":""}],"text":"","id":"RoO4dwsAiogqSCxmMMzcUb2pnng"},{"type":"paragraph","children":[{"type":"text","text":"对于新手来说,想要短时间内上热门,最好的方法就是模仿,我要模仿那些点赞量高的视频。","id":""}],"text":"","id":"FKi8dYem2oE0aoxIlp8cwT6jnfe"},{"type":"paragraph","children":[{"type":"text","text":"这里有两点给大家说:","id":""}],"text":"","id":"X4UIdkkYqoQ8yaxILiHcX4fpnHf"},{"type":"paragraph","children":[{"type":"text","text":"①平台的风气就是模仿,大家可以发现,只要有一个梗上了热门,就会出现大量的模仿者,而他们模仿的视频,还依旧能上热门。","id":""}],"text":"","id":"PoIodMosuouiykxcZfTcCJr6n0d"},{"type":"paragraph","children":[{"type":"text","text":"②热门视频是经过用户的检测的,模仿的作品,大概率会上热门,能快速试错。","id":""}],"text":"","id":"BCoMdGM4QouIIQxOQlvcAAs0nld"},{"type":"heading","attrs":{"level":1},"children":[{"type":"text","text":"视频拍摄","id":""}],"text":"","id":"QsqwdQ8uiowicyxgfFXcMEDDnAh"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"拍抖音的步骤","id":""}],"text":"","id":"EqS4dMg2yoY8CsxshH7cwdTJnSf"},{"type":"paragraph","children":[{"type":"text","text":"1、打开手机软件商店,点击下载,然后下载抖音APP,安装抖音APP。","id":""}],"text":"","id":"W0MGdeSoqoK6KAxhhvWcv9JBnmn"},{"type":"image","attrs":{"height":768,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/16f9744e92bb4ca0b743149be1e596d8","width":393},"text":"","id":"Ju6UdeWyIoksW0xM7IIcTLHknef"},{"type":"paragraph","children":[{"type":"text","text":"2、打开抖音App,之后点击抖音下方的加号键;","id":""}],"text":"","id":"RkqydUe2IookEmxMVQ0cX7Yqn0f"},{"type":"image","attrs":{"height":743,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/db58d8f4947b49daaf9ec63c40b72e5b","width":341},"text":"","id":"FGkqdsSo8o0oasxSaP6cTbOfn1f"},{"type":"paragraph","children":[{"type":"text","text":"3、然后点击屏幕左下方的特效或道具,接着选择想要的特效或道具;","id":""}],"text":"","id":"GOy8d480YoaYSOx4dPTcqhsWnkg"},{"type":"image","attrs":{"height":867,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/a074681cd69c41c3b3d82afa2a6db077","width":411},"text":"","id":"DQOOdQKgIoYW8yxOya1cOQiAnaf"},{"type":"paragraph","children":[{"type":"text","text":"4、点击上方选择音乐,可以添加背景音乐;","id":""}],"text":"","id":"AqSUdQ6uWo2qmGx2tyqceHbenNg"},{"type":"image","attrs":{"height":224,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/afd4b604d6fe41228c21fe97d4890a1a","width":484},"text":"","id":"RQw2dySc8oGwGwxoDZXcVzZxnHe"},{"type":"paragraph","children":[{"type":"text","text":"5、然后点击屏幕中的拍摄按钮,开始拍摄视频;","id":""}],"text":"","id":"NOSCdKgyGoUWwgxjfjcc56S2nBE"},{"type":"paragraph","children":[{"type":"text","text":"6、在拍摄完成之后,接着点击下一步;","id":""}],"text":"","id":"VK46di4oWoEeMIxAu0kccj6en4b"},{"type":"image","attrs":{"height":312,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/5ce47f2f4915469c941501b4e5f2e02d","width":623},"text":"","id":"PAOAdMim4owyYMxeirHccHTOnwd"},{"type":"paragraph","children":[{"type":"text","text":"7、最后再点击发布就可以了,这样就能发布自己拍摄的抖音小视频了。","id":""}],"text":"","id":"RMMGd0QKAoCag0xYDWFcsG7nnkh"},{"type":"image","attrs":{"height":784,"note":[{"type":"text","text":"拍抖音的步骤","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/984cd64564c843219d5ea22525e7a2ad","width":613},"text":"","id":"FqOWde4YkosI26xQxBlcDLZEnPg"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"拍摄方式","id":""}],"text":"","id":"IAGWdim6ioGSiOxqqHwcZfEPnsu"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"远程控制暂停","id":""}],"text":"","id":"Py4idmMAmoG628x4VvCcfStTnJf"},{"type":"paragraph","children":[{"type":"text","text":"拍摄视频的时候,如果手机隔得比较远,可以使用拍摄里面的“倒计时”功能。例如我们只要拍摄10s就暂停,可以将暂停拉杆拖到10s的位置处即可。然后点击“开始拍摄”拍摄,当拍摄到第10s的时候就会自动暂停。这样拍摄的时候,自己可以在手机随着自己的需求来拍摄不同的风格。","id":""}],"text":"","id":"DmoOdQ2C2oKYIyxk9SicJJYWnhf"},{"type":"paragraph","children":[{"type":"text","text":" ","id":""}],"text":"","id":"B0EadG6IOoIcwCxc584clHPmnLe"},{"type":"image","attrs":{"height":502,"note":[{"type":"text","text":"远程控制暂停","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/e79d8df6bfbb4476bbb016b98fd17874","width":615},"text":"","id":"TSi0dYCemoEUwSxccEicMYB3nQ1"},{"type":"paragraph","children":[{"type":"text","text":" ","id":""}],"text":"","id":"SyYodgu22oa2WMxw9Vvc0s2endf"},{"type":"paragraph","children":[{"type":"text","text":"具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。","id":""}],"text":"","id":"U0QwdU066oIquqx2L7CcVdDKnwe"},{"type":"paragraph","children":[{"type":"text","text":"远程控制暂停:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1PB4y1Q743/?spm_id_from=333.337.search-card.all.click"},"children":[{"type":"text","text":"https://bilibili/video/BV1PB4y1Q743/?spm_id_from=333.337.search-card.all.click","id":""}],"text":"","id":""}],"text":"","id":"EM6cdycyooAEYExaemPc5s17nWd"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"调整播放速度","id":""}],"text":"","id":"HUY0dsSago0iCQxuMRYc5aT5nqc"},{"type":"paragraph","children":[{"type":"text","text":"拍摄视频的时候可以调节播放速度,快慢速度调整就是调整音乐和视频的匹配。如果选择“快”或者“极快”,拍摄的时候音乐就会放慢,相应的视频成品中的画面就会加快;反之,如果选择“慢”或者“极慢”,拍摄时的音乐就会加快,成品中的画面就会放慢。","id":""}],"text":"","id":"Scoqdeyw6oaaUmxIsiZcmYZCnuW"},{"type":"image","attrs":{"height":449,"note":[{"type":"text","text":"调整播放速度","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/e4f5a8ac397d45e2ac186c5f9bd5fe55","width":431},"text":"","id":"DsaMdewAao66qIxeOF0cObtlnuf"},{"type":"paragraph","children":[{"type":"text","text":" ","id":""}],"text":"","id":"KEeAdGAgWom4A0x3A6scws2KnBQ"},{"type":"paragraph","children":[{"type":"text","text":"具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。","id":""}],"text":"","id":"WmCqdCgmSoeo6wxsZtGcpCvcnLd"},{"type":"paragraph","children":[{"type":"text","text":"调节播放速度:","id":""},{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1ZK411V778/?spm_id_from=333.337.search-card.all.click"},"children":[{"type":"text","text":"https://bilibili/video/BV1ZK411V778/?spm_id_from=333.337.search-card.all.click","id":""}],"text":"","id":""}],"text":"","id":"NOyCdSWgCoI8WAxYM2ccg9ljnrb"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"拍摄分段视频","id":""}],"text":"","id":"FCM2dAS4Qoecm0x9biYcbrc1nMg"},{"type":"paragraph","children":[{"type":"text","text":"抖音可以拍摄分段视频,拍摄一段视频后点击暂停,然后再拍摄另外一段视频,最后把这两段视频拼接起来成为一个完整的视频,这就是分段视频。","id":""}],"text":"","id":"PmOSdEIW0oY48Ax2hejcio3hnif"},{"type":"paragraph","children":[{"type":"text","text":"例如很多达人拍摄的“变装视频”用的就是分段视频拍摄手法。但是拍摄分段视频的时候,拍摄内容不要牛头不对马嘴,前面一个视频拍摄的是一个内容,后面的视频拍的又是另一个内容,这样会让用户看起来觉得很乱,不知道你要表达什么内容。","id":""}],"text":"","id":"BeUsdICkooMIOGxei3ccTovQnUe"},{"type":"image","attrs":{"height":724,"note":[{"type":"text","text":"拍摄分段视频","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/8e9a8fc1485a43e2a60abb0ba9b5a7eb","width":832},"text":"","id":"GQMmdWguOoKESaxqO8icvMcRnld"},{"type":"paragraph","children":[{"type":"text","text":"操作方法:","id":""}],"text":"","id":"EuG0dsscWoMG0yxWC4JcjsiNnVe"},{"type":"paragraph","children":[{"type":"text","text":"1、进入抖音App后,打开发布视频功能。","id":""}],"text":"","id":"BYeAd6KuqoEUSExk5Grc6Kgpnrf"},{"type":"image","attrs":{"height":357,"note":[{"type":"text","text":"拍摄分段视频","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/b47937053205414394cccc6b82a6b8d6","width":620},"text":"","id":"GSCkda2seo04kSxCzsocwZakndN"},{"type":"paragraph","children":[{"type":"text","text":"2、打开录制长视频","id":""}],"text":"","id":"N8qmdQkmIoMyksxqCercJJi6nRg"},{"type":"paragraph","children":[{"type":"text","text":"进入发布视频功能后,打开长视频功能。","id":""}],"text":"","id":"L2MqdaSemoY0Cyxc55hcDA2unW8"},{"type":"image","attrs":{"height":587,"note":[{"type":"text","text":"拍摄分段视频","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/7d48494eb5094df7baab3de8d7564c83","width":614},"text":"","id":"PoW0dCio8o2KUWxfS1RcJqPKnHA"},{"type":"paragraph","children":[{"type":"text","text":"3、进行分段拍摄","id":""}],"text":"","id":"NSmCdKMGOoCuiQxYR8ncRlVAnOc"},{"type":"paragraph","children":[{"type":"text","text":"进入录制视频页面后,开始录制视频,录制完成一段视频后点击暂停录制按钮,停止录制视频,然后在选择开始录制,进行录制下一段视频即可。","id":""}],"text":"","id":"UAeCduEI2oAqsQxMZ9ccVHc7nYb"},{"type":"image","attrs":{"height":481,"note":[{"type":"text","text":"拍摄分段视频","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/176065cf662f4b29b7e482e835f2de8e","width":620},"text":"","id":"W8gkdSCM6oyCKAx8JMOcQuLpnPc"},{"type":"heading","attrs":{"level":3},"children":[{"type":"text","text":"转场","id":""}],"text":"","id":"RGsGdeSu2o8s6UxWSuGct7U1ncc"},{"type":"paragraph","children":[{"type":"text","text":"静态转场:","id":""}],"text":"","id":"A6IqdqiwioO8ucxZVXdcIrXGnvu"},{"type":"paragraph","children":[{"type":"text","text":"静态转场的时候参照物不是变的。","id":""}],"text":"","id":"KoaGd822qoGqEKxGN0CcJV4Bnlb"},{"type":"paragraph","children":[{"type":"text","text":"如果你想做出秒换服装的效果,就必须是除了服装款式以外,屏幕内其他东西都保持不变,包括本人的动作表情之类的因素也要保持不变。同样的,如果想换背景,就以上一个场景的最后一个动作作为下一个场景的开始继续拍摄,这样动作看起来就是连贯的。","id":""}],"text":"","id":"QgSmdOK4ioawkuxIRBocM1Kqnpf"},{"type":"paragraph","children":[{"type":"text","text":"动态转场:","id":""}],"text":"","id":"QU2adqW6Oo2IY8xMrzFcPDnUnfg"},{"type":"paragraph","children":[{"type":"text","text":"动态转场中动作要保持连贯性,连贯的含义就是上一个场景中的动作要无缝衔接到下一个场景,比如这个场景你正在做向下蹲的动作,蹲到一半暂停了,下一个场景中你也要从刚刚蹲到一半的地方继续往下蹲。","id":""}],"text":"","id":"AAGedywwcowQCAxEJBpc6EdVnrc"},{"type":"paragraph","children":[{"type":"text","text":"动态转场有三种,第一摄像机不动,主体动作的连贯。第二主体物不动,摄像机拍摄方向的连贯。第三主体物和摄像机都动,且前后连贯。","id":""}],"text":"","id":"FSgGdKieuoSGOWxAZvyc3l6Pnde"},{"type":"paragraph","children":[{"type":"text","text":"1、摄像机不动,主体动作的连贯","id":""}],"text":"","id":"OMAKdYY4KoYOSOxghwOckdUKnOg"},{"type":"paragraph","children":[{"type":"text","text":"例:上一个场景中你伸出手拳头盖住摄像头,下一个场景你也要是以同样的姿势收回你的拳头,中间你可以换衣服换背景甚至换另外一个人。你还可以手伸向摄像头,暂停后切换成后置摄像头,开拍的时候手继续向前伸出去,最后看起来就像是你的手穿过了手机屏幕一样。当然了,要想最后成品效果好,除了要改变的东西变化以外,其他元素都要尽量保持不变。","id":""}],"text":"","id":"Rwg0dG0GQoe6oQxKX1GcsGv8npb"},{"type":"paragraph","children":[{"type":"text","text":"2、主体物不动,摄像机拍摄方向的连贯","id":""}],"text":"","id":"Rk6Gdi8MYoM2SmxeSppclPx6nSf"},{"type":"paragraph","children":[{"type":"text","text":"所谓拍摄镜头的连贯性就是比如,上一个场景用左手把手机从中间水平移动到左边,下一个场景就要用右手把手机从右边移回中间,这样最终的效果看起来就像是镜头绕了一圈。","id":""}],"text":"","id":"XS82d60oUoKi6kxe0DYcCbEQnOg"},{"type":"paragraph","children":[{"type":"text","text":"3、主体物和摄像机都动,且前后连贯如果有另一个人帮你拍,你可以试试这种。比如你头向右看,摄像机跟着你往右拍。暂停,换另一个人另一个场景,同样让摄像机从左向右拍。最后的成果看起来就像是PPT里面有一个后一帧推走前一帧的转场效果。","id":""}],"text":"","id":"N2sodqEqiouaE2x2BA9cSEpZnAg"},{"type":"paragraph","children":[{"type":"text","text":"操作方法:","id":""}],"text":"","id":"ZAwYdakWUoSiQuxGsQzcNKMqnZb"},{"type":"paragraph","children":[{"type":"text","text":"1、进入抖音App后,打开发布视频功能。","id":""}],"text":"","id":"WM8idGUaIoeSuoxOQlecmwSLnDh"},{"type":"image","attrs":{"height":357,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/ad8874948830434c9439d69109c7a67c","width":620},"text":"","id":"Ziisd2Ee8om2MGxukg3cj702nee"},{"type":"paragraph","children":[{"type":"text","text":"2、在拍摄页面,点击相册,选择需要的素材。","id":""}],"text":"","id":"PQoId6SeioI686x8dK7cipOlnok"},{"type":"image","attrs":{"height":425,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/871c83651424436bb796d6f34599435c","width":624},"text":"","id":"CM86dKwqoo62gsxgVW8caJLQn3b"},{"type":"paragraph","children":[{"type":"text","text":"3、选择视频,点击下一步。","id":""}],"text":"","id":"KKcYdMCE2oMsAwxIBi2ch7V5nzb"},{"type":"image","attrs":{"height":601,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/352ec37eb3654624836afcb077c21e21","width":635},"text":"","id":"DsEkdMEIioY8ScxhtiWcmabVnwf"},{"type":"paragraph","children":[{"type":"text","text":"4、接着点击下一步。","id":""}],"text":"","id":"CyUIdYcw6o0ym6xGgJicy9umnwh"},{"type":"image","attrs":{"height":735,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/2334a7ab729b40ee9e71454cbe6f7771","width":383},"text":"","id":"BeoEdGW8CosKE6xIxfDc8bLYnjh"},{"type":"paragraph","children":[{"type":"text","text":"5、在选择音乐页面,点击特效。","id":""}],"text":"","id":"Dq2qdk42YoUuMoxymKhc7ToKnqf"},{"type":"image","attrs":{"height":617,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/7ff56938ec42431998a984ea642dbac3","width":400},"text":"","id":"AWcGdIuwqo4gYuxuQkVcoc3QnYf"},{"type":"paragraph","children":[{"type":"text","text":"6、选择转场,接着选中想要的特效,点击保存。","id":""}],"text":"","id":"PmycdWeqioCAmux8zjtcfvcnnAd"},{"type":"image","attrs":{"height":802,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/18f3435311db477d9c34fccd95b67831","width":380},"text":"","id":"GuWqdsQaUoSw8ExhcDbcUuvhnxg"},{"type":"paragraph","children":[{"type":"text","text":"7、返回后,点击下一步,设置好后,点击发布,这样添加转场特效的视频就发布成功。","id":""}],"text":"","id":"WIaQdmoWgo6MOoxIXiIc3fUFn5f"},{"type":"paragraph","children":[{"type":"text","text":"合拍蹭热门","id":""}],"text":"","id":"C4yedoaCGoyyeWxULjYcCBYvncc"},{"type":"paragraph","children":[{"type":"text","text":"合拍就是与达人一起合拍一个视频,比如最近很火的“合拍唱歌”,唱热门歌曲,一人唱一句歌词。","id":""}],"text":"","id":"Wu6SdQAmYoaAAMx6PqncXJvTnze"},{"type":"image","attrs":{"height":574,"note":[{"type":"text","text":"转场","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/c8018e68c22e4731bbd79fa44582eafd","width":623},"text":"","id":"ZiQsdIYoaoMu4Cx2DDkcZmnznJg"},{"type":"paragraph","children":[{"type":"text","text":"具体的拍摄技巧可以观看以下课程,课程里会有详细的介绍。","id":""}],"text":"","id":"HsIkdIwMKowQICx61Qxcr2kmn6b"},{"type":"paragraph","children":[{"type":"text","text":"抖音合拍视频:","id":""},{"type":"external_link","attrs":{"url":"https://jingyan.baidu/article/ff42efa9ee8b0dc19e2202a0.html"},"children":[{"type":"text","text":"https://jingyan.baidu/article/ff42efa9ee8b0dc19e2202a0.html","id":""}],"text":"","id":""}],"text":"","id":"Xq6mdoguuo86C0x6ICVcjnTYnOh"},{"type":"heading","attrs":{"level":2},"children":[{"type":"text","text":"拍摄技巧","id":""}],"text":"","id":"HEuMdA8IYo260Gx04VGcPEXfnth"},{"type":"paragraph","children":[{"type":"text","text":"1、拍摄不能手抖","id":""}],"text":"","id":"HCYgdsKeuoQ4KExWOqCcxuHVnOc"},{"type":"paragraph","children":[{"type":"text","text":"拍摄视频的时候千万不能手抖,手抖拍出来的视频都是模糊不清的。要时刻保持正确的对焦,这样才能拍摄出清晰的视频效果。","id":""}],"text":"","id":"IkGOdeicQomIeGx8erHckS2UnCb"},{"type":"paragraph","children":[{"type":"text","text":"我们可以把手机放在支架上或使用自拍杆拍摄,这样拍摄出来的画面比较稳定。","id":""}],"text":"","id":"VOc8dwAwQoisqKxwTpNcTQPdnch"},{"type":"paragraph","children":[{"type":"text","text":"2、学会利用光线","id":""}],"text":"","id":"YysQdOIiYowMaQx2xuvcUVDynog"},{"type":"paragraph","children":[{"type":"text","text":"拍摄短视频时光线十分重要,好的光线布局可以有效提高画面质量。尤其是在拍摄人像时要多用柔光,会增强画面美感,要避免明显的暗影和曝光如果光线不清晰,可以手动打光,灯光打在人物的脸上或用反光板调节。","id":""}],"text":"","id":"H0y8dqsoIoAaOIx0mPIcApnUnNb"},{"type":"paragraph","children":[{"type":"text","text":"光线不好的地方,可以开启闪光灯功能拍摄,还可以购买个专业的外置闪光灯,自由调节外置闪光灯的亮度。","id":""}],"text":"","id":"LsYOdi6YUoUs2ixyUi3ceHonngQ"},{"type":"paragraph","children":[{"type":"text","text":"在天气好的时候,可以尝试逆光拍摄,在拍摄界面可以对准高光区域进行测光,即可拍出艺术感十足的剪影大片。","id":""}],"text":"","id":"RaMId2UGiouGE8x6kijcM6yxnzh"},{"type":"paragraph","children":[{"type":"text","text":"3、切换场景","id":""}],"text":"","id":"Q4aQd6eiWo4KSgxugAScVXumnig"},{"type":"paragraph","children":[{"type":"text","text":"在拍摄视频之前要确定好自己拍摄的主题是什么、内容是什么,根据视频内容来选定拍摄场景,并且,我们可以根据视频的内来换多个拍摄场景。如可以从远处将镜头推近,或者可以从近处将镜头拉远,甚至可以斜着拍,来避免视频过于单调,让视频画面更加生动。根据不同的拍摄手法与拍摄场景来不断丰富自己视频的内容。","id":""}],"text":"","id":"JQsYdQag0oeOgqxiCmNcU7Lzn6b"},{"type":"paragraph","children":[{"type":"text","text":"4、提高发布作品的清晰度","id":""}],"text":"","id":"VQYCduU44o6mgAxsPA5cNrLRnQc"},{"type":"paragraph","children":[{"type":"text","text":"①使用手机原相机拍摄:","id":""}],"text":"","id":"OAI2dM6WIoyAOmxiy8ocVs91nCd"},{"type":"paragraph","children":[{"type":"text","text":"手机相机设置1080P HD,","id":""},{"type":"text","text":"60fps","id":""},{"type":"text","text":";","id":""}],"text":"","id":"KuQcdqmyuoAAs8xUF2JclMo6n3f"},{"type":"paragraph","children":[{"type":"text","text":"用剪映加美颜,调节参数亮度+10、对比度+10、饱和度+10、色温-8、锐化+60;","id":""}],"text":"","id":"LEEqdyMGyoOkuGx8AKvcCptNndc"},{"type":"paragraph","children":[{"type":"text","text":"导出设置调1080P 60fps;","id":""}],"text":"","id":"Ou4md08qUoaUIAxttGacwGkVnzQ"},{"type":"paragraph","children":[{"type":"text","text":"②用抖音相机拍摄:降低曝光、清晰度调到最高;","id":""}],"text":"","id":"VQCadCmyIo86EcxYvomcAjKxnEd"},{"type":"paragraph","children":[{"type":"text","text":"打开画质增强;","id":""}],"text":"","id":"I6iudMSCcoYYkmx4sXMco6ayn8e"},{"type":"paragraph","children":[{"type":"text","text":"发布设置点击高清发布;","id":""}],"text":"","id":"Am0OdYys6oaK2WxiW06cn7Skn5d"},{"type":"paragraph","children":[{"type":"text","text":"③真人出镜用轻颜相机APP拍摄,补光灯补光。","id":""}],"text":"","id":"Qckud4c26oCScuxkRzicFqhMnTd"},{"type":"heading","attrs":{"level":1},"children":[{"type":"text","text":"后期剪辑","id":""}],"text":"","id":"FmiudqmiOoWaM0xEzlvctgTIn7g"},{"type":"paragraph","children":[{"type":"text","text":"拍摄视频的时候有些技巧需要使用视频剪辑软件,我们可以选择剪映进行操作。","id":""}],"text":"","id":"FWsydM8qcoYQmcxmr62c0GuWnkb"},{"type":"paragraph","children":[{"type":"text","text":"比如说视频变速功能,就可以在剪映里面制作出来。","id":""}],"text":"","id":"MuOydeykmoAkoMxSgCwcZRldnKh"},{"type":"paragraph","children":[{"type":"text","text":"打开剪映,点击页面中的加号按钮。","id":""}],"text":"","id":"BWMUdqkCioQqMyxaYxXckSAknbf"},{"type":"image","attrs":{"height":415,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/bd526ec58cc04f18add2a396d8c7fbdf","width":525},"text":"","id":"JAe0dCewgowOgIxK2gmcCuU3nYg"},{"type":"paragraph","children":[{"type":"text","text":"选择最下方的剪映工具栏对视频素材【剪切、配音和加特效】。","id":""}],"text":"","id":"YaMKdEUakoCqO2x0Q4LcQSPgn1c"},{"type":"image","attrs":{"height":405,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/7817b1ae7259434a833d5628ae1e6a3f","width":527},"text":"","id":"Ce8IdUMUsoQag2xQxl5cAs06nyf"},{"type":"paragraph","children":[{"type":"text","text":"点击视频编辑条使用下方编辑工具箱【分割、变速和添加动画】。","id":""}],"text":"","id":"OqwodwIoUoqykGxqqKYcyLy4ncb"},{"type":"image","attrs":{"height":772,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/b97b5d4ba6eb47b39eeb1c6799c9a550","width":399},"text":"","id":"NwM6dKC2YoOGCWxiMBZcfC7xn1g"},{"type":"paragraph","children":[{"type":"text","text":"选择视频,点击变速,可以调整视频播放的速度。","id":""}],"text":"","id":"MoiudAyUGomgSixwJaEcCPxXnVg"},{"type":"image","attrs":{"height":645,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/561c42408d174446b79da5a3023f65b8","width":314},"text":"","id":"RYosdQM8Oo6I4KxyGenc5UIXncf"},{"type":"paragraph","children":[{"type":"text","text":"点击添加音频,选择自己喜欢的音乐。","id":""}],"text":"","id":"MKycdcSYMomi0kxg9rwc0eUInUg"},{"type":"image","attrs":{"height":619,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/374490367ba54148aa6fa1e1f5561511","width":320},"text":"","id":"WAO6dCQWCoYGAcxAy6bcGP7tnbX"},{"type":"paragraph","children":[{"type":"text","text":"剪辑完成后,点击右上角的导出。","id":""}],"text":"","id":"Jc8uduUkyoUskKxGhwfcFXPUnQa"},{"type":"image","attrs":{"height":623,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/c2d5e732ecc54598b3840ce5bde12338","width":315},"text":"","id":"Us44d28ocow2sYx2t8VcXrEongc"},{"type":"paragraph","children":[{"type":"text","text":"点击下方的一键分享到抖音,还可以直接打开抖音发布这个视频。","id":""}],"text":"","id":"SWY4dKccyoQQAUxSoYccJSYHnrd"},{"type":"image","attrs":{"height":617,"note":[{"type":"text","text":"后期剪辑","id":""}],"url":"https://p3.douyinpic/large/tos-cn-i-qvj2lq49k0/630e862bc70b466ab7c146200db9bc63","width":316},"text":"","id":"Leeudcgk4ouYwGxknmOctGctntb"},{"type":"paragraph","children":[{"type":"text","text":"剪映操作步骤","id":""}],"text":"","id":"CoiGd2MIsock6OxyEwIcbBaZnlb"},{"type":"paragraph","children":[{"type":"text","text":"第一、准备视频素材点击【添加到项目】导入到剪映编辑界面。","id":""}],"text":"","id":"Lm2sdcEIioqIeSxysVVcU6konkc"},{"type":"paragraph","children":[{"type":"text","text":"第二、选择下方的剪映工具栏对视频素材【剪切、配音和加特效】。","id":""}],"text":"","id":"NsIgd8IO4oAyOSxecGGcHa38nLh"},{"type":"paragraph","children":[{"type":"text","text":"第三、点击视频编辑条使用下方编辑工具箱【分割、变速和添加动画】。","id":""}],"text":"","id":"JOu2d2s0IoQC8WxmIKvc1xOvnCh"},{"type":"paragraph","children":[{"type":"text","text":"第四、点击【添加音频】选择音乐为视频加入背景音乐。","id":""}],"text":"","id":"Jca2dI28ioeUo8xs1MYcJsa6nnh"},{"type":"paragraph","children":[{"type":"text","text":"第五、点击动画设置视频片段转场动画效果。","id":""}],"text":"","id":"XKEGdgmWeo4KEgx2b1bcwavBnpf"},{"type":"paragraph","children":[{"type":"text","text":"第六、视频制作完成后设置分辨率点击【导出】按钮即可。","id":""}],"text":"","id":"R0qSdcSsGogUcqx67bqcGnSPnBw"},{"type":"paragraph","children":[{"type":"text","text":"准备视频素材点击【添加到项目导入】到剪映编辑界面。","id":""}],"text":"","id":"POoGdSWAgoqUSYxOKMqc0wTFn5d"},{"type":"paragraph","children":[{"type":"text","text":"网上有很多剪映的功能教程,如果想学习更多剪辑方式,可以在网上观看一些网络教程,简单易学。","id":""}],"text":"","id":"IUA2dsGwco2MMwxkreec5iVCnyd"},{"type":"paragraph","children":[{"type":"text","text":"教程推荐:","id":""}],"text":"","id":"OU2Qd6YGeoaCQOxaYzEcUXrinNh"},{"type":"paragraph","children":[{"type":"text","text":"剪映基础入门","id":""}],"text":"","id":"HgiudCQOEogYakxeSJOcV6egnId"},{"type":"paragraph","children":[{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1eP41157vE/?p=2\u0026spm_id_from=pageDriver"},"children":[{"type":"text","text":"https://bilibili/video/BV1eP41157vE/?p=2\u0026spm_id_from=pageDriver","id":""}],"text":"","id":""}],"text":"","id":"KiuEdcWI6oUqSQxusEMcyInvn6d"},{"type":"paragraph","children":[{"type":"text","text":"一小时学会剪映","id":""}],"text":"","id":"JqoMdoKm6oSoamxWsNdcjHtlnOh"},{"type":"paragraph","children":[{"type":"external_link","attrs":{"url":"https://bilibili/video/BV1Gz4y1Z7ug/?spm_id_from=333.337.search-card.all.click"},"children":[{"type":"text","text":"https://bilibili/video/BV1Gz4y1Z7ug/?spm_id_from=333.337.search-card.all.click","id":""}],"text":"","id":""}],"text":"","id":"PWYUdYQ6ioO262xW8S0cbDTAnxe"},{"type":"heading","attrs":{"level":1},"children":[{"type":"text","text":"发布视频","id":""}],"text":"","id":"TOy2dscYeowc24xYdjEcwbDwnvg"},{"type":"paragraph","children":[{"type":"text","text":"视频拍摄好了之后我们可以观看下视频,然后把不合适的地方剪切掉,把视频剪辑一下,让视频看起来更加完善,这样就可以发布了。","id":""}],"text":"","id":"UqQaduA6OoQI24x6KREcJQdXnRg"},{"type":"paragraph","children":[{"type":"text","text":"发布视频的时候还可以添加热点标签,在发布视频的页面可以","id":""},{"type":"text","text":"点击“添加标签”,然后根据视频内容选择标签,","id":""},{"type":"text","text":"这样也可以带来一部分流量,最后点击发布就行。","id":""}],"text":"","id":"Xg2KdO4Gko4WuaxQL0scQ6RIn1b"},{"type":"paragraph","children":[{"type":"text","text":"","id":""}],"text":"","id":"WmqqdEKOiokU66xi2xjcn47an0f"}]%3C%2Fhowto_content%3E6. pb读取excel
PB对测量误差和样本分布没有特定假设,是非参数方法,不同于一般的线性回归(Passing & Bablok,1983)。因此不能采用excel中所用方法来做。Excel不太清楚是否有模块,可编程完成,或采用专业软件,如Medcalc。
7. pb数据窗口导出为excel
很久没用过PB了,网上找了一篇,大致看了一下,应该没什么问题
--转自51CTO论坛
在PowerBuilder里面操作BLOB数据地灵活技术
PowerBuilder提供的BLOB(Binary Large Object)数据类型可以用来处理大型数据,包括图像、大文本、Word文档、二进制文件和多媒体等各种数据,它的长度可以是0~2GB字节,我们利用BLOB类型的变量可以将数据传递给数据库以大字段方式存储。但是用通常的数据窗口技术无法将BLOB类型数据加入到数据库中,也不能将数据库中相应字段的数据提取出来,即使在程序中直接使用UPDATE和SELECT等SQL语句也是无法对BLOB类型数据进行操作的。下面笔者将介绍在PowerBuilder 7.0中操作BLOB类型数据的技巧。
程序设计原理
在PB中实现BLOB类型数据的入库和查询,主要要用到两条特殊的SQL命令——UPDATEBLOB和SELECTBLOB,首先定位要进行操作的记录,然后使用UPDATEBLOB命令就可以将BLOB类型变量中存放的数据传递给数据库,而使用SELECTBLOB则是将指定记录中的大字段数据传递给BLOB变量。
使用BLOB类型变量获取外界文件的数据内容,还必须借助于PB提供的可视化OLE控制对象,通过它可以将指定的文件内容显示成相应的对象(如BMP图片),双击它就可以激活相应的OLE服务器应用程序,来编辑修改对象的内容,同时也可以读取对象的数据内容(利用OLE控件的ObjectData属性),给BLOB类型变量赋值。
下面结合一个简单的程序实例,讲述如何处理BLOB数据类型。在这个例子中,BMP图片将作为一个大字段存储在数据库中。我们选择Microsoft Access 2000作为后台数据库,它的字段类型中包含“OLE对象”类型(如果选择MS SQL Server作为数据库服务器,可以使用TEXT或IMAGE类型字段存放大字段数据),这样就为管理多媒体数据、大文件和图片提供了支持。
操作BLOB字段的实现过程
我们在Access中创建一个新的数据库文件,文件名是bmp.mdb,在其中定义BMP图片数据表bmptable如下:
各字段的其它设置(如字段宽度等),均采用缺省形式即可。
编程前还需要做的一步准备工作是在操作系统的ODBC配置中建立指向bmp.mdb数据库的连接,名称定为bmptable。
下面的程序片段实现了数据库的连接,图片的插入、更新、删除和查询。考虑文章的篇幅,本文只列出与主题相关的程序源码。
1. 连接Access数据库
SQLCA.DBMS = "ODBC"
// SQLCA为全局transaction事务变量
SQLCA.AutoCommit = False
SQLCA.DBParm = "Connectstring='DSN=bmptable;UID=WD='"
CONNECT USING SQLCA;
If SQLCA. SQLCode <> 0 Then
MessageBox ("数据库错误", "连接失败!")
Halt close;
End If
2. 将BMP图片存入数据库
integer bmpno,icount
//变量bmpno存放给定的图片编号
string filepath,filename
blob blb_tmp
//…此处对图片编号bmpno赋值,例如bmpno=101;可以通过程序实现为弹出对话框窗口提供一个图片编号
//查询指定的图片编号是否已经存在
icount=0
SELECT COUNT() INTO :icount
FROM bmptable
WHERE bmptable.bmpno=:bmpno
USING SQLCA; //:bmpno为给定的图片编号
if icount>0 then
MessageBox("查询结果",string(bmpno)+" 号图片已经存在,请输入一个新的图片编号")
return
end if
//在OLE控制对象ole_1中插入BMP图片文件
GetFileOpenName("请选择一个需要插入的BMP图片文件",filepath,filename,"BMP","BMP图片文件(.BMP),.BMP")
If Len(filepath)=0 Then
Return
End If
If ole_1.InsertFile(filepath)<>0 Then //OLE错误
Return
End If
//新图片入库
string sql
sql= "INSERT INTO bmptable (bmpno,bmpdata,bmpname) &&
VALUES ("&&
+string(bmpno)+",'','"&&
+filename+"')"
EXECUTE IMMEDIATE :sql;
If SQLCA.SQLDBCode=0 Then
COMMIT USING SQLCA;
//提交事务
Else
MessageBox("数据库错误","插入失败")
ROLLBACK USING SQLCA;
//事务回滚
Return
End If
Blb_tmp=ole_1.ObjectData
UPDATEBLOB bmptable SET bmpdata=:blb_tmp
WHERE bmptable.bmpno=:bmpno
USING SQLCA; //更新存放图片的字段
If SQLCA.SQLDBCode=0 Then
COMMIT USING SQLCA;
//提交事务
MessageBox("插入成功","图片入库成功")
Else
MessageBox("数据库错误","更新图片失败")
ROLLBACK USING SQLCA;
//事务回滚
Return
End If
3. 从数据库中删除BMP图片
UPDATE bmptable SET bmpdata=''
WHERE bmptable.bmpno=:bmpno
USING SQLCA;
//bmpno为要删除的图片编号
If SQLCA.SQLDBCode=0 Then
COMMIT USING SQLCA;
//提交事务
Else
MessageBox("数据库错误","更新失败")
ROLLBACK USING SQLCA;
//事务回滚
Return
End If
DELETE FROM bmptable
WHERE bmptable.bmpno=:bmpno
USING SQLCA;
If SQLCA.SQLDBCode=0 Then
COMMIT USING SQLCA;
//提交事务
MessageBox("删除成功","图片删除成功")
Else
MessageBox("数据库错误","删除失败")
ROLLBACK USING SQLCA;
//事务回滚
Return
End If
4. 按图片编号查询图片信息
//需要提供一个图片编号存放在变量bmpno中
SetNull(blb_tmp)
SELECTBLOB bmptable.bmpdata INTO :blb_tmp
FROM bmptable
WHERE bmptable.bmpno=:bmpno
USING SQLCA;
If Not IsNull(blb_tmp) Then
ole_1.ObjectData=blb_tmp
//双击OLE控制唤醒OLE服务器即可编辑图片
End If
使用PB编程时,每次对数据库进行操作后要注意检查返回结果,以保证程序的可靠性。以上程序只是对操作BLOB数据类型的关键技术进行探讨,通过画板设计相应的用户界面,即可形成一个完整的基于Client/Server结构的数据库应用程序。
8. pb excel
操作步骤:
1、在A1单元格输入=INT(MOD((ROW(A1)-1)/2^(COLUMN(A1)-1),2))
2、公式往右复制或填充至N列(14列)
3、选上A1-N1,复制或填充至16384行(14位数,2个数字的组合共有2的14次方种)
(ctrl+g,可以快速定位到N16384单元格,然后用shift+鼠标可以快速选择区域)
4、在01单元格输入=A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1&L1&M1&N1
公式往下填充或复制
5、复制O列,粘贴为数值
6、用查找替换功能(ctrl+F),把0、1分别换成B、P或P、B