Design a general log audit scheme

1. Demand 1. Record detailed log information with the least code and without changing the business logic code 2. Support log output in file form or database storage, and switch flexibly through configuration file. 2. Implementation To achieve this, annotation and aop must be used to intercept and record logs, so as to minimize changes to b ...

Posted on Sun, 10 May 2020 07:46:16 -0700 by azul85

Example Summary of Oracle Knowledge Points

Article Directory Oracle Knowledge Points Tablespaces, users, roles Tablespace Getting relationships between tablespaces and data files View data block size Query information about tables owned by the current user, accessible tables, and all tables in the current database Query information for all tables ...

Posted on Sun, 10 May 2020 00:00:11 -0700 by sheila

php realizes simple chat function

1. To create a chat message table, its fields include message content, sending time and sender's name; SQL: CREATE TABLE `guanhui`.`message` ( `id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'news ID' , `content` VARCHAR(255) NOT NULL COMMENT 'Message content' , `sender` VARCHAR(60) NOT NULL COMMENT 'sender ' , `send_time` IN ...

Posted on Thu, 07 May 2020 08:33:20 -0700 by thatsme

ubuntu uses mysql and connects it to C + + programs

Install mysql sudo apt-get install mysql-server sudo apt-get install mysql-client sudo apt-get install libmysqlclient-dev During the installation process, you will be prompted to set a password, so that you can complete the mysql installation. You can log in through the following command: mysql -u root -p where - u represents the user n ...

Posted on Tue, 05 May 2020 10:27:51 -0700 by mrneilrobinson

tyboot simple function demonstration without sql encoding

tyboot simple function demonstration without sql encoding tybootdemo source https://gitee.com/magintursh/tybootdemo tyboot source: https://gitee.com/magintursh/tyboot https://github.com/magintursh/tyboot Example project interface screenshot The following are the interface features for this demonstration to demonstrate simple tyboot-based encod ...

Posted on Tue, 05 May 2020 03:38:28 -0700 by ukphoto

String similarity processing function

oracle queries, for example, the jobs related to table SALES in stored procedures SELECT * FROM (SELECT a.name,upper(b.what)AS what,SYS.UTL_MATCH.edit_distance_similarity (a.name,upper(b.what)) AS similarity FROM dba_source a,dba_jobs b WHERE SYS.UTL_MATCH.edit_distance_similarity(a.name,upper(b.what))>80 AND upper(a.text) LIK ...

Posted on Mon, 04 May 2020 16:33:26 -0700 by tartou2

How to use. net delegation and its benefits

usage method: //Definition method of no return value and no parameter delegate public delegate void NoReturnPara(); Several ways to assign values to delegates //Instantiate the delegate and pass in the method NoReturbNoPara noreturn = new NoReturbNoPara(this.DoNothing); //LinqToObject NoReturbNoPara noreturn = () => { }; //Direct assignm ...

Posted on Mon, 04 May 2020 03:17:53 -0700 by mlampard

News crawler based on php, inserted into WordPress database

This reptile has been writing for a long time. It hasn't updated its blog for a long time. 1. The first idea is: you can easily and quickly grab the web page through the curl Φ setopt() function of php. 2. What kind of news attracts people? Of course, hot news. Here choose Baidu's search billboard to get a list of hot keywords. 3. For th ...

Posted on Sun, 03 May 2020 06:30:08 -0700 by bigscanner

Basic knowledge of python operation database

How does python access the database? Through the database interface DB-API, it is a standard to clarify a series of required objects and database access mechanisms. It can provide consistent access for different database adapters and underlying database systems. In order to access the database, python has developed many adapters for connecting ...

Posted on Sun, 03 May 2020 00:47:37 -0700 by harshilshah

java JDBC connecting mysql database

Preface I have to admit the complexity of java code. concept 1 Parameters for creating database links String driver; String url; String user; String password; 2 load database class.formName(driver) 3 get database link Connection conn = DriverManager .getConnection(url,user,passwo ...

Posted on Sat, 02 May 2020 23:15:13 -0700 by tskweb