mybatis执行动态sql语句

mybatis执行动态sql语句

---

Mybatis执行任意sql
在mapper.xml中写入

    <select id="executeSql" resultType="map">
        ${_parameter}
    </select>

调用

    sqlSession.selectList("executeSql", "select * from sysuser where enabled = 1");

或者使用

    //定义接口
    List<Map> executeSql(String sql);
    //然后接口调用方法
    xxMapper.executeSql("select * from sysuser where enabled = 1");

---

Mybatis传入参数执行动态sql

…