python crawler -- scratch framework

Scrapy Introduction Scrapy introduction 1.Scrapy is an application framework written in pure Python for crawling website data and extracting structural data. It is widely used 2. The power of the framework, users only need to customize and develop a few modules to easily realize a crawler, which is used to grab web content and various pictures ...

Posted by SeaJones on Mon, 16 Dec 2019 05:46:30 +0100

Using Java Sources in Oracle Database

Using Java Sources in Oracle Database Because of some special requirements, the password of the user table in the database needs to be changed to "user name + specified character". Therefore, the encryption algorithm in the program is changed to java sources, function call, convenient to update data. Environment: Ora ...

Posted by SycoSyco on Fri, 13 Dec 2019 20:33:24 +0100

Scratch: Top 250 crawling

Content of this article Climb to the top 250 page of Douban movie. The fields include:Ranking, title, director, one sentence Description: some are blank, rating, number of evaluation, release time, release country, category Grab data storage scrapy introduction Scrapy crawler framework tutorial (1) -- getting started with scrapy Create projec ...

Posted by JCBarry on Thu, 12 Dec 2019 20:53:55 +0100

How to write results to MySQL in Spark

The Spark mentioned here includes SparkCore/SparkSQL/SparkStreaming. In fact, all operations are the same. The following shows the code in the actual project. Method 1: write the entire DataFrame to MySQL at one time (the Schema of DataFrame should be consistent with the domain name defined in the MySQL table) Dat ...

Posted by blacksheepradio on Wed, 11 Dec 2019 06:08:20 +0100

Basic use of Express

Preface List project Express is a brief and flexible node.js Web application framework, which provides a series of powerful features to help you create various Web applications and rich HTTP tools. text A simple example of express framework // Download express cnpm install express --save // Quote import expre ...

Posted by I Am Chris on Wed, 11 Dec 2019 01:35:07 +0100

Python crawls the information of the broker

Python crawls the information of the broker Python2.7.15 Today, we're going to crawl through the information of the settlement agent. This time we don't use regular, we use beautiful soup. If you don't know about it, you can read this document first for easy understanding. https://beautifulsoup.readthedocs.io/zh_CN/v4.4.0/ I ...

Posted by herschen on Wed, 11 Dec 2019 00:08:36 +0100

[Trafodion tips] Trafodion's support for Chinese

In the Trafodion database, when we set a field type as character type (such as CHAR or VARCHAR), the character encoding will be subject to the default character encoding of the database. For example, in the following example, create a table with a character type field, and you can see that the encoding method of this field is ISO88591 through t ...

Posted by trooper on Tue, 10 Dec 2019 20:00:16 +0100

Configuration and use of log4j in SSM framework

I. Introduction of related packages and dependencies I use the method of slf4j+log4j to introduce pom files. There is another method of Commons logging + log4j. I will not talk about it here. You can refer to the materials you need. <!--slf4j+log4j--> <dependency> <groupId>org.slf4j</groupId> &lt ...

Posted by Matth_S on Tue, 10 Dec 2019 02:20:46 +0100

Oracle sql shared pool $sqlarea analysis of SQL resource usage

If you need to check the sql usage of a system, you can query the $sql, $sssession, $sqlarea of Oracle for statistical troubleshooting Check the basic information of $sql and $session before troubleshooting select * from v$sql a, v$session b where b.SQL_ADDRESS = a.ADDRESS and b.SQL_HASH_VALUE = a.HASH_VALUE and b.SQL ...

Posted by GBahle on Mon, 09 Dec 2019 21:53:47 +0100

0021 - use JDBC to insert Chinese characters into Kudu table - Secret of cast

1. Problem description Use Impala JDBC to insert Chinese characters into Kudu table. The inserted Chinese characters are garbled and the Chinese characters are truncated. After the previous document uses sql splicing method to insert Chinese string scrambling solution, this document describes the problem of using jdbc PreparedStatement method t ...

Posted by ohjay on Sun, 08 Dec 2019 14:53:32 +0100