Message sending method and device

Abstract

The invention provides a message sending method and device, and relates to the technical field of communication, and the method comprises the steps: classifying and storing imported user data of different data types, and obtaining a database table storing different data types; creating a plurality of variables in the database table, wherein each variable corresponds to a respective query statement; a message sending template is set, fixed sending content is edited in the message sending template, and a plurality of target variables are added in the message sending template; and querying in the database table through the target query statements corresponding to the plurality of target variables to obtain reusable user data, and sending reusable message content established by the reusable user data and the fixed sending content to at least one recipient. Therefore, by performing variable editing and template editing on the database table of the imported user data, the reusable message content can be flexibly generated, and each variable can be obtained again in the database table when being sent, so that the real-time performance and reliability of the message are ensured.

Description

Technical Field

[0001] The present invention relates to the field of communication technology, and in particular to a message sending method and device. Background Art

[0002] In the related art, when sending a message, usually in a fixed system, after editing the fixed content, setting the recipient information, and calling the interface regularly to trigger the email sending. Therefore, the original system is highly bound to the user management module, and the system cannot be modularized and split out. In addition, the message content is fixed and cannot be flexibly configured. A more convenient message sending method is urgently needed. Summary of the invention

[0003] The present invention aims to solve one of the technical problems in the related art at least to a certain extent.

[0004] To this end, the first purpose of the present invention is to propose a message sending method, which can flexibly generate reusable message content by performing variable editing and template editing on the database table of imported user data, and each variable will be retrieved from the database table when sending, thereby ensuring the real-time and reliability of the message.

[0005] A second objective of the present invention is to provide a message sending device.

[0006] A third objective of the present invention is to provide an electronic device.

[0007] A fourth object of the present invention is to provide a non-transitory computer-readable storage medium storing computer instructions.

[0008] A fifth object of the present invention is to provide a computer program product.

[0009] To achieve the above object, a first embodiment of the present invention provides a message sending method, comprising:

[0010] Importing user data, and classifying and storing the user data based on data types of the user data to obtain a database table storing the different data types;

[0011] Creating a plurality of variables in the database table, each variable being set with a recipient field and a receipt date field as a first query condition, or a user-defined preset field as a second query condition, and generating a query statement corresponding to the first query condition or the second query condition;

[0012] A message sending template is set, wherein the message sending template has fixed sending content edited therein, and a plurality of target variables are added to the message sending template;

[0013] The database table is queried through target query statements corresponding to multiple target variables to obtain reusable user data, and reusable message content composed of the reusable user data and fixed sending content is sent to at least one recipient.

[0014] To achieve the above-mentioned purpose, a second embodiment of the present invention provides a message sending device, comprising:

[0015] A user management module, used for importing user data, and classifying and storing the user data based on the data type of the user data, so as to obtain a database table storing the different data types;

[0016] A variable editing module, used to create multiple variables in the database table, each variable is set with a recipient field and a receipt date field as a first query condition, or a user-defined preset field as a second query condition, and generate a query statement corresponding to the first query condition or the second query condition;

[0017] A template setting module is used to set a message sending template, wherein the message sending template is edited with fixed sending content, and a plurality of target variables are added to the message sending template;

[0018] The message sending module is used to query the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and send the reusable message content composed of the reusable user data and fixed sending content to at least one recipient.

[0019] To achieve the above-mentioned purpose, the third aspect of the present invention proposes an electronic device, comprising: at least one processor; and a memory communicatively connected to the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the method described in the first aspect.

[0020] In order to achieve the above-mentioned purpose, the fourth aspect of the present invention proposes a non-transitory computer-readable storage medium storing computer instructions, where the computer instructions are used to enable the computer to execute the method described in the first aspect.

[0021] In order to achieve the above-mentioned purpose, a fifth aspect of the present invention provides a computer program product, and when the computer program is executed by a processor, it implements the method described in the first aspect.

