Learn extjs5 with me (40--Add a custom module [1 Create tables and bean files])

Original Link: https://my.oschina.net/zipu888/blog/549846 Learn extjs5 with me (40--Add a custom module [1 Create tables and bean files]) With the above work, CRUD of a separ ...

Posted on Fri, 13 Sep 2019 21:18:38 -0700 by brucec

Simple Management System (PHP) based on MySQL

Original Link: https://my.oschina.net/gal/blog/200190 Environment: Because it's not real server building, I'm lazy about phpstudy, integrating lightweight apache,mysql and php. IDE wit ...

Posted on Thu, 12 Sep 2019 11:32:31 -0700 by Loldongs

What is the difference between WHERE clause and HAVING clause?

Links to the original text: https://www.codeproject.com/Articles/5164738/What-is-the-difference-between-WHERE-and-HAVING-cl Catalog What's the difference between Where and Having? The WHERE Clause HAVING clause Combining the two: WHE ...

Posted on Thu, 12 Sep 2019 06:51:12 -0700 by mattlatos

Singleton pattern: seven implementations of singleton

What is the singleton pattern? Singleton pattern: A class can only have one instance, providing a global access point. Whenever possible, make sure that a class has only one instance, and that it is self-instantiated and provides this instance to t ...

Posted on Wed, 11 Sep 2019 05:11:25 -0700 by gl_itch

Apache Flink Zero Foundation Introduction Flink Table API&SQL

What is Flink relational API? Although Flink already supports DataSet and DataStream API s, is there a better way to program without caring about specific API implementations? There is no need to understand the specific implementations of Java and Scala. Flink provides three layered APIs. Each API offers a different trade-off between conci ...

Posted on Wed, 11 Sep 2019 02:54:21 -0700 by navtheace

Chapter 1, Introduction to Mybatis _HelloWorld

Article directory Introduction to Mybatis 1. Mybatis History 2. Introduction to Mybatis 3. How to download Mybatis from the official website 4. Why use Mybatis - a comparison of existing persistence technologies Case Hello World 1. Development ...

Posted on Tue, 10 Sep 2019 04:50:27 -0700 by lokesh_kumar_s

99%SQL optimization encountered in your work, here are all solutions for you

-- Example table CREATE TABLE `employees` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NULL DEFAULT '' COMMENT 'Full name', `age` int(20) NOT NULL DEFAULT '0' COMMENT 'Age', `position` varchar(20) NOT NULL DEFAULT '' COMMENT 'position', `hire_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMEST ...

Posted on Mon, 09 Sep 2019 18:08:40 -0700 by Monkey-Moejo

Find all one-to-many tables in the database

Recently, in a project, we encountered a SQL optimization to remove distinct keywords. The distinct keyword is used as a de-duplication, which will find out all the result sets, sort them, and finally remove duplicate data. Generally, tables tha ...

Posted on Mon, 09 Sep 2019 04:16:32 -0700 by BooRadLey

python basic 60 training questions

1. Merge dictionary: a1.update(a2) 2. List de-duplication: a= [11,22,33,44,11,22] print (list (set(a)) 3. Distinction of range(100) between Python 2 and python 3 python 2 returns the list, python 3 returns the iterator, saving memory 4. List [1, 2, 3 ...

Posted on Sat, 07 Sep 2019 01:48:19 -0700 by Vidya_tr

Mybatis one-to-many nested queries and paging

Articles Catalogue Define model Mode 1: Result query Mode 2: Nested queries todo Requirement: According to the classification ID, we query the commodity set under the classification, and each commodity has a picture set. There are many similar ...

Posted on Fri, 06 Sep 2019 06:22:23 -0700 by dink87522