تخزين الصورة من صفحة JSP الي قاعده بيانات

احمد الجابري كتب:

اليك هذا الكود مع تغيير ما يلزم

الملف الاول fileupload.html

<form method="post" ACTION="fileupload.jsp" name="upform" ENCTYPE='multipart/form-data'>
<input type="file" name="uploadfile">
<p>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
<input type="hidden" name="action" value="upload">
</form>

الملف الثاني fileupload.jsp

<%@ page import="java.sql.*,java.io.*,java.util.*;"%>
<%

/* The Following Code is Used To Insert An Image Into Database 

String filename="";
try
{
MultipartRequest multi= new MultipartRequest(request,"d:/phani",5*1024*1024);
Enumeration files=multi.getFileNames();
File f=null;
while(files.hasMoreElements())
{
String name=(String)files.nextElement();
filename=multi.getFilesystemName(name);
String type=multi.getContentType(name);
f=multi.getFile(name);
System.out.println("The File is "+f);
}
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@hostname:1521:orcl", "scott", "tiger");
Statement stmt = con.createStatement();
System.out.println("2 "+f);
InputStream is = new FileInputStream(f);
System.out.println("4 "+is);
byte b[]=new byte[is.available()];
is.read(b);
String sql = "INSERT into photo_test (\"Photo\") values('" + b + "')";
System.out.println("sql is " +sql);
stmt.execute(sql);
stmt.close();

}catch(Exception e)
{
System.out.println(e);
}
out.println("The Image is Added into Database");

بالتوفيق .

أصل الموضوع : http://www.araboug.org/ib/index.php?showto...4&hl=upload