//set the SELECT query field where the where statement, splicing + the where condition and the and statement,
//stitching +=value AND field andNew AND statements, splicing + AND (field=value) or the or statements,
//stitching +=value OR field orNew OR statements, splicing + OR=value (field)
//eq equals=allEq based on map content equals=ne doesn't equal & lt;> Gt is greater than & gt; Ge is greater than or equal to & gt;=lt is smaller than & lt; Le less than or equal to & lt;=
//like fuzzy query like notLike fuzzy query NOT like in the in query notIn the NOT in query
//isNull NULL values query isNotNull grouping IS NOT NULL groupBy GROUP BY having having keywords
//orderBy sort ORDER BY orderAsc ASC sort ORDER BY orderDesc sort ORDER BY DESC
//the exists exists conditional statements notExists NOT exists conditional statements between between conditional statement
//notBetween NOT BETWEEN conditional statements addFilter free splicing SQL last joining together at the last, for example: the last (" LIMIT 1 ")
Widely collect spring boot integrated Mybatis plus general IService and BaseMapper statements use, please indicate the statement USES usage ( scene in the enterprise application of exact way )! Summary of your drop culture, dedication, is our motivation!!!!!!!!!!!!!!!!!!!!!
A great god, please leave your statement to rookie I learn and use!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
CodePudding user response:
Refer to blog: https://blog.csdn.net/qq_40298231/article/details/103343837CodePudding user response:
General IService use statement