雅奇-小蘑菇最新说明书

《小蘑菇》建站和WEB应用开发工具-V2015 用户手册 1 目 录

第1章 基础篇 ·········································································· 1

1.1 系统安装 ························································································ 1

1.1.1 软件安装 ................................................................................................................................. 1

1.1.2 安全问题 ................................................................................................................................. 2 1.1.3?浏览器?要求 ....................................................................................................................... 3 1.1.4?电脑配置?要求 ................................................................................................................... 3 1.2 启动系统 ························································································ 4 1.2.1 启动 ......................................................................................................................................... 4 1.2.2“账号、密码” ............................................................................................................................ 5 1.2.3 打开“项目管理器” .................................................................................................................. 7 1.3“新建和设计”项目 ············································································ 7 1.3.1 项目名称 ................................................................................................................................. 8 1.3.2 使用IP或域名 ........................................................................................................................ 8 1.3.3 数据库类型 ........................................................................................................................... 10 1.3.4 打开?网站设计器? ........................................................................................................... 12 1.4“其它”操作 ····················································································· 13 1.4.1“修改?项目 ........................................................................................................................... 13 1.4.2“复制、删除”项目 .................................................................................................................. 15 1.5“服务器和启动” ··············································································· 16 1.5.1 服务“启动” ............................................................................................................................ 16 1.5.2?服务器?说明 ..................................................................................................................... 16 1.6 关于《小蘑菇》“USB卡限量定制版” ················································ 18 1.6.1 区别说明 ............................................................................................................................... 18 1.6.3 界面的自定义编辑 ............................................................................................................... 20 1.6.4 软件升级 ............................................................................................................................... 21 1.6.5 关于USB卡和账号 ............................................................................................................. 21

第2章 网站设计器 ··································································· 23

2.1 设计器结构 ··················································································· 23

2.1.1事件编辑器 ............................................................................................................................ 23

2.1.2 页面设计器 ........................................................................................................................... 25 2.2 图示化语言 ··················································································· 26 2.2.1?图示化语言?的特点 ......................................................................................................... 26 2.2.2 模块和流程图 ....................................................................................................................... 27 2.3“主流程”事件编辑 ·········································································· 30 2.3.1“主流程”结构 .......................................................................................................................... 30 2.3.2 应用实例 ............................................................................................................................... 31 2.4 “图标”和“密码”设置 ································································· 33 2.4.1?网站图标?设置 ................................................................................................................. 34 2.4.2?项目密码?设置 ................................................................................................................. 34

第3章 页面设计器 ··································································· 36

3.1 认识“页面设计器” ······································································· 36

3.1.1“控件选择”.............................................................................................................................. 36

3.1.2“属性设置”.............................................................................................................................. 38 3.1.3?事件定义? ......................................................................................................................... 38 3.1.4?数据源编辑器? ................................................................................................................. 39 3.1.5?智能控制? ......................................................................................................................... 40 3.2 主页面栏目规划 ············································································· 41 3.2.1“页头栏?设计 ....................................................................................................................... 42 3.2.2“菜单导航栏?设计 ............................................................................................................... 44 3.2.3?频道内容栏?设计 ............................................................................................................. 45 3.2.4?页尾栏?设计 ..................................................................................................................... 45

