insert data
i've got a problem to insert my data to database.i can upload my multipart file but not text data.Please help me to solve this .Attached herewith my source code..
a)index.jsp
<%@ page import="java.util.Date,java.text.DateFormat,java.text.SimpleDateFormat"%>
<%
DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
Date date = new Date();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Page Insert</title>
</head>
<body>
<form action="formpost.jsp" method="post" ENCTYPE="multipart/form-data" >
<table width="361" border="2" align="center">
<tr>
<th scope="row">TRANSACTION</th>
<td><input type="text" name="transaction" readonly="true" value="<%=dateFormat.format(date)%>">
</tr>
<tr>
<th scope="row">VALID START </th>
<td><select name="start" size="1" >
<option>equal</option>
<option>before</option>
<option>after</option>
<option>meet</option>
<option>met_by</option>
</select>
<input type="text" name="textfield" size="15">
</tr>
<tr>
<th scope="row">VALID END </th>
<td><select name="end" size="1" id="end">
<option>equal</option>
<option>before</option>
<option>after</option>
<option>meet</option>
<option>met_by</option>
</select>
<input type="text" name="textfieldd" size="15">
</tr>
<tr>
<th> UPLOAD FILE </th>
<td><input type="file" name="file"></td>
</tr>
</table>
<p align="center">
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Reset" value="Reset">
</p>
</form>
</body>
</html>
b)formpost.jsp
<%@page import="java.text.*,java.io.*,java.sql.*" %>
<% //obtain parameter from the client
String transaction=request.getParameter("transaction");
String start=request.getParameter("start");
String textfield=request.getParameter("textfield");
String end=request.getParameter("end");
String textfieldd=request.getParameter("textfieldd");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/test",
"root", "daisy");
PreparedStatement st =
con.prepareStatement("insert into images values(?,?,?,?,?)");
st.setString(2, transaction);
st.setString(3, start);
st.setString(4, textfield);
st.setString(5, end);
st.setString(6, textfieldd);
st.executeUpdate();
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
<% //to get the content type information from JSP Request Header
String contentType = request.getContentType();
//here we are checking the content type is not equal to Null and as well as the passed data from mulitpart/form-data is greater than or equal to 0
if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
DataInputStream in = new DataInputStream(request.getInputStream());
//we are taking the length of Content type data
int formDataLength = request.getContentLength();
byte dataBytes[] = new byte[formDataLength];
int byteRead = 0;
int totalBytesRead = 0;
//this loop converting the uploaded file into byte code
while (totalBytesRead < formDataLength) {
byteRead = in.read(dataBytes, totalBytesRead, formDataLength);
totalBytesRead += byteRead;
}
String file = new String(dataBytes);
//for saving the file name
String 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;
//extracting the index of file
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;
// creating a new file with the same name and writing the content in new file
String folder = "C:/Program Files/Apache Software Foundation/Apache Tomcat 6.0.20/webapps/ROOT/upload/web/";
FileOutputStream fileOut = new FileOutputStream(folder+saveFile);
//out.print("Saved here: " + saveFile);
//fileOut.write(dataBytes);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
fileOut.close();
}
%>
c)table created as below:-
(
id INT not null primary key,
transaction VARCHAR(15),
startoperator VARCHAR(15),
startvalid VARCHAR(15),
endoperator VARCHAR(15),
endvalid VARCHAR(15)
)
View Answers
Related Tutorials/Questions & Answers:
insert datainsert data i've got a problem to
insert my
data to database.i can...("
insert into images values(?,?,?,?,?)"); st.setString(2... and as well as the passed
data from mulitpart/form-
data is greater than or equal to 0
Advertisements
insert and delete data in databaseinsert and delete
data in database
insert and delete
data in database from servlets through JDBC
Hi Friend,
Please visit the following links:ADS_TO_REPLACE_1
Insert Data
Delete
Data
ThanksADS_TO_REPLACE_2
insert data into databaseinsert data into database hi,thanks for reply
just i am doing student information project,frontend is jsp-servlet and backend is msaccess2007. i... the
data into the jsp page that
data stored into the database.Here the error
Insert Data From File Insert Data From File
Insert Data From File is used to
insert data from file... an example to
insert data from file. To understand
this example, we create
How to insert clob data??How to
insert clob
data?? Can any one tell me in details how... to
insert more than 4000 characters.I have heard that clob fields can hold 4 gb of
data and need pl/sql to avail that feature.Can any one tell me how to create
database is connected but not insert the datadatabase is connected but not
insert the data hi,
i am getting connected to database.Retrive the
data also but cannot
insert the
data into database...=con.prepareStatement("
insert into studentmaster(slno) values('"+batch+"')");
i
unable to insert data into database unable to
insert data into database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into database based
unable to insert data into database unable to
insert data into database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into database based
unable to insert data into database unable to
insert data into database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into database based
unable to insert data into database unable to
insert data into database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into database based
insert data into databaseinsert data into database type Exception report
message...)Go to the start->Control Panel->Administrative Tools->
data sources.
2... selecting the driver, click finish button.
4)Then give
Data Source Name
EJB Insert data
.style1 {
color: #FFFFFF;
}
EJB
Insert data... describes you the way to
insert data into the database using EJB. The steps involved in inserting
data are as :-
1)Create an interface named
Insert Data From File Insert Data From File
Insert Data From File is used to
insert data from file... an example to
insert data from file. To understand
this example, we create
To insert maximum number of data in database.To
insert maximum number of
data in database. how to change string
data type into clob
data type in jsp
Hi Friend,
Please visit the following link:ADS_TO_REPLACE_1
http://www.roseindia.net/jdbc/
insert-clob
How to insert data into MySQL Table?How to
insert data into MySQL Table? Hi,
How to
insert the
data...
Hi,
The
insert into query is used to
insert the
data into MySQL...
)
Then we can use the following query to
insert the
data:
insert into email(first_name
FAILED TO INSERT DATA FROM FUNCTION();FAILED TO
INSERT DATA FROM FUNCTION(); HELLO, I HAVE A PROBLEM TO
INSERT DATA FROM OUTPUT FROM FUNCTION()...
I WANT TO STORE THE OUTPUT IN DATABASE, BUT FAILED TO
INSERT...
before
insert and retrive data and time - SQLinsert and retrive
data and time hello everybody .
Is there any method in java so that we can
insert current system time and then it can... default NULL,
PRIMARY KEY (`id`)
)
To
insert current date and time
insert data in the database using checkboxinsert data in the database using checkbox i am fetching
data from... each row but the problem is that i am not fetching
data in any textboxes so how should i
insert only checked
data into database on submission.
We
how to insert data from netbeans into databsehow to
insert data from netbeans into databse how to
insert data from netbeans into databse
Please visit the following link:
http://www.roseindia.net/webservices/web-services-database.shtml
Insert file data into databaseInsert file
data into database
In this section, you will learn how to
insert.... Now to
insert this
data into the database, we have
established a database connection. Then using the
insert query, we have inserted
whole file
data 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 Mysql Blob data Insert Mysql Blob data
In this section, we will discuss about how to
insert a blob
data into a
database table. A Blob stores a binary large... which points to the Blob
data,
data is
not directly stored in the row
insertinsert
insert data in database from servlet through JDBC
Ho Friend,
Please visit the following:ADS_TO_REPLACE_1
Insert data into database
Thanks
Java insert file data to JTableJava
insert file
data to JTable
In this section, you will learn how to
insert text file
data into JTable.
Swing has provide useful and sophisticated set...();
frame.setVisible(true);
}
}
Through the above code, you can
insert the file
data how to insert data into database using jsp & retrivehow to
insert data into database using jsp & retrive Hello,
I have created 1 html page which contain username, password & submit button. in my oracle10G database already contain table name admin which has name, password
how to insert, retrieve data from,to db(code)....how to
insert, retrieve
data from,to db(code).... Hi.....
i ve created login page n in that a registration form also....
my doubt is-when... that
data will b stored in db(m using sybase).
2.also hw to retrieve the
data from
insert excel value in to oracle data baseinsert excel value in to oracle
data base Hi All
I am using... org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class
Insert... = dba.getVIS2Connection();
PreparedStatement stat=con.prepareStatement("
insert into login
EJB Insert data
.style1 {
color: #000000;
}
EJB
Insert data... describes you the way to
insert data into the database using EJB. The steps involved in inserting
data are as :-
1)Create an interface named
how to insert, retrieve data from,to db(code)....how to
insert, retrieve
data from,to db(code).... Hi, i have created... register his details,(for ex,username,password,dob,gender) 1.how that
data will b stored in db(m using sybase).
2.also hw to retrieve the
data from db. cn u
how to insert data in database using html+jsphow to
insert data in database using html+jsp anyone know what... = null;
// declare a resultset that uses as a table for output
data from... table.
String QueryString = "
insert into xxqc_announcement(PID,msg
how to insert data into databasse by using jdbchow to
insert data into databasse by using jdbc â?¢ Create... and
insert those inputs into database using JDBC.
Here is a jsp code... st=con.createStatement();
int i=st.executeUpdate("
insert into student
how to insert data into databasse by using jdbchow to
insert data into databasse by using jdbc â?¢ Create... and
insert those inputs into database using JDBC.
Here is a jsp code... st=con.createStatement();
int i=st.executeUpdate("
insert into student
how to insert data into databasse by using jdbchow to
insert data into databasse by using jdbc â?¢ Create... and
insert those inputs into database using JDBC.
Here is a jsp code... st=con.createStatement();
int i=st.executeUpdate("
insert into student
how to insert data into databasse by using jdbchow to
insert data into databasse by using jdbc â?¢ Create... and
insert those inputs into database using JDBC.
Here is a jsp code... st=con.createStatement();
int i=st.executeUpdate("
insert into student
insert data into mysql databse using swinginsert data into mysql databse using swing
Blockquote
hi,
here is my code,
i want code for store
data into mysql database when click on submit button from access
data from this form,
please provide code,
import java.awt.
Insert XML file data to databaseInsert XML file
data to database
In this tutorial, you will learn how to
insert the xml file
data to database
using dom parser.
You all are aware of XML file, it is a tag based language. You can easily
transfer and store its
data Insert text file data into DatabaseInsert text file
data into Database
In this section, you will learn how to
insert the text file
data into the database. For this purpose, we have created... the
data to the ArrayList.
This list is then iterated through the Iterator
can i use trigger to insert data within a time period ?can i use trigger to
insert data within a time period ? Hello sir,
i want to calculate company's closing account each Saturday 12.00. In this case i... this trigger concept the
data will be
insert to each Employee's ID.
Plz sir help me
The INSERT INTO Statement of
data into the table.
To
insert records into a table, just write the key word...
[email protected]
Insert Data in Specified Columns
Let us consider we have a table... we want to
insert data in field name 'emp_name',
'Position' and in 'email_id