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

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

Servlets

servlets

Servlets

SERVLETS

Ads