mysql里面怎样插入图片

发布网友发布时间：2022-04-21 23:32

我来回答

共2个回答

懂视网时间：2022-04-29 20:04

推荐：《mysql视频教程》

正常的图片储存要么放进本地磁盘，要么就存进数据库。存入本地很简单，现在我在这里记下如何将图片存进mysql数据库

如果要图片存进数据库要将图片转化成二进制。

1.数据库存储图片的字段类型要为blob二进制大对象类型

2.将图片流转化为二进制

下面放上代码实例

一、数据库

CREATE TABLE `photo` (
 `id` int(11) NOT NULL,
 `name` varchar(255) DEFAULT NULL,
 `photo` blob,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

二、数据库链接

/**
 * 
 */
package JdbcImgTest;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * @author Administrator
 * 
 */
public class DBUtil
{
 // 定义数据库连接参数
 public static final String DRIVER_CLASS_NAME = "com.mysql.jdbc.Driver";
 
 public static final String URL = "jdbc:mysql://localhost:3306/test";
 
 public static final String USERNAME = "root";
 
 public static final String PASSWORD = "root";
 
 // 注册数据库驱动
 static
 {
 try
 {
  Class.forName(DRIVER_CLASS_NAME);
 }
 catch (ClassNotFoundException e)
 {
  System.out.println("注册失败！");
  e.printStackTrace();
 }
 }
 
 // 获取连接
 public static Connection getConn() throws SQLException
 {
 return DriverManager.getConnection(URL, USERNAME, PASSWORD);
 }
 
 // 关闭连接
 public static void closeConn(Connection conn)
 {
 if (null != conn)
 {
  try
  {
  conn.close();
  }
  catch (SQLException e)
  {
  System.out.println("关闭连接失败！");
  e.printStackTrace();
  }
 }
 }
 
 //测试
/* public static void main(String[] args) throws SQLException
 {
 System.out.println(DBUtil.getConn());
 }
 */
}

三、图片流

package JdbcImgTest;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;

/**
 * @author Administrator
 * 
 */
public class ImageUtil
{
 
 // 读取本地图片获取输入流
 public static FileInputStream readImage(String path) throws IOException
 {
 return new FileInputStream(new File(path));
 }
 
 // 读取表中图片获取输出流
 public static void readBin2Image(InputStream in, String targetPath)
 {
 File file = new File(targetPath);
 String path = targetPath.substring(0, targetPath.lastIndexOf("/"));
 if (!file.exists())
 {
  new File(path).mkdir();
 }
 FileOutputStream fos = null;
 try
 {
  fos = new FileOutputStream(file);
  int len = 0;
  byte[] buf = new byte[1024];
  while ((len = in.read(buf)) != -1)
  {
  fos.write(buf, 0, len);
  }
  fos.flush();
 }
 catch (Exception e)
 {
  e.printStackTrace();
 }
 finally
 {
  if (null != fos)
  {
  try
  {
   fos.close();
  }
  catch (IOException e)
  {
   e.printStackTrace();
  }
  }
 }
 }
}

四、转码存储

package JdbcImgTest;

import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * @author Administrator 测试写入数据库以及从数据库中读取
 */
public class ImageDemo
{
 
 // 将图片插入数据库
 public static void readImage2DB()
 {
 String path = "D:/Eclipse/eclipseWorkspace/TestProject/Img/mogen.jpg";
 Connection conn = null;
 PreparedStatement ps = null;
 FileInputStream in = null;
 try
 {
  in = ImageUtil.readImage(path);
  conn = DBUtil.getConn();
  String sql = "insert into photo (id,name,photo)values(?,?,?)";
  ps = conn.prepareStatement(sql);
  ps.setInt(1, 1);
  ps.setString(2, "Tom");
  ps.setBinaryStream(3, in, in.available());
  int count = ps.executeUpdate();
  if (count > 0)
  {
  System.out.println("插入成功！");
  }
  else
  {
  System.out.println("插入失败！");
  }
 }
 catch (Exception e)
 {
  e.printStackTrace();
 }
 finally
 {
  DBUtil.closeConn(conn);
  if (null != ps)
  {
  try
  {
   ps.close();
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  }
 }
 
 }
 
 // 读取数据库中图片
 public static void readDB2Image()
 {
 String targetPath = "C:/Users/Jia/Desktop/mogen.jpg";
 Connection conn = null;
 PreparedStatement ps = null;
 ResultSet rs = null;
 try
 {
  conn = DBUtil.getConn();
  String sql = "select * from photo where id =?";
  ps = conn.prepareStatement(sql);
  ps.setInt(1, 1);
  rs = ps.executeQuery();
  while (rs.next())
  {
  InputStream in = rs.getBinaryStream("photo");
  ImageUtil.readBin2Image(in, targetPath);
  }
 }
 catch (Exception e)
 {
  e.printStackTrace();
 }
 finally
 {
  DBUtil.closeConn(conn);
  if (rs != null)
  {
  try
  {
   rs.close();
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  }
  if (ps != null)
  {
  try
  {
   ps.close();
  }
  catch (SQLException e)
  {
   e.printStackTrace();
  }
  }
  
 }
 }
 
 //测试
 public static void main(String[] args)
 {
 //readImage2DB();
 readDB2Image();
 }
}

热心网友时间：2022-04-29 17:12

新建类型为mediumblob的字段【小图片可以用blob，更大的图片可以用LongBlob】

将图片转为base64格式的数据，存到这个字段中