1. Background Object Type Hook is an in-depth Hook based on Object Type, which is more in-depth than the commonly used SSDT Hook. For the analysis of Object Type, please see the article “Windows Driver Development Learning Record-ObjectType Hook’s ObjectType Structure Related Analysis”. The Hook used here is one of OkayToCloseProcedure. The article implements filtering […]
Tag: procedure
[Software Testing] Specific operating procedures for bank projects
Project background: The XXXX bank project adopts a B/S structure, mainly to solve the management of tellers, vouchers, cash, accounts, etc. from the deposit, loan, and accounting modules in banking business. Manual Disadvantages: 1. The project business complexity is high and the regression testing workload is heavy 2. The function of a single interface is […]
[MySQL] Stored procedures and stored functions
[MySQL] Stored procedures and stored functions 1. Overview of stored procedures and functions Meaning: The English name for stored procedure is Stored Procedure. Its idea is very simple, it is a set of pre-compiled SQL statements of packaging. Execution process: The stored procedure is stored on the MySQL server in advance. When it needs to […]
OpenProcedure of Windows ObjectType Hook
1. Background Object Type Hook is an in-depth Hook based on Object Type, which is more in-depth than the commonly used SSDT Hook. For the analysis of Object Type, please see the article “Windows Driver Development Learning Record-ObjectType Hook’s ObjectType Structure Related Analysis”. The Hook used here is one of the OpenProcedures. The article is […]
Views, triggers and stored procedures
Python operates MySQL The origin of SQL: MySQL itself is a C/S architecture, with a server and a client. It comes with a client: mysql.exe The python language has become the client of MySQL (for a server, there can be many clients) Steps: 1. Connect to MySQL first host, port, username, password, charset, library, etc. […]
Python operates MySQL, SQL injection issues, views, triggers, transactions, stored procedures, built-in functions, process control, indexes
1. Python operates MySQL Import third-party module: pymysql Operation steps (text description): 1. Connect to MySQL first host, port, username, password, charset, library, autocommit, etc. 2. Write SQL statements in python 3. Start executing the SQL statement and get the result 4. Processing in python (further processing of data) Code implementation: # 1. Link mysql […]
[From deleting database to running away] MySQL database | Stored procedure | Stored function (use code to assist understanding)
Column [MySQL] Favorite poem: I am even more happy with the thousands of miles of snow in Minshan Mountain. After the three armies are over, they are all happy. Music Sharing【The Right Path】 Welcome and thank everyone for pointing out Xiaoji’s problem Article directory Introduction to stored procedures Characteristics of stored procedures Stored procedure ?create […]
[Oracle] VC6.0 uses odbc to access Oracle stored procedures
Environmental description System environment System: Windows XP IDE: Microsoft Visual C++ 6.0 msado15.dll: File version: 6.2.19041.3570 Product version: 10.0.19041.3570 Data source driver: Oracle in OraClient11g_home1 – Oracle Datebase Client 11g Release 2 (11.2.0.1.0) for Microsoft Windows (32-Bit) Object used msado15.tlh _ConnectionPtr m_pConnection; HRESULT hr = m_pConnection.CreateInstance(“ADODB.Connection”); _RecordsetPtr m_pRecordset; m_pRecordset.CreateInstance(“ADODB.Recordset”); _CommandPtr m_pCommand; m_pCommand.CreateInstance(“ADODB.Command”); _ParameterPtr pInputParam; pInputParam.CreateInstance(__uuidof(Parameter)); […]
SpringBoot environment construction and startup procedures
1: IDEA environment preparation IDEA Community Edition version: 2021.1-2022.1.4 IDEA Professional Edition: No requirement If the IEDA installed on your personal computer is not in this range, you need to uninstall and reinstall it; and you must delete the registry Reference article? IDEA uninstalls and deletes the registry Two: Maven (1) Concept of Maven Maven […]
Stored procedures in MySQL
Stored procedures in MySQL Overview Stored procedures are supported starting from MySQL version 5.0. If we need to write a complex set of SQL statements to achieve certain user needs, then we can write this complex set of SQL statements in the database in advance, and call JDBC to execute this set of SQL statements. […]