2. Mybatis Select

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper  
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"  
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">  
<mapper namespace="com.accp.mybatis.model.Blog">  
      
    <!--可重用的SQL代码段-->  
    <sql id="blog_column">id,title,author_id as authorId</sql>  
      
    <select id="selectBlog_as_map" parameterType="int" resultType="hashmap">  
        select <include refid="blog_column"/> from Blog where id = #{id}  
    </select>  
      
</mapper>  

String selectBlog_as_map = “select * from Blog where id =?”;   
PreparedStatement ps = conn.prepareStatement(selectBlog_as_map);   
ps.setInt(1,id);

public static void selectBlogAsMap(int id) {  
    SqlSession session = sqlMapper.openSession();  
    Map<String, Object> map = session.selectOne("selectBlog_as_map",id);  
    System.out.println(map);  
    session.close();  
}