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