通过java把图片放入Longblob类型的数据库中 运行报错 sql语句乱码

Question

package cn.zd.jdbc;

import java.io.FileInputStream;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**

• 测试BLOB 二进制大对象的基本用法

• @author zdd
  *
  */
  public class Demo10 {
  public static void main(String[] args) {
  Connection conn=null;
  PreparedStatement ps=null;
  //加载驱动类
  try {
  Class.forName("com.mysql.cj.jdbc.Driver");
  //建立连接
  conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mySqlJdbc?serverTimezone=UTC&characterEncoding=gbk", "root", "1314shabizd");
  ps=conn.prepareStatement("insert into mysqljdbc.user(userName,blob) values (?,?)");
  ps.setString(1, "zd");
  ps.setBlob(2, new FileInputStream("g:/a.jpg"));
  ps.execute();

  } catch (ClassNotFoundException e) {
      e.printStackTrace();
  } catch (Exception e) {
      e.printStackTrace();
  }finally {
      try {
          if(ps!=null) {
              ps.close();
          }
      } catch (SQLException e) {
          e.printStackTrace();
      }
      try {
          if(conn!=null) {
              conn.close();
          }
      } catch (SQLException e) {
          e.printStackTrace();
      }
  }
  

  }
  }

Answer 1

https://blog.csdn.net/cngump/article/details/83081200