Hi friend,


Insert image code

<%@ page language="java" import="java.sql.*,java.util.*,java.io.*,java.awt.image.BufferedImage,java.io.ByteArrayOutputStream,java.io.InputStream,java.text.*" %>

<%

Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver ="com.mysql.jdbc.Driver";
String userName ="amar" ;
String password ="amar123" ;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
PreparedStatement pst = con.prepareStatement("insert into Image values(?,?,?)");
File file = new File("/home/vinod/Desktop/apache-tomcat-6.0.1/webapps/examples/jsp/javabook.gif");
FileInputStream fis = new FileInputStream(file);
pst.setInt(1, 7);
pst.setString(2, "kumar");
pst.setBinaryStream(3,fis,fis.available());
int i = pst.executeUpdate();
if(i!=0){
out.println("image has been inserted");
}
else{
out.println("image is not inserted");
}
}
catch (Exception e){
System.out.println(e);
}

%>

retrive image from database code in jsp.

<%@ page language="java" session="true"
import= "
java.awt.image.BufferedImage,java.io.ByteArrayOutputStream,java.io.InputStream,java.sql.Blob,java.sql.Connection,
java.sql.ResultSet,javax.swing.ImageIcon,java.sql.*" %>

<%
try
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(ClassNotFoundException e)
{ System.out.println(e);
}
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String userName ="amar" ;
String password ="amar123" ;
Connection con;
con = DriverManager.getConnection(url+db,userName,password);
String query = "SELECT image from Image where id = 7";
out.println(query);
ResultSet rs = con.createStatement().executeQuery(query);
if(rs.next()) {
byte[] bytearray = new byte[4096];
int size=0;
InputStream image;
image = rs.getBinaryStream(1);
response.reset();
response.setContentType("image/gif");
while((size=image.read(bytearray))!= -1 ){
response.getOutputStream().write(bytearray,0,size);
}
response.flushBuffer();
image.close();
rs.close();
}
}
catch (Exception exc)
{ System.out.println(exc);
}

%>
---------------------------------------------

Read for more information.

http://www.roseindia.net/jsp/

Thanks.