Tuesday, 14 February 2012

After long days of searching and coding i have finally been able to upload Blob or binary data into my database
so i thought i might help others who might be stuck like i was...
here is the code..


<%@ page import="java.sql.*,java.io.*,java.util.*,com.oreilly.servlet.MultipartRequest;"%>
<%@page import="java.text.*" %>


try
{
MultipartRequest multi= new MultipartRequest(request,".",20*1024*1024);
Enumeration files=multi.getFileNames();
File f=null;
while(files.hasMoreElements())
{
String name=(String)files.nextElement();
filename=multi.getFilesystemName(name);
f=multi.getFile(name);
System.out.println("The File is "+f);

Class.forName("oracle.jdbc.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","arjun","arjun");

PreparedStatement pre=null;
InputStream is = new FileInputStream(f);
byte b[]=new byte[is.available()];
is.read(b);
String sql = "INSERT into binary_files (id,name,doc) values(?,?,?)";
 pre = con.prepareStatement(sql);
 pre.setInt(1,1);
 pre.setString(2,filename);
 pre.setBytes(3,b);
pre.executeUpdate();
}
}
catch(Exception e)
{
System.out.println(e);
}
finally{
out.println("The Data is Added into Database");
    }

No comments:

Post a Comment