Add a file into database

Provide the code to upload a file into oracle database?

View Answers

April 27, 2012 at 1:36 PM

1)page.jsp

<%@ page language="java" %>
<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="2" >
<tr><center><td colspan="2"><p align="center"><B>UPLOAD THE FILE</B><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">
<p align="right"><INPUT TYPE="submit" VALUE="Send File" ></p></td></tr>
<table>
</center>
</FORM>
</BODY>
</HTML>

2)upload.jsp

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

<%
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);
String saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1,saveFile.indexOf("\""));
out.println(saveFile);
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;

FileOutputStream fileOut = new FileOutputStream(saveFile);
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://192.168.10.112:3306/file";
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

add record to database - JDBC
add record to database How to create program in java that can save record in database ? Hi friend, import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class

uploading a text file into a database
uploading a text file into a database how to upload a text file into a database using jchooser import java.io.*; import java.sql.... { static File file; public static void main(String[] args) throws Exception

Displaying file from database
Displaying file from database I have list of files in my database. I... that corresponding file from database. I have list of file id related to search. I want to retrieve and display all the file using list of file ID. Is there is any other way

How to convert XML file to database ?
How to convert XML file to database ? How to convert XML file to database

how to add a file in GZIP
how to add a file in GZIP Hi, how to add a file in GZIP using Java. Hi, I have found a good referral site for How to Add a file in GZIP file format using Java. http://www.roseindia.net/java/examples/io

inserting multiple file formats into database
inserting multiple file formats into database hi i want to insert multiple file format like .pdf.doc.zip into mysql database using jsp

To insert attachment file in database in JSP.
To insert attachment file in database in JSP. I am doing project in JSP. How to insert attachment file in mysql database? Please suggest some solution. Your inputs is valuable to me. Hi Friend, Visit HereADS

write excel file into the oracle database
write excel file into the oracle database dear sir, i need the jsp code that reads the excel file and stores it into the oracle database table..and also i need the code to connect oracle database? thank u in advance

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

Java save file to database
Java save file to database In this section, you will learn how to insert file... between MySql database and java file with the help of various types of APIs... code, you can insert any file into the database

how to add database in Java Applet
how to add database in Java Applet hi every java master or Java... to add database in Java Applet below this code is my applet source code . thank... to Rental Car System"); lab.setBounds(100,20,200,20); add(lab); label1 = new

To insert attachment file in database in JSP.
To insert attachment file in database in JSP. I am doing project in JSP. How to insert attachment file in mysql database? Please suggest some... file upload form to the user</TITLE></HEAD> <BODY> <FORM

Explain the relationship among database, tablespace and data file.
the size of the database to store more data we have to add data file. Thanks...Explain the relationship among database, tablespace and data file. Explain the relationship among database, tablespace and data file. Hi

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

add plist file iphone sdk
add plist file iphone sdk how to add plist file in XCode

converting an xml file in relational database objects
converting an xml file in relational database objects converting an xml file in relational database objects

Add a jsp file to java application
Add a jsp file to java application How to add a JSP file to java... a file,having any application,code or any content..</h2><br/> <%@include file="success.jsp" %><br/> <h2>Here You are including a Jsp

Insert file data into database
Insert file data into database In this section, you will learn how to insert the file data into database. Description of code: Here we have used FileReader and BufferedReader class to read the file. The data of the file is then stored

Uploading a Profile with image[file] into a sql database
Uploading a Profile with image[file] into a sql database I need to upload a file along with the some text into a database ......[ Similar to http... , but upload file to database ] ... Pls help

data insertion from xml file to database table
data insertion from xml file to database table Hi all, I have data in the XML file. I need to insert it into table in the database using servlet. so please reply me . ThankYou

How to Delete a column and Add a new column to database
How to Delete a column and Add a new column to database How to Delete a column and Add a new column to database Hi, The following query is executed for add and delete a column in a table-ADS_TO_REPLACE_1 for drop

inserting multiple file formats into database using html
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

Question about "Insert text file data into Database"
Question about "Insert text file data into Database" Hey I was reading the tutorial "Insert text file data into Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader

insert rows from browsed file to sql database
insert rows from browsed file to sql database i need to insert rows from excel to database by browsing the file in jsp. by connecting both..., content of the file has to go to database. how can i insert record into database

Servlet to add the data into database
Servlet to add the data into database �...; <description> Servlet to add the data into database <... the data in the database table from a html form. This servlet program

Import Excel file(date) into mysql database in php
Import Excel file(date) into mysql database in php I try to import excel file which contains data date(yyyy-mm-dd) into mysql database in php...(); //connect to the database $connect = mysql_connect("localhost","root",""); mysql

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

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. The max size of the file can be 1mb. Along with the file name, there are other 2

insert values from excel file into database
file that should go to database which exists. am using SQL Server management... the following link: Insert values from excel file to database...insert values from excel file into database hi i want to insert

Insert database values in the file
Insert database values in the file In this section, you will learn how to retrieve the data from the database and insert into the file. Description of code... retrieve the values from the database and store them into the file

downloading file through a file's path stored in database in jsp
downloading file through a file's path stored in database in jsp hi want to download a file from a directory where the file location is stored in a database,i have done the coding for retrieving the path from database to a html

Shifting txt file to database - Java Beginners
Shifting txt file to database Question Details: I want to shift data from txt file to Database. The data is written in the following text format... and put into database using Java/JSP. Database table is as below ID numeric

php csv file uploding into mysql database table.
php csv file uploding into mysql database table. hai friends, i... fields. i have one mysql database table with two files fields, when ever i am uploding csv file, i want to fetch the datas in corresponding fields in table. can

JSP to add details to a database from a HTML form.
JSP to add details to a database from a HTML form. Hi I'm a second year CS student who has to use JSP to validate a HTML form and add the details entered into a database. The files are all in one folder for use in tomcat

How to create a jar file with database connection
How to create a jar file with database connection Hello Everyone!!! Pls Help me in this... i have a program which has a database connection with ms access & i want to create a jar file of it... I have tried with manifest

Storing records of a file inside database table in java
Storing records of a file inside database table in java Here is my requirement, I have a file which contains some number of records like... the records inside the database except headings (Here sid,sname,age are headings

use properties file to connect to the database in jsp..
use properties file to connect to the database in jsp.. How to use properties file to connect jsp code with database .......... Here is a jsp code that connects to database using properties file. <%@page import

Unable to upload a file to mysql database using struts1
Unable to upload a file to mysql database using struts1 Hi, Below...="multipart/form-data"> Select a File :<html:file property="file"/> <... extends ActionForm{ private FormFile file; public FormFile getFile(){ return

how to display data from jsp file into database
how to display data from jsp file into database this is a jsp file . look at the line with code-> Statement st=con.createStatement...+",'"+email+"')"); out.println("Data is successfully inserted into database

jsp page to add users to mysql database
jsp page to add users to mysql database <%@taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@taglib uri="/WEB-INF/struts-bean.tld...-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Add

jsp page to add the user to mysql database
jsp page to add the user to mysql database adduser.jsp: <%@taglib uri="/WEB-INF/struts-html.tld" prefix="html" %> <%@taglib uri="/WEB-INF...;title>Add User</title> </head> <form name="user" action

How to add a file in GZIP file format in Java programme.
How to add a file in GZIP file format in Java programme. Hi please help me. How to add a file GZIP File format in Java program. If example..., This is the example and suggest link that will help you related to how to add the file

upload file to server and store recode in database
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

How to add Apache Commons IO in pom.xml file?
How to add Apache Commons IO in pom.xml file? Hi, How to add the dependency of the Apache Commons IO library in the pom.xml file in a Java project? My Project is using the maven for dependency management and compilation

code save word file in 10g database - SQL
code save word file in 10g database I am not having any idea to save...(false); File file = new File(fileName); fis = new FileInputStream(file); pstmt = conn.prepareStatement("insert into file( file, file_data

storing records which of a file into a table of mssql database
storing records which of a file into a table of mssql database I have a requirement like this, A file contains some records with headers same as column names of a table. I have to store those records into a table

a problem during add jar file javax.annotation.Resource
a problem during add jar file javax.annotation.Resource when i use this jar file in my application i got this problem pls tell me about it Access restriction: The type Resource is not accessible due to restriction on required

Ads