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

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

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

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/43680' title=' 几百万条数据的处理!解决思路 ' target="_blank"> 几百万条数据的处理!解决思路 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/44304' title=' mysql 有没有系统表或者视图？解决方案 ' target="_blank"> mysql 有没有系统表或者视图？解决方案 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38637' title=' 用MYSQL BACKUP工具备份出来的SQL，怎么还原？用MYSQL BACKUP工具备份出来的SQL，怎么还原？用MYSQL BACKUP工具备份 ' target="_blank"> 用MYSQL BACKUP工具备份出来的SQL，怎么还原？用MYSQL BACKUP工具备份出来的SQL，怎么还原？用MYSQL BACKUP工具备份 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38716' title=' java开发中mysql与oracle差异总结 ' target="_blank"> java开发中mysql与oracle差异总结 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38756' title=' mysql滴滴答答 ' target="_blank"> mysql滴滴答答 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38346' title=' 新手怎么对不同列进行求和 ' target="_blank"> 新手怎么对不同列进行求和 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/41829' title=' 谁帮小弟我看看这个有关问题 ' target="_blank"> 谁帮小弟我看看这个有关问题 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/40701' title=' mysql十分有用的几个命令 ' target="_blank"> mysql十分有用的几个命令 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/42786' title=' mysql全局变量的有关问题 ' target="_blank"> mysql全局变量的有关问题 </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/42505 title=' SQL的请问 ' target="_blank"> SQL的请问 </a></li> <li class="articleAbout"><a href=/mysql/42133 title=' []一个关于考试成绩的SQL语句 ' target="_blank"> []一个关于考试成绩的SQL语句 </a></li> <li class="articleAbout"><a href=/mysql/37053 title=' MySQL怎么修改Root密码 ' target="_blank"> MySQL怎么修改Root密码 </a></li> <li class="articleAbout"><a href=/mysql/42196 title=' txt文件导入MySQL数据库指定列解决思路 ' target="_blank"> txt文件导入MySQL数据库指定列解决思路 </a></li> <li class="articleAbout"><a href=/mysql/26813 title='如何实现MySQL中的用户管理?' target="_blank"> 如何实现MySQL中的用户管理?</a></li> <li class="articleAbout"><a href=/mysql/37083 title=' Slave_SQL_Running: No mysql同步故障解决办法 ' target="_blank"> Slave_SQL_Running: No mysql同步故障解决办法 </a></li> <li class="articleAbout"><a href=/mysql/39691 title=' mysql 存储过程如何比较数据库里面记录的日期，是不是和当前日期相同 ' target="_blank"> mysql 存储过程如何比较数据库里面记录的日期，是不是和当前日期相同 </a></li> <li class="articleAbout"><a href=/mysql/43733 title=' MySQL的驱动版本，是不是直接下载最新的就行了？该怎么处理 ' target="_blank"> MySQL的驱动版本，是不是直接下载最新的就行了？该怎么处理 </a></li> <li class="articleAbout"><a href=/mysql/43802 title=' 触发器触发的条件是表还是字段？该如何处理 ' target="_blank"> 触发器触发的条件是表还是字段？该如何处理 </a></li> <li class="articleAbout"><a href=/mysql/38234 title=' Oracle移栽到MySQL注意事项 ' target="_blank"> Oracle移栽到MySQL注意事项 </a></li> <li class="articleAbout"><a href=/mysql/36383 title=' mysql表修理 ' target="_blank"> mysql表修理 </a></li> <li class="articleAbout"><a href=/mysql/40029 title=' 在mysql中剔除前缀是delete的所有表 ' target="_blank"> 在mysql中剔除前缀是delete的所有表 </a></li> <li class="articleAbout"><a href=/mysql/40817 title=' mysql从服务器出现的异常解決方法:Slave_SQL_Running: No(主-从) ' target="_blank"> mysql从服务器出现的异常解決方法:Slave_SQL_Running: No(主-从) </a></li> <li class="articleAbout"><a href=/mysql/41752 title=' postgresql在centos中用户切换,该如何解决 ' target="_blank"> postgresql在centos中用户切换,该如何解决 </a></li> <li class="articleAbout"><a href=/mysql/41686 title=' mysql所有的数据库后缀为*MYD大小都为0，咋回事 ' target="_blank"> mysql所有的数据库后缀为*MYD大小都为0，咋回事 </a></li> <li class="articleAbout"><a href=/mysql/39994 title=' Mysql命令行下令 ' target="_blank"> Mysql命令行下令 </a></li> <li class="articleAbout"><a href=/mysql/42148 title=' 根据几个条件查询表的条数解决方案 ' target="_blank"> 根据几个条件查询表的条数解决方案 </a></li> <li class="articleAbout"><a href=/mysql/36782 title=' mysql日期跟字符相互转换 ' target="_blank"> mysql日期跟字符相互转换 </a></li> <li class="articleAbout"><a href=/mysql/36628 title=' mysql怎么执行脚本文件 ' target="_blank"> mysql怎么执行脚本文件 </a></li> <li class="articleAbout"><a href=/mysql/37064 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 爱易网页当前在线：129人　网站在1天4时59分49秒内访问总人数：200529人当前 18.51% 　<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>