upload file to server and store recode in database

i want to upload a file into the server and store a recode in mysql database.any one know the code for this?

View Answers

June 25, 2011 at 2:40 PM

1)page.jsp:

<%@ page language="java" %>
<HTML>
<FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<center>
<table border="0" bgcolor=#ccFDDEE>
<tr>
<center><td colspan="2" align="center"><B>UPLOAD THE FILE</B><center></td>
</tr>
<tr><td colspan="2" align="center">�</td></tr>
<tr><td><b>Choose the file To Upload:</b></td>
<td><INPUT NAME="file" TYPE="file"></td>
</tr>
<tr><td colspan="2" align="center">�</td></tr>
<tr><td colspan="2" align="center"><input type="submit" value="Send File"> </td></tr>
<table>
</center>
</FORM>
</HTML>

2)upload.jsp:

<%@ page import="java.io.*,java.sql.*,java.util.zip.*" %>
<%
String saveFile="";
String contentType = request.getContentType();
if((contentType != null)&&(contentType.indexOf("multipart/form-data") >= 0)){
DataInputStream in = new DataInputStream(request.getInputStream());
int formDataLength = request.getContentLength();
byte dataBytes[] = new byte[formDataLength];
int byteRead = 0;
int totalBytesRead = 0;
while(totalBytesRead < formDataLength){
byteRead = in.read(dataBytes, totalBytesRead,formDataLength);
totalBytesRead += byteRead;
}
String file = new String(dataBytes);
saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
int lastIndex = contentType.lastIndexOf("=");
String boundary = contentType.substring(lastIndex + 1,contentType.length());
int pos;
pos = file.indexOf("filename=\"");
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
pos = file.indexOf("\n", pos) + 1;
int boundaryLocation = file.indexOf(boundary, pos) - 4;
int startPos = ((file.substring(0, pos)).getBytes()).length;
int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
File ff = new File(saveFile);
FileOutputStream fileOut = new FileOutputStream(ff);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
fileOut.close();
%><br><table border="2"><tr><td><b>You have successfully upload the file:</b>
<%out.println(saveFile);%></td></tr></table>
<%
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/test";
PreparedStatement psmnt = null;
FileInputStream fis;
InputStream sImage;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
File f = new File(saveFile);
psmnt = connection.prepareStatement("insert into file(file_data) values(?)");
fis = new FileInputStream(f);
psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
int s = psmnt.executeUpdate();
}
catch(Exception e){
    e.printStackTrace();
}
}
%>

Advertisements

jsp upload file to server
jsp upload file to server How to create and upload file to server in JSP? Find the given example that explains how to upload single and multiple file on server using JSP

Store XML file into Sqlserver Database
Store XML file into Sqlserver Database Code for storing a typical XML file into SQl server database in 1 or more tables using asp.net using C

how to store image upload path to mssql database
how to store image upload path to mssql database hi there!!, i need help in storing the image upload path into the database. basically i just use file select to upload the image from jsp to database. however when i click submit

How to upload file on FTP Server
How to upload file on FTP Server In my application there is a requirement of uploading the file on FTP server. How to upload file on FTP Server... is good and can be used in Java applications. Read FTP File Upload in Java for more

Store XML file into Sqlserver Database
Store XML file into Sqlserver Database Code for storing a typical XML file into SQl server database in 1 or more tables using asp.net using C#. <?xml version="1.0" ?> <!DOCTYPE PubmedArticleSet (View Source

file upload and insert name into database - JSP-Servlet
file upload and insert name into database Hi, I just joined as a fresher and was given task to upload a file and insert its name into database... HIread for more information,http://www.roseindia.net/jsp/file_upload

store dropdown box values in database server
store dropdown box values in database server how to store dropdown box values in database server in jsp

image file upload to a web server
Tomcat 5 server. How can I upload a file to the web server? Here...image file upload to a web server Refer roseindia post http... and upload it on the server. 1)page.jsp: <%@ page language="java" %> <

How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail form

Unable to upload a file to mysql database using struts1
Unable to upload a file to mysql database using struts1 Hi, Below..." %> <html:html> <body> <html:form action="upload" enctype="multipart/form-data"> Select a File :<html:file property="file"/> <

Excel File data upload into postgresql database in struts 1.x
Excel File data upload into postgresql database in struts 1.x Dear members please explain how Excel Files data upload into postgresql database in struts 1.x

how to upload multiple files in jsp and saving the path in database and the file in folder
how to upload multiple files in jsp and saving the path in database and the file in folder how to upload multiple files in jsp and saving the path in database and the file in folder I have created a form for the upload of files

To Upload and insert the CSV file into Database
To Upload and insert the CSV file into Database... to upload a CSV file through JSP and insert it into the database. For this, we have... on upload_page.jsp. Before proceeding further, we need table in database. We created

upload file and insert other details to database using a single form
upload file and insert other details to database using a single form hi.. I have problem with uploading a file and insert other user datas together which I retrieved from another jsp/html page. Here i was able to upload file

