centos7 install MySQL version 5.7 (full)
centos installation
Version Description: centos7, mysql5.7, not centos7, some commands may not be compatible
Install MySQL server
# Download and install mysql yum.
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
# Install MySQL server
yum -y install m ...
Added by DusterG20 on Sat, 19 Oct 2019 10:52:32 +0300
python-Arduino serial port transfers data to computer and saves it to excel table
Cause: the school canal cup reported a project to make a weather forecast device. I ran BME280 module with arduino, and realized two Arduino master-slave transmission with Bluetooth module. But in order to analyze, we need to extract data. So I wrote a PC program with python, realized the serial communication between arduiho and computer with p ...
Added by adige on Mon, 14 Oct 2019 19:50:21 +0300
spring-data-redis-cache usage and source code Walk-through
Prospective readers
Students preparing to use spring's data-redis-cache
Understand the use of @CacheConfig, @Cacheable, @CachePut, @CacheEvict, @Caching
Deeply Understanding the Realization Principle of data-redis-cache
Description of article content
How to use redis-cache
Customize keyGenerator and expiration time
Source code interpretation ...
Added by Felex on Sun, 13 Oct 2019 12:48:15 +0300
Introduction to Python Data Analysis and Practical Learning Resources
pandas is a software package of Python language. When we use Python language for machine learning programming, it is a very common basic programming library. This article is an introduction to it.
pandas provides a fast, flexible and expressive data structure, which aims to make the work of "relation" or "mark" data simple ...
Added by gin on Sat, 12 Oct 2019 20:23:32 +0300
After page office opens word file online, it can save document and save data separately.
PageOffice's storage mechanism is to save data first and then files, so clicking the Save button once can save both data and files at the same time. But there is a need to save files or data separately. The following is a demonstration of the implementation process.
I. Core Code
poCtrl.setSaveDataPage("SaveData.jsp");//Set up the page to save ...
Added by Highlander on Sat, 12 Oct 2019 06:55:02 +0300
File upload into library MySQL and download
Demand:
Excel files need to be parsed, uploaded to a table in the database and downloaded.
Technology:
ElementUI for front-end vue, spring boot for back-end, mybatis
Achieving results:
Upload implementation:
1) Field type selection
The field type used to store files in the database is BLO ...
Added by Dlex on Fri, 11 Oct 2019 23:38:20 +0300
Implementing Goroutine Pool through Channel
Recent use of Go to import data from Excel into the server is for http requests But there is a problem that new Goroutine will be added indefinitely after reading from the file. Causes all cards to be stuck in the initialization request and then gets stuck.
Problem simulation
Simulation code
func main() {
pool := sync.WaitGroup{}
for ...
Added by drucifer on Thu, 10 Oct 2019 03:20:03 +0300
Pandas versus Excel Notes 2
I. Creating Sequences
series can represent excel rows and columns
How to create it:
1. Using dictionaries, key is converted to index and value is converted to data.
2. Use lists
"Mode 1"
s1=pd.Series()#Generate a sequence that represents rows and columns
d={'x':100,'y':200,'z':300}
s1=pd.Series(d)#Con ...
Added by flforlife on Tue, 08 Oct 2019 14:01:02 +0300
Using Python to Send Hive Detailed Data by Mail
Links to the original text: https://www.jianshu.com/p/f13fb250369d
I. Requirement Description
Customers need to receive specific activity data every Monday, generate Excel or CSV files, and send them to designated recipients by mail. The p ...
Added by zvonko on Mon, 07 Oct 2019 17:21:37 +0300
Import Excel in Winforn and display it, then get the contents of the multiple-checkbox selection
scene
Use NPOI to import Excel and assign it to the DataTable, then display it on the DataGrdView, add a check box, and get the contents of the selected row.
Winform uses NPOI to import Excel and assign it to DataTable:
https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/100064821
Effect
Realization
On the basis of the succes ...
Added by Swerve1000 on Sun, 06 Oct 2019 06:24:51 +0300