java毕业设计 springboot公司网站企业网站 springboot毕业设计题目课题选题 springboot毕业设计项目作品源码（2）开发概要和数据库表

我就是我 2022-09-16 04:50 147阅读 0赞

## 开发概要 ##

开发环境：JDK1.8 + Tomcat8

开发语言：Java

开发框架：springboot

模板引擎：Thymeleaf

开发工具：Idea2020

数据库：mysql8

数据库管理工具：navicat

其他开发语言：html + css +javascript

## 文件对应说明表 ##

### **后台管理文件** ###

都在Com.huang.cms包下

下面是后台管理所涉及的

<table> 
 <tbody> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> 程序名 </td> 
 <td style="border-color:#000000;vertical-align:top;width:152.45pt;"> 包含 </td> 
 <td style="border-color:#000000;vertical-align:top;width:152.45pt;"> </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/fenzu.java 后台分组管理 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_fenzu_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 分组权限列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_fenzu_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 分组权限 修改 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ guanliyuan.java 后台用户管理 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /ht_mima </td> 
 <td style="vertical-align:top;width:152.45pt;"> 密码修改 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_user_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台用户录入 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_user_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台用户列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_user_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 用户修改 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ guanyu.java 关于我们设置 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_shezhi_guanyu </td> 
 <td style="vertical-align:top;width:152.45pt;"> 关于我们设置 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_guanggao_shezhi </td> 
 <td style="vertical-align:top;width:152.45pt;"> 设置广告 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_liuyan_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 留言列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_liuyan_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除留言 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ huiyuan.java 后台框架 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /login </td> 
 <td style="vertical-align:top;width:152.45pt;"> 用户登录页面 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /main </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台首页 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /top </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台顶部文件 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /center </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台中间文件首页 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /middel </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台中间文件（包含左右） </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /left </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台中间文件-左边 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /tab </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台中间文件-右边 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /down </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台底部文件 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /logout </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台退出登录 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ quanxian.java 后台权限管理 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_caidan_1ji </td> 
 <td style="vertical-align:top;width:152.45pt;"> 1级菜单列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_caidan_2ji </td> 
 <td style="vertical-align:top;width:152.45pt;"> 2级菜单列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_caidan_2ji_nei </td> 
 <td style="vertical-align:top;width:152.45pt;"> 2级菜单 操作 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_caidan_3ji </td> 
 <td style="vertical-align:top;width:152.45pt;"> 3级菜单列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /quanxian_caidan_3ji_nei </td> 
 <td style="vertical-align:top;width:152.45pt;"> 3级菜单 操作页面 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ xinxi.java 后台新闻管理 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_xinxi_fenlei </td> 
 <td style="vertical-align:top;width:152.45pt;"> 信息分类管理 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_xinxi_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 信息录入 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_xinxi_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 信息列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_xinxi_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 修改资讯 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_xinxi_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除资讯 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/ yonghu.java 用户管理 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_yonghu_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 用户列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /houtai_yonghu_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除用户 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/anli 后台案例 </td> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 案例录入 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 案例列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 修改案例 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除案例 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_pinglun_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台 案例 评论 列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_anli_pinglun_caozuo </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台 案例 评论 列表操作（修改xiugai和删除del） </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> houtai/chanpin 后台产品 </td> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_fenlei </td> 
 <td style="vertical-align:top;width:152.45pt;"> 产品分类管理 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 产品录入 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 产品列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 修改产品 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除产品 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> houtai_chanpin_pinglun_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台 产品 评论 列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> outai_chanpin_pinglun_caozuo </td> 
 <td style="vertical-align:top;width:152.45pt;"> 后台 产品 评论 列表操作（修改xiugai和删除del） </td> 
 </tr> 
 </tbody> 
</table>

### **前台文件** ###

都在Com.huang.cms包下

下面是后台管理所涉及的

