Install Oracle11gR2-11.2.0.4 database silently on oraclelinux 7.6
I. prepare the responseFile file 1. For environment deployment, please refer to the blog: 2. Active and standby responseFile files, and obtain file t...
Troubleshooting for abnormal downtime of nodes in Galera Cluster
background Before Group Replication was released, MySQL official replication had asynchronous and semi synchronous. At that time, most companies would...
Add and query data table with object-oriented idea, JDBC code is super detailed
In this paper, the JDBC program is written with the object-oriented idea, and the java program is used to add the student information to the data tabl...
Three states of Hibernate object
hibernate has three states: Transient, persistent, detached The following figure shows the state transition of objects in hibernate: Example 1 @Test ...
Navicat tool and pymysql module of mysql
1. Introduction to ide tools (Navicat) In order to facilitate the test, use the IDE tool, Navicat, which is essentially a socket client, a visual tool...
Rest Framework: IV. authentication component
I. create LoginAuth class to complete the authentication process urls.py url(r'^login/', views.Login.as_view()), url(r'^books/', ...
Character set scrambling in mysql
#View the character set of mysql database mysql> show variables like "%character%"; +--------------------------+------------------------...
Java code generator
Full automatic code generator Project address https://github.com/GitHub-Laziji/mybatis-generator The code template is located under resources and can ...
The implementation of registration function in Java Web
Implementation of registration function Experimental steps 1. Create the database mydb with the character code of utf-8. 2. Create a tb_user table in...
springboot custom exception
Spring boot custom exception and exception handling In a web project, we may need to return different prompt codes to the front end. For example, 401 ...
Deployment and monitoring of MYSQL 5.6 replication from the library
Deployment and monitoring of MYSQL 5.6 replication from the library MYSQL 5.6 installation and deployment #1. Download the installation package wget h...
PHP+Redis can delay tasks and automatically cancel and complete orders
Simple timing task solution: use redis's keyspace notifications (notify events after key failure); (A) business scenario: 1. When a business is t...
[tutorial] Java MySQL connection
Reprinted from http://www.runoob.com/java/java-mysql-connect.html In this chapter, we will show you how to use JDBC to connect to MySQL database. A d...
Python automatic operation and maintenance development: basic Mysql Database Paging and paging in Python code
Back end database paging is implemented according to limit The first writing method: limit the number of pages offset start position select id,name,s...
Troubleshooting of Oracle with high resource consumption but execution = 0
During the daily inspection of a customer's production environment database, it was found that the AWR report had a high resource consumption but...
05 "filter to solve the Chinese scrambling of the request (inherited from HttpServletRequestWrapper)
1) create a new EncodingFilter Create a new filter for all requests in the past. The decoding method used to process the request parameters is UTF-8,...
Small php framework
Project source address Link address( https://github.com/cxp1539/mi... Framework Simple php framework Framework features Single entry index.php Based o...
Project deployment of seed search website based on python
This lecture will explain the deployment process of seed search website in detail. Website presentation: https://bt.mypython.me Source address: https:...
Getting started with Python crawler 17-100 blog crawling data
Written in front I've been blogging for a while, but I suddenly forget that the blog of blog channel can also be grabbed, so I did In fact, it�...
Django's own background management configuration
Configuration of Django's own background management Create projects and apps Modify profile Database configuration DATABASES = { 'default�...
mongodb installation under Centos7 and its simple and practical application
i skeleton spirit Concern August 20, 2018 17:45 * words 141 read 76 comments 0 like 0 mongodb version: 4.0 Official website installation tutorial For...
Appearance mode of design mode (structural type)
[TOC] I. model definition Appearance mode: appearance mode is to provide a unified interface to access a group of interfaces of subsystem. The facade...
Interpretation of PostgreSQL source code (108) - background process (PGPROC data structure)
PostgreSQL uses the process mode. For each client, it will Fork a background process to respond to the client's request. This section describes ...
Spring Data JPA must master 20 + query keywords
WeChat public number: an excellent wasterIf you have any questions or suggestions, please leave a message in the background. I will try my best to sol...
Some problems in Ubuntu 18.04 PostgreSQL 11 apt default installation
First, install the software by default (this article takes PostgreSQL 11.1 as an example, and other versions are similar). sudo apt install postgresql...
PostgreSQL remote link server configuration
PostgreSQL server needs to be configured to be remotely linked by users Profile:pg_hba.conf controls access security and manages the access rights of ...
Views and templates for ThinkPHP
In short, a controller corresponds to a view, and a method corresponds to a template. Let's go to the figure above. 2. Assign value to template A...
Node connects MySQL and encapsulates its addition, deletion, query and modification
Node connects to mysql In this note, the connection between node and mysql will be introduced, and the encapsulated code will be shared, which can be ...
Fifth populate of mongoose series
Effect Mongoose's populate() can join tables to query, referencing documents in other collections. Populate() automatically replaces the specifie...
java instance understands the concept of blockchain
The core of blockchain is decentralized storage. Traditional database solutions, including relational database and non relational database, belong to...