this is the code for inserting imahe files suing java
servlets import java.lang.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
//public class WriteBlob
public class WriteBlob extends HttpServlet
{
// private static Connection con = null;
private static PreparedStatement ps;
//public static void main(
String[] argv)
public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
{
PrintWriter out=res.getWriter();
res.setContentType("text/html");
try
{
String name=req.getParameter("text1");
String type=req.getParameter("text2");
String file1=req.getParameter("file");
Connection con = null;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con=DriverManager.getConnection("jdbc
racle:thin:@oracle:1521
RCL","scott","tiger");
/*Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc
dbc:img","sa","");*/
//File file =new File("fevicon.ico");
File file =new File(file1);
InputStream is = new FileInputStream(file);
ps =con.prepareStatement("insert into emp_photo VALUES(?,?,?)");
ps.setString(1,name);
ps.setString(2,type);
out.println("name is" +name+"<br>");
out.println("type is" +type);
out.println("pic is" +file1);
out.println("Inserted Succesfully***************..");
ps.setBinaryStream(3,is,Integer.MAX_VALUE);
out.println("Inserted Succesfully..");
ps.execute();
out.println("Inserted Succesfully..");
con.close();
out.println("<a href=http://subra:7001/GetBlob><b>Image</b></a>");
out.println("<br>");
out.println("<a href=http://subra:7001/img.jsp><i>Home</i></a>");
//res.sendRedirect("http://subra:7001/img.jsp");
}
catch (Exception ex)
{
ex.printStackTrace(out);
}
}
}
This is the code for retreving images from database
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class GetBlob extends HttpServlet
{
public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
try
{
res.setContentType("text/plain");
PrintWriter out = res.getWriter();
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con =DriverManager.getConnection("jdbc
racle:thin:@oracle:1521
RCL","scott","tiger");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT picture from emp_photo where empno = 'red' and photo_format='jpg' ");
if(rs.next())
{
InputStream is = rs.getBinaryStream(1);
InputStreamReader isr=new InputStreamReader(is);
BufferedReader bfr = new BufferedReader(isr);
String str=null;
while((str=bfr.readLine())!=null)
{
out.println(str);
}
}
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}