2 《小蘑菇》建站和WEB应用开发工具-V2015 用户手册 3.2.5“固定栏?设计 ....................................................................................................................... 46 3.3“首页面”内容设计 ············································································ 46 3.3.1规划类型 ................................................................................................................................ 46 3.3.2 设计风格实例 ....................................................................................................................... 46 3.4“子页面”内容设计 ············································································ 49 3.4.1?子频道?内容更新原理 ..................................................................................................... 49 3.4.2 多框架的同时更新 ............................................................................................................... 50 3.4.3“多级页面?的设计原理 ....................................................................................................... 51 3.5“网站后台”功能的实现 ··································································· 52 3.5.1?后台管理?变量方式的网站管理后台 ............................................................................. 52 3.5.2?数据库?方式的网站管理后台 ......................................................................................... 58 3.6“页面设计”基础 ··············································································· 74 3.6.1 控件的选用 ........................................................................................................................... 75 3.6.2 使用?帮助? ....................................................................................................................... 75 3.6.3 控件?属性设置? ............................................................................................................... 75 3.6.4?属性公式?编辑器 ............................................................................................................. 77 3.6.5 快捷操作工具 ....................................................................................................................... 87 3.7 页面“应用设置” ·········································································· 90 3.7.1 页面设计器?环境设置? ................................................................................................... 90 3.7.2“Tab键跳转次序?设置 ........................................................................................................ 92 3.8“常用页面”制作实例 ······································································ 92 3.8.1?登录?功能的制作 ............................................................................................................. 93 3.8.2“注册”功能的制作 .................................................................................................................. 95 3.8.3?修改密码?功能制作 ......................................................................................................... 97 3.8.4?新闻?功能的制作 ............................................................................................................. 98 3.8.5?留言与回复?功能的制作 ............................................................................................... 103 3.8.6?论坛?功能的制作 ............................................................................................................111 3.8.7“在线网购订单?功能的制作 ..............................................................................................111 3.8.8 数据库方式的?网站后台管理?制作 ............................................................................. 112 3.8.9?页面访问次数?功能的制作 ........................................................................................... 113 3.8.10?站内短信?功能的制作 ................................................................................................. 115 3.8.11?权限编辑器?的自制 ..................................................................................................... 117 3.8.12“word文档?嵌入网页 ...................................................................................................... 118 3.8.13?软件下载?功能的制作 ................................................................................................. 119 3.8.14?在线试卷?功能的制作 ................................................................................................. 120 3.8.15?页面不允许访问?的设置方法 ..................................................................................... 121 3.8.16 页面中嵌入?站长统计?的设置方法 ........................................................................... 122 3.8.17?站内搜索?功能的设置原理 ......................................................................................... 122 3.9 “控件模板”的应用 ······································································ 122 3.9.1“控件组”保存为模板 ............................................................................................................ 124 3.9.2“控件模板”的交流 ................................................................................................................ 126 3.10“页面”应用说明 ········································································· 127 3.10.1?页面类型?说明 ............................................................................................................. 127 3.10.2?页面?的重用 ................................................................................................................. 127 3.10.3?页面?访问机制 ............................................................................................................. 127

第4章 事件编辑器 ································································· 129

4.1 事件编辑基础 ··············································································· 129

4.1.1 ?控件事件?的编辑方法 ................................................................................................. 129

4.1.2?页面对象?事件编辑器 ................................................................................................... 130 4.1.3 事件流程结构类型 ............................................................................................................. 130 4.2 表达式编辑基础 ············································································ 131 4.2.1 表达式分类 ......................................................................................................................... 131 4.2.2 编辑器结构 ......................................................................................................................... 132 4.2.3 表达式属性 ......................................................................................................................... 135 4.2.4“&()?函数应用 .................................................................................................................... 136

《小蘑菇》建站和WEB应用开发工具-V2015 用户手册 3 4.2.5?如果：?应用 ..................................................................................................................... 136 4.2.6 编辑器?环境设置? ......................................................................................................... 137 4.3“子查询”应用 ·············································································· 137 4.3.1 用?子查询?获得库存余量 ............................................................................................. 137 4.3.2?查询类型?说明 ............................................................................................................... 140 4.3.3?子查询?的引用 ............................................................................................................... 142 4.3.4?子查询?应用实例 ........................................................................................................... 143 4.4“检测执行”模块 ··········································································· 143 4.4.1?程序分支?原理 ............................................................................................................... 144 4.4.2?检测执行?应用实例 ....................................................................................................... 144 5.4.3?检测执行?公式实例 ....................................................................................................... 147 4.5“流程标注”模块 ··········································································· 148 4.5.1?标注文本?编辑 ............................................................................................................... 148 4.5.2 位置和尺寸 ......................................................................................................................... 149 4.5.3 与?标注对象”的连接 ....................................................................................................... 149 4.6“页面模板”的应用 ········································································ 149 4.6.1 页面保存为模板 ................................................................................................................. 149 4.6.2 页面文件的交流 ................................................................................................................. 151 4.7“已有事件”页使用说明 ·································································· 152 4.8“综合任务”应用 ·············································································· 153 4.8.1?控件行为?的调用 ........................................................................................................... 154 4.8.2?已有事件?的引用 ........................................................................................................... 155 4.8.3?控件属性?的动态改变 ................................................................................................... 156 4.8.4?查询公式?的动态改变 ................................................................................................... 161 4.8.5?定位公式?的动态改变 ................................................................................................... 166 4.8.6?排序公式?的动态改变 ................................................................................................... 169 4.8.7“可执行函数”的调用 ............................................................................................................ 172 4.8.8?变量、页变量、公有变量”应用...................................................................................... 173 4.8.9?循环执行?表达式编辑 ................................................................................................... 182

第5章 数据库和数据源 ··························································· 186