[0022] The message sending method, device, electronic device and storage medium provided by the embodiment of the present invention classify and store the imported user data of different data types to obtain a database table storing different data types; create multiple variables in the database table, each variable corresponds to its own query statement; set a message sending template, the message sending template is edited with fixed sending content and multiple target variables are added; query the database table through the target query statements corresponding to the multiple target variables to obtain reusable user data, and send the reusable message content composed of reusable user data and fixed sending content to at least one recipient. Therefore, by editing the variables and templates of the database table of the imported user data, reusable message content can be flexibly generated, and each variable will be retrieved from the database table when sending, so as to ensure the real-time and reliability of the message.

[0023] Additional aspects and advantages of the present invention will be given in part in the following description and in part will be obvious from the following description, or will be learned through practice of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0024] The above and / or additional aspects and advantages of the present invention will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0025] Figure 1 A schematic diagram of a flow chart of a message sending method provided by an embodiment of the present invention;

[0026] Figure 2 A schematic diagram of another message sending implementation process provided by an embodiment of the present invention;

[0027] Figure 3 A diagram of an application device of a message sending method provided by an embodiment of the present invention;

[0028] Figure 4 A schematic diagram of the structure of a message sending device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0029] Embodiments of the present invention are described in detail below, examples of which are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are intended to be used to explain the present invention, and should not be construed as limiting the present invention.

[0030] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in the present invention are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards.

[0031] The acquisition, transmission, storage, use, and processing of data in the technical solution of the present invention are in compliance with the relevant provisions of relevant laws and regulations.

[0032] It should be noted that in the embodiments of the present invention, certain software, components, models and other existing solutions in the industry may be mentioned, which should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present invention, but it does not mean that the applicant has or will necessarily use the solution.

[0033] The message sending method and device according to the embodiments of the present invention are described below with reference to the accompanying drawings.

[0034] Figure 1 A flowchart of a message sending method provided by an embodiment of the present invention.

[0035] like Figure 1 As shown, the method comprises the following steps:

[0036] Step 101 : importing user data, and classifying and storing the user data based on the data type of the user data, so as to obtain a database table storing different data types.

[0037] Optionally, the user data may be some email data or enterprise data, which is not specifically limited in this embodiment.

[0038] Furthermore, the data type of the user data may be determined by the user's behavioral attributes, but is not limited thereto.

[0039] In some embodiments, when importing user data, if the user belongs to a preset user whitelist, the user data can be imported in a user whitelist manner. Specifically, the user whitelist is a security mechanism that defines a group of allowed or trusted entities, which can be email addresses, IP addresses, websites, and applications, so that no additional checks or verifications are required, thereby improving the efficiency of importing user data.

[0040] Furthermore, taking the email user whitelist as an example, the email user whitelist refers to a list of trusted email addresses set by the user. When emails from addresses in the address list arrive, the email system will not identify them as spam, but directly put them into the normal inbox, thus avoiding important emails being misjudged as spam and missed.

[0041] The database used by the database table may be a relational database (Structured Query Language, SQL), but is not limited thereto.

[0042] Step 102, create multiple variables in the database table, each variable is set with the recipient field and the receipt date field as the first query condition, or the user-defined preset field as the second query condition, and generate a query statement corresponding to the first query condition or the second query condition.

[0043] In some embodiments, a back-end (server) may generate a query statement corresponding to the first query condition or the second query condition. Specifically, the recipient field and the receipt date field may be written through SQL to obtain a first SQL statement corresponding to the first query condition. Similarly, the user-defined preset field may be written through SQL to obtain a second SQL statement corresponding to the second query condition.

[0044] Among them, the user-defined preset fields may include but are not limited to name, address, and email address, which are not specifically limited in this embodiment.

[0045] Step 103, setting a message sending template, in which fixed sending content is edited, and a plurality of target variables are added to the message sending template.

[0046] In some embodiments, the message sending template is a reusable message body, in which the fixed sending content can be edited arbitrarily, and one or more target variables can be added anywhere therein, the target variables including variable recipients and receiving time or user-defined preset fields. The edited message sending template can be referenced before subsequent message sending, wherein the backend is the spring framework.

[0047] The edited fixed content may include but is not limited to the title, introduction, and conclusion of the message, which is not specifically limited in this embodiment.

[0048] Step 104, query the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and send the reusable message content composed of the reusable user data and fixed sending content to at least one recipient.

