createimageblob1.java~4~

来自「Java 集成开发实例精解」· JAVA~4~ 代码 · 共 37 行

package cmp2image;

import java.sql.*;
import java.io.*;

public class CreateImageBlob1 {
  public static void main(String[] args) throws Exception {
    String dbUrl = "jdbc:mysql://127.0.0.1/mydb1";
    String user = "";
    String password = "";
    // Load the driver
    Class.forName("com.mysql.jdbc.Driver");
    //connecting the databse
    Connection con = DriverManager.getConnection(
        dbUrl, user, password);
    String createTable = "CREATE TABLE Flower" +
        " (Name VARCHAR(250) NOT NULL PRIMARY KEY,  "+
        "          IMGBYTES BLOB )";
    Statement s = con.createStatement();
    s.executeUpdate(createTable);
    String insertSQL = "Insert INTO Flower(Name,IMGBYTES) "+
       "  VALUES(?,?,)";
    PreparedStatement pstmt = con.prepareStatement(insertSQL);
    System.out.println("Connection OK");
    File file = new File("D:\\WebDesignCodes\\MyPlants\\images\\FlowerAfricanOrchid.jpg");
    FileInputStream fis = new FileInputStream(file);
    pstmt.setString(1, "AfricanOrchid");
    pstmt.setBinaryStream(2, fis, (int) file.length());
    pstmt.executeUpdate();
    pstmt.close();
    s.close();
    con.close();
    fis.close();
    System.out.println("Image Insert Successful");
  }
}