File Upload
File Upload when i execute the image upload to mysql database it shows an exception that file path cannot be found

Upload and insert the file contents - Java Server Faces Questions
Upload and insert the file contents I want to browse and upload 2 files on server and insert the values into table from JSP page. So i have...,M I want to browse and upload two or more files into database. the sample

upload a file into database and progrm should support excel and text and csv file formats
upload a file into database and progrm should support excel and text and csv file formats Hai all, I need a program to upload a file into database table... and the program should support .excel ,.txt ,.csv file formats. can

How to Upload a file directly to Oracle database using JSP or Servlets?
How to Upload a file directly to Oracle database using JSP or Servlets? Hi I want to upload a file(csv or excel) to Oracle 10g Database using JSP...;Upload File to Oracle Database</h2> <form id="form1" enctype

How to upload zip file from android to server programmatically?????
How to upload zip file from android to server programmatically????? hi , I want to upload zip file from android phone sdcard to server programmatically. So any one do this task in past so please share your experience with me

upload to database - JSP-Servlet
to upload a pdf file into database(sqlserver2000) using jsp. In roseindia some examples i seen that is only for uploading into the server but i need the uploaded file into database whenever i want that uploaded pdf file i have to retrieve

File upload in JSP
File upload in JSP hi! In my previous interview i got two questions which i could not answer regarding file upload and annotations. I want to know which is the best method can be used for file upload. Whether moving them

Upload file on server automatically on specific time - JSP-Servlet
Upload file on server automatically on specific time Hi all, Is there any way to upload file on server on specific time automatically using java... only to upload a file? If java application running, which will be the best

how to store image file and videofile in ms access database using java? - JDBC
how to store image file and videofile in ms access database using java? how to store image file and video file in ms access database using java

image upload and stored in database - JSP-Servlet
image upload and stored in database How can i upload a image and store that image in a database

Upload file with ather Fieldn
Upload file with ather Fieldn hello i want upload file with other record to database for my project,like that (FileID, Filename,Filedescrption,Filedate,file_upload) see( upload file with path) i can send data to database

How can store image in server folder when deployed with a .war file?
How can store image in server folder when deployed with a .war file? Hi all; When I am using application.getRealPath() , it return null when deployed with a .war file and when I use hard code it shows syntax error or path

File Upload and Retrive files
File Upload and Retrive files Can any body help me am getting an error in uploading file. into mysql database.... thank's in advance

File Upload
File Upload Hi I need script / string in PHP where I uploaded the file in html frontend and it should sent the uploaded file as attachment to my email address

file upload
file upload how to recieve the uploaded file on the next jsp page for modification if its uploaded to the previous page using a from

file upload using spring - Spring
file upload using spring How to upload a file in server using spring framework

File Upload in Struts.
File Upload in Struts. How to do File Upload in Struts

file upload plugin in jquery
file upload plugin in jquery file upload plugin in jquery You can use the following code to use the JQuery plugin. $(document).ready...", onComplete: function(response){ alert( "server response

FTP Server : Upload file
This tutorial contains description of file uploading to the FTP server using java

Java upload file to ftp
Java upload file to ftp Hi, How to uploaded file to a ftp server.... View complete example at FTP File Upload in Java Thanks... that uploads files on FTP server. You have to use the Apache FTP client library

upload image to database
upload image to database i am try to upload image to MySql database using netbeans. when jsp execute it return no error. but also data does inserted in database. i am using blob datatype and preopared statement

upload and save the file
upload and save the file upload and save a file from a computer to specific location of remote computer using jsp

How to store image into database
How to store image into database Hi, all I want to store image into database using Java. Can anyone help me that how can i store image into database using Java. Thanks in advance. hi friend, To store image

upload a file - Framework
upload a file Hi to All, I need to upload a file from the client and that upload file should be sent to our co., mail please if any one provide.... Thankyou in Advance. Hi friend, For upload a file in JSP visit

Upload file to MS Access
Upload file to MS Access Iam beginner and need to upload file to msaccess using jsp . Iam using netbeans platform. Kindly explain do I need to mention Attachment format in the table

image store in database - JDBC
to store image into database. Check at http://www.roseindia.net/servlets/insert...image store in database Dear Deepak Sir, If I want to store image into the database what is the process to do that? Please explain

servlet file upload
servlet file upload please tell me the complete code to upload a file on localhost using servlet

Struts upload file - Framework
Struts upload file Hi, I have upload a file from struts... and send to file upload struts..how to get the sheets and data in that sheets Thanks. Hi friend, For upload a file in struts visit to : http

AJAX file upload
AJAX file upload If you want to upload file asynchronously means without... Description You need to create a form with file fields you wish to upload... and browse button for seeking file in local directory to upload file using

Upload csv or .xlsx file from JSP form to Database Table using servlet
Upload csv or .xlsx file from JSP form to Database Table using servlet dear sir, i need the Servlet code that reads the .xlsx or CSV excel file and stores it into the oracle database table. Sir Its very Urgent I have

Ads