How to exequte query directly from java code using mybatis?

Mybatis has already this function, but you must use the adapter as follows.

1. create an adapter class;

   public class SQLAdapter {
     String sql;
   
     public SQLAdapter(String sql) {
         this.sql = sql;
     }
   
     public String getSql() {
         return sql;
     }
   
     public void setSql(String sql) {
         this.sql = sql;
     }
   }
   

2. create typeAlias of class SQLAdapter

<typeAlias alias="sqladapter" type="com.zj.xxx.xxx.SQLAdapter" />

3. put select tag in each object xml where you need to execute the sql directly.

   <select id="findRecords" parameterType="SQLAdapter" resultMap="xxxxxResultMap">  
       ${sql}  
   </select> 
   

4. call this select method like

   String _sql = "select * from table where... order by... limit...";
   xxxxx.findRecords(new SQLAdapter(_sql));
   

5. Things have been all done. you can no longer writer complex sql language in the xml file. Good Luck.

Seems like the best answer is to use JDBC in this case.

You can do this using SQL query as literal parameter:

<select id="findRecords" parameterType="string" resultMap="xxxxxResultMap">  
    ${_parameter}
</select>

You can pass only where clause:

<select id="findRecords" parameterType="string" resultMap="xxxxxResultMap">  
    select * from records where ${_parameter}
</select>