HollisChuang's Blog">
<meta http-equiv="Cache-Control" content="no-siteapp">
<title>ibatis直接执行已有sql语句-HollisChuang&#039;s Blog</title>
<link rel='dns-prefetch' href='//s.w.org' />
		<script type="text/javascript">
			window._wpemojiSettings = {"baseUrl":"https:\/\/s.w.org\/images\/core\/emoji\/11\/72x72\/","ext":".png","svgUrl":"https:\/\/s.w.org\/images\/core\/emoji\/11\/svg\/","svgExt":".svg","source":{"concatemoji":"http:\/\/www.hollischuang.com\/wp-includes\/js\/wp-emoji-release.min.js?ver=4.9.8"}};
			!function(a,b,c){function d(a,b){var c=String.fromCharCode;l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,a),0,0);var d=k.toDataURL();l.clearRect(0,0,k.width,k.height),l.fillText(c.apply(this,b),0,0);var e=k.toDataURL();return d===e}function e(a){var b;if(!l||!l.fillText)return!1;switch(l.textBaseline="top",l.font="600 32px Arial",a){case"flag":return!(b=d([55356,56826,55356,56819],[55356,56826,8203,55356,56819]))&&(b=d([55356,57332,56128,56423,56128,56418,56128,56421,56128,56430,56128,56423,56128,56447],[55356,57332,8203,56128,56423,8203,56128,56418,8203,56128,56421,8203,56128,56430,8203,56128,56423,8203,56128,56447]),!b);case"emoji":return b=d([55358,56760,9792,65039],[55358,56760,8203,9792,65039]),!b}return!1}function f(a){var c=b.createElement("script");c.src=a,c.defer=c.type="text/javascript",b.getElementsByTagName("head")[0].appendChild(c)}var g,h,i,j,k=b.createElement("canvas"),l=k.getContext&&k.getContext("2d");for(j=Array("flag","emoji"),c.supports={everything:!0,everythingExceptFlag:!0},i=0;i<j.length;i++)c.supports[j[i]]=e(j[i]),c.supports.everything=c.supports.everything&&c.supports[j[i]],"flag"!==j[i]&&(c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&c.supports[j[i]]);c.supports.everythingExceptFlag=c.supports.everythingExceptFlag&&!c.supports.flag,c.DOMReady=!1,c.readyCallback=function(){c.DOMReady=!0},c.supports.everything||(h=function(){c.readyCallback()},b.addEventListener?(b.addEventListener("DOMContentLoaded",h,!1),a.addEventListener("load",h,!1)):(a.attachEvent("onload",h),b.attachEvent("onreadystatechange",function(){"complete"===b.readyState&&c.readyCallback()})),g=c.source||{},g.concatemoji?f(g.concatemoji):g.wpemoji&&g.twemoji&&(f(g.twemoji),f(g.wpemoji)))}(window,document,window._wpemojiSettings);
		</script>
		<style type="text/css">
