学成在线项目数据库表结构分析

1. cms-config 配置

域	解释
“_id”	ObjectId(“5a791725dd573c3574ee333f”),
“_class”	“com.xuecheng.framework.domain.cms.CmsConfig”
“name”	“轮播图”、精品推荐、分类信息
“model”	json格式的数据模型

例子

{ 
    "_id" : ObjectId("5a791725dd573c3574ee333f"), 
    "_class" : "com.xuecheng.framework.domain.cms.CmsConfig", 
    "name" : "轮播图", 
    "model" : [
        {
            "key" : "banner1", 
            "name" : "轮播图1地址", 
            "value" : "http://192.168.101.64/group1/M00/00/01/wKhlQFp5wnCAG-kAAATMXxpSaMg864.png"
        }, 
        {
            "key" : "banner2", 
            "name" : "轮播图2地址", 
            "value" : "http://192.168.101.64/group1/M00/00/01/wKhlQVp5wqyALcrGAAGUeHA3nvU867.jpg"
        }, 
        {
            "key" : "banner3", 
            "name" : "轮播图3地址", 
            "value" : "http://192.168.101.64/group1/M00/00/01/wKhlQFp5wtWAWNY2AAIkOHlpWcs395.jpg"
        }
    ]
}

查询此表

1. 条件查询

 		//条件查询
 		int size=9;
        int page=1;
        Pageable pageable=PageRequest.of(page,size);
        CmsPage cmsPage = new CmsPage();
        cmsPage.setSiteId("5a751fab6abb5044e0d19ea1");
        ExampleMatcher matching = ExampleMatcher.matching();
        Example< CmsPage> example=Example.of(cmsPage,matching);
        Page<CmsPage> all = cmsPageRepository.findAll(example, pageable);
        System.out.println(all.getContent());

2. 模糊查询

//只需要在匹配器上设置参数就行
cmsPage.setPageAliase("轮播");
matching=matching.withMatcher("pageAliase",ExampMatcher.GenericPropertyMatchers.contains());

2. cms-page 页面信息

域	解释
“_class”	“com.xuecheng.framework.domain.cms.CmsPage”
“siteId”	站点ID — “5a751fab6abb5044e0d19ea1”
“pageName”	“index.html” 页面名称
“pageAliase”	页面别名
“pageWebPath”	访问地址 — “/index.html”
“pagePhysicalPath”	物理地址 --“F:\develop\xc_portal_static\”
“pageType”	静态页面或者动态页面 “0”
“pageCreateTime”	创建时间 ISODate(“2018-02-03T05:37:53.256+0000”)
“templateId”	模板ID—“5a962b52b00ffc514038faf7”
“htmlFileId”	“5a7c1c54d019f14d90a1fb23”

{ 
    "_id" : ObjectId("5a754adf6abb500ad05688d9"), 
    "_class" : "com.xuecheng.framework.domain.cms.CmsPage", 
    "siteId" : "5a751fab6abb5044e0d19ea1", 
    "pageName" : "index.html", 
    "pageAliase" : "首页", 
    "pageWebPath" : "/index.html", 
    "pagePhysicalPath" : "F:\\develop\\xc_portal_static\\", 
    "pageType" : "0", 
    "pageCreateTime" : ISODate("2018-02-03T05:37:53.256+0000"), 
    "templateId" : "5a962b52b00ffc514038faf7", 
    "htmlFileId" : "5a7c1c54d019f14d90a1fb23"
}

cms-site 站点数据

域	解释
_id	ObjectId( 5a751fab6abb5044e0d19ea1 ) page数据中的siteID
_class	com.xuecheng.framework.domain.cms.CmsSite
siteName	门户主站
siteDomain	http
sitePort	80 ,
siteWebPath	/
siteCreateTime	ISODate( 2018-02-03T02

{ 
    "_id" : ObjectId("5a751fab6abb5044e0d19ea1"), 
    "_class" : "com.xuecheng.framework.domain.cms.CmsSite", 
    "siteName" : "门户主站", 
    "siteDomain" : "http://localhost", 
    "sitePort" : "80", 
    "siteWebPath" : "/", 
    "siteCreateTime" : ISODate("2018-02-03T02:34:19.113+0000")
}

cms-site-server 服务器信息

域	解释
_id	ObjectId(5a754bdb6abb500ad05688db)
_class	com.xuecheng.framework.domain.cms.CmsSiteServer
ip	127.0.0.1
port	80
webPath	/
serverName	门户服务器
uploadPath	/upload
siteId	5a751fab6abb5044e0d19ea1

cms-template 模板信息

域	解释
_id	ObjectId(5a925be7b00ffc4b3c1578b5)
_class	com.xuecheng.framework.domain.cms.CmsTemplate
siteId	5a751fab6abb5044e0d19ea1
templateName	模板名称 课程详情页面
templateParameter	courseid
templateFileId	模板文件ID 5ad8a51f68db5240b42e5fea

fileSystem 文件系统 fastDFS

域	解释
_id	group1/M00/00/01/wKhlQFp5fGiAUSkDAAARA0xqVgo187.png
_class	com.xuecheng.framework.domain.filesystem.FileSystem
filePath	group1/M00/00/01/wKhlQFp5fGiAUSkDAAARA0xqVgo187.png
fileSize	NumberLong(4355)
fileName	asset-logo.png
fileType	image/png
fileWidth	NumberInt(0)
fileHeight	NumberInt(0)

fs.chunks 大文件存储

域	解释
_id	ObjectId(5a7719d76abb5042987eec3b)
files_id	ObjectId(5a7719d76abb5042987eec3a)
n	NumberInt(0)
data	BinData(0，“大文件字符码” )

fs.file 文件存储

域	解释
_id	ObjectId(5a7719d76abb5042987eec3a)
metadata	{cms-page的所有信息}
filename	index.html
aliases	null
chunkSize	NumberLong(261120)
uploadDate	ISODate(2018-02-04T14
length	NumberLong(33595)
contentType	null
md5	abea232200712179ed3dce1505c1be46

sys-dictionary

域	解释
_id	ObjectId(5a7d50bdd019f150f4ab8ef7)
d_name	文件类型
d_type	100
d_value	[ { “sd_name” : “cms配置图片”, “sd_id” : “100001”, “sd_status” : “1”}]

user-test 用户测试

域	解释
_id	ObjectId(5abe3b9c5b05aa218434f4cf)
_class	com.xuecheng.framework.domain.test.UserTest
name	传智播客
createTime	ISODate(2018-03-30T13