ibatis 如何将整句sql当做参数传入

转自：http://www.myexception.cn/j2ee/587183.html

 

String str ="select * from tab1"
把str传入的ibatis中执行,是传递整条sql语句...

XML code

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="sql">
    <!-- selectBySql -->
    <select id="selectBySql" resultClass="java.util.HashMap"
            remapResults="true" parameterClass="java.lang.String">
    <![CDATA[ $sql$ ]]>
    </select>
    <!-- updateBySql -->
    <update id="updateBySql" parameterClass="java.lang.String">
    <![CDATA[ $sql$ ]]>
    </update>
</sqlMap>