img.wp-smiley,
img.emoji {
	display: inline !important;
	border: none !important;
	box-shadow: none !important;
	height: 1em !important;
	width: 1em !important;
	margin: 0 .07em !important;
	vertical-align: -0.1em !important;
	background: none !important;
	padding: 0 !important;
}
</style>
<link rel='stylesheet' id='_bootstrap-css'  href='http://www.hollischuang.com/wp-content/themes/dux/css/bootstrap.min.css?ver=THEME_VERSION' type='text/css' media='all' />
<link rel='stylesheet' id='_fontawesome-css'  href='http://www.hollischuang.com/wp-content/themes/dux/css/font-awesome.min.css?ver=THEME_VERSION' type='text/css' media='all' />
<link rel='stylesheet' id='_main-css'  href='http://www.hollischuang.com/wp-content/themes/dux/css/main.css?ver=THEME_VERSION' type='text/css' media='all' />
<link rel='stylesheet' id='wp-markdown-prettify-css'  href='http://www.hollischuang.com/wp-content/plugins/wp-markdown/css/prettify.css?ver=1.6.1' type='text/css' media='all' />
<link rel='stylesheet' id='douban_collections-css'  href='http://www.hollischuang.com/wp-content/plugins/douban-collections/douban-collections.css?ver=1.0.0' type='text/css' media='screen' />
<script type='text/javascript' src='http://www.hollischuang.com/wp-content/themes/dux/js/libs/jquery.min.js?ver=THEME_VERSION'></script>
<link rel='https://api.w.org/' href='http://www.hollischuang.com/wp-json/' />
<link rel='prev' title='Java中的&#8221;魔数&#8221;' href='http://www.hollischuang.com/archives/491' />
<link rel='next' title='[转]程序员必备的代码审查（Code Review）清单' href='http://www.hollischuang.com/archives/495' />
<link rel="canonical" href="http://www.hollischuang.com/archives/493" />
<link rel='shortlink' href='http://www.hollischuang.com/?p=493' />
<link rel="alternate" type="application/json+oembed" href="http://www.hollischuang.com/wp-json/oembed/1.0/embed?url=http%3A%2F%2Fwww.hollischuang.com%2Farchives%2F493" />
<link rel="alternate" type="text/xml+oembed" href="http://www.hollischuang.com/wp-json/oembed/1.0/embed?url=http%3A%2F%2Fwww.hollischuang.com%2Farchives%2F493&#038;format=xml" />
<meta name="keywords" content="ibatis, ibatis">
<meta name="description" content="&lt;select id='selectAppNames' parameterClass='String' resultClass='String'&gt;        &lt;![CDATA[ $sql$ ]]&gt;  &lt;/select&gt;">
<style>a:hover, .site-navbar li:hover > a, .site-navbar li.active a:hover, .site-navbar a:hover, .search-on .site-navbar li.navto-search a, .topbar a:hover, .site-nav li.current-menu-item > a, .site-nav li.current-menu-parent > a, .site-search-form a:hover, .branding-primary .btn:hover, .title .more a:hover, .excerpt h2 a:hover, .excerpt .meta a:hover, .excerpt-minic h2 a:hover, .excerpt-minic .meta a:hover, .article-content .wp-caption:hover .wp-caption-text, .article-content a, .article-nav a:hover, .relates a:hover, .widget_links li a:hover, .widget_categories li a:hover, .widget_ui_comments strong, .widget_ui_posts li a:hover .text, .widget_ui_posts .nopic .text:hover , .widget_meta ul a:hover, .tagcloud a:hover, .textwidget a:hover, .sign h3, #navs .item li a, .url, .url:hover{color: #2CDB87;}.btn-primary, .label-primary, .branding-primary, .post-copyright:hover, .article-tags a, .pagination ul > .active > a, .pagination ul > .active > span, .pagenav .current, .widget_ui_tags .items a:hover, .sign .close-link, .pagemenu li.active a, .pageheader, .resetpasssteps li.active, #navs h2, #navs nav, .btn-primary:hover, .btn-primary:focus, .btn-primary:active, .btn-primary.active, .open > .dropdown-toggle.btn-primary, .tag-clouds a:hover{background-color: #2CDB87;}.btn-primary, .search-input:focus, #bdcs .bdcs-search-form-input:focus, #submit, .plinks ul li a:hover,.btn-primary:hover, .btn-primary:focus, .btn-primary:active, .btn-primary.active, .open > .dropdown-toggle.btn-primary{border-color: #2CDB87;}.search-btn, .label-primary, #bdcs .bdcs-search-form-submit, #submit, .excerpt .cat{background-color: #2CDB87;}.excerpt .cat i{border-left-color:#2CDB87;}@media (max-width: 720px) {.site-navbar li.active a, .site-navbar li.active a:hover, .m-nav-show .m-icon-nav{color: #2CDB87;}}@media (max-width: 480px) {.pagination ul > li.next-page a{background-color:#2CDB87;}}</style><link rel="shortcut icon" href="http://www.hollischuang.com/favicon.ico">
<!--[if lt IE 9]><script src="http://www.hollischuang.com/wp-content/themes/dux/js/libs/html5.min.js"></script><![endif]-->
</head>
<body class="post-template-default single single-post postid-493 single-format-standard comment-open site-layout-2">
<header class="header">
	<div class="container">
		<div class="logo"><a href="http://www.hollischuang.com" title="HollisChuang&#039;s Blog-Java干货集散地"><img src="http://www.hollischuang.com/wp-content/uploads/2015/05/小没logo小版.png">HollisChuang&#039;s Blog</a></div>		<div class="brand">天道不一定酬所有勤</br>但是，天道只酬勤<br></div>		<ul class="site-nav site-navbar">
			<li id="menu-item-174" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-174"><a href="http://www.hollischuang.com/">首页</a></li>
