Ibaits操作二进制数据的一些小技巧

最新推荐文章于 2020-02-11 20:48:39 发布

瞄一眼就跑

最新推荐文章于 2020-02-11 20:48:39 发布

阅读量447

点赞数

文章标签： Ibatis 二进制图片数据库 ja

本文链接：https://blog.csdn.net/sxrenchao/article/details/45336229

版权

<pre name="code" class="html"><span style="font-family: Arial, Helvetica, sans-serif;"></span><pre name="code" class="html"><strong><span style="font-size:18px;">xml设置：</span></strong>

	    	insert into LogoManageForLogin(id,leftLogoForLogin,rightLogoForLogin,rightsForLogin) values (LogoManageForLogin_SEQ.NEXTVAL,#leftLogoForLogin#,#rightLogoForLogin#,#rightsForLogin#)
    	</insert>    	
    	<!--设置返回格式-->
	    <resultMap id="logoForLoginMap" class="java.util.HashMap">
	    	<result property="id" column="id"/>
	    	<result property="leftLogoForLogin" column="leftLogoForLogin" typeHandler="com.ibatis.sqlmap.engine.type.BlobTypeHandlerCallback"/>
	    	<result property="rightLogoForLogin" column="rightLogoForLogin" typeHandler="com.ibatis.sqlmap.engine.type.BlobTypeHandlerCallback" />
	        <result property="rightsForLogin" column="rightsForLogin"/>
	    </resultMap>
		<!-- 查询初始化信息 -->	    
	    <select id="queryBlobByLogin" parameterClass="java.lang.Integer" resultMap="logoForLoginMap">
	        SELECT * FROM LogoManageForLogin WHERE id = (select id from (select t.*,row_number() over(order by id) rn from LogoManageForLogin t) where rn=1)
	    </select>	    
	    <!-- 还原设置 -->
	    <!-- 查询总记录数 -->
	    <select id="getCountByLogin" parameterClass="java.lang.Integer" resultClass="java.lang.Integer">
			select count(1) from LogoManageForLogin
		</select>
		<!-- 查询最后一条 -->
	    <select id="queryLastButOneForLogin" parameterClass="java.lang.Integer" resultMap="logoForLoginMap">
			SELECT * FROM LogoManageForLogin WHERE id = (select id from (select t.*,row_number() over(order by id desc) rn from LogoManageForLogin t) where rn=2)
	    </select>   
		<!-- 删除最后一条 -->
	    <delete id="deleteLastRowForLogin">
			delete from LogoManageForLogin WHERE id = (select id from (select t.*,row_number() over(order by id desc) rn from LogoManageForLogin t) where rn=1)
	    </delete>
	    <!-- 删除除初始化以外的数据 -->
	    <delete id="deleteOtherRowForLogin">
			delete from LogoManageForLogin
	    </delete>

JAVA代码应用

			Map map = (Map) getSqlMapClient().queryForObject(queryXmlStr,null);  
			String StrResult="";  
			if(map!= null){  
				byte[] leftLogo_blobBytes = (byte[])map.get("leftLogoForLogin");
				byte[] rightLogo_blobBytes = (byte[])map.get("rightLogoForLogin");</span>

<span style="white-space: pre;">		</span>byte[] leftLogoForLoginData = LogoSettingUtil

				.getImageBinary(leftLogoForLogin);
		byte[] rightLogoForLoginData = LogoSettingUtil
				.getImageBinary(rightLogoForLogin);
		
		if(null == leftLogoForLoginData && null == rightLogoForLoginData && "".equals(rightsForLogin)){
			throw new RuntimeException("请提交数据后保存！");
		}
		
		Map map = new HashMap();
		map.put("leftLogoForLogin", leftLogoForLoginData); 
		map.put("rightLogoForLogin", rightLogoForLoginData); 
		map.put("rightsForLogin", rightsForLogin);
		 
		try {
			// 保存数据至数据库
			getSqlMapClient().update("admp.saveLogoForLogin", map);
			// 生成图片