ibatis返回HashMap结果类型与映射

<!-- 返回HashMap结果 类型--> <!-- 如果想返回JavaBean,只需将resultType设置为JavaBean的别名或全限定名 --> <!-- TypeAliasRegistry类初始化时注册了一些常用的别名，如果忘记了别名可以在这里面查看 --> <select id="selectBlogRetHashMap" parameterType="int" resultType="map"> SELECT id AS "id", title AS "title", content AS "content" FROM Blog WHERE id = #{id} </select> 测试代码：/** * 测试返回HashMap */ @SuppressWarnings("unchecked") @Test public void testSelectBlogRetHashMap() { SqlSession session = sqlSessionFactory.openSession(); HashMap<String,Object> blog = (HashMap<String,Object>) session.selectOne( "cn.enjoylife.BlogMapper.selectBlogRetHashMap", 15); session.close(); System.out.println(blog.get("title")); }

ibatis高级映射：

表结构:

create table BLOG ( ID NUMBER(20), TITLE VARCHAR2(50), CONTENT VARCHAR2(4000), BLOG_AUTHOR_ID NUMBER(20) ) create table AUTHOR ( ID NUMBER(20), AUTHOR_NAME VARCHAR2(50) ); create table POSTS ( ID NUMBER(20), SUBJECT VARCHAR2(50), BODY VARCHAR2(4000), BLOG_ID NUMBER(20) ) bean信息：package cn.enjoylife.domain; import java.util.List; public class Blog { private Integer id; private String title; private String content; private Author author; private List<Post> posts/*=new ArrayList<Post>()*/; public List<Post> getPosts() { return posts; } public void setPosts(List<Post> posts) { this.posts = posts; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getTitle() { return title; } public void setTitle(String title) { this.title = title; } public String getCon