MyBatis dynamically including script

Question

I am trying to dynamically include select query based on some input parameters. The following is what I am trying to achieve.

<sql id="query1">
  SELECT * from 
    table_1
   WHERE a = #{param1}
</sql>

<sql id="query2">
  SELECT * from 
    table_2
   WHERE b = #{param2}
</sql>

<select id = "selectSomethingFromDB">
  <include refid="#{readerIdName}" />
</select>

I am planning to pass the sql id name as parameter to the query and trying to dynamically choose the select query based on this param. (Sort of like a factory design implementation). However #{readerIdName} is not getting replaced with the value I am passing as param. Is something like this possible?

Dariusz · Accepted Answer · 2022-01-03 09:55:16Z

1

The xml attributes at this level are not evaluated in runtime by mybatis.

You can use a single <SQL id="..."> query and an <if test="..."> dynamic sql in it.

answered Jan 3, 2022 at 9:55

Dariusz

22.5k9 gold badges81 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MyBatis dynamically including script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related