ibatis参考

最新推荐文章于 2018-11-19 16:33:35 发布

勇哥聊IT

最新推荐文章于 2018-11-19 16:33:35 发布

阅读量566

点赞数

分类专栏： ibatis 文章标签： ibatis integer user string class

本文链接：https://blog.csdn.net/wodwl/article/details/7718770

版权

ibatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

指定别名

<typeAlias alias="user" type="com.wodwl.User" />

使用resultMap

 <!-- 使用resultMap -->
	<resultMap class="user" id="resultMap1">
		<result property="id" column="id" javaType="integer" jdbcType="int" />
		<result property="name" column="xingming" javaType="string"
			jdbcType="VARCHAR" />
		<result property="sex" column="xingbie" javaType="integer"
			jdbcType="int" />
	</resultMap>
	<select id="select2" resultMap="resultMap1" parameterClass="integer">
   		<![CDATA[
   		
   		SELECT id,xingming,xingbie FROM user WHERE id=#id#
   		
   		]]>
	</select>





 public static void select2() throws IOException, SQLException{
    	String resource="com/wodwl/map/SqlMapConfig.xml";
    	Reader reader=Resources.getResourceAsReader(resource);
    	SqlMapClient smc=SqlMapClientBuilder.buildSqlMapClient(reader);
    	smc.startTransaction();
    	
    	User user=(User)smc.queryForObject("user.select2",new Integer(1));
    	
    	smc.commitTransaction();
    	
    	System.out.println(user.getName());
    	
    }


使用select as 实现字段名和属性名的映射
<select id="select1" resultClass="java.util.HashMap"
		parameterClass="integer">

		SELECT id,xingming as name,xingbie as sex FROM user WHERE id=#id#

	</select>