How MyBatis dynamically passes in table name and field name parameters

This article is about how MyBatis dynamically passes in table names and field name parameters. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

To dynamically pass table and column names, you need to make the following modifications:

Add property statementType= "STATEMENT"

At the same time, the values of owned variables in sql are changed to ${xxxx} instead of # {xxx}.

Delete from ${table} where

${col}

1. Any one of statementType:STATEMENT (non-precompiled), PREPARED (precompiled) or CALLABLE, which tells MyBatis to use Statement,PreparedStatement or CallableStatement, respectively. Default: PREPARED. It is clear that precompilation cannot be used here, but should be changed to non-precompiled.

2. ${xxxx}: $displays the incoming data directly and generates it in sql. For string data, you need to put quotation marks manually.

String dateStr = DateFormatUtils.format (date.getTime (), "yyyy-MM-dd HH:mm:ss")

DateStr = "'" + dateStr + "'"

Thank you for reading! This is the end of the article on "how MyBatis dynamically passes in table names and field name parameters". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!