Summary of JSP scrambling

Specify the encoding format on the jsp page to ensure that it is consistent with the character set of mysql: <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> Step 1: make sure the project code is UTF-8 Step 2: ma ...

Posted by gigabyt3r on Sun, 03 May 2020 21:19:25 -0700

ubuntu uses apt get to make OfflinePackage

ubuntu uses apt get to make offline package (take mysql as an example) Recently, I am studying the deployment of engineering software. Although this is the work of operation and maintenance, it is quite interesting. Question: what factors need to be considered in software environment configuration There are two ways ...

Posted by CG_dude on Sun, 03 May 2020 20:41:23 -0700

Using Python to realize WeChat official account fan migration

Recently, official account official has been merged into one public official account for the company's business needs, that is to say, one official account (mainly fans) should be transferred to another public number. Two According to WeChat specification, the openid of the same user in different official account is different. Our business syst ...

Posted by nitharsanke on Sun, 03 May 2020 18:14:45 -0700

MySQL high availability scheme Mgr + consumer combination test

To fully simulate a complete set of consumer + Mgr environment, we may need to configure the following servers:Three serve as the consumer server, and the other three serve as MySQL servers in MGR single master mode. 1, Build Mysql MGR: Download the new version of mysql 8.0.13 wget https://cdn.mysql.com/archives/mysql-8.0/mysql-8.0.13-linux-gl ...

Posted by tisa on Sun, 03 May 2020 15:16:08 -0700

How to insert test data in MySQL

There are two methods for inserting MySQL test data: Select the priority (generate test data in combination with PHP > use stored procedures). Use stored procedures (it is recommended to use this method when the test data is less than 1000) The specific code is as follows: To create a table: 1 mysql> create table TB1( 2 -> id in ...

Posted by myraleen on Sun, 03 May 2020 12:39:21 -0700

MyBatis and Oracle,MySql,SqlServer insert data return primary key method

MyBatis and Oracle,MySql,SqlServer insert data return primary key method MyBatis Oracle MySql SqlServer insert return primary key MyBatis returns an auto increasing primary key when insert ing data. It can be realized through XML configuration, while different configurations of database are different. Let's take a lo ...

Posted by kef on Sun, 03 May 2020 10:14:58 -0700

Install mysql5.7 through binary source code under Linux (5.7 installation and commands are different from previous versions)

Here I choose the official website to download the source package, compile and install Reference 1: when linux is configured, how do you choose to install it by compilation or by yum Reference 2: mysql installation under linux 1, Preparation: Download address on Mysql official website 2, Pit summary: 2.1 about i ...

Posted by Brendan Nolan on Sun, 03 May 2020 07:56:02 -0700

Using index extensions

The so-called index extension refers to that in the secondary index, innodb adds the primary key to the key of the secondary index, which usually leads to good performance and query plan. Index extension can be used for index scanning of ref, range, index ﹣ merge, loose index scanning, join and sorting optimization, ...

Posted by smilley654 on Sun, 03 May 2020 04:54:25 -0700

The use of mybatis plus code generator

Code generator MyBatis plus (MP for short) is an enhancement tool of MyBatis. Based on MyBatis, only enhancements are made and no changes are made to simplify development and improve efficiency. Step demo 1, Add mybatis plus dependency <!--spring-boot web--> <dependency> <groupId>org.springfram ...

Posted by luddeb on Sun, 03 May 2020 02:26:54 -0700

Use demonstration of Hive lateral view

Lateral view is used with split, expand and other UDTF to split a row of data into multiple rows. On this basis, the split data can be aggregated. Lateral view first calls UDTF for each row of the original table, and UDTF will split a row into one or more rows. Then lateral view combines the results to produce a virtual table that supports alia ...

Posted by ayzee01 on Sat, 02 May 2020 19:41:55 -0700