<table> 
 <tbody> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> 程序名 </td> 
 <td style="border-color:#000000;vertical-align:top;width:152.45pt;"> 包含 </td> 
 <td style="border-color:#000000;vertical-align:top;width:152.45pt;"> </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_controller.java 前台公用controller类 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_zixun_chaxun </td> 
 <td style="vertical-align:top;width:152.45pt;"> 资讯查询 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /api_zixun_shoucang </td> 
 <td style="vertical-align:top;width:152.45pt;"> 收藏接口 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /api_zixun_pinglun_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 资讯评论 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_mima_act </td> 
 <td style="vertical-align:top;width:152.45pt;"> 密码修改 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_logout </td> 
 <td style="vertical-align:top;width:152.45pt;"> 退出登录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_guanyu_liuyan_add </td> 
 <td style="vertical-align:top;width:152.45pt;"> 留言信息 写入数据库 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_index.java 前台首页 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_index </td> 
 <td style="vertical-align:top;width:152.45pt;"> 首页 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_mem.java 前台会员 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_huiyuan_zhuce </td> 
 <td style="vertical-align:top;width:152.45pt;"> 注册 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_huiyuan_denglu </td> 
 <td style="vertical-align:top;width:152.45pt;"> 登录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_index </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员首页 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_xinxi_xiugai </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 信息修改 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_mima </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 密码修改 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_ pc_mem_controller.java 前台会员controller类 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /check_mem_reg </td> 
 <td style="vertical-align:top;width:152.45pt;"> 验证 用户注册 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /check_mem_login </td> 
 <td style="vertical-align:top;width:152.45pt;"> 验证 用户登录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_zixun_shoucang_del </td> 
 <td style="vertical-align:top;width:152.45pt;"> 删除 用户资讯收藏 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_mem_zixun.java 会员资讯 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_zixun_liulan </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 资讯 浏览记录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_zixun_shoucang </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 资讯 收藏列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_mem_zixun_pinglun </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 资讯 评论记录 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_public.java 前台公用类 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_toubu </td> 
 <td style="vertical-align:top;width:152.45pt;"> 头部文件 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_guanyu_women </td> 
 <td style="vertical-align:top;width:152.45pt;"> 关于我们 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_guanyu_liuyan </td> 
 <td style="vertical-align:top;width:152.45pt;"> 留言反馈 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_zixun.java 资讯 </td> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_zixun_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 资讯列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> /pc_zixun_xiangqing </td> 
 <td style="vertical-align:top;width:152.45pt;"> 资讯详情 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_anli.java 案例 </td> 
 <td style="vertical-align:top;width:152.45pt;"> pc_anli_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 案例列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_anli_xiangqing </td> 
 <td style="vertical-align:top;width:152.45pt;"> 案例详情 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_chanpin.java 产品 </td> 
 <td style="vertical-align:top;width:152.45pt;"> pc_chanpin_list </td> 
 <td style="vertical-align:top;width:152.45pt;"> 产品列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_chanpin_xiangqing </td> 
 <td style="vertical-align:top;width:152.45pt;"> 产品详情 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_mem_anli.java 会员案例 </td> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_anli_liulan </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 案例 浏览记录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_anli_shoucang </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 案例 收藏列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_anli_pinglun </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 案例 评论记录 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> pc/ pc_mem_chanpin.java 会员产品 </td> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_chanpin_liulan </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 产品 浏览记录 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_chanpin_shoucang </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 产品 收藏列表 </td> 
 </tr> 
 <tr> 
 <td style="vertical-align:top;width:152.45pt;"> pc_mem_chanpin_pinglun </td> 
 <td style="vertical-align:top;width:152.45pt;"> 会员 产品 评论记录 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:152.4pt;"> </td> 
 <td style="vertical-align:top;width:152.45pt;"> </td> 
 <td style="vertical-align:top;width:152.45pt;"> </td> 
 </tr> 
 </tbody> 
</table>

## 数据库表 ##

### **关于我们概要表：gaiyao** ###

存放关于我们的相关项目数据

