See source solution: org.apache.ibatis.binding.BindingException: Parameter '0' not found

Wrong information org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter '0' not found. Available parameters are [arg1, arg0, param1, param2] at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) at org.mybatis.spring.SqlS ...

Posted by devil6600 on Sun, 08 Dec 2019 12:56:32 -0800

Traditional way and plug-in way realize paging function pageHelper plug-in respectively

Implement paging: there are two ways: traditional paging and classification based on pageHelper plug-in. The latter is recommended First, create a pageUtil tool manually to record all kinds of information of paging, and then use the tedious way to call data pageUtil class can be customized as required package com.imooc.project.util; /** ...

Posted by lwq on Sun, 08 Dec 2019 07:44:01 -0800

How Mybatis works

Objectives of this paper: Using the pure Mybatis framework to obtain data; Clarify the working process of Mybatis. Create project and run First, create maven project, and the process will not be repeated. The dependence is as follows: <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifa ...

Posted by samsolomonraj on Sat, 07 Dec 2019 18:48:51 -0800

Analysis of Mybatis plug-in

Preface MyBatis provides a powerful extension function, that is, the plugins function of MyBatis. MyBatis allows you to intercept and call at a point during the execution of mapped statements. After interception, you can add some customized functions to existing methods, such as common page splitting functions. When you try to modify or rewrit ...

Posted by mayanktalwar1988 on Sat, 07 Dec 2019 10:25:58 -0800

After reading this article, do you still feel that spring security integration OAuth2 custom query users are complex?

Spring security integration OAuth2 is recognized by developers as the best matching partner for resource protection and service authentication. This pair of good friends have been quietly guarding the security of application services. According to the different roles of visitors, they can control the granularity to specific interfaces, so as to ...

Posted by charlieholder on Sat, 07 Dec 2019 05:17:58 -0800

Enterprise spring boot tutorial spring boot enable declarative transaction

springboot is very simple to start a transaction, only one annotation is needed @Transactional Just fine. Because in springboot, events have been enabled for jpa, jdbc and mybatis by default. When they are introduced, things will be enabled by default. Of course, if you need to use other orm, such as beatlsql, you need to configure the relevant ...

Posted by jasonman1 on Sat, 07 Dec 2019 04:24:59 -0800

Mybatis List contains List query

Function: query a data list and each data contains its own sub data set Usage scenario: 1. When multiple order data needs to be queried and order details need to be included in the order data at the same time 2. When you need to query multiple comment data and include comment reply data in the comment data at the same time F ...

Posted by ScoobyDooobyD00 on Fri, 06 Dec 2019 10:16:16 -0800

MyBatis reverse engineering -- automatic generation of Java code

As for automatic code generation, there are many tools and different methods on the Internet. MyBatis is the first automatic code generator I have come into contact with. It's relatively simple, with less code, and it's easy to understand. After that, I won't talk about much nonsense. Let's talk about the implementation method and code explanat ...

Posted by phychion on Thu, 05 Dec 2019 16:45:50 -0800

MyBatis -- generator reverse engineering

I. Introduction Official website: http://www.mybatis.org/generator/index.html By using the official mapper auto generation tool, mybatis-generator-core-1.3.2, po classes and mapper mapping files are automatically generated. Function: mybatis officially provides reverse engineering, which can be used to automatically generate Mapper interface, m ...

Posted by sumathi on Wed, 04 Dec 2019 21:56:30 -0800

springboot learning notes

(V) springboot integrates the thmeleaf template to realize simple login 1. Modify the user table in the note in the previous section, add a password field, and require the username to be UNIQUE to realize login verification. The table structure is as follows.   CREATE TABLE `user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` var ...

Posted by James25 on Wed, 04 Dec 2019 21:47:35 -0800