Sharing Jdbc2.X Learning Summary Series: Source Parsing - SQL Execution

The previous articles introduced the process of SQL parsing, SQL routing, and SQL rewriting, including assembling the final Collection <Prepared Statement Unit>. This article begins with an introduction to the execution of SQL public boolean execute() throws SQLException { try { ...

Posted by lyonsperf on Sun, 04 Aug 2019 13:48:41 +0200

Mybatis Framework -- Basic Introduction

Introduction to Mybatis Mybatis is a persistence framework, ORM framework, is the top-level project under Apache, supporting customized SQL, stored procedures and advanced mapping. Mybatis avoids all JDBC code and manual parameter setting and result set acquisition in the JDBC programming process. Mai ...

Posted by maineyak on Sat, 03 Aug 2019 10:14:39 +0200

Java - Factory Design Patterns

Polymorphism: Method Polymorphism Method overloading 2. Method overwriting Object polymorphism 3. Inheritance of abstract classes 4. Implementation of Interface Coupling: When the code changes, the client needs to adjust accordingly. Factory design pattern: 1. Simple Factory Mode (Defining a ...

Posted by 758 on Fri, 02 Aug 2019 05:12:56 +0200

Result Set from BeanHandler and BeanListHandler

Links to the original text: https://blog.csdn.net/smile_Running/article/details/87009755 DBUtils Toolkit DBUtils is an open source JDBC tool class library provided by Apache. It is a simple encapsulation of JDBC and has a very low learning c ...

Posted by signs on Wed, 31 Jul 2019 18:43:32 +0200

MyBatis Example Class Details

About the definition of Example class? Mybatis-generator generates Criterion for each field and creates dynamic sql for the underlying mapper.xml. If there are more fields in the table, the example class will be very large. In theory, you can construct any filter condition you think of by using the exam ...

Posted by itsjareds on Wed, 31 Jul 2019 10:58:47 +0200

Java Foundation Review Generics, Java in? Wildcards? Variable parameters, enhanced for loops, Collections classes

Java Basic Review (9) generic paradigm Definition: Receiving a data type by <Data Type> detects elements in a collection using this data type at compilation time. If the element is not of the type specified in <>, it is not allowed to be added to the current collection (compilation failu ...

Posted by jimmyborofan on Wed, 31 Jul 2019 09:19:20 +0200

The First Computer Room Charging System

For general users, the process of recharge record is the same as that of inquiring on-line record. The only difference is that the line_info table is replaced by the recharge_info table. The other similarities are not repeated. The following is a summary of general users'inquiry on-line status: Operat ...

Posted by marschen on Wed, 31 Jul 2019 03:08:35 +0200

Implementation of multi-table paging query based on Mybatis Plus

Note: Mybatis Plus version 3.0.7 only started using Custom SQL + [Query Wrapper], low version can not be used, or honest SQL for conditional splicing. 2.0. Source code analysis In the Wrapper < T > interface, there are the following methods /** * Get custom SQL to simplify custom XML comple ...

Posted by bryan52803 on Wed, 31 Jul 2019 02:04:36 +0200

[MYSQL] MHA Building Process

Environmental Introduction IP role 172.16.20.105 master 172.16.20.106 slave1(manage) 172.16.20.107 slave2 Install mysql Download the mha installation package https://code.google.com/archive/p/mysql-master-ha/downloads?page=1 mha installation ## Install dependency packages (all nodes ...

Posted by imawake on Tue, 30 Jul 2019 21:05:48 +0200

ORACLE 11g uses ROWNUM to perfect ORA-00600: internal error code

  1, ORA-00600: Internal error code Oracle upgraded from 11.2.0.1 to 11.2.0.4. Developers reported a job failure, debugging error messages, ORA-00600: internal error code, parameters: [rwoirw: check ret val], [], [], [], ORA-06512:... As shown in the following figure:   C:\pic\oracle\2017040501 ...

Posted by postmanager on Tue, 30 Jul 2019 08:56:41 +0200