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");
}
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