<li id="menu-item-165" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-165"><a href="http://www.hollischuang.com/archives/category/java">爪哇</a></li>
<li id="menu-item-166" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor menu-item-has-children menu-item-166"><a href="http://www.hollischuang.com/archives/category/%e6%a1%86%e6%9e%b6">框架</a>
<ul class="sub-menu">
	<li id="menu-item-831" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-831"><a href="http://www.hollischuang.com/archives/category/%e6%a1%86%e6%9e%b6/webx">webx</a></li>
	<li id="menu-item-830" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-830"><a href="http://www.hollischuang.com/archives/category/%e6%a1%86%e6%9e%b6/spring">spring</a></li>
	<li id="menu-item-829" class="menu-item menu-item-type-taxonomy menu-item-object-category current-post-ancestor current-menu-parent current-post-parent menu-item-829"><a href="http://www.hollischuang.com/archives/category/%e6%a1%86%e6%9e%b6/ibatis">ibatis</a></li>
	<li id="menu-item-1824" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1824"><a href="http://www.hollischuang.com/archives/category/%e4%b8%ad%e9%97%b4%e4%bb%b6/jboss">jboss</a></li>
</ul>
</li>
<li id="menu-item-825" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-has-children menu-item-825"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8">综合应用</a>
<ul class="sub-menu">
	<li id="menu-item-826" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-826"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8/%e5%88%86%e5%b8%83%e5%bc%8f">分布式</a></li>
	<li id="menu-item-828" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-828"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8/%e7%83%ad%e9%83%a8%e7%bd%b2">热部署</a></li>
	<li id="menu-item-1441" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1441"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8/%e7%bd%91%e7%ab%99%e6%9e%b6%e6%9e%84">网站架构</a></li>
	<li id="menu-item-1442" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-1442"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8/%e8%ae%be%e8%ae%a1%e6%a8%a1%e5%bc%8f">设计模式</a></li>
	<li id="menu-item-827" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-827"><a href="http://www.hollischuang.com/archives/category/%e7%bb%bc%e5%90%88%e5%ba%94%e7%94%a8/%e5%8d%95%e5%85%83%e6%b5%8b%e8%af%95">单元测试</a></li>
</ul>
</li>
<li id="menu-item-832" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-has-children menu-item-832"><a href="http://www.hollischuang.com/archives/category/%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f">操作系统</a>
<ul class="sub-menu">
	<li id="menu-item-833" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-833"><a href="http://www.hollischuang.com/archives/category/%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f/linux">Linux</a></li>
	<li id="menu-item-834" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-834"><a href="http://www.hollischuang.com/archives/category/%e6%93%8d%e4%bd%9c%e7%b3%bb%e7%bb%9f/mac-os">mac os</a></li>
