Springboot annotations are used for full table fuzzy query, and the query result set is empty. - Codes Helper - Programming Question Answer

Springboot annotations are used for full table fuzzy query, and the query result set is empty.

1. I am a rookie, in the process of learning springboot to do annotation mode of the full table fuzzy query, the result set of the query is always empty, but the sql statement in the navicat test can normally find the data, please answer the doubt, thank you very much.

2. I searched all the major websites for a long time, but I didn"t get a solution.

3.mapper method
@ Select ("SELECT id,parent_name,title,content,publish_time FROM tb_article WHERE CONCAT (id,parent_name,title,content) LIKE-sharp {params}")

public List<Article> selectParams(String params);

4.controller method
@ RequestMapping (value= "/ selectParam", method=RequestMethod.POST)

@ResponseBody
public List<Article> selectParam(@RequestParam String param){
    System.out.println(param);
    String params=""%"+param+"%"";
    System.out.println(params);
    if(params.equals("") || params==null) {
        return asi.selectArticleAll();
    }else {
        return asi.selectParams(params);
    }
}

Test statement in 5.navicat
SELECT id,parent_name,title,content,publish_time FROM tb_article WHERE CONCAT (id,parent_name,title,content) LIKE"% 1%"

6.postman

7. Please answer your doubts, thank you very much

Mysql spring java

May.30,2022

LIKE CONCAT ('%',-sharp {params},'%')

@ResponseBody
public List<Article> selectParam(@RequestParam String param){
    if(params !=null && !"".equals(params)) {
        return asi.selectParams(params);
    } else {
        return asi.selectArticleAll();
    }
}

@Select("SELECT id,parent_name,title,content,publish_time FROM tb_article WHERE CONCAT(id,parent_name,title,content) LIKE '-sharp{params}'")

try changing the single quotation marks

@ResponseBody
public List<Article> selectParam(@RequestParam String param){
    System.out.println(param);
    String params="%"+param+"%";
    System.out.println(params);
    if(params.equals("") || params==null) {
        return asi.selectArticleAll();
    }else {
        return asi.selectParams(params);
    }
}

Previous: How can Google browser or Firefox check the storage time of passwords or cookie?

Next: Multiple uploads of antd upload components, sometimes showing only one?

Database Operation usage of HIbernate
Which method of HIbernate is more appropriate to use in the SQL statement select name,sex from db, for example: public T findByID (ID id, I dbName) throws Exception; public List<T> findAll(I dbName) throws Exception; public List<T> findBy...

Sql mysql spring java javascript

Mar.07,2021
When SpringBoot uploads in batches, the information of uploaded files is written, and the database is found to be duplicated.
when SpringBoot uploads batch files, the information of uploaded files is written, and the database is found to be duplicated. uses mybatis + mybatis-plus. service code as follows: public Boolean insertByEntity(SysPkFile entity) { System.out....

Intellij-idea mysql spring java

Mar.23,2021
Is it better to use multiple Dao combinations or a link query in the business?
< H2 > problem description < H2 > if there is an interface for querying user details the user base table is associated with a lot of other information about the user, it is better to query all the queries now, whether to use multiple dao to combine i...

Mysql spring java

Apr.01,2021
ClientAbortException:socket write error.
org.apache.catalina.connector.ClientAbortException: java.net.SocketException: Software caused connection abort: socket write error at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:370) at org.apache.catalina.connector.OutputBuffe...

Tomcat mysql spring java

Apr.07,2021
How to speed up the batch deletion of tables containing compound unique indexes by foreach of mybatis?
the project uses the SpringBoot framework, and the persistence layer uses the mybatis, database for the mysql, business table to contain a composite unique index of four fields. Batch insertion or deletion on this table requires no logical deletion. Whe...

Mysql spring java

Dec.02,2021

Menu