Insert Picture into M.S Access/SQL table using Java

Home	»	Java	»	Advance Java	»	Java Database	»	Insert Picture Into Table

The following is a simple Java program which will insert a picture into M.S. Access/SQL table. For this first of all you need to create a M.S.Access database or SQL... but in this example I'm using M.S.Access. Now you need create one table in M.S Access as shown below:

Table Definitions:

Table Name : Img[InsertPicture.mdb] Primary Key : Nil Foreign Key : Nil Column Definition: Column Name Data Type ID AutoNumber Images OLE Object Table Description: Column Name Description ID Create AutoNumber for image id Image Image type "OLE Object"

After create table in M.S. Access database now you will create DSN.

Following is the source code of the InsertPicture.java

/* =========================================================== File Name : InsertPicture.java WebSite : http://javaproglang.blogspot.in/ Facebook : https://www.facebook.com/AdvanceJavaProgramming Twitter ID : https://twitter.com/AdvanceJava Created By : Bintu Chaudhary =========================================================== */ import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class InsertPicture { public static void main(String[] args) throws Exception, IOException { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url="jdbc:odbc:MyDsn"; Connection conn=DriverManager.getConnection(url); String INSERT_PICTURE = "insert into Img(ID,Image) values (?, ?)"; FileInputStream fis = null; PreparedStatement ps = null; try { conn.setAutoCommit(false); File file = new File("laura.jpg"); fis = new FileInputStream(file); ps = conn.prepareStatement(INSERT_PICTURE); ps.setString(1, "001"); ps.setBinaryStream(2, fis, (int) file.length()); ps.executeUpdate(); conn.commit(); } finally { ps.close(); fis.close(); } } }

Now compile the above code using javac compiler and the run program.

C:\jdk1.4\bin javac InsertPicture.java
C:\jdk1.4\bin java InsertPicture



The above code will insert a "laura.jpg" named picture into img table.


Download Database