</ul>
</li>
<li id="menu-item-169" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-169"><a href="http://www.hollischuang.com/archives/category/debug">异常</a></li>
<li id="menu-item-173" class="menu-item menu-item-type-taxonomy menu-item-object-category menu-item-173"><a href="http://www.hollischuang.com/archives/category/%e5%85%b6%e4%bb%96">其他</a></li>
							<li class="navto-search"><a href="javascript:;" class="search-show active"><i class="fa fa-search"></i></a></li>
					</ul>
		<div class="topbar">
			<ul class="site-nav topmenu">
				
<li class="page_item page-item-983"><a href="http://www.hollischuang.com/%e4%ba%ba%e6%89%8d%e6%8b%9b%e8%81%98">人才招聘</a></li>
<li class="page_item page-item-1466"><a href="http://www.hollischuang.com/%e5%b8%b8%e7%94%a8%e5%b7%a5%e5%85%b7">常用工具</a></li>
<li class="page_item page-item-140"><a href="http://www.hollischuang.com/list">文章归档</a></li>
<li class="page_item page-item-987"><a href="http://www.hollischuang.com/%e8%bd%ac%e8%bd%bd%e8%af%b4%e6%98%8e">版权说明</a></li>
<li class="page_item page-item-113"><a href="http://www.hollischuang.com/%e8%b5%84%e6%ba%90%e4%b8%8b%e8%bd%bd">资源下载</a></li>
<li class="page_item page-item-1112"><a href="http://www.hollischuang.com/%e9%98%85%e8%af%bb%e4%b9%a6%e5%8d%95">阅读书单</a></li>
<li class="page_item page-item-2"><a href="http://www.hollischuang.com/sample-page">关于作者</a></li>

				<li class="menusns">
					<a href="javascript:;">关注本站 <i class="fa fa-angle-down"></i></a>
					<ul class="sub-menu">
						<li><a class="sns-wechat" href="javascript:;" title="关注”HollisChuang“" data-src="http://www.hollischuang.com/wp-content/uploads/2016/01/qrcode_for_gh_4ebd1b130cbe_430-1-e1453007336936.jpg"><i class="fa fa-wechat"></i> 微信</a></li>						<li><a target="_blank" rel="external nofollow" href="http://weibo.com/hollischuang"><i class="fa fa-weibo"></i> 微博</a></li>						<li><a target="_blank" href="http://www.hollischuang.com/feed/"><i class="fa fa-rss"></i> RSS订阅</a></li>					</ul>
				</li>
			</ul>
			Hi,Welcome To HollisChuang's Blog		</div>
		<i class="fa fa-bars m-icon-nav"></i>
	</div>
</header>
<div class="site-search">
	<div class="container">
		<form method="get" class="site-search-form" action="http://www.hollischuang.com/" ><input class="search-input" name="s" type="text" placeholder="输入关键字" value=""><button class="search-btn" type="submit"><i class="fa fa-search"></i></button></form>	</div>
</div><section class="container">
	<div class="content-wrap">
	<div class="content">
				<header class="article-header">
			<h1 class="article-title"><a href="http://www.hollischuang.com/archives/493">ibatis直接执行已有sql语句</a></h1>
			<div class="article-meta">
				<span class="item">2015-08-03</span>
								<span class="item">分类：<a href="http://www.hollischuang.com/archives/category/%e6%a1%86%e6%9e%b6/ibatis" rel="category tag">ibatis</a></span>
				<span class="item post-views">阅读(2573)</span>
				<span class="item">评论(0)</span>
				<span class="item"><br><br>本站采用[<a href="http://creativecommons.org/licenses/by-nc-sa/3.0/deed.zh" target="_blank">知识共享署名-非商业性使用-相同方式共享 许可协议</a>]进行许可，转载请在<code>正文明显处</code>注明原文地址<br>【<a href="https://mp.weixin.qq.com/s/b8ZCXHk8z4_RskoD0HxMMA"><b><code>Java架构专家总结学习体系，送给还在为职业生涯迷茫的你</code> ></b></a>】</span></div></header>
		<article class="article-content">
			<div class="asb asb-post asb-post-01"></div>			<pre><code> &lt;select id="selectAppNames" parameterClass="String" resultClass="String"&gt;
       &lt;![CDATA[ $sql$ ]]&gt;
 &lt;/select&gt;
