inserting multiple file formats into database using html

hi the code was working fine,i want to choose the file and then upload to database,by using html.whether it is possible to upload larger file size,please explain the code with comment line.

View Answers

April 19, 2012 at 3:14 PM

1)page.jsp:

<HTML>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD> 
<BODY> <FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<br><br><br>
<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>
</BODY>
</HTML>

2)upload.jsp:

<%@ page import="java.io.*,java.sql.*" %>
<%
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;
saveFile="C:/UploadedFiles/"+saveFile;
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 by the name of:</b>
<% out.println(saveFile);%></td></tr></table>
<%

Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/test";
ResultSet rs = null;
PreparedStatement psmnt = null;
FileInputStream fis;
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();
if(s>0) {
System.out.println("Uploaded successfully !");
}
else{
System.out.println("unsucessfull to upload file.");
}
}
catch(Exception e){e.printStackTrace();}
}
%>

Advertisements

inserting text into text file using java application
inserting text into text file using java application Hi, I want to insert a text or string into a text file using java application

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

inserting image in mysql database using browse button in servlets
inserting image in mysql database using browse button in servlets Hi,I want to insert a image in mysql database using browse button. and, i want...;TITLE>Display file upload form to the user</TITLE></HEAD> <

inserting image into database
inserting image into database how to insert image into database using struts frame work and spring JDBC

fetch and insert multiple rows into mysql database using jsp servlet
fetch and insert multiple rows into mysql database using jsp servlet �... jsp form and want inserting it into my mysql database table. but i am having a problem to insert multiple rows into database using a single insert query

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

