生活随笔
收集整理的這篇文章主要介紹了
mybatis插入图片处理--mysql
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
1. 數據庫Scheme
1.數據庫Scheme
DROP?TABLE?IF?EXISTS?`user_graphic_t`;?? /*!40101?SET?@saved_cs_client?????=?@@character_set_client?*/;?? /*!40101?SET?character_set_client?=?utf8?*/;?? CREATE?TABLE?`user_graphic_t`?(?? ??`id`?int(11)?NOT?NULL?AUTO_INCREMENT,?? ??`graphic_data`?blob,?? ??PRIMARY?KEY?(`id`)?? )?ENGINE=InnoDB?AUTO_INCREMENT=360?DEFAULT?CHARSET=utf8;?
2.Mapper配置文件
<resultMap?id="userGraphicMap"?type="userGraphicVo">?? ????????<id?column="id"?property="id"?jdbcType="DECIMAL"?/>?? ????????<span?style="color:?#ff0000;"><result?column="graphic_data"?property="graphicData"?jdbcType="BLOB"?/></span>?? ?? ?? ?? </resultMap>?? ?? <sql?id="resultColumn">?? ????????id,graphic_data?? </sql>?? ?????? <insert?id="insertUserGraphic"?parameterType="userGraphicVo">?? ????????INSERT?INTO?user_graphic_t?(?? ????????<include?refid="resultColumn"?/>?? ????????)?? ????????values?(?? ????????#{id},,#{graphicData}?? ????????)?? </insert>?? ?????? <select?id="selectUserGraphic"?parameterType="java.lang.Long"?resultMap="userGraphicMap">?? ????????SELECT?? ????????<include?refid="resultColumn"?/>?? ????????from?user_graphic_t?WHERE?? ????????id=#{id}??? ????????order?by?id?desc?? </select>?? 3.Java bean public?class?UserGraphicVo?{?? ?? ????private?Long?id;?? ?????? ????private?byte[]?graphicData;?? ?? ????????? } ? 4.Action 處理 public?void?showReportImage()?{?? ????????????????response.setContentType("image/jpeg");?? ?? ????????????????if?(!"".equals(id))?{?? ????????????List<UserGraphicVo>?list?=?userGraphicService.findUserGraphicVoById(id);?? ????????????if(null?!=?list?&&?!list.isEmpty()){?? ????????????????OutputStream?os?=?null;?? ????????????????try?{?? ????????????????????os?=?response.getOutputStream();?? ????????????????????os.write(list.get(0).getGraphicData());?? ????????????????????os.flush();?? ????????????????}?catch?(IOException?e)?{?? ????????????????????Log.info("讀取文件出錯！"?+?e.getMessage());?? ????????????????}?finally?{?? ????????????????????if(null?!=?os){?? ????????????????????????try?{?? ????????????????????????????os.close();?? ????????????????????????}?catch?(IOException?e)?{?? ????????????????????????????Log.info("關閉文件輸出流出錯！"?+?e.getMessage());?? ????????????????????????}?? ????????????????????}?? ????????????????}????????????????? ????????????}?? ????????}?? ????} ?
總結
以上是生活随笔為你收集整理的mybatis插入图片处理--mysql的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