</code></pre>
<p class="asb-post-footer"><strong>【公告】</strong><a target="_blank" href="http://www.hollischuang.com/转载说明">版权声明</a></p>(全文完)<center><img src="http://www.hollischuang.com/wp-content/uploads/2016/01/qrcode_for_gh_4ebd1b130cbe_430-1.jpg" width="300px" height="300px">欢迎关注HollisChuang微信公众账号</center><p class="post-copyright">如未加特殊说明，此网站文章均为原创，转载必须注明出处。<a href="http://www.hollischuang.com">HollisChuang&#039;s Blog</a> &raquo; <a href="http://www.hollischuang.com/archives/493">ibatis直接执行已有sql语句</a></p>		</article>
				<div class="article-tags">标签：<a href="http://www.hollischuang.com/archives/tag/ibatis" rel="tag">ibatis</a></div>		<div class="action-share bdsharebuttonbox">
			分享到：<a class="bds_qzone" data-cmd="qzone"></a><a class="bds_tsina" data-cmd="tsina"></a><a class="bds_weixin" data-cmd="weixin"></a><a class="bds_tqq" data-cmd="tqq"></a><a class="bds_sqq" data-cmd="sqq"></a><a class="bds_bdhome" data-cmd="bdhome"></a><a class="bds_tqf" data-cmd="tqf"></a><a class="bds_renren" data-cmd="renren"></a><a class="bds_diandian" data-cmd="diandian"></a><a class="bds_youdao" data-cmd="youdao"></a><a class="bds_ty" data-cmd="ty"></a><a class="bds_kaixin001" data-cmd="kaixin001"></a><a class="bds_taobao" data-cmd="taobao"></a><a class="bds_douban" data-cmd="douban"></a><a class="bds_fbook" data-cmd="fbook"></a><a class="bds_twi" data-cmd="twi"></a><a class="bds_mail" data-cmd="mail"></a><a class="bds_copy" data-cmd="copy"></a><a class="bds_more" data-cmd="more">更多</a> (<a class="bds_count" data-cmd="count"></a>)		</div>
	<div class="asb asb-post asb-post-02"></div>		<div class="relates"><div class="title"><h3>相关推荐</h3></div><ul><li><a href="http://www.hollischuang.com/archives/502">ibatis防止sql注入</a></li></ul></div><a name="comments"></a>
