saveimage.java

来自「书籍源程序《J2EE应用开发（WebLogic+JBuilder）》代码」· Java 代码 · 共 34 行

package imagefile;
import java.sql.*;
import java.util.*;
import java.io.*;

public class SaveImage {
  public static void main(String[] args) {
   String filename="c:\\imagefile.jpg";
    Properties props = new Properties();
    props.put("user",     "scott");
    props.put("password", "tiger");
    props.put("server",   "myoracle");

    try{
      Driver myDriver = (Driver)
              Class.forName("weblogic.jdbc.oci.Driver").newInstance();
      Connection con = myDriver.connect("jdbc:weblogic:oracle" , props);

 con.setAutoCommit(false);
 File files = new File(filename);
 FileInputStream fis=new FileInputStream(files);
 PreparedStatement ps = con.prepareStatement(
         "INSERT INTO filetable (filename,filedata)" +
            "VALUES (?, ?)");
  ps.setString(1, files.getName());
  ps.setBinaryStream(2, fis,(int)files.length());
  ps.executeUpdate();
  fis.close();
  ps.close();
  con.close();
  System.out.println("file is saved into filetable");
    }catch(Exception e){e.printStackTrace();}
  }
}