### **广告表：guanggao** ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> Int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz1 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告1的链接地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz2 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告2的链接地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> wz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的文字 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> tpdz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> ljdz3 </td> 
 <td style="vertical-align:top;width:3cm;"> longtext </td> 
 <td style="vertical-align:top;width:260.5pt;"> 广告3的链接地址 </td> 
 </tr> 
 </tbody> 
</table>

### **留言表：liuyan** ###

### **会员表：huiyuan** ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> shouji </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 手机号：用户名 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> mima </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 密码 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> </td> 
 <td style="vertical-align:top;width:3cm;"> </td> 
 <td style="vertical-align:top;width:260.5pt;"> </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xingming </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 姓名 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xingbie </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 性别 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> qq </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> QQ号 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> youxiang </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> Email </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> touxiang </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 头像地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> jianjie </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 简介 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> jieshao </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 介绍 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> add_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 注册日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> add_shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 注册时间 </td> 
 </tr> 
 </tbody> 
</table>

### **资讯分类表：zixun\_fenlei** ###

### **资讯表：zixun** ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> Int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_lxid1 </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息1级类型的id，参考资讯类型表的id </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_biaoti </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息标题 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyin </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有简介：1表示有简介；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 简介内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有图片：1表示有图片；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_ding </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 预留是否置顶：1表示置顶；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_neirong </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> riqi </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的时间 </td> 
 </tr> 
 </tbody> 
</table>

### **资讯收藏表：zixun\_shoucang** ###

### **资讯浏览记录表：zixun\_liulan** ###

### **资讯评论表：zixun\_pinglun** ###

### **产品分类表：cp\_leixing** ###

### **产品表：cp** ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> Int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_lxid1 </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息1级类型的id，参考资讯类型表的id </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_biaoti </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息标题 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyin </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有简介：1表示有简介；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 简介内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有图片：1表示有图片；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_ding </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 预留是否置顶：1表示置顶；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_neirong </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> riqi </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的时间 </td> 
 </tr> 
 </tbody> 
</table>

### **产品浏览记录表：cp\_liulan** ###

### **产品评论表：cp\_pinglun** ###

### **案例收藏表：anli\_shoucang** ###

### **案例表：anli** ###

<table> 
 <tbody> 
 <tr> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:111.75pt;"> 字段名 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:3cm;"> 类型 </td> 
 <td style="background-color:#f2f2f2;border-color:#000000;width:260.5pt;"> 备注 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> id </td> 
 <td style="vertical-align:top;width:3cm;"> Int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 自动递增；菜单的id（主键），不允许空 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_lxid1 </td> 
 <td style="vertical-align:top;width:3cm;"> int </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息1级类型的id，参考资讯类型表的id </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_biaoti </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息标题 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_riqi </td> 
 <td style="vertical-align:top;width:3cm;"> date </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyin </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有简介：1表示有简介；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_jianjie </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 简介内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian_yn </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 是否有图片：1表示有图片；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_tupian </td> 
 <td style="vertical-align:top;width:3cm;"> varchar </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息图片地址 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_ding </td> 
 <td style="vertical-align:top;width:3cm;"> tinyint </td> 
 <td style="vertical-align:top;width:260.5pt;"> 预留是否置顶：1表示置顶；0没有 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> xinxi_neirong </td> 
 <td style="vertical-align:top;width:3cm;"> text </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息内容 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> riqi </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的日期 </td> 
 </tr> 
 <tr> 
 <td style="border-color:#000000;vertical-align:top;width:111.75pt;"> shijian </td> 
 <td style="vertical-align:top;width:3cm;"> datetime </td> 
 <td style="vertical-align:top;width:260.5pt;"> 信息发布的时间 </td> 
 </tr> 
 </tbody> 
</table>

### **案例浏览记录表：anli\_liulan** ###

### **案例评论表：anli\_shoucang** ###

### **案例收藏表：anli\_shoucang** ###