<div id="SOHUCS" sid="493"></div><script>
if(window.screen.width > 960) {
    (function(){var appid = 'cyrFnsBtC',conf = 'prod_957fbae232bab98fce4551fdee712071';
        var doc = document,
        s = doc.createElement('script'),
        h = doc.getElementsByTagName('head')[0] || doc.head || doc.documentElement;
        s.type = 'text/javascript';
        s.charset = 'utf-8';
        s.src =  'http://assets.changyan.sohu.com/upload/changyan.js?conf=' + conf + '&appid=' + appid;
        h.insertBefore(s,h.firstChild);
    })()
    } else {
    (function(){
        var expire_time = parseInt((new Date()).getTime()/(5*60*1000));
        var head = document.head || document.getElementsByTagName("head")[0] || document.documentElement;
        var script_version = document.createElement("script"),script_cyan = document.createElement("script");
        script_version.type = script_cyan.type = "text/javascript";
        script_version.charset = script_cyan.charset = "utf-8";
        script_version.onload = function(){
            script_cyan.id = 'changyan_mobile_js';
            script_cyan.src = 'http://changyan.itc.cn/upload/mobile/wap-js/changyan_mobile.js?client_id=cyrFnsBtC&conf=prod_957fbae232bab98fce4551fdee712071&version=cyan_resource_version';
            head.insertBefore(script_cyan, head.firstChild);
        };
        script_version.src = 'http://changyan.sohu.com/upload/mobile/wap-js/version.js?_='+expire_time;
        head.insertBefore(script_version, head.firstChild);
    })();
}</script>
<div id="ds-ssr" style="display:none">
		            <ol id="commentlist">
                            </ol>

		    </div>
	</div>
	</div>
			</div>
	</div>
	<aside class="sidebar">
		<div class="widget widget_recent_entries">		<h3>近期文章</h3>		<ul>
											<li>
					<a href="http://www.hollischuang.com/archives/2700">一文读懂什么是Java中的自动拆装箱</a>
									</li>
											<li>
					<a href="http://www.hollischuang.com/archives/2673">再有人问你volatile是什么，把这篇文章也发给他。</a>
									</li>
											<li>
					<a href="http://www.hollischuang.com/archives/2662">内存模型是怎么解决缓存一致性问题的？</a>
									</li>
											<li>
					<a href="http://www.hollischuang.com/archives/2648">深入理解Java中的volatile关键字</a>
									</li>
											<li>
					<a href="http://www.hollischuang.com/archives/2642">服务器性能指标（三）——内存使用分析及问题排查</a>
									</li>
					</ul>
		</div><div class="widget widget_ui_ads"><div class="item"><img src="http://www.hollischuang.com/wp-content/uploads/2018/02/公众号.jpg"></a></div></div></aside></section>

<div class="branding branding-black">
	<div class="container">
		<h2>HollisChuang's Blog</h2>
		<a target="blank" class="btn btn-lg" href="http://mail.qq.com/cgi-bin/qm_share?t=qm_mailme&email=-JSTkJCVj5_UiZ2Sm7yNjdKfk5E">联系我</a><a target="blank" class="btn btn-lg" href="/sample-page">关于我</a>	</div>
</div>
<footer class="footer">
	<div class="container">
		<p>&copy; 2018 <a href="http://www.hollischuang.com">HollisChuang&#039;s Blog</a> &nbsp; <a href='http://www.hollischuang.com/sitemap.xml'>网站地图</a>|<a href="http://www.aliyun.com" target="_blank">阿里云</a>|<a href="http://www.alibaba.com" target="_blank">Alibaba.com</a>|<script type="text/javascript">var cnzz_protocol = (("https:" == document.location.protocol) ? " https://" : " http://");document.write(unescape("%3Cspan id='cnzz_stat_icon_1256611093'%3E%3C/span%3E%3Cscript src='" + cnzz_protocol + "s4.cnzz.com/z_stat.php%3Fid%3D1256611093%26show%3Dpic' type='text/javascript'%3E%3C/script%3E"));</script></p>
			</div>
</footer>

<script>
window.jsui={
    www: 'http://www.hollischuang.com',
    uri: 'http://www.hollischuang.com/wp-content/themes/dux',
    ver: 'THEME_VERSION',
	roll: ["2","6"],
    ajaxpager: '0',
    url_rp: 'http://www.hollischuang.com/sample-page'
};
</script>
<script type='text/javascript' src='http://www.hollischuang.com/wp-content/themes/dux/js/libs/bootstrap.min.js?ver=THEME_VERSION'></script>
<script type='text/javascript' src='http://www.hollischuang.com/wp-content/themes/dux/js/loader.js?ver=THEME_VERSION'></script>
<script type='text/javascript' src='http://www.hollischuang.com/wp-content/plugins/wp-markdown/js/prettify.min.js?ver=1.6.1'></script>
<script type='text/javascript' src='http://www.hollischuang.com/wp-includes/js/wp-embed.min.js?ver=4.9.8'></script>
<script type='text/javascript' src='http://www.hollischuang.com/wp-content/plugins/wp-markdown/js/markdown.min.js?ver=1.6.1'></script>
</body>
</html>