mysql blob字段储存图片操作示例-MySQL教程-爱易网页

mysql blob字段储存图片操作示例

日期：2014-05-16　浏览次数：20913 次

mysql blob字段存储图片操作示例

表结构：

create table view(id int unsigned NOT NULL AUTO_INCREMENT, catid int,title varchar(256),picture MEDIUMBLOB, content TEXT,PRIMARY KEY (id));
java类操作：

import java.awt.Image; import java.io.*; import java.nio.ByteBuffer; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.ImageIcon; import org.bean.View; /** * * @author weijian.zhongwj */ public class ViewPointDao { public static View getView(Integer catId) { View view = new View(); try { String sql2 = "SELECT title, content, picture FROM view where catid=? limit 1"; PreparedStatement stmt2 = BaseDaoFactory.getInstance().prepareStatement(sql2); stmt2.setInt(1, catId); ResultSet resultSet = stmt2.executeQuery(); while (resultSet.next()) { String name = resultSet.getString(1); String description = resultSet.getString(2); ByteBuffer bb = ByteBuffer.allocate(1024 * 1024); byte[] buffer = new byte[1]; InputStream is = resultSet.getBinaryStream(3); while (is != null && is.read(buffer) > 0) { bb.put(buffer); } ImageIcon icon = new ImageIcon(bb.array()); view.setImage(icon.getImage()); view.setTitle(name); view.setContent(description); return view; } } catch (IOException ex) { Logger.getLogger(ViewPointDao.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(ViewPointDao.class.getName()).log(Level.SEVERE, null, ex); } return null; } public static boolean addView(View view) { FileInputStream fis = null; try { if (exit(view.getCatId())) { return update(view); } String sql = "INSERT INTO view (title, content, catid, picture) VALUES (?, ?, ?, ?)"; PreparedStatement stmt = BaseDaoFactory.getInstance().prepareStatement(sql); stmt.setString(1, view.getTitle()); stmt.setString(2, view.getContent()); stmt.setInt(3, view.getCatId()); if (view.getImageFile() != null) { File image = new File(view.getImageFile()); fis = new FileInputStream(image); //image.length(),返回文件的大小 stmt.setBinaryStream(4, fis, (int) image.length()); } else { stmt.setBinaryStream(4, null, 0); } int count = stmt.executeUpdate(); if (count > 0) { return true; } else { return false; } } catch (IOException ex) { Logger.getLogger(ViewPointDao.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(ViewPointDao.class.getName()).log(Level.SEVERE, null, ex); } finally { try { if (fis != null) { fis.close(); } } catch (IOException ex) { } } return false; } public static boolean update(View view) { FileInputStream fis = null; try { String sql = "update view set title= ? ,content= ? " + (view.getImageFile() != null ? (",picture= ? ") : " ") + "where catid= ? "; PreparedStatement stmt = BaseDaoFactory.getInstance().prepareStatement(sql); stmt.setString(1, view.getTitle()); stmt.setString(2, view.getContent()); if (vi <div class="clearfix"></div> </div> <nav aria-label="..."> <ul class="pager"> <li class="previous"><a href="44373">上一篇：MYSQL锁处理</a></li> <li class="next"><a href="41592">下一篇： MySQL经验10-1-事务 </a></li> </ul> </nav> <div class="alert alert-warning" role="alert"> <strong>免责声明：</strong> 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。 </div> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">相关资料<span><a target="_blank" class="pull-right" href="/MySQL/">更多></a></span></h3> </div> <div class="panel-body row"> <ol> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/44090' title=' 怎么写这个sql ' target="_blank"> 怎么写这个sql </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/40814' title=' mysql向Oracle迁徙 ' target="_blank"> mysql向Oracle迁徙 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/43612' title=' MySql中为什么不能添加汉字？该如何处理 ' target="_blank"> MySql中为什么不能添加汉字？该如何处理 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/42805' title=' mysql command line client 怎样输入中文解决办法 ' target="_blank"> mysql command line client 怎样输入中文解决办法 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/41951' title=' 请教怎么查看mysql 的端口号 ' target="_blank"> 请教怎么查看mysql 的端口号 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/40133' title=' 一种MySQL主从同步加快方案－改进 ' target="_blank"> 一种MySQL主从同步加快方案－改进 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/41481' title=' mysql状态汇报工具 mysqlreport ' target="_blank"> mysql状态汇报工具 mysqlreport </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/35609' title=' MySQL命令学习(1) ' target="_blank"> MySQL命令学习(1) </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/MySQL/35561' title=' mysql学习之4：sql语句学习2 ' target="_blank"> mysql学习之4：sql语句学习2 </a></li></div> </ol> </div> </div> </div> <div class="col-lg-4 hidden-sm hidden-xs">  <a id="AdPageRight1_AdPageRight" href="http://www.tdyun.com/cloud/?aiyiweb" target="_blank"><img class="img-responsive" src="/images/TdPageAd/vps.png" alt="香港云服务器免备案云主机VPS 国内独立IP 独享15M 月付SSD" /></a> <script src='/Scripts/AdContentPage300_1.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_2.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_3.js' language='javascript'></script> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">推荐阅读<span><a target="_blank" class="pull-right" href="/MySQL/">更多></a></span></h3> </div> <div class="panel-body"> <ol> <li class="articleAbout"><a href=/MySQL/40187 title=' 二次装配mysql不能启动服务 ' target="_blank"> 二次装配mysql不能启动服务 </a></li> <li class="articleAbout"><a href=/MySQL/39981 title=' mysql内存储器表弊端 ' target="_blank"> mysql内存储器表弊端 </a></li> <li class="articleAbout"><a href=/MySQL/42552 title=' mysql交流,该怎么处理 ' target="_blank"> mysql交流,该怎么处理 </a></li> <li class="articleAbout"><a href=/MySQL/43936 title=' SHOW PROCESSLIST只需要死锁的部分信息,该怎么处理 ' target="_blank"> SHOW PROCESSLIST只需要死锁的部分信息,该怎么处理 </a></li> <li class="articleAbout"><a href=/MySQL/36890 title=' MySql数目字函数大全 ' target="_blank"> MySql数目字函数大全 </a></li> <li class="articleAbout"><a href=/MySQL/43988 title=' 检测MySql数据库的工具，大家一块讨论讨论,该怎么处理 ' target="_blank"> 检测MySql数据库的工具，大家一块讨论讨论,该怎么处理 </a></li> <li class="articleAbout"><a href=/MySQL/44359 title=' 年月+日（日在列上）　化列为行解决方案 ' target="_blank"> 年月+日（日在列上）　化列为行解决方案 </a></li> <li class="articleAbout"><a href=/MySQL/43645 title=' 看看这个存储过程哪里错了 ' target="_blank"> 看看这个存储过程哪里错了 </a></li> <li class="articleAbout"><a href=/MySQL/35955 title=' mysql workbench创建表碰到fetching back view definitions in final form ' target="_blank"> mysql workbench创建表碰到fetching back view definitions in final form </a></li> <li class="articleAbout"><a href=/MySQL/39281 title=' MySQL的增添用户的两种方法 ' target="_blank"> MySQL的增添用户的两种方法 </a></li> <li class="articleAbout"><a href=/MySQL/44234 title=' 数据库所有表数据删除或替换如何整 ' target="_blank"> 数据库所有表数据删除或替换如何整 </a></li> <li class="articleAbout"><a href=/MySQL/43376 title=' 请教怎么求值? ' target="_blank"> 请教怎么求值? </a></li> <li class="articleAbout"><a href=/MySQL/39889 title=' mysql学习札记-常用命令 ' target="_blank"> mysql学习札记-常用命令 </a></li> <li class="articleAbout"><a href=/MySQL/38295 title=' mono联接mysql时的ArgumentNullException的解决 ' target="_blank"> mono联接mysql时的ArgumentNullException的解决 </a></li> <li class="articleAbout"><a href=/MySQL/40403 title=' mysql 日记查看 ' target="_blank"> mysql 日记查看 </a></li> <li class="articleAbout"><a href=/MySQL/43196 title=' mysqlimport使用有关问题 ' target="_blank"> mysqlimport使用有关问题 </a></li> <li class="articleAbout"><a href=/MySQL/37287 title=' zerofill在mysql字段定义中的施用以及auto_increment的注意事项 ' target="_blank"> zerofill在mysql字段定义中的施用以及auto_increment的注意事项 </a></li> <li class="articleAbout"><a href=/MySQL/41010 title=' MySQL高速掌握之基础篇 ' target="_blank"> MySQL高速掌握之基础篇 </a></li> <li class="articleAbout"><a href=/MySQL/39592 title=' 数据库入门解决办法 ' target="_blank"> 数据库入门解决办法 </a></li> <li class="articleAbout"><a href=/MySQL/38454 title=' mysql自定义函数有关问题。 ' target="_blank"> mysql自定义函数有关问题。 </a></li> </ol> </div> </div> </div> </div> <div class="clearfix"></div> <footer class=" footer navbar-bottom"> <em>友情链接：</em> <a href="http://www.aiyiweb.com/" target="_blank">爱易网 </a> <a href="http://www.aiyiweb.com/" target="_blank">云虚拟主机技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">云服务器技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">程序设计技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">开发网站 </a> <a href="http://www.aiyiweb.com/" target="_blank">APP开发教程 </a> <br /> <script type="text/javascript">(function(){document.write(unescape('%3Cdiv id="bdcs"%3E%3C/div%3E'));var bdcs = document.createElement('script');bdcs.type = 'text/javascript';bdcs.async = true;bdcs.src = 'http://znsv.baidu.com/customer_search/api/js?sid=15239353030108964139' + '&plate_url=' + encodeURIComponent(window.location.href) + '&t=' + Math.ceil(new Date()/3600000);var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(bdcs, s);})();</script> Copyright © 2013-2025 爱易网页当前在线：610人　网站在739377天9时12分58秒内访问总人数：118000人 12时46分44秒前 10.98% 　<a href="https://beian.miit.gov.cn" target="_blank">粤ICP备18100884号-2 </a> <script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script> <script>LA.init({ id: "JszEmKrtpbU59dY5", ck: "JszEmKrtpbU59dY5" })</script> </footer> </div> </body> </html>