servlets
hi i am using servlets i have a problem in doing an application.
in my application i have html form, in which i have to insert on date value, this date value is retrieved as a request parameter in my servlet. and it was in the form of string. so my question is, how to convert that string value into java.sql.Date type and insert into database
View Answers
March 10, 2011 at 12:46 PM
Servlet Insert Date
1)date.html:
<html>
<form method="post" action="http://localhost:8080/examples/InsertDate">
Enter date:<input type="text" name="dd"><br>
<input type="submit" action="Submit">
</form>
</html>
2)InsertDate.java:
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class InsertDate extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String d=req.getParameter("dd");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
PreparedStatement pstmt = con.prepareStatement("insert into emp(JOINING_DATE) values(?)");
java.sql.Date sqlDate = new java.sql.Date(new java.util.Date(d).getTime());
pstmt.setDate(1, sqlDate);
pstmt.executeUpdate();
out.println("Date is successfully inserted");
}
catch(Exception e){
System.out.println(e);
}
}
}
Ads
Related Tutorials/Questions & Answers:
servlets
servlets what is the duties of response object in
servlets
servlets
what are advantages of servlets what are advantages of
servlets
Please visit the following link:
Advantages Of
Servlets
Advertisements
Servlets
Servlets How to edit and delete a row from the existing table in
servlets
servlets
what is the architecture of a
servlets package what is the architecture of a
servlets package
The javax.servlet package provides interfaces and classes for writing
servlets.
The Servlet Interface
The central
Servlets
Servlets How to check,whether the user is logged in or not in
servlets to disply the home page
Servlets
.
Anyways, please visit the following links:
http://www.roseindia.net/
servlets/introductiontoconfigrationservlet.shtml
http://www.roseindia.net/
servlets
servlets
servlets why we require wrappers in
servlets? what are its uses?
Please explain
These wrappers classes help you to modify request...://www.roseindia.net/
servlets/response-filte.shtml
servlets
servlets How to open and read the contents of a text file in
servlets?
Please visit the following link:
Read text file using Servlet
servlets
servlets Hi
what is pre initialized
servlets, how can we achives?
When servlet container is loaded, all the
servlets defined in the web.xml file does not initialized by default. But the container receives
servlets
servlets why do we need web-inf directory in web application why do we need web-inf directory in web application? means what's the benefits of doing so
Servlets and
Servlets and Sir...! I want to insert or delete records form oracle based on the value of confirm box can you please give me the idea.... thanks
servlets
which are the differ ways you can communicat between servlets which are the differ ways you can communicat between
servlets
Different ways of communicating between
servlets:-
1)Using RequestDispatcher object.
2
servlets
package supports the development of
servlets that use the HTTP protocol. The classes... javax.servlet.GenericServlet and serves as the base class for HTTP
servlets. HttpServlet-Request
servlets
what are sessions in servlets what are sessions in
servlets
A Session refers to all the request that a single client makes to a server...:
http://roseindia.net/jsp/jspsession/
http://www.roseindia.net/
servlets
the servlets
what is diff between generic
servlets and httpservlets what is diff between generic
servlets and httpservlets
Difference between GenericServlet and HTTPServlet:
1)GenericServlet belongs to javax.servlet package
servlets
regarding the user usage and habits.
Servlets sends cookies to the browser client...://www.roseindia.net/jsp/jspcookies.shtml
http://www.roseindia.net/
servlets/use
servlets
servlets hi i am using
servlets i have a problem in doing an application.
in my application i have html form, in which i have to insert on date value, this date value is retrieved as a request parameter in my servlet
servlets
what are filters in java servlets what are filters in java
Filters are powerful tools in servlet environment. Filters add certain functionality to the
servlets apart from processing request and response paradigm
servlets
servlets what are different authentication options available in
servlets
There are four ways of authentication:-
HTTP basic authentication
HTTP digest authentication
HTTPS client authentication
Form-based
jsp -servlets
jsp -servlets i have
servlets s1 in this
servlets i have created emplooyee object, other
servlets is s2, then how can we find employee information in s2
servlets
Servlets with Extjs
Servlets with Extjs how to integrate
servlets and extjs and also show database records in extjs grid using servlet how to get
servlets json response. Can any one please help me
java servlets
java servlets please help...
how to connect java
servlets with mysql
i am using apache tomcat 5.5
servlets and struts
servlets and struts wat is the diffrence between
servlets and struts?
A Servlet is a technology and Struts is a framework which relies on or makes use of Servlets.A Servlet is a controller. Struts has its own Servlet
Servlets Programming
Servlets Programming Hi this is tanu,
This is a code for knowing... visit the following links:
http://www.roseindia.net/
servlets/SimpleCounterInServlet.shtml
http://www.roseindia.net/
servlets/CounterInInit.shtml
http