Timer Program Design Sharing
Timer Programming Sharing
Timer Program Design Sharing
1. Background
The timer program referred to in this paper is not a narrow timer program, but a general way to achieve certain business scenarios through the timer trigger program, combined with the database.
2. Scheme Analysis
3.1 Scene 1
3.1.1 Requirements
We need to push comp ...
Posted by KGodwin on Wed, 18 Dec 2019 23:37:24 -0800
New micro ORM framework of Weed3 for java
Weed3, micro ORM framework (support: java sql, xml sql, annotation sql; stored procedure; transaction; cache; monitor; etc.)
The first generation was developed in 2005;
In 2008, the second generation was developed. At that time, it entered the Internet company and had a new understanding of performance;
The third generation was developed in 14 ...
Posted by adamp1 on Tue, 17 Dec 2019 20:08:00 -0800
File migration to FileTable
Before reading this document, please refer to the document https://blog.csdn.net/download/article/details/24374609
Environment: alicloud ECS SQL Server 2017 + Delphi7
It seems that xcopy, robocopy and other commands can not be used to migrate files. If you have any interested friends, let me know.
You can use T-SQL, but you need files on the se ...
Posted by Roman Totale on Tue, 17 Dec 2019 06:40:22 -0800
Technology sharing: an interesting exploration of MySQL client command usage
Author: Chen Yi
preface
This article briefly introduces some tips of "MySQL client" often used in operation and maintenance. These tips will not be used by non professional DBAs. Professional DBAs are necessary. I hope you can use my share.
The built-in commands of MySQL client are as follows, and we will explore 6 of them:
List of ...
Posted by jeff_lawik on Tue, 17 Dec 2019 00:57:10 -0800
Under MVC in Java Web
There is a lot of code, skip it and understand that logic is studying code
Introduce
Looking back at the projects in the previous section, the final hierarchy is:
On MVC, we analyze the advantages and disadvantages of MVC design mode, and add Service layer to deal with business logic, but this is not complete. For large projects, the program s ...
Posted by zTagged on Mon, 16 Dec 2019 20:53:49 -0800
Using nfs to realize remote backup and recovery of database
The importance of mysql (mariadb) database backup:
Data is one of the most important files in a database. When our database is damaged, many of our programs will be affected, which will affect the normal operation of the company. Now more and more enterprises begin to pay more and more attention to the database, so we are requ ...
Posted by alfieshooter on Mon, 16 Dec 2019 11:50:16 -0800
The use of Navicat software and pymysql
I. installation and use of navicate
download
Baidu searches navicate directly, as shown below
Connect to database
New database and new table
Select and right-click
modeling
Using navicate to query practice
--Query the names of all courses and the corresponding teachers
-- SELECT
-- course.cname,
-- teacher.tname
-- FROM
...
Posted by wiseass on Mon, 16 Dec 2019 06:16:49 -0800
Table operation of oracle rookie learning
First episode: http://www.arppinging.com/wordpress/?p=96
Table operation of oracle rookie learning
1. create table
In oracle, create table is used to create a table
SQL> create table student(sno number(6),sname varchar2(12),address varchar2(20));
Table created.
SQL> desc student;
Name Null? Type ...
Posted by darklight on Sun, 15 Dec 2019 14:22:33 -0800
Installation and use of greenplus plug-in tablefunc (row column conversion)
Note: this plug-in is only demonstrated in the test environment. If it is used in the production environment, please assess the risk yourself
Environment list:
Host 1: intranet: 125.10.1.166
System configuration list:
IP
HOSTNAME
CPU
MEM
DISK
RELEASE
1 ...
Posted by beermaker74 on Sun, 15 Dec 2019 12:44:00 -0800
Oracle (5) stored procedures
stored procedure
I think it's just a function.... maybe it didn't get to the point, please let me know.
[general structure]
create or replace procedure storage name (input variable name data structure of variable)
as
begin
Operation statement
end;
Call stored procedure
exec procedure name ()
[example 1] create a store ...
Posted by Luvac Zantor on Sun, 15 Dec 2019 12:32:15 -0800