HTML code to servlet to database using jdbc
HTML code to servlet to database using jdbc pls send me the code related to the title Hi Friend, Try the following code:ADS... { String msg=req.getParameter("msg"); res.setContentType("text/html

Merge multiple jasper file to one word Doc using java
Merge multiple jasper file to one word Doc using java how to Merge multiple jasper file to one word Doc using java

how to insert data in database using html+jsp
how to insert data in database using html+jsp anyone know what... and database name. Here machine name id localhost and database name..."; // declare a connection by using Connection interface

display multiple image file or pdf file in multiple column of a row from server or database
display multiple image file or pdf file in multiple column of a row from server or database hello sir I have uploaded the file to the server and I want to display that file to the user page but I want to display that file

inserting dropdown values into database table
inserting dropdown values into database table hi i want to insert dropdown values into a database table by using jsp

Unable to upload a file to mysql database using struts1
Unable to upload a file to mysql database using struts1 Hi, Below are my classes 1.upload.jsp <%@ taglib uri="/tags/struts-html" prefix="html...="multipart/form-data"> Select a File :<html:file property="file"/> <

save multiple records into database using jsp/servlet mvc
save multiple records into database using jsp/servlet mvc hai, this is my jsp where i have enter multiple username and password and save it to database in single hit user.jsp <form action="UserServlet" method="post

HOW TO STORE MULTIPLE EMPLOYEE DETAILS TO XML FILE USING JSP?
HOW TO STORE MULTIPLE EMPLOYEE DETAILS TO XML FILE USING JSP? HELLO SIR, CAN ANYONE HELP ME OUT HOW TO STORE MULTIPLE EMPLOYEE DETAILS TO XML... HELP ME OUT WITH HOW TO VIEW THE STORED DATA IN XML FILE USING EMPNAME. PLEASE

Inserting data from the HTML page to the database
Inserting data from the HTML page to the database... have got from the html will be set in the database by using the setString... program in which we are going to insert the values in the database table from

inserting all the values in a html table column
inserting all the values in a html table column strong text hai everyone, i'm a fresher to servlet i need to know that, how can i insert all the values in a html table column into a database. Thanks in advance

How to export data from html file to excel sheet by using java
How to export data from html file to excel sheet by using java reading the data from Html file

How to export data from html file to excel sheet by using java
How to export data from html file to excel sheet by using java How to export data from html file to excel sheet by using java

how to convert doc file into html using java swing
how to convert doc file into html using java swing i want to convert doc file into html and display it on jtextarea please help me and give the sample code

How I Upload File and Store that file name in Database using JSP
How I Upload File and Store that file name 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

How to store multiple images in folder and images path in database at a time using jsp?
How to store multiple images in folder and images path in database at a time using jsp? I wanna browse multiple images in one form and store them in one folder and their path into datrabase

MySql Databse query to fetch results from database and display it in HTML File
MySql Databse query to fetch results from database and display it in HTML File Hi. I have a field in database named stages. its datatype is varchar... as one value. and i have to show it in html. how to do

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

how insert multiple images in mysql database with use of struts 1.3.8 or java method, with single bean,or using array
how insert multiple images in mysql database with use of struts 1.3.8 or java method, with single bean,or using array i am using netbeans 7.0 ,with struts 1.3.8 and i want to insert multiple images in mysql database ,with use

Handling multiple buttons in HTML Form
Handling multiple buttons in HTML Form How to handle Handling multiple buttons in HTML Form

how to store multiple values from drop down in database where i am using java struts 1.3
how to store multiple values from drop down in database where i am using java... where i have to select multiple keyskills. but it is taking only one valuee.. i... is displaying.. i need code in java so that it takes multiple values

Insert Image into Database Using Servlet
Insert Image into Database Using Servlet �... image into database table using Servlet. This type of program is useful in social... the image from database using Servlet. After retrieving the image from database

Insert Image into Database Using Servlet
of inserting image into database table using Servlet. This type of program is useful... Insert Image into Database Using Servlet �... to retrieve the image from database using Servlet. After retrieving the image from

Inserting id in place of name to database
Inserting id in place of name to database Hello, I have a database department where I have "id" and "name". I am fetching this data to a jsp form in dropdown list displaying "name" there and Now I wanted to insert data from

How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server

delete multiple row using checkbox
delete multiple row using checkbox how to delete multiple row in a table which is connected to database using checkbox

How to insert multiple checkboxes into Msaccess database J2EE using prepared statement - Java Beginners
How to insert multiple checkboxes into Msaccess database J2EE using prepared... with me the solutions. In my html form which has a post, I have the following... for different subjects, you can insert the multiple subjects in one column

Inserting Data In Database table using Statement
Inserting Data In Database table using Statement... to insert the data in the database from our java program in the table stored in the database. To accomplish our goal we first have to make a class named

TO connect multiple database
TO connect multiple database How to connect several database from a single application in java depending upon the user input it will connect to that database

how to save html form data into .csv file using only jsp.
how to save html form data into .csv file using only jsp. Dear all, I am developing a website only using jsp and html. i need to save the form data into a .csv file using jsp. can anyone give me any sample solution or tutorial

How to browse excel file and stored the contents into the database using jsp/servlet?
How to browse excel file and stored the contents into the database using jsp/servlet? Hi.. I want to browse excel file and stored the file data into the My-sql database using jsp/servlet

inserting an path of an image in database - JDBC
inserting an path of an image in database hello kindly help related... an image using web cam.... and when the image is saved in a project at the same time its full path should be inserted in the database(MS Sql 2000).. I m able

how to retrieve image from mysql database using java and show it in HTML img tag ?
how to retrieve image from mysql database using java and show it in HTML img tag ? how to retrieve image from mysql database using java and show it in HTML img tag

Read data from excel file and update database using jsp
Read data from excel file and update database using jsp read data from excel file and update database using jsp Hi, I am using a MySQL database... upload excel file and update database using JSP ? Thanks in Advance

How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can

Inserting data on a database in servlet - JSP-Servlet
Inserting data on a database in servlet Hi I am following... to a databse by a servlet.I used the example in "Inserting Data In Database table... of a table,that is none of the data which i tried to enter into database by using

Database and HTML
Database and HTML How to retrieve data from database and add them to web page as options

Data needs to be gathered in XML file from the database (MySql) using JSP
Data needs to be gathered in XML file from the database (MySql) using JSP�... in XML file from the database (MySql) using appropriate JSP/Java Bean functions... files. using following database create database music; use music; CREATE

Data is not inserting correctly in mysql database.
Data is not inserting correctly in mysql database. Hello Sir, below is my code to insert data into database by list iteration through for loop but it is not getting inserted ..it is taking only one value

urgent help for inserting database in a project
urgent help for inserting database in a project I need some urgent... and then the result at the end.I need to add simple database connectivity... cannot be connected using PS/2 port\n", "Question 11:\nWhat is Google's URL

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

how to insert multiple columns of a single row into my sql database using jsp
how to insert multiple columns of a single row into my sql database using jsp hi sir, how to insert multiple columns of a single row into my sql database using jsp. when i click ADD ROW,rows are added.when i click submit

Ads