[0049] In some embodiments, when the message sending template filled with the reusable message content is sent to at least one recipient in the form of an email, the size of the attachment uploaded in the email is lower than a preset threshold and is sent together with the reusable message content. Thus, after the email data is imported, the email data is packaged and packed to achieve sending emails to multiple people at one time.

[0050] Optionally, the preset threshold may be 5M but is not limited thereto.

[0051] In addition, the message sending template filled with the reusable message content may be sent to at least one recipient via SMS.

[0052] In other embodiments, the message sending method can also be integrated as a plug-in to be applied in the user management page, variable editing page, template editing page, message content page, and log page corresponding to different project front ends. The user management page is used to classify user data, the variable editing page is used to create multiple variables in the database table, the template editing page is used to set the message sending template, the message content page is used to form a reusable message content, and the log page is used to collect the sending log of each reusable message content. Among them, the front end introduces the Lerna tool to support JavaScript frameworks (vue2 and vue3 frameworks). Therefore, the front end references lerna to achieve compatibility with vue2 and vue3 frameworks, and is compatible with other projects using different technical frameworks.

[0053] The message sending method of the embodiment of the present invention classifies and stores the imported user data of different data types to obtain a database table storing different data types; creates multiple variables in the database table, each variable corresponds to its own query statement; sets a message sending template, in which fixed sending content is edited and multiple target variables are added; queries the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and sends the reusable message content composed of reusable user data and fixed sending content to at least one recipient. Thus, by performing variable editing and template editing on the database table of imported user data, reusable message content can be flexibly generated, and each variable will be retrieved from the database table when sending, ensuring the real-time and reliability of the message.

[0054] In order to clearly explain the previous embodiment, this embodiment further provides a message sending method. Figure 2 A schematic flow chart of another message sending method provided by an embodiment of the present invention.

[0055] like Figure 2 As shown, the method may include the following steps:

[0056] Step 201 : importing user data, and classifying and storing the user data based on the data type of the user data, so as to obtain a database table storing different data types.

[0057] Step 202, create multiple variables in the database table, each variable is set with the recipient field and the receipt date field as the first query condition, or the user-defined preset field as the second query condition, and generate a query statement corresponding to the first query condition or the second query condition.

[0058] Step 203, setting a message sending template, in which fixed sending content is edited, and a plurality of target variables are added to the message sending template.

[0059] It should be noted that, for the specific implementation of steps 201 to 203, reference may be made to the relevant description in the above embodiments.

[0060] Step 204, query the database table through the target query statements corresponding to the multiple target variables to obtain the reusable user data and determine the message body composed of the reusable user data and the fixed sending content.

[0061] In some embodiments, when the database used by the database table is SQL and the corresponding target query statement is an SQL statement, the SQL database table is queried through the SQL statement to obtain the reusable user data corresponding to the recipient field and the receiving date field, and then the message sending template is filled with the fixed sending content to obtain the message body of the message sending template. Therefore, each target variable will be retrieved from the database when sending the message, ensuring the real-time and reliability of the message body.

[0062] Step 205, based on the sending requirements of the sender, modify the content and format of the message sending template filled with the message body to obtain reusable message content, and send the message sending template filled with the reusable message content to at least one recipient, wherein each reusable message content has a unique identity.

[0063] In some embodiments, when the sender needs to add or delete requirements, the content and format of the message sending template that fills in the message body are added or deleted to obtain reusable message content. Furthermore, when sending via email, the content and format of the email body of the email message sending template can be added or deleted to achieve flexibility in message sending.

[0064] Among them, the unique identity of each reusable message content can be generated through the recipient and the recipient address, but is not limited to this.

[0065] Step 206, collecting the sending log of each reusable message content through a preset log collection system, wherein the log includes the sent reusable message content, recipient, receipt date, and whether the sending is successful.

[0066] In some embodiments, the preset log collection system may be Flume, which is mainly used to collect, aggregate and transmit massive log data to achieve rapid log collection. The log collection system will store the sending record regardless of whether the reusable message content is sent successfully.

[0067] The message sending method of the embodiment of the present invention classifies and stores the imported user data of different data types to obtain a database table storing different data types; creates multiple variables in the database table, each variable corresponds to a respective query statement; sets a message sending template, in which fixed sending content is edited and multiple target variables are added; queries the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and determines the message body composed of reusable user data and fixed sending content; based on the sending requirements required by the sender, the message sending template filled with the message body is modified in content and format to obtain reusable message content, and the message sending template filled with reusable message content is sent to at least one recipient, wherein each reusable message content has a unique identity; and collects the sending log of each reusable message content through a preset log collection system, wherein the log includes the sent reusable message content, recipient, receiving date, and whether the sending is successful. Therefore, after the database table of the imported user data is edited with variables and templates, the reusable message content can be flexibly modified to improve the flexibility of message sending.

[0068] In addition, the embodiment of the present invention also provides an application device diagram of a message sending method, such as Figure 3As shown, specifically, the application device of the message sending method may include a user data management module, a template management module, a message content management module, and a message log management module, wherein the user management module is used to import user data, and when importing user data, supports classification of user data and import of user whitelist; the template management module includes two functions: variable editing and template editing, the variable editing is used to create multiple variables in the database table, each variable is set with a recipient field and a receipt date field as the first query condition, or a user-defined preset field as the second query condition, the template editing is used to set a message sending template, the message sending template is edited with fixed sending content, and multiple target variables are added to the message sending template to generate reusable message content; the message content management module is used to import the message sending template to modify the content and format of the reusable message content, and the message sending template is sent in the form of an email, and supports uploading attachments; the message log management module is used to record the sending log, and the sending log includes the reusable message content, the recipient, the receipt date, and whether the sending is successful. Thus, the separation of the user data system and the user data management module and the flexible configuration of the reusable message content are realized.

[0069] In order to implement the above embodiment, the present invention also provides a message sending device.

[0070] Figure 4 A schematic diagram of the structure of a message sending device provided by an embodiment of the present invention.

[0071] like Figure 4 As shown, the message sending device 40 includes: a user management module 41, a variable editing module 42, a template setting module 43 and a message sending module 44.

[0072] A user management module 41, used for importing user data, and classifying and storing the user data based on the data type of the user data, so as to obtain a database table storing the different data types;

[0073] The variable editing module 42 is used to create a plurality of variables in the database table, each variable is set with a recipient field and a receipt date field as a first query condition, or a user-defined preset field as a second query condition, and generate a query statement corresponding to the first query condition or the second query condition;

[0074] The template setting module 43 is used to set a message sending template, wherein the message sending template is edited with fixed sending content, and a plurality of target variables are added to the message sending template;

[0075] The message sending module 44 is used to query the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and send the reusable message content composed of the reusable user data and fixed sending content to at least one recipient.

[0076] Furthermore, in a possible implementation manner of the embodiment of the present invention, when importing user data, if the user belongs to a preset user whitelist, the user data is imported in a user whitelist manner.

[0077] Furthermore, in a possible implementation of the embodiment of the present invention, the message sending module 44 is specifically configured to:

[0078] Querying the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and determining a message body consisting of the reusable user data and fixed sending content;

[0079] Based on the sending requirements of the sender, the content and format of the message sending template filled with the message body are modified to obtain reusable message content, and the message sending template filled with the reusable message content is sent to at least one recipient, wherein each reusable message content has a unique identity.

[0080] Furthermore, in a possible implementation of an embodiment of the present invention, when the message sending template filled with reusable message content is sent to at least one recipient by email, the size of the attachment uploaded in the email is lower than a preset threshold and is sent together with the reusable message content.

[0081] Furthermore, in a possible implementation of the embodiment of the present invention, the device further includes:

[0082] The message log module is used to collect the sending log of each reusable message content through a preset log collection system, wherein the log includes the sent reusable message content, recipient, receipt date, and whether the sending is successful.

[0083] Furthermore, in a possible implementation of the embodiment of the present invention, the device further includes:

[0084] An integration module is used to integrate the message sending device into a plug-in for application in the user management page, variable editing page, template editing page, message content page, and log page corresponding to different project front ends. The user management page is used to classify the user data, the variable editing page is used to create multiple variables in the database table, the template editing page is used to set the message sending template, the message content page is used to assemble reusable message content, and the log page is used to collect the sending log of each reusable message content. The front end introduces the Lerna tool to support the JavaScript framework.

[0085] The message sending device of the embodiment of the present invention classifies and stores the imported user data of different data types to obtain a database table storing different data types; creates multiple variables in the database table, each variable corresponds to its own query statement; sets a message sending template, in which fixed sending content is edited and multiple target variables are added; queries the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and sends the reusable message content composed of reusable user data and fixed sending content to at least one recipient. Thus, by performing variable editing and template editing on the database table of imported user data, reusable message content can be flexibly generated, and each variable will be retrieved from the database table when sending, ensuring the real-time and reliability of the message.

[0086] In order to implement the above embodiment, the present invention further provides an electronic device, including:

[0087] at least one processor; and

[0088] a memory communicatively connected to the at least one processor; wherein,

[0089] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can perform the aforementioned method.

[0090] In order to implement the above embodiment, the present invention further proposes a non-transitory computer-readable storage medium storing computer instructions, where the computer instructions are used to enable the computer to execute the above method.

[0091] In order to implement the above embodiments, the present invention further provides a computer program product, including a computer program, wherein the computer program implements the above method when executed by a processor.

[0092] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" etc. means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representations of the above terms do not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner. In addition, those skilled in the art may combine and combine the different embodiments or examples described in this specification and the features of the different embodiments or examples, without contradiction.

[0093] In addition, the terms "first" and "second" are used for descriptive purposes only and should not be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined as "first" and "second" may explicitly or implicitly include at least one of the features. In the description of the present invention, the meaning of "plurality" is at least two, such as two, three, etc., unless otherwise clearly and specifically defined.

[0094] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code comprising one or more executable instructions for implementing the steps of a custom logical function or process, and the scope of the preferred embodiments of the present invention includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present invention belong.

[0095] The logic and / or steps represented in the flowchart or otherwise described herein, for example, can be considered as an ordered list of executable instructions for implementing logical functions, and can be embodied in any computer-readable medium for use by an instruction execution system, device or apparatus (such as a computer-based system, a system including a processor, or other system that can fetch instructions from an instruction execution system, device or apparatus and execute the instructions), or in combination with these instruction execution systems, devices or apparatuses. For the purpose of this specification, "computer-readable medium" can be any device that can contain, store, communicate, propagate or transmit a program for use by an instruction execution system, device or apparatus, or in combination with these instruction execution systems, devices or apparatuses. More specific examples of computer-readable media (a non-exhaustive list) include the following: an electrical connection with one or more wires (electronic device), a portable computer disk box (magnetic device), a random access memory (RAM), a read-only memory (ROM), an erasable and programmable read-only memory (EPROM or flash memory), a fiber optic device, and a portable compact disk read-only memory (CDROM). In addition, the computer-readable medium may even be paper or other suitable medium on which the program is printed, since the program may be obtained electronically, for example, by optically scanning the paper or other medium and then editing, interpreting or processing in other suitable ways if necessary, and then stored in a computer memory.

[0096] It should be understood that the various parts of the present invention can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, a plurality of steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0097] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0098] In addition, each functional unit in each embodiment of the present invention may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0099] The storage medium mentioned above may be a read-only memory, a magnetic disk or an optical disk, etc. Although the embodiments of the present invention have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limiting the present invention. A person of ordinary skill in the art may change, modify, replace and modify the above embodiments within the scope of the present invention.

Claims

1. A message sending method, characterized in that: The method comprises: Importing user data, and classifying and storing the user data based on data types of the user data to obtain a database table storing the different data types; Creating a plurality of variables in the database table, each variable being set with a recipient field and a receipt date field as a first query condition, or a user-defined preset field as a second query condition, and generating a query statement corresponding to the first query condition or the second query condition; A message sending template is set, wherein the message sending template has fixed sending content edited therein, and a plurality of target variables are added to the message sending template; The database table is queried through target query statements corresponding to multiple target variables to obtain reusable user data, and reusable message content composed of the reusable user data and fixed sending content is sent to at least one recipient.

2. The method according to claim 1, characterized in that When importing user data, if the user belongs to a preset user whitelist, the user data is imported in a user whitelist manner.

3. The method according to claim 1, characterized in that The target query statements corresponding to the multiple target variables are used to query the database table to obtain reusable user data, and the reusable message content composed of the reusable user data and the fixed sending content is sent to at least one recipient, including: Querying the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and determining a message body consisting of the reusable user data and fixed sending content; Based on the sending requirements of the sender, the content and format of the message sending template filled with the message body are modified to obtain reusable message content, and the message sending template filled with the reusable message content is sent to at least one recipient, wherein each reusable message content has a unique identity.

4. The method according to claim 3, characterized in that When the message sending template filled with reusable message content is sent to at least one recipient by email, the size of the attachment uploaded in the email is lower than a preset threshold and is sent together with the reusable message content.

5. The method according to claim 3, characterized in that: After querying the database table through target query statements corresponding to the multiple target variables to obtain reusable user data, and sending the reusable message content composed of the reusable user data and the fixed sending content to at least one recipient, the method further includes: The sending log of each reusable message content is collected through a preset log collection system, wherein the log includes the sent reusable message content, recipient, receipt date, and whether the sending is successful.

6. The method according to claim 5, characterized in that The method further comprises: The message sending method is integrated into a plug-in to be applied in the user management page, variable editing page, template editing page, message content page, and log page corresponding to different project front ends. The user management page is used to classify the user data, the variable editing page is used to create multiple variables in the database table, the template editing page is used to set the message sending template, the message content page is used to assemble reusable message content, and the log page is used to collect the sending log of each reusable message content. Among them, the Lerna tool is introduced in the front end to support the JavaScript framework.

7. A message sending device, characterized in that: The device comprises: A user management module, used for importing user data, and classifying and storing the user data based on the data type of the user data, so as to obtain a database table storing the different data types; A variable editing module, used to create multiple variables in the database table, each variable is set with a recipient field and a receipt date field as a first query condition, or a user-defined preset field as a second query condition, and generate a query statement corresponding to the first query condition or the second query condition; A template setting module is used to set a message sending template, wherein the message sending template is edited with fixed sending content, and a plurality of target variables are added to the message sending template; The message sending module is used to query the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and send the reusable message content composed of the reusable user data and fixed sending content to at least one recipient.

8. The device according to claim 7, characterized in that When importing user data, if the user belongs to a preset user whitelist, the user data is imported in a user whitelist manner.

9. The device according to claim 7, characterized in that The message sending module is specifically used for: Querying the database table through target query statements corresponding to multiple target variables to obtain reusable user data, and determining a message body consisting of the reusable user data and fixed sending content; Based on the sending requirements of the sender, the content and format of the message sending template filled with the message body are modified to obtain reusable message content, and the message sending template filled with the reusable message content is sent to at least one recipient, wherein each reusable message content has a unique identity.

10. The device according to claim 9, characterized in that When the message sending template filled with reusable message content is sent to at least one recipient by email, the size of the attachment uploaded in the email is lower than a preset threshold and is sent together with the reusable message content.

11. The device according to claim 9, characterized in that The device further comprises: The message log module is used to collect the sending log of each reusable message content through a preset log collection system, wherein the log includes the sent reusable message content, recipient, receipt date, and whether the sending is successful.

12. The device according to claim 11, characterized in that The device also includes: An integration module is used to integrate the message sending device into a plug-in for application in the user management page, variable editing page, template editing page, message content page, and log page corresponding to different project front ends. The user management page is used to classify the user data, the variable editing page is used to create multiple variables in the database table, the template editing page is used to set the message sending template, the message content page is used to assemble reusable message content, and the log page is used to collect the sending log of each reusable message content. The front end introduces the Lerna tool to support the JavaScript framework.

13. An electronic device, characterized in that: include: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 6.

14. A non-transitory computer-readable storage medium storing computer instructions, characterized in that: The computer instructions are used to cause the computer to execute the method according to any one of claims 1-6.

15. A computer program product, characterized in that The invention comprises a computer program which, when executed by a processor, implements the method according to any one of claims 1 to 6.

Images