CN113254444B - Background attachment implementation method for customized television desktop component - Google Patents

Background attachment implementation method for customized television desktop component Download PDF

Info

Publication number
CN113254444B
CN113254444B CN202110572571.2A CN202110572571A CN113254444B CN 113254444 B CN113254444 B CN 113254444B CN 202110572571 A CN202110572571 A CN 202110572571A CN 113254444 B CN113254444 B CN 113254444B
Authority
CN
China
Prior art keywords
component
content
type
type value
database table
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202110572571.2A
Other languages
Chinese (zh)
Other versions
CN113254444A (en
Inventor
秦赞
彭一亮
杨胜
黄睿葱
龙杰
宋舰
邓文科
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sichuan Hongmagic Cube Network Technology Co ltd
Original Assignee
Sichuan Hongmagic Cube Network Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sichuan Hongmagic Cube Network Technology Co ltd filed Critical Sichuan Hongmagic Cube Network Technology Co ltd
Priority to CN202110572571.2A priority Critical patent/CN113254444B/en
Publication of CN113254444A publication Critical patent/CN113254444A/en
Application granted granted Critical
Publication of CN113254444B publication Critical patent/CN113254444B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/445Program loading or initiating
    • G06F9/44521Dynamic linking or loading; Link editing at or after load time, e.g. Java class loading
    • G06F9/44526Plug-ins; Add-ons

Abstract

The invention discloses a method for realizing background attachment of a customized component of a television desktop, which comprises the steps of creating a database table according to a component type and a content type, and respectively storing the component type, a component type value, a content type value and a content type value into the database table; the component type value corresponds to the component strategy, and the content type value corresponds to the content strategy one by one; establishing a one-to-one corresponding relation between the component type and the content type; the front end initiates a request, a json character string in request information is transmitted into a Controller layer at the rear end, the Controller layer calls a Bean acquisition method according to the component type value and the content type value to transmit a json parameter to a corresponding Service layer for realization, the type value is converted into a target entity, and corresponding operation is carried out after parameter verification is carried out; and storing the association relationship between the plate and the component. The invention manages database table uniformly, reduces interface quantity, and maintains each type of component and content separately.

Description

Background attachment implementation method for customized television desktop component
Technical Field
The invention relates to the technical field of televisions, in particular to a background attachment implementation method of a television desktop customized component.
Background
In background attachment of a television desktop component, if the relationship between a board, a component and a content is hierarchical association, as shown in fig. 1, when a plurality of types exist in both a component type and a content type, the first method is to create a database table of the component and the content, which contains all fields as much as possible, or to associate the components and the content according to the hierarchy of board-component-content; the second is to perform component-to-content by type, and the tile re-associates all components and content, as shown in FIG. 2. The first method has the disadvantages of more fields, low field utilization rate, difficult expansion and the like; the second method has the advantages that the data pressure can be reduced by the fact that the components and the content are divided into tables, all parts are maintained separately, but when new types of components and content are added, a large number of interfaces are added, and the components and the content are not easy to maintain and develop.
Disclosure of Invention
The invention aims to provide a background attachment implementation method of a customized component of a television desktop, which is used for solving the problems that in the prior art, a plate, a component and content are associated according to a fixed hierarchy, fields are more, and the field utilization rate is low, and the problems that when the component and the content are subjected to table division according to types, and the plate is associated with all the components and the content again, a large number of interfaces are increased, and development and maintenance are difficult when the components and the content are newly added.
The invention solves the problems through the following technical scheme:
a background attachment implementation method for a television desktop customization component comprises the following steps:
step S1: creating a database table according to the component type, storing the component type and the component type value of the component into the database table, and reducing the pressure of the component table; creating a database table according to the content type, storing the content type and the content type value of the content into the database table, and reducing the pressure of the content table; if the components need the content, each type of component corresponds to one type of content, namely the components correspond to the content one by one, and the integral independence of each component is ensured; the component type values correspond to component strategies one by one, and the component strategies comprise operations of adding, deleting, modifying, checking and the like to the components; the content type values correspond to content strategies one by one, and the content strategies comprise operations of adding, deleting, modifying, checking and the like to the content; when the front end sends a request, parameter values of component types and content types need to be attached, so that the number of interfaces is greatly reduced, and unified maintenance and management are facilitated;
and determining the component strategy through the component type value sent by the front end request, determining the content strategy through the content type value sent by the front end request, and returning a processing result after processing. This has the advantage that each type of component can be developed and maintained separately;
step S2: establishing an association relationship between the components and the content through the component type value, the component unique ID, the content unique ID and the content type value, wherein the component types correspond to the content types one to one, and the association relationship between the components and the content is stored in a database;
and step S3: the front end initiates a request, a json character string in request information is transmitted to a Controller layer at the rear end, and the json character string comprises a component type, a component type value, a content type and a content type value, so that the number of interfaces is greatly reduced, and unified maintenance and management are facilitated; the Controller layer calls a Bean acquisition method of the stratey layer according to the component type value and the content type value;
and step S4: calling a corresponding Bean method and transmitting json parameters to a corresponding Service layer for realization, converting the requested json character strings into target entities according to type values, and then performing parameter verification, thereby flexibly solving the problem that the parameter verification cannot be performed on a Controller layer; after the parameter verification is passed, corresponding operation is carried out according to the component strategy and the content strategy;
step S5: and establishing the incidence relation between the plate and the component through the plate unique ID, the component type value and the component unique ID and storing the incidence relation into a database.
In the step S4, a fastjson self-contained method is adopted to convert the json character string into an entity of a component or content, and then the parameter verification is performed by using the programming verification of the Spring validity.
Compared with the prior art, the invention has the following advantages and beneficial effects:
on the basis of performing table division on the components and the content according to types, the invention establishes the association relationship between the components and the content according to the one-to-one correspondence relationship between the component types and the content types, unifies the component interface inlets and the content interface inlets, reduces the number of interfaces, maintains each type of component and content independently and ensures the integral independence of each component.
Drawings
FIG. 1 is a schematic diagram of a prior art attachment method;
FIG. 2 is a schematic diagram of a prior art demand assignment logic;
FIG. 3 is a schematic diagram of the attachment logic of the present invention;
FIG. 4 is a diagram of an implementation of component management code according to the present invention.
Detailed Description
The present invention will be described in further detail with reference to examples, but the embodiments of the present invention are not limited thereto.
The embodiment is as follows:
a method for realizing background attachment of a customized component of a television desktop comprises the following steps:
step S1: a database table is created according to the component type, and the component type value of the component are stored in the database table, so that unified management is facilitated, and the pressure of the component table is reduced; creating a database table according to the content type, storing the content type and the content type value of the content into the database table, and reducing the pressure of the content table; if the components need the content, each type of component corresponds to one type of content, namely the components correspond to the content one by one, and the integral independence of each component is ensured; the component type values correspond to component strategies one by one, and the component strategies comprise adding, deleting, modifying and checking operations of the components; the content type values correspond to content strategies one by one, and the content strategies comprise adding, deleting, modifying and checking operations of the content; when the front end sends a request, parameter values of component types and content types need to be attached, so that the number of interfaces is greatly reduced, and unified maintenance and management are facilitated;
and determining the component strategy through the component type value sent by the front end request, determining the content strategy through the content type value sent by the front end request, and returning a processing result after processing. This has the advantage that each type of component can be developed and maintained separately;
step S2: establishing an association relationship between the components and the content through the component type value, the component unique ID, the content unique ID and the content type value, wherein the component types correspond to the content types one to one, and the association relationship between the components and the content is stored in a database;
as shown in fig. 3, the content is classified into a custom content, a list content, a background broadcast content, a fitness content, and other contents by type, and the custom content corresponds to the custom component according to the content type value and the component type value; the list content corresponds to the list component, the background broadcast content corresponds to the background broadcast component, the fitness content corresponds to the fitness component, and other content corresponds to other components. The components are then associated with the tiles.
And step S3: as shown in fig. 4, the front end initiates a request, a json character string in the request information is transmitted to a Controller layer at the rear end, and the json character string contains a component type, a component type value, a content type and a content type value, so that the number of interfaces is greatly reduced, and uniform maintenance and management are facilitated; the Controller layer calls a Bean acquisition method of the Strategy layer according to the component type value and the content type value;
and step S4: calling a corresponding Bean method and transmitting json parameters to a corresponding Service layer for realization, converting the requested json character strings into target entities according to type values, and then performing parameter verification, thereby flexibly solving the problem that parameter verification cannot be performed on a Controller layer; for the incoming parameters with hierarchical relation, the nested verification of Spring validity is adopted to verify the parameters; for the same entity, only part of parameters are different in check rule during updating and adding, and the group check of Spring validity is adopted to check the parameters;
after the parameter verification is passed, corresponding operation is carried out according to the component strategy and the content strategy; such as querying data, updating data, or inserting data into a database, etc.; if the verification fails, performing unified abnormal throwing and returning a result;
step S5: and establishing the association relationship between the plate and the component through the plate unique ID, the component type value and the component unique ID, and storing the association relationship into a database.
In the step S4, a fastjson method is adopted to convert the json character string into an entity of a component or a content, and then the parameter is verified by using the Spring validity programming verification.
Although the invention has been described herein with reference to the illustrated embodiments thereof, which are intended to be the only preferred embodiments of the invention, it is not intended that the invention be limited thereto, since many other modifications and embodiments will be apparent to those skilled in the art and will be within the spirit and scope of the principles of this disclosure.

Claims (2)

1. A background attachment implementation method for a television desktop customization component is characterized by comprising the following steps:
step S1: creating a database table according to the component type, and storing the component type and the component type value of the component into the database table; creating a database table according to the content type, and storing the content type and the content type value of the content into the database table; the component type values correspond to component strategies one by one, and the component strategies comprise adding, deleting, modifying and checking operations on the components; the content type values correspond to content strategies one by one, and the content strategies comprise adding, deleting, modifying and checking operations of the content;
step S2: establishing an association relationship between the components and the content through the component type values, the component unique IDs, the content unique IDs and the content type values, wherein the component types correspond to the content types one to one, and the association relationship is stored in a database;
and step S3: the front end initiates a request, a json character string in request information is transmitted into a Controller layer at the rear end, and the json character string comprises a component type, a component type value, a content type and a content type value; the Controller layer calls a Bean acquisition method of the Strategy layer according to the component type value and the content type value;
and step S4: calling a corresponding Bean method and transmitting json parameters to a corresponding Service layer for realization, converting the requested json character string into a target entity according to a type value, and then performing parameter verification, and performing corresponding operation according to a component strategy and a content strategy after the parameter verification is passed;
step S5: and establishing the association relationship between the plate and the component through the plate unique ID, the component type value and the component unique ID, and storing the association relationship into a database.
2. The method as claimed in claim 1, wherein step S4 is performed by using a fastjson-owned method to convert json strings into entities of components or contents, and then using a Spring Validation programming to verify parameters.
CN202110572571.2A 2021-05-25 2021-05-25 Background attachment implementation method for customized television desktop component Active CN113254444B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110572571.2A CN113254444B (en) 2021-05-25 2021-05-25 Background attachment implementation method for customized television desktop component

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110572571.2A CN113254444B (en) 2021-05-25 2021-05-25 Background attachment implementation method for customized television desktop component

Publications (2)

Publication Number Publication Date
CN113254444A CN113254444A (en) 2021-08-13
CN113254444B true CN113254444B (en) 2022-11-04

Family

ID=77184316

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110572571.2A Active CN113254444B (en) 2021-05-25 2021-05-25 Background attachment implementation method for customized television desktop component

Country Status (1)

Country Link
CN (1) CN113254444B (en)

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103092613A (en) * 2012-12-31 2013-05-08 中山大学 Widget middleware system based on smart television
CN105164668A (en) * 2013-03-06 2015-12-16 谷歌公司 Automatic alignment of multi-dimensional layout
CN106843817A (en) * 2015-12-03 2017-06-13 陈包容 A kind of intelligent display method and device of mobile terminal desktop component
CN106980508A (en) * 2017-04-01 2017-07-25 百度在线网络技术(北京)有限公司 Method and apparatus for generating the page
CN109085977A (en) * 2018-08-10 2018-12-25 武汉优品楚鼎科技有限公司 A kind of method, system and device of customized market functional module showing interface
CN109561156A (en) * 2018-12-23 2019-04-02 广东行远信息技术有限公司 A kind of web terminal system based on content distribution and screen display control
CN110737666A (en) * 2019-10-25 2020-01-31 四川虹魔方网络科技有限公司 method for supporting operational television pre-release
CN111538930A (en) * 2020-03-26 2020-08-14 中国平安人寿保险股份有限公司 Home page display method and related equipment
CN111831295A (en) * 2020-07-13 2020-10-27 四川虹魔方网络科技有限公司 Television desktop system implementation method for automatic media asset operation

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8413205B2 (en) * 2001-09-19 2013-04-02 Tvworks, Llc System and method for construction, delivery and display of iTV content

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103092613A (en) * 2012-12-31 2013-05-08 中山大学 Widget middleware system based on smart television
CN105164668A (en) * 2013-03-06 2015-12-16 谷歌公司 Automatic alignment of multi-dimensional layout
CN106843817A (en) * 2015-12-03 2017-06-13 陈包容 A kind of intelligent display method and device of mobile terminal desktop component
CN106980508A (en) * 2017-04-01 2017-07-25 百度在线网络技术(北京)有限公司 Method and apparatus for generating the page
CN109085977A (en) * 2018-08-10 2018-12-25 武汉优品楚鼎科技有限公司 A kind of method, system and device of customized market functional module showing interface
CN109561156A (en) * 2018-12-23 2019-04-02 广东行远信息技术有限公司 A kind of web terminal system based on content distribution and screen display control
CN110737666A (en) * 2019-10-25 2020-01-31 四川虹魔方网络科技有限公司 method for supporting operational television pre-release
CN111538930A (en) * 2020-03-26 2020-08-14 中国平安人寿保险股份有限公司 Home page display method and related equipment
CN111831295A (en) * 2020-07-13 2020-10-27 四川虹魔方网络科技有限公司 Television desktop system implementation method for automatic media asset operation

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
Android平台网络电视机的桌面系统与功能模块的设计与实现;文璨;《中国优秀硕士学位论文全文数据库 信息科技辑》;20130115(第01期);I136-636 *

Also Published As

Publication number Publication date
CN113254444A (en) 2021-08-13

Similar Documents

Publication Publication Date Title
CN109597853B (en) Business scene element serial number generation method, device, medium and computer equipment
CN102446303B (en) Distribution method and device of process route assembly
CN103209223A (en) Distributed application conversation information sharing method and system and application server
CN103186455B (en) Page automatic test script generates method and system
CN110119292A (en) System operational parameters querying method, matching process, device and node device
US20110137958A1 (en) Implementation Method of DATACOM Data Command Platform
CN105183672B (en) A kind of adaptive interface call method and system
CN106713471B (en) Configuration file acquisition method and device
CN111125496A (en) Price query method, device and system
CN111027284B (en) Standardized output method based on flexible data access
CN112464632A (en) Form style dynamic storage and conversion method under excel report
CN111385370A (en) ID allocation method, device, storage medium and ID allocation system
CN113254444B (en) Background attachment implementation method for customized television desktop component
CN105868170A (en) Method for generating industrial data report in server
EP2439881A1 (en) Cluster system and request message distribution method for processing multi-node transaction
CN101694661B (en) Method and device for generating statistical form and statistical server
CN112929331B (en) Universal communication protocol implementation method
CN114285852A (en) Service calling method and device based on multi-stage service platform
CN102402515A (en) General custom query system and method
CN106598690A (en) Code management method and device
CN110704196A (en) Resource data transfer method, device and block chain system
CN103164199B (en) Application model generating apparatus and method based on hierarchy
CN107979580B (en) A kind of access control method, device and server
CN106210159A (en) A kind of domain name analytic method and equipment
CN101925021B (en) Method/system for processing messages and convergence service system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant