QuestionAsk Questions?
farah
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)
)
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 Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
