mysql插入图片数据

来源：互联网发布：java collection遍历编辑：程序博客网时间：2024/05/24 06:23

import java.sql.*;  import java.util.Scanner;import java.io.*;   public class mysql插入图片 {      private static final File File = null; private static String String;      public static  Connection getConn() {          Connection conn = null;          try {              Class.forName("com.mysql.jdbc.Driver");              conn = DriverManager.getConnection(                      "jdbc:mysql://localhost:3306/xinxi", "root", "123456");          } catch (ClassNotFoundException e) {              e.printStackTrace();          } catch (SQLException e) {              e.printStackTrace();          }                 return conn;      }   public static void add( String  fromFileName,  String toFileName) {      Connection conn = getConn();

    String sql = <span style="font-family: simsun;">"insert into  image( id , image)  values(?,?)"</span><span style="font-family: simsun;">;</span>    PreparedStatement ps;      try {          ps = conn.prepareStatement(sql);          ps.setString(1, "tupian");            File file1=new File("D:\\test.jpg");        InputStream in;          in = new BufferedInputStream(new FileInputStream(file1));          ps.setBinaryStream(2, in, (int) file1.length());          int count = 0;          count = ps.executeUpdate();          if(count==1)          {               System.out.println("success");           }else         {              System.out.println("failed");           }          in.close();          ps.close();          conn.close();      } catch (SQLException e) {          e.printStackTrace();      }catch (FileNotFoundException e) {          e.printStackTrace();      } catch (IOException e) {          e.printStackTrace();      }  }

0 0