天天看點

Mybatis傳遞多個參數

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());        

}