createimageblob1.java~1~

Java源码 Java源码

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 INVENTORY" +
        " (INVENTORYID VARCHAR(250) NOT NULL PRIMARY KEY,  "+
        "           NAME VARCHAR(250),"+
        "          IMGBYTES BLOB ,"+
         "          DESCRIPTION VARCHAR(250),"+
          "         PKGINFO VARCHAR(250),"+
           "        IMAGE VARCHAR(250),"+
            "       PRICE REAL,"+
             "      COST REAL,"+
              "     QUANTITY INTEGER,"+
               " CATEGORY INTEGER,"+
                "   NOTES VARCHAR(250),"+
                 "  ISPUBLIC INTEGER,"+
              " HEADING VARCHAR(250))";


    Statement s = con.createStatement();
    s.executeUpdate(createTable);
    String insertSQL = "Insert INTO INVENTORY(INVENTORYID,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, "001");
    pstmt.setString(2, "African Orchid");

    pstmt.setBinaryStream(3, fis, (int) file.length());
    pstmt.executeUpdate();
    pstmt.close();
    s.close();
    con.close();
    fis.close();
    System.out.println("Image Insert Successful");
  }
}