ibatis3如何傳遞多個參數有兩個方法:一種是使用java.map,另一種是使用javabean。
通過map傳遞多個參數
parametertype 可以是别名或完全限定名,map或者java.util.map,這兩個都是可以的
<select id="selectblogbymap" parametertype="map" resulttype="blog">
select t.id, t.title, t.content
from blog t
where t.title = #{h_title}
and t.content =#{h_content}
</select>
public void testselectbymap() {
sqlsession session = sqlsessionfactory.opensession();
map<string, object> param=new hashmap<string, object>();
param.put("h_title", "oracle");
param.put("h_content", "使用序列");
blog blog = (blog)session.selectone("cn.enjoylife.blogmapper.selectblogbymap",param);
session.close();
system.out.println("blog title:"+blog.gettitle());
}
通過javabean傳遞多個參數
<select id="selectblogbybean" parametertype="blog" resulttype="blog">
select t.id, t.title, t.content
from blog t
wheret.title = #{title}
and t.content =#{content}
</select>
public void testselectbybean() {
blog blog=new blog();
blog.settitle("oracle");
blog.setcontent("使用序列!");
blog newblog = (blog)session.selectone("cn.enjoylife.blogmapper.selectblogbybean",blog);
system.out.println("new blog id:"+newblog.getid());
}