5.1 数据库应用 ·················································································· 186

5.1.1 数据库和数据表 ................................................................................................................. 186

5.1.2 字段和记录 ......................................................................................................................... 187 5.2 数据表创建和编辑 ········································································· 188 5.2.1?数据表?创建 ................................................................................................................... 188 5.2.2?数据表?编辑 ................................................................................................................... 189 5.2.3“数据表?修改 ..................................................................................................................... 191 5.2.4 避免网络冲突 ..................................................................................................................... 192 5.3 页面“数据源” ·············································································· 192 5.4“常规型”数据源 ··········································································· 193 5.4.1?常规型?数据源创建 ....................................................................................................... 193 5.1.2?常规型?数据源的提交机制 ........................................................................................... 197 5.1.3 ?数据源?应用说明 ......................................................................................................... 198 5.2“汇总型”数据源 ··········································································· 198 5.2.1“合并汇总?数据源创建 ..................................................................................................... 198 3.2.2?交叉汇总?数据源创建 ................................................................................................... 201 3.2.3“子串分组”的实例说明 ........................................................................................................ 208 3.2.4?汇总计算?的实例说明 ................................................................................................... 213 5.3“数据源组”应用 ············································································ 214 3.3.1、原理说明 ........................................................................................................................... 214 3.3.2 创建?采集数据?的数据源组 ......................................................................................... 216 3.3.3?连接字段? ....................................................................................................................... 218 3.3.4?约束修改和删除?说明 ................................................................................................... 218 3.3.5 修改数据源?设置或连接?的操作 ................................................................................. 220 3.3.6 断开数据源组需要注意的问题 ......................................................................................... 222

4 《小蘑菇》建站和WEB应用开发工具-V2015 用户手册 5.4“数据源”的动态查询 ····································································· 222

5.4.1 使用?查询框?改变“条件公式” ...................................................................................... 222 5.4.2 使用?综合任务?改变?条件公式” ................................................................................ 224 5.4.3?汇总型、计算型?数据源的动态查询 ........................................................................... 227 5.5“条件公式”规则与实例 ····································································· 228 5.5.1 编辑规则 ............................................................................................................................. 228 5.5.2?逻辑表达式?应用 ........................................................................................................... 230 5.5.3“条件公式?应用实例 ......................................................................................................... 232 5.5.4“选择型”条件公式 ................................................................................................................ 233 5.6“高级型”数据源介绍（定制版功能） ··············································· 236 5.6.1?多表视图型?数据源 ....................................................................................................... 236 5.6.2“SQL型?数据源 ................................................................................................................. 238

第6章 “数据管理页面”设计 ····················································· 242

6.1 页面功能规划 ··············································································· 242

6.1.1?采集数据?页面 ............................................................................................................... 242

6.1.2?加工数据?页面 ............................................................................................................... 243 6.2 页面功能的设计步骤 ······································································ 244 6.3 页面“快速设计” ············································································ 245 6.3.1“编辑框?批量设计方法 ..................................................................................................... 245 6.3.2“表单框”设计方法 ................................................................................................................ 246 6.3.3?数据查询?功能制作 ....................................................................................................... 246 6.4 页面“智能化控制” ········································································· 247 6.4.1“智能计算?应用 ................................................................................................................. 247 4.7.2“智能检测?应用 ................................................................................................................. 260 6.4.4“智能显示?应用 ................................................................................................................. 267 6.5 页面“权限控制” ············································································ 272 6.5.1 编辑?用户权限? ............................................................................................................. 272 6.5.2?权限设置表?的使用 ....................................................................................................... 273 6.5.3?权限控制?控件属性 ....................................................................................................... 274 6.5.4?权限控制?数据源条件 ................................................................................................... 275

第7章“数据加工”应用 ··························································· 277

7.1“计算修改”模块 ·············································································· 277

7.1.1“表内计算?功能的实现 ..................................................................................................... 277

