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