Hi all my Friends I have below code which insert a picture into M.S. Access Database But i m still not able to open this picture through Java using M.S. Access and i wants to open this Picture On Web Browser using Java Servlet anybody can help me....?
//Code for Insert Picture into M.S.Access using Java 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("bintu.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(); } }
}
Ads