7.1.2“表外取值?功能的实现 ..................................................................................................... 282 7.1.3?横纵计算?功能的实现 ................................................................................................... 287 7.1.4“智能计算?规则与实例 ..................................................................................................... 290 7.1.5?计算修改?的高级选项 ................................................................................................... 295 7.2“生成记录”模块 ············································································ 296 7.2.1自动编号?功能的实现 ...................................................................................................... 296 7.2.2自动“行关联取值”的功能实现 ........................................................................................... 298 7.2.3“智能计算?规则与实例 ..................................................................................................... 301 7.2.4?记录条数?规则与实例 ................................................................................................... 301 7.2.5“生成记录”的高级选项 ........................................................................................................ 301 7.3“删除记录”模块 ············································································ 302 6.3.1“条件删除?功能的实现 ..................................................................................................... 302 7.3.2 “删除重复记录”功能的实现 ............................................................................................... 304 7.3.3?子查询条件?实现特殊删除 ........................................................................................... 307 7.3.4?删除记录?的高级选项 ................................................................................................... 310 7.4“复制记录”模块 ··········································································· 311 6.4.1“简单复制?功能的实现 ..................................................................................................... 311 7.4.2“子查询条件?实现特殊复制 ............................................................................................. 314 7.4.3 复制后计算的实例 ............................................................................................................. 317 7.4.4?复制记录?的高级选项 ................................................................................................... 318 7.5“分组汇总”模块 ············································································ 319

《小蘑菇》建站和WEB应用开发工具-V2015 用户手册 5 7.5.1?简单汇总?功能的实现 ................................................................................................... 319 7.5.2 ?子查询?实现特殊汇总 ................................................................................................. 321 7.5.3?子串分组?的实例说明 ................................................................................................... 325 7.5.5?分组汇总?的高级选项 ................................................................................................... 329 7.6“分组累计”模块 ············································································ 329 7.6.1?分组累计?原理说明 ....................................................................................................... 329 7.6.2?顺序排名?功能的实现 ................................................................................................... 330 7.6.3?销量累计?功能的实现 ................................................................................................... 336 7.6.4?子串分组?的实例说明 ................................................................................................... 338 7.6.5?累计递增值”说明 ............................................................................................................. 339 7.6.6?累计初始值?说明 ........................................................................................................... 339 7.6.7?分组累计?的高级选项 ................................................................................................... 340 7.7“行次整理”模块 ············································································ 340 7.7.1?次序整理?功能的实现 ................................................................................................... 340 7.7.2?行次整理?的高级选项 ................................................................................................... 343 7.8“编辑SQL”模块 ··········································································· 343 7.8.1?表达式编辑器?的使用 ................................................................................................... 343 7.8.2“SQL表达式?编辑原理 ..................................................................................................... 344 7.9“综合应用”实例 ··········································································· 344 7.9.1“库存余量?的动态更新应用 ............................................................................................. 344 7.9.2 数据加工后?排序、定位?事件 ..................................................................................... 355

第8章“控件”应用详解·························································· 356

8.1“控件”的共有特性 ········································································· 356

8.1.1 控件的共有?属性” ........................................................................................................... 356

8.1.2控件的共有?事件” ............................................................................................................ 360 8.1.3控件的共有?行为” ............................................................................................................ 360 8.2“页面和数据源” ············································································ 361 8.2.1“页面?单元 ......................................................................................................................... 361 8.2.2“数据源?控件 ..................................................................................................................... 373 8.3 常用控件组 ·················································································· 381 8.3.1?主框架?控件 ................................................................................................................... 381 8.3.2?上下框架?控件 ............................................................................................................... 384 8.3.3?框架?控件 ....................................................................................................................... 385 8.3.4?面板?控件 ....................................................................................................................... 388 8.3.5?多层面板?控件 ............................................................................................................... 391 8.3.6?隐式面板?控件 ............................................................................................................... 398 8.3.7“文本标签?控件 ................................................................................................................. 399 8.3.8?格式文本?控件 ............................................................................................................... 402 8.3.9?标题字?控件 ................................................................................................................... 411 8.3.10?图文列表框?控件 ......................................................................................................... 412 8.3.11?线框?控件 ..................................................................................................................... 418 8.3.12?图片?控件 ..................................................................................................................... 418 8.3.13?图片轮转?控件 ............................................................................................................. 420 8.3.14?图片滚动?控件 ............................................................................................................. 424 8.3.15?播放图片?控件 ............................................................................................................. 428 8.3.16“FLV视频?控件 ............................................................................................................... 431 8.3.17?透明视频?控件 ............................................................................................................. 433 8.3.18“多媒体播放?控件 ........................................................................................................... 436 8.3.19?声音?控件 ..................................................................................................................... 438 8.3.20?按键?控件 ..................................................................................................................... 439 8.3.21?文字按键?控件 ............................................................................................................. 441 8.3.22?卡片式菜单?控件 ......................................................................................................... 444 8.3.23?链接热区?控件 ............................................................................................................. 447 8.3.24?独立事件?控件 ............................................................................................................. 448 8.4 数据控件组 ·················································································· 450

本文来源：https://www.bwwdw.com/article/jdm3.html