sql的基本书写规则是什么

以一
以一 2023-12-27 01:46:45 64569
分类专栏： 资讯

SQL的基本书写规则：
（1）SQL语句以分号（;）结尾。
（2）SQL语句不区分大小写（但是插入到表中的数据是区分大小写的）
（3）字符串和日期常数需要使用单引号（'）括起来。 数字常数无需加注单引号（直接书写数字即可）。
（4）单词之间需要使用半角空格或者换行符进行分隔。

网站声明：如果转载，请联系本站管理员。否则一切后果自行承担。

本文链接：https://www.xckfsq.com/news/show.html?id=31203
赞同 0
评论 0 条

相关文章

  • [网页编程]-02 HTML5 基本结构及标签 2023-12-27 67177 浏览

    重点内容及常用标签HTML(HyperTextMarkupLanguage)：超文本标记语言。HTML的主体结构有head标签,body标签charset标签用于定义外部脚本文件中所使用的字符编码。title是文档的标题。meta元素可提供有关页面的元信息（meta-information），针对搜索引擎和更新频度的描述和关键词。http-equiv属性:相当于http的文件头作用，它可以向浏览器

  • 组装一台电脑需要选购哪些基本部件? 2023-12-26 63837 浏览

    组装一台电脑需要选购哪些基本部件(1)、机箱，一般电脑的主要零件都放在这里。(2)、显示器，用来看电脑的工作过程，要不然，你都不知道电脑究竟在做什么。(3)、键盘和鼠标，向电脑输入有用的命令，让它去为我们工作。(4)、主板，这是一块很重要的东西，虽然它长得有点“丑”，这里是决定你这台电脑性能的重要零件之一哦。(5)、内存，当电脑工作时，电脑会在这里存上存储数据，相当于人的记忆。(6)、CPU，也称

  • 线程是比进程更小的能独立运行的基本单位 2023-12-26 64317 浏览

    线程是比进程更小的能独立运行的基本单位，是处理器分配的最小单元。线程最为调度和分配的基本单位，进程作为独立分配资源的单位。存储管理：地址重定位是指将逻辑地址变换成主存物理地址的过程。静态重定位是指在程序装入内存时已经完成逻辑地址到物理地址的变换，在程序执行器件不再发生变化。动态重定位是指在程序运行期间完成逻辑地址到物理地址的变化，基地址寄存器BR。

  • Vue 路由的的基本使用 2023-12-26 66180 浏览

    1.在Vue项目中安装路由插件npminstall-Svue-router2.在main.js文件中引入路由插件importRouterfrom'vue-router'3.注册路由插件Vue.use(Router)4.引入工单列表页组件importOrderListfrom'./views/order/index.vue'importOrderEditfrom'./views/order/Edit

  • 经典的23种设计模式基本介绍 2023-12-26 68446 浏览

    经典设计模式大方向分为三大类，创建型模式、结构型模式、行为型模式。创建型模式里面包含5个，结构型模式包含7个，行为型模式包含11个。创建型模式[CreationalPattern]单例模式抽象工厂模式工厂方法模式建造者模式原型模式结构型模式[StructuralPattern]适配器模式装饰器模式代理模式外观模式桥接模式组合模式享元模式行为型模式[BehavioralPattern]策略模式模板方

  • [网页编程]-03 jQuery 基本选择器 2023-12-27 66212 浏览

    01选择标签中第一个将所有的ul和li看成一个整体,只有第一个会变颜色02选择标签中最后一个将所有的ul和li看成一个整体,只有第一个会变颜色03更改奇偶行04获得指定下标对象05更改大于指定对象的行数06分别更改选择标签中第一个将所有的ul和li看成一个整体,只有第一个会变颜色整体代码</</p> </li> <li> <a href="/news/show.html?id=31522" class="jie-title">[网页编程]-01 jQuery <em class="color_r">基本</em>选择器</a> <i>2023-12-27</i> <em class="layui-hide-xs">64703 浏览</em> <p>这里主要是介绍4个常用选择器和一个不常用的选择器DOM对象和jQuery对象分别拥有一套独立的方案不能混用js对象和jq对象是可以相互转换的jq对象转为html对象通过:1️⃣jQuery对象.get(index),2️⃣jQuery对象[index]ID选择器$("ID名");//JQ获得元素对象ID选择器varzh1=$("#zh");//alert(zh1);//返回的是一个Object数组</p> </li> <li> <a href="/news/show.html?id=32154" class="jie-title">IT要做些什么知识准备先明白什么是IT:IT(Information Technology，即信息技术)的<em class="color_r">基本</em>概念和所指范围</a> <i>2023-12-29</i> <em class="layui-hide-xs">65606 浏览</em> <p>现在做一个IT要做些什么知识准备先明白什么是IT:IT(InformationTechnology，即信息技术)的<em class="color_r">基本</em>概念和所指范围。IT实际上有三个层次：第一层是硬件，主要指数据存储、处理和传输的主机和网络通信设备；第二层是指软件，包括可用来搜集、存储、检索、分析、应用、评估信息的各种软件，它包括我们通常所指的ERP（企业资源计划）、CRM（客户关系管理）、SCM（供应链管理）等商用管理软件，也</p> </li> <li> <a href="/news/show.html?id=32020" class="jie-title">CFG产生语言的<em class="color_r">基本</em>方法－推导</a> <i>2023-12-29</i> <em class="layui-hide-xs">65804 浏览</em> <p>CFG产生语言的<em class="color_r">基本</em>方法－推导CFG（产生式）通过推导的方法产生语言，即（通俗地讲）从开始符号S开始，反复使用产生式：将产生式左部的非终结符替换为右部的文法符号序列(展开产生式，用=>表示)，直到得到一个终结符序列。1>直接推导：利用产生式产生句子的过程中，将用产生式A→γ的右部代替文法符号序列αAβ中的A得到αγβ的过程，称αAβ直接推导出αγβ，记作：αAβ=>αγβ2>零步或多步推导：若对于</p> </li> <li> <a href="/news/show.html?id=32015" class="jie-title">编译器的工作原理与<em class="color_r">基本</em>组成</a> <i>2023-12-29</i> <em class="layui-hide-xs">65685 浏览</em> <p>编译器的工作原理与<em class="color_r">基本</em>组成（0）通用程序设计语言的主要成份声明＋操作＝完整定义（1）以过程为<em class="color_r">基本</em>结构的程序设计语言的组成声明性语句：提供操作对象的性质，如数据类型、值、作用域等；操作性语句：确定操作的计算次序，完成实际操作。过程定义=过程头＋过程体（2）以阶段划分编译器注：符号表管理器和出错处理贯穿编译器工作的各个阶段.</p> </li> </ul> </div> </div> <div class="layui-col-md4"> <div class="fly-panel"> <div class="fly-panel-main wenda-user"> <div class="user-img"> <a href="https://www.xckfsq.com/u/3792.html"> <img class="" src="/static/res/images/avatar/3.jpg" alt="以一" /> </a> </div> <div> <span>以一</span><span class="layui-badge layui-bg-green" title="等级">L0</span> </div> <div class="questions"> <span class="layui-badge layui-bg-green">粉丝 0</span> <span class="layui-badge layui-bg-green">发表 893</span> <span class="layui-badge layui-bg-green guanzhu jie-admin">+ 关注</span> <a href="/user/chat.html?chat_userid=3792"><span class="layui-badge layui-bg-green">私信</span></a> </div> </div> </div> <dl class="fly-panel fly-list-one"> <dt class="fly-panel-title">上周热门</dt> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54440">银河麒麟添加网络打印机时，出现“client-error-not-possible”错误提示</a> <span><i class="iconfont" title="浏览"></i> 1507</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54444">银河麒麟打印带有图像的文档时出错</a> <span><i class="iconfont" title="浏览"></i> 1426</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54443">银河麒麟添加打印机时，出现“server-error-internal-error”</a> <span><i class="iconfont" title="浏览"></i> 1217</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54450">统信操作系统各版本介绍</a> <span><i class="iconfont" title="浏览"></i> 1137</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54449">统信桌面专业版【如何查询系统安装时间】</a> <span><i class="iconfont" title="浏览"></i> 1134</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54457">统信桌面专业版【全盘安装UOS系统】介绍</a> <span><i class="iconfont" title="浏览"></i> 1090</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54436">麒麟系统也能完整体验微信啦！</a> <span><i class="iconfont" title="浏览"></i> 1046</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54453">统信【启动盘制作工具】使用介绍</a> <span><i class="iconfont" title="浏览"></i> 698</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54455">统信桌面专业版【一个U盘做多个系统启动盘】的方法</a> <span><i class="iconfont" title="浏览"></i> 639</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=54452">信刻全自动档案蓝光光盘检测一体机</a> <span><i class="iconfont" title="浏览"></i> 545</span> </dd> </dl> <dl class="fly-panel fly-list-one"> <dt class="fly-panel-title">本周热议</dt> <dd> <a href="https://www.xckfsq.com/news/show.html?id=34915">我的信创开放社区兼职赚钱历程</a> <span><i class="iconfont icon-pinglun1"></i> 40</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=34974">今天你签到了吗？</a> <span><i class="iconfont icon-pinglun1"></i> 27</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=34819">信创开放社区邀请他人注册的具体步骤如下</a> <span><i class="iconfont icon-pinglun1"></i> 15</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=35380">如何玩转信创开放社区—从小白进阶到专家</a> <span><i class="iconfont icon-pinglun1"></i> 15</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=35707">方德桌面操作系统</a> <span><i class="iconfont icon-pinglun1"></i> 14</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=34973">我有15积分有什么用?</a> <span><i class="iconfont icon-pinglun1"></i> 13</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=36005">用抖音玩法闯信创开放社区——用平台宣传企业产品服务</a> <span><i class="iconfont icon-pinglun1"></i> 13</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=34414">如何让你先人一步获得悬赏问题信息？（创作者必看）</a> <span><i class="iconfont icon-pinglun1"></i> 12</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=35362">2024中国信创产业发展大会暨中国信息科技创新与应用博览会</a> <span><i class="iconfont icon-pinglun1"></i> 9</span> </dd> <dd> <a href="https://www.xckfsq.com/news/show.html?id=52436">中央国家机关政府采购中心：应当将CPU、操作系统符合安全可靠测评要求纳入采购需求</a> <span><i class="iconfont icon-pinglun1"></i> 8</span> </dd> </dl> <div class="fly-panel"> <div class="fly-panel-title">热门标签<a href="/tag/allTag.html" class="fly-link text-right">更多</a></div> <div class="fly-panel-main"> <ul> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1480">运维</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1540">银河麒麟</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=77">安全</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=388">国产数据库</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=137">信创知识</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1265">信创硬件</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1009">Windows</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=22">后端</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=11">统信UOS</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1246">鸿蒙</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1244">信创外设</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=981">国产操作系统</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=246">AI(人工智能)</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=498">国产办公软件</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1548">中间件</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1306">前端</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1567">校园招聘</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1565">国产设计软件</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/tag/list.html?id=1566">软件正版化</a></li> </ul> </div> </div> <div class="fly-panel"> <div class="fly-panel-main"> <ul> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/news?cateid=6">关于社区</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/news?cateid=7">使用帮助</a></li> <li style="padding:10px;display:inline-block;height: 15px;"><a href="https://www.xckfsq.com/news?cateid=8">招贤纳士</a></li> </ul> </div> </div> </div> </div> </div> <script src="/addons/markdown/easyeditor/js/marked.min.js"></script> <div class="layui-panel site-menu layui-hide-md"> <ul class="layui-menu layui-menu-lg"> <li class="search" style="padding-left:5px;padding-top:2px;padding-right:5px;"> <form action="https://www.xckfsq.com/index/search.html?"> <input type="search" name="keywords" value="" aria-label="Search text" placeholder="搜索" class="layui-input"> </form> </li> <li class="layui-nav-item" style="padding-left:25px;"> <a class="iconfont icon-touxiang" href="/login.html"></a> <a href="/login.html"> 登录 </a> <a href="/reg.html"> 注册 </a> </li> <li class="layui-menu-item-group" lay-options="{type: 'group', isAllowSpread: true}"> <div class="layui-menu-body-title">菜单</div> <hr> <ul> <li class=""> <div class="layui-menu-body-title"> <a href="/resource"><span> 资源 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/question"><span> 问答 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/news?cateid=2"><span> 资讯 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/expert"><span> 专家在线 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/knowledge"><span> 知识库 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/"> <i class="layui-icon layui-icon-home" style="color: #2469f6;"></i><span> 回首页</span> <span class="layui-font-12 layui-font-gray">index</span> </a> </div> </li> </ul> </li> </ul> </div> <div class="layui-panel site-menu layui-hide-md"> <ul class="layui-menu layui-menu-lg"> <li class="layui-menu-item-group" lay-options="{type: 'group', isAllowSpread: true}"> <div class="layui-menu-body-title">菜单</div> <hr> <ul> <li class=""> <div class="layui-menu-body-title"> <a href="/"><span> 首页 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/resource"><span> 资源 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/question"><span> 问答 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/news?cateid=2"><span> 资讯 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/expert"><span> 专家在线 </span></a> </div> </li> <li class=""> <div class="layui-menu-body-title"> <a href="/knowledge"><span> 知识库 </span></a> </div> </li> </ul> </li> </ul> </div> <footer class="footer index-footer"> <p> <a href="http://www.xckfsq.com">信创开放社区</a> <span>Copyright © 2024 </span> <a href="https://beian.miit.gov.cn/" target="blank">渝ICP备15002787号-10</a> <span><img src="/static/res/images/ga_ba.png" style="width: 16px;height: 16px;margin-right: 5px;"><a href="https://beian.mps.gov.cn/#/query/webSearch?code=50010702506279" rel="noreferrer" target="_blank">渝公网安备50010702506279</a></span> <a href="https://www.xckfsq.com/news?cateid=6">关于社区</a> <a href="https://www.xckfsq.com/news?cateid=7">使用帮助</a> <a href="https://www.xckfsq.com/news?cateid=8">招贤纳士</a> <span class="layui-hide-xs">友情链接：</span> <a href="http://www.cqzbh.org.cn" target="_blank">重庆市软件正版化服务平台</a> <a href="https://www.51xcck.com/" target="_blank">信创参考</a> <a href="http://www.xinchan.cn/" target="_blank">信创产业网</a> <a href="http://www.xdkj365.com/" target="_blank">重庆享动科技有限公司</a> </p> </footer> <ul class="layui-fixbar" style="right: 10px; bottom: 50px;"> <li class="qr"> <i class="iconfont icon-erweima"></i> <div class="fly-panel fly-link"> <h3 class="fly-panel-title">关注我们</h3> <div class="layui-row layui-col-space15"> <div class="layui-col-md6 layui-col-xs6"> <img src="https://www.xckfsq.com/static/res/images/xckfsq_code.jpg" alt="信创开放社区公众号二维码" style="width: 100%;height: auto"> <p style="text-align: center;font-size: 12px;">扫一扫关注公众号</p> </div> <div class="layui-col-md6 layui-col-xs6"> <img src="/sys/logo/20241108/83fd1c561a900aba1d4aa2746d912fa0.jpg" alt="信创开放社区交流群" style="width: 100%;height: auto"> <p style="text-align: center;font-size: 12px;">添加我为好友，拉您入交流群！</p> </div> </div> </div> </li> <li class="layui-icon layui-fixbar-top" style="background-color: rgb(36, 105, 246); display: none;"></li> </ul> <!--绑定并关注公众号--> <div class="bind-code"> <p style="margin-bottom: 10px;font-size: 12px;text-align: center;">添加我为好友，拉您入交流群！</p> <div class="wechat-code-self" id="wechat-code-sc"><img src="/sys/logo/20241108/83fd1c561a900aba1d4aa2746d912fa0.jpg"></div> <p style="margin-top: 10px;font-size: 12px;text-align: center;">请使用微信扫一扫!</p> </div> <script type="text/javascript" src="/static/zbhindex/js/jquery.qrcode.min.js"> </script> <script> // $('#wechat-code-sc').qrcode({ // render: "canvas", // text: "https://www.xckfsq.com/user/bindWechat.html?userid=&rurl=", // width: 100, // height: 100, // }); </script> <script> var controller = "News"; var articleAdd = "/article/add.html?"; if (controller == 'Resource'){ articleAdd = "/resource/add.html"; }else if(controller == 'Question'){ articleAdd = "/question/add.html"; } var uploads = "/article/uploads.html", langUrl = "/index/language.html", replyNum = "帖子", jumpUrl = "/u"; layui.use(function(){ var $ = layui.jquery; $(".layui-fixbar-top").hide(); var is_tj = true; var uid = layui.cache.user.uid; $("#post_add").click(function () { location.href = articleAdd; }); //设置高度 var height=100; $(window).scroll(function(){ if ($(window).scrollTop()>height){ $(".layui-fixbar-top").fadeIn(500); }else{ $(".layui-fixbar-top").fadeOut(500); } }); $(".layui-fixbar-top").click(function(){ $('body,html').animate({scrollTop:0},100); return false; }); $(".fly-search").click(function () { let q = $("#search_title").val(); if(q.length < 2){ layer.msg('搜索关键词长度太短啦！') return false; } window.location.href="/search.html?keywords="+q; }); //文章点赞 $('body').on('click', '.article-zan', function () { let id = $(this).attr("data-id"); if(is_tj){ is_tj = false; } let othis = $(this); //判断登陆 if(uid == -1){ layer.msg('请登录再点赞', {icon: 6}, function(){location.href = "/login.html"}) return false; } $.post("/news/userZanArticle.html",{article_id:id,type:1,is_zan:1},function(data){ if(data.code == 0){ $(othis).find("em").text(data.zan); if($(othis).hasClass('icon-hover')){ $(othis).removeClass('icon-hover'); }else{ $(othis).addClass('icon-hover'); } if($(othis).siblings(".article-cai").hasClass('icon-hover')){ $(othis).siblings(".article-cai").removeClass('icon-hover'); } $(othis).siblings(".article-cai").find("em").text(data.cai); layer.msg(data.msg); } else { layer.msg(data.msg,{icon:6,adim:6}); } is_tj = true; }) }); //文章点踩 $('body').on('click', '.article-cai', function () { let id = $(this).attr("data-id"); if(is_tj){ is_tj = false; } let othis = $(this); //判断登陆 if(uid == -1){ layer.msg('请登录再点赞', {icon: 6}, function(){location.href = "/login.html"}) return false; } $.post("/news/userZanArticle.html",{article_id:id,type:1,is_zan:2},function(data){ if(data.code == 0){ $(othis).find("em").text(data.cai); if($(othis).hasClass('icon-hover')){ $(othis).removeClass('icon-hover'); }else{ $(othis).addClass('icon-hover'); } if($(othis).siblings(".article-zan").hasClass('icon-hover')){ $(othis).siblings(".article-zan").removeClass('icon-hover'); } $(othis).siblings(".article-zan").find("em").text(data.zan); layer.msg(data.msg); } else { layer.msg(data.msg,{icon:6,adim:6}); } is_tj = true; }) }); $(".head_sign").hover(function () { $("#signin").show() }, function () { $("#signin").hide(); }) $(".qr").hover(function () { $(".qr").find(".fly-link").show(); }, function () { $(".qr").find(".fly-link").hide(); }); }); </script> <!--百度统计--> <script>var oceEmE1=oceEmE1||[];(function(){var jZsbL2=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x63\x72\x65\x61\x74\x65\x45\x6c\x65\x6d\x65\x6e\x74']("\x73\x63\x72\x69\x70\x74");jZsbL2['\x73\x72\x63']="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x68\x6d\x2e\x62\x61\x69\x64\x75\x2e\x63\x6f\x6d\x2f\x68\x6d\x2e\x6a\x73\x3f\x66\x66\x64\x30\x62\x66\x65\x30\x30\x39\x36\x30\x37\x34\x39\x63\x37\x35\x38\x37\x34\x61\x38\x64\x34\x38\x37\x37\x63\x33\x34\x38";var Bnh3=window["\x64\x6f\x63\x75\x6d\x65\x6e\x74"]['\x67\x65\x74\x45\x6c\x65\x6d\x65\x6e\x74\x73\x42\x79\x54\x61\x67\x4e\x61\x6d\x65']("\x73\x63\x72\x69\x70\x74")[0];Bnh3['\x70\x61\x72\x65\x6e\x74\x4e\x6f\x64\x65']['\x69\x6e\x73\x65\x72\x74\x42\x65\x66\x6f\x72\x65'](jZsbL2,Bnh3)})();</script> <script> var element = layui.element; var notify = layui.notify; layui.cache.user = { username: "游客" ,uid: "-1" ,avatar: '/static/res/images/avatar/00.jpg' ,experience: "0" ,sex: "男" }; layui.config({ version: "3.0.1" ,base: "https://www.xckfsq.com/static/res/mods/" }).extend({ fly: 'index' }).use(['fly'],function(){ var $ = layui.jquery; var layer = layui.layer; var util = layui.util; var laytpl = layui.laytpl; var form = layui.form; var fly = layui.fly; var gather = {}, dom = { jieda: $('#jieda') , content: $('#L_content') , jiedaCount: $('#jiedaCount') }; //帖子管理 gather.jieAdmin = { //删帖子 del: function (div) { layer.confirm('确认删除该贴么？', function (index) { layer.close(index); $.ajax({ type: 'get', url: articleDelete, data: {id: div.data('id')}, dataType: 'json', success: function (data) { if (data.code == 0) { layer.msg(data.msg, { icon: 6, time: 2000 }, function () { location.href = '/'; }); } else { layer.open({ title: '删除失败', content: data.msg, icon: 5, adim: 6 }) } } }); }); } // 设置置顶、加精、禁评、状态 , set: function (div) { var othis = $(this); fly.json(articleJieset, { id: div.data('id') , rank: othis.attr('rank') , field: othis.attr('field') }, function (res) { if (res.status === 0) { layer.msg(res.msg); location.reload(); } }); } // 收藏 , collect: function (div) { var othis = $(this), type = othis.data('type'); fly.json(collection + type + '/', { cid: div.data('id'), typeid: div.data('typeid'), }, function (res) { if (type === 'add') { othis.data('type', 'remove').html(langCancelCollection).addClass('layui-btn-danger'); } else if (type === 'remove') { othis.data('type', 'add').html(langCollection).removeClass('layui-btn-danger'); } }); } }; $('body').on('click', '.jie-admin', function () { var othis = $(this), type = othis.attr('type'); gather.jieAdmin[type] && gather.jieAdmin[type].call(this, othis.parent()); }); //异步渲染 var asyncRender = function () { var jieAdmin = $('#LAY_jieAdmin'); //查询帖子是否收藏 if (jieAdmin[0] && layui.cache.user.uid != -1) { $.post("/Collection/find.html",{ cid: jieAdmin.data('id'), typeid: jieAdmin.data('typeid')},function(res){ jieAdmin.append('<span class="layui-btn layui-btn-xs jie-admin ' + (res.data.collection ? 'layui-btn-danger' : '') + '" type="collect" data-type="' + (res.data.collection ? 'remove' : 'add') + '">' + (res.data.collection ? langCancelCollection : langCollection) + '</span>'); }) } }(); var is_tj = true; //解答操作 gather.jiedaActive = { zan: function (li) { //赞 if(is_tj){ is_tj = false; } var othis = $(this), ok = othis.hasClass('icon-hover'); $.post(commentJiedaZan,{comment_id:li.data('id'),type:2,is_zan:1},function(data){ if(data.code == 0){ layer.msg(data.msg); setTimeout("window.parent.location.reload()", 2000); } else { layer.msg(data.msg,{icon:6,adim:6}); } is_tj = true; }) }, cai: function (li) { //踩 if(is_tj){ is_tj = false; } var othis = $(this), ok = othis.hasClass('icon-hover'); $.post(commentJiedaZan,{comment_id:li.data('id'),type:2,is_zan:2},function(data){ if(data.code == 0){ layer.msg(data.msg); setTimeout("window.parent.location.reload()", 2000); } else { layer.msg(data.msg,{icon:6,adim:6}); } is_tj = true; }) } , reply: function (li) { //回复 var val = dom.content.val(); var aite = '@' + li.find('.forum-head-user cite').text().replace(/\s/g, ''); dom.content.focus() if (val.indexOf(aite) !== -1) return; dom.content.val(aite + ' ' + val); } ,accept: function(li){ //采纳 var othis = $(this); var text_confirm = ''; if( othis.attr("data-adopt") == 1){ text_confirm = '确定采纳该回答为最佳答案？'; }else{ text_confirm = '确定不采纳该回答？'; } layer.confirm(text_confirm, function(index){ layer.close(index); fly.json(commentJiedaCai, { id: li.data('id'), adopt: othis.attr("data-adopt") }, function(res){ if(res.status === 0){ location.reload(); } else { layer.msg(res.msg); } }); }); } , edit: function (li) { //编辑评论 fly.json(commentGetDa, { id: li.data('id') }, function (res) { var data = res.rows; layer.prompt({ formType: 2 , value: data.content , maxlength: 100000 , title: '编辑回帖' , area: ['738px', '310px'] , success: function (layero) { fly.layEditor({ elem: layero.find('textarea') }); } }, function (value, index) { fly.json(commentUpdateDa, { id: li.data('id') , content: value }, function (res) { layer.close(index); layer.msg(res.msg); li.find('.detail-body').html(fly.content(value)); }); }); }); } , del: function (li) { //删除评论 layer.confirm('确认删除该回答么？', function (index) { layer.close(index); fly.json(commentJiedaDelete, { id: li.data('id') }, function (res) { if (res.status === 0) { var count = dom.jiedaCount.text() | 0; dom.jiedaCount.html(--count); li.remove(); //如果删除了最佳答案 if (li.hasClass('jieda-daan')) { $('.jie-status').removeClass('jie-status-ok').text('求解中'); } } else { layer.msg(res.msg); } }); }); } }; $('.jieda-reply span').on('click', function () { var othis = $(this), type = othis.attr('type'); gather.jiedaActive[type].call(this, othis.parents('li')); }); }); </script> <script src="/static/jquery-3.6.0.min.js"></script> <script src="/addons/taonyeditor/tinymce/tinymce.min.js"></script> <script src="/addons/taonyeditor/tinymce/tinymce-jquery.min.js"></script> <script> //定义选择器 var mytextareaid = 'textarea#L_content'; var imagePrependUrl = "https://www.xckfsq.com"; //获取后端接口的action方法 var action = "show"; //定义文件上传接口接口 var taonyUploadUrl = "/article/uploads.html", taonyUploadImgage = "/article/uploads.html?type=image", taonyUploadVideo = "/article/uploads.html?type=video"; taonyUploadZip = "/article/uploads.html?type=zip"; taonyUploadAudio = "/article/uploads.html?type=audio"; $(mytextareaid).removeClass(); var gz_userlist = []; </script> <script src="/addons/taonyeditor/js/taonyeditor.js"></script> <script> layui.extend({ editor: '{/}/addons/taonyeditor/js/taonyeditor' }).use(['editor'], function () { var editor = layui.editor; // 1.渲染内容 $('.detail-body').each(function(){ var othis = $(this), html = othis.html(); othis.html(editor.content(html)); }); //获取后端接口的controller方法 var controller = "News"; // 2.从详情页自动调用端口过滤，获取描述信息(只有在add和edit才调用此方法) if(controller == 'Article' && (action == 'add' || action == 'edit')) { tinymce.get('L_content').on('mouseleave', function() { //var content = $(this).val(); var content = tinymce.get('L_content').getContent({format: 'text'}); content = content.replace(/[\r\n]/g,"").replace(/\n/g, '').replace(/\s/g, '').replace(/\t/g, ''); if(content.length >200) { content = content.substring(0,200); } $('[name="description"]').val(content); }); } }); </script> <script src="/static/res/mods/highlight.min.js"></script> <script> $(document).ready(function() { $('pre').each(function(i, block) { hljs.highlightBlock(block); }); }); </script> <script> var collection = "/collection/", articleJieset = "/news/jieset.html", articleDelete = "/Article/delete.html", commentJiedaZan = "/Comment/jiedaZan.html", commentJiedaCai = "/Comment/jiedaCai.html", commentGetDa = "/Comment/getDa.html", commentUpdateDa = "/Comment/updateDa.html", commentJiedaDelete = "/Comment/jiedaDelete.html", langCollection = "收藏", langCancelCollection = "收藏 -"; layui.use(['fly', 'face','colorpicker', 'laypage'], function(){ var $ = layui.jquery ,form = layui.form ,fly = layui.fly ,colorpicker = layui.colorpicker ,laytpl = layui.laytpl ,uid = layui.cache.user.uid ,laypage = layui.laypage; var id = "31203"; //如果你是采用模版自带的编辑器，你需要开启以下语句来解析。 var taonystatus = "1"; // 编辑器插件启用状态 var isShow = taonystatus ? false : true; if(isShow) { $('.detail-body').each(function(){ var othis = $(this), html = othis.html(); othis.html(fly.content(html)); }); } //评论需要登陆 form.on('submit(user-comment)',function (data){ var index = layer.load(1); var filed = data.field; if (uid == -1) { layer.msg('请先登陆',{icon:5,time:2000},function(){location.href = "/login.html"}); } else { $.ajax({ type: "post", url: "/news/comment.html", data: filed, dataType: "json", success:function (data) { if (data.code == 0) { layer.msg(data.msg,{icon:6,adim:6},function () { location.reload(true); }); }else { layer.open({title:'评论失败',content:data.msg,icon:5,anim:6}); } } }); } return false; }); //下载 $('#zip-download').click(function (){ var id = "31203"; $.ajax({ type:"get", url:"/news/download.html", data:{id:id}, success:function (res) { if(res.code == 0){ location.href = res.src; }else{ layer.msg(res.msg); return false; } } }); }); //关注 $(".guanzhu").click(function () { var user_id = "3792"; if(uid == -1){ layer.msg('请登录再操作', {icon: 6}, function(){location.href = "/login.html"}) return false; } $.post("/userfollow/add.html",{to_user_id:user_id},function(data){ if(data.code == 0){ layer.msg(data.msg,{icon:6,adim:6},function () { location.reload(true); }); } else { layer.msg(data.msg,{icon:6,adim:6}); } }) }); function scrollTo(prop){ $('html,body').animate({scrollTop: $(prop).offset().top + parseInt($(prop).css('padding-top'),10) + parseInt($(prop).css('margin-top'),10)},'slow'); } var hash = window.location.hash; if (hash !== '') { var elem = $('#' + hash.replace('#', '')); // 接下来可以继续使用elem变量进行操作 if(elem) { scrollTo(elem); } } else { // 处理URL中没有'#'字符的情况 } $(".comment-ks p").click(function () { let html = $(this).html(); var content = tinymce.get('L_content').getContent(); $("textarea#L_content").val(content+html); $("textarea#L_content").removeAttr("lay-verify"); tinymce.get('L_content').save(); form.render(); }); }); </script> <script> var importCssJs = { css: function (path) { if (!path || path.length === 0) { throw new Error('参数"path"错误'); } var head = document.getElementsByTagName('head')[0]; var link = document.createElement('link'); link.href = path; link.rel = 'stylesheet'; link.type = 'text/css'; head.appendChild(link); }, js: function (path) { if (!path || path.length === 0) { throw new Error('参数"path"错误'); } var head = document.getElementsByTagName('head')[0]; var script = document.createElement('script'); script.src = path; script.type = 'text/javascript'; head.appendChild(script); } } $(function () { importCssJs.css('/addons/markdown/easyeditor/css/easyeditor.css'); importCssJs.js('/addons/markdown/easyeditor/js/marked.min.js'); }); $("#content").removeClass().addClass('easyeditor-content'); layui.config({ base: '/addons/markdown/easyeditor/mods/' }).extend({ easyeditor: 'easyeditor' }).use(['easyeditor'], function () { var easyeditor = layui.easyeditor; easyeditor.init({ elem: '.editor' //textarea 元素class , uploadUrl: "/article/uploads.html?type=image" //图片上传地址 , videoUploadUrl: "/article/uploads.html?type=video", videoUploadSize: '102400' //限制的上传大小 单位kb 默认 10240 kb , uploadSize: '' //限制的上传大小 单位kb 默认 1024k , style: 'fangge',//内置样式 目前只有默认 和 方格两种 //codeStyle:'layuiCode', //代码风格 layuiCode风格 与 默认风格 //,codeSkin:'notepad' //代码框样式 默认不填 与notepad 该属性与codeStyle='layuiCodexw'搭配使用 //,buttonColor:'#FFB800' //自定义按钮颜色 //,hoverBgColor:'red' // 自定义鼠标悬浮背景颜色 //,hoverColor:'#000000' // 自定义鼠标悬浮按钮颜色 }); easyeditor.render({ elem: ".easyeditor-content" //存放md内容的元素ID }); function markdown() { var othis = $('.easyeditor-content'); var content = othis.html(); } }); </script> <script> //扫码阅读 $("#rdown").hover(function(){ $("#phonedl").show().stop(); },function(){ $("#phonedl").hide().stop(); }); $("#phonedl").hover(function(){ $("#phonedl").show().stop(); },function(){ $("#phonedl").hide().stop(); }); function PhoneDown(){ layer.open({ title: "扫码查阅", skin: 'layui-layer', content: "<img src='/qrcode/?text=https://www.xckfsq.com/article/detail.html?id=31203&size=230'>" }); } </script> </body> </html>