Programmer Think

I. Preparations Python Tool Library Installation xlwt and xlrd Installation under 1.1win7 1.1.1 Method 1: Download and Install 1. From http://pypi.python.org/pypi/xlwt Download xlwt-1.0.0.tar.gz; 2. From http://pypi.python.org/pypi/xlrd Download xlrd-0.9.4.tar.gz; 3. Unzip the package; 4. Run under win7. [plain] view plain copy cmd ...

For the mybatis framework. It seems to be used in copy all the time. For mybatis caching. There is no accurate cognition. Take advantage of the holiday. Learn the cache of mybatis. This article mainly studies the first level cache of mybatis. Why cache In fact, we have been working for a long time, and we know that many bottlenecks ar ...

Distributed transaction solution -- Seata -- Implementation Seata Background Seata version selection Seata practice 1. Problem description 2. Problem location 3. Solutions Seata Seata is an open source distributed transaction solution, which is committed to providing high-performance and easy-to- ...

JdbcTemplate JdbcTemplate is an object provided in the spring framework, which functions as QueryRunning and is a simple encapsulation of the original Jdbc API object. The spring framework provides many template classes that are facing different database types. Operational relationship data: JdbcTempl ...

[1] The difference between int(3) and int(11) (cognitive error of thinking inertia) Here, 3 or 11 represents the specific length stored in the database, always thinking that int(3) can only store 3 numbers of length, and int(11) can only store 11 numbers of length. [2] Mysql Basics When learning M ...

Code reference http://bbs.csdn.net/topics/391070227?page=1     Here is the posted Code: public void dealListWithMutiThread(){ List<Object> list = new ArrayList<Object>(10000); int index = 0; ExecutorService ex = Executors.newFixedThreadPool(5); int dealSize = 2000; List&l ...

Before  , there was a small test project that needed to synchronize some local data to Alibaba cloud database regularly. It was implemented by executing LOAD DATA with the most mechanical script. Here is a brief introduction. LOAD DATA can quickly read text file data into the table (LOAD DATA is us ...

SQL parsing order Next, let's take a look at the past and present life of an SQL statement. First, let's look at the sample statement: SELECT DISTINCT < select_list > FROM < left_table > < join_type > JOIN < right_table > ON < join_condition > WHERE < wh ...

Content Summary constraint condition Relationships between tables (constraints) Modify the full syntax of the table Copy Table constraint condition Default default """ # Supplement: You can specify fields when inserting data create table t1 ( id int, name varchar(16) ); insert into t1 (name, id) values ('samuel', 1); create table ...

mysql database account management and DDL language 1, Database account management 1. Account creation and password modification 2. Create Zara account, password zara123, only with query permission 2, mysql four engines 3, Table management 1. Library management 1. Library creation 2. Modification ...