How do I use parameters for a custom global sql in Mybatis Plus?

< H2 > as in the question, we want to define a global method to get any random data, but we can"t find out how to use parameters in the global method. < / H2 >

official documentation does not indicate how to use it.

// BaseDao.java
/**
 * 
 */
List<T> listByRandom(@Param("num") Integer num);

// CustomSqlInjector.java
/**
 * 
 */
private static final String SQL_LIST_BY_RANDOM = "select %s from %s where id >= ((select max(id) from user_default_avatar) - (select min(id) from user_default_avatar)) * rand() + (select min(id) from user_default_avatar)limit %s";

public void listByRandom(Class<?> mapperClass, Class<?> modelClass, TableInfo table) {
    final String sql = String.format(SQL_LIST_BY_RANDOM, this.sqlSelectColumns(table, false), table.getTableName());
    final SqlSource sqlSource = languageDriver.createSqlSource(configuration, sql, modelClass);
    this.addSelectMappedStatement(mapperClass, "listByRandom", sqlSource, modelClass, table);
}

does anyone know? (please tell me) *: please tell

Java mybatis

Oct.31,2021

has been resolved. Use-sharp {param} directly. For more information, please see
https://blog.rxliuli.com/p/5b.

Previous: Mayday! After the vue project is compressed, an error is reported in IOS9 and cannot be executed.

Next: What does Makefile pseudo-target mean?

Intellij cannot use mybatis's comments in the project?
...

Java mybatis

Mar.01,2021
Ask for help c3p0-0.9.1.2 NewProxyPreparedStatement.isClosed () Z is abstract
error prompt use: <dependency> <groupId>org.springframework< groupId> <artifactId>spring-orm< artifactId> <version>4.3.14.RELEASE< version> < dependency> <depend...

Java mybatis spring-mvc spring

Mar.03,2021
How does mybatis iterate through a string?
is a string made up of multiple id String ids = "1 id 2, 3 4 ". Now you want to traverse through the mybatis without cutting it into an array. What do you do according to the delete operation according to the id? I reported an error here: < where > ...

Java-ee java-web ssm java mybatis

Mar.05,2021
JedisPool injects spring into null
recently, when (spring) integrates redis in a project, I always hold a null pointer exception when going to the factory instance: but the unit test is always normal: the following is the redis-config.xml file public class SpringContextUtil implement...

Redis spring java mybatis

Mar.05,2021
Springboot configuration mybatis cannot find mapper.
1. Build the demo of springboot manually. The project service layer auto injection does not show that it cannot be injected. But the method that calls the service layer will statement not found. Then the @ Qualifier () annotation is used, and the servic...

Java mybatis springboot

Mar.06,2021
Mybatis parameter passing
use mybatis insert sentence to: There is no getter for property named DictionaryType in class com.bjpowernode.crm.domain.DictionaryType the code is as follows: public int insertDictionaryType(DictionaryType dictionaryType) { SqlSessionFac...

Java mybatis

Mar.07,2021
How do I update the value of the same field in multiple tables?
problem description orcaleABCAPHONEBPHONECPHONE: A B C ID PHONE ID PHONE ID PHONE a1 11111 b1 11111 c1 11111 a1 22222 b2 33333 c2 11111 now I want to change the PHONE=11111 in ...

Java mybatis oracle

Mar.09,2021
Has anyone considered adding mappedStatement dynamically to mybatis?
mybatis-3.4.4.jar org.apache.ibatis.builder.xml.XMLMapperBuilder line:132 private void buildStatementFromContext(List<XNode> list, String requiredDatabaseId) { for (XNode context : list) { final XMLStatementBuilder statementParse...

Springboot java mybatis

Mar.09,2021
Mybatis will report an error when inserting multiple entries with foreach, but one will be fine, saying that there is a format error.
this is the xml file: the following error: -sharp-sharp-sharp Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: TODO : COMMA values : insert into BIA_HGU_INFO (HGU_ID, AREA_CODE, BIND_CODE, SN, HG...

Java mybatis oracle mysql

Mar.22,2021
I would like to ask MySQL to divide the table by month, and the engine is InnoDB.
I have a blank table in the database. Please give me some advice. ...

Java mybatis mysql

Mar.26,2021
What plug-ins do you use for mybatis sub-tables?
Hello, everyone mybatis ...

High-concurrency ssm java mybatis

Aug.06,2021
How mybatis handles many-to-many inserts relatively easily
1. The current table structure partition is . the main table is an and contains the necessary underlying data. from the table: B, c, d, e, etc. related tables: ab, ac, ad, ae, etc. now the data sent from the front end is a string of json string...

Mysql sql java mybatis springboot

Aug.20,2021
MybatisPlus Custom Global Operation exists always returns null
< H1 > MybatisPlus Custom Global Action exists always returns null < H1 > < H2 > scene < H2 > customizes a global operation for mybatis-plus , and then returns null all the time. when I was customizing the sql injector class, I suddenly found t...

Sql java mybatis

Mar.05,2022
Mybatis annotation method, how to implement MySQL, after update, return the updated value
as shown in the title, the stupidest way is to write a modification statement first, and then write a query statement, but it is a waste of resources to connect to the database frequently based on Mybatis, can @ Update be implemented, and the return v...

Springboot java mybatis

Apr.10,2022
It cannot be loaded normally using MyBatis,TypeHandler in OSGI environment
how do you solve the problem that MyBatis cannot load TypeHandler according to the fully qualified name of the class in the configuration file in OSGI environment? for example: <delete id="deleteById" statementType="PREPARED"&...

Class-loader class-loading-mechanism osgi java mybatis

Apr.13,2022
Error in batch query encapsulated with Mybatis Plus
< H1 > error using Mybatis Plus encapsulated batch query < H1 > < H2 > Environment < H2 > JDK 1.8 Spring Boot 2.0.6.RELEASE mybatis-plus-boot-starter 2.3 < H2 > scene < H2 > We need to encapsulate a general method that can be queried accor...

Java mybatis

Jul.12,2022
In the SpringBoot project, use Mybatis to dynamically create sql statements and how to insert OR conditions between loop inserts Where
first post the code for dynamically creating sql AND(); for (Object key : key_values){ WHERE("(article.title LIKE %"+key.toString()+"% OR article.content LIKE %"+key.toString()+"% )"); } the final output SQL s...

Java mybatis

Jul.14,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b38d3d-2c14b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b38d3d-2c14b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?