storing date from html form to oracle 10g using servlet

i have following html form from where date,month and year is retrieved separately..

<html>
<form action="./registration.java" method="post">
<select name="DOB_Month">
    <option> - Month - </option><option value="January">January</option>
    <option value="Febuary">Febuary</option><option value="March">March</option>
    <option value="April">April</option><option value="May">May</option>
    <option value="June">June</option><option value="July">July</option>
    <option value="August">August</option><option value="September">September</option>
    <option value="October">October</option><option value="November">November</option>
    <option value="December">December</option>
</select>
<select name="DOB_Day">
<option> - Day - </option><option value="1">1</option><option value="2">2</option>
<option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option>
<option value="9">9</option><option value="10">10</option><option value="11">11</option>
<option value="12">12</option><option value="13">13</option><option value="14">14</option>
<option value="15">15</option><option value="16">16</option><option value="17">17</option>
<option value="18">18</option><option value="19">19</option><option value="20">20</option>
<option value="21">21</option><option value="22">22</option><option value="23">23</option>
<option value="24">24</option><option value="25">25</option><option value="26">26</option>
<option value="27">27</option><option value="28">28</option><option value="29">29</option>
<option value="30">30</option><option value="31">31</option>
</select>
<select name="DOB_Year"><option> - Year - </option>
<option value="2004">2004</option><option value="2003">2003</option>
<option value="2002">2002</option><option value="2001">2001</option>
<option value="2000">2000</option><option value="1999">1999</option>
<option value="1998">1998</option><option value="1997">1997</option>
<option value="1996">1996</option><option value="1995">1995</option>
<option value="1994">1994</option><option value="1993">1993</option>
<option value="1992">1992</option><option value="1991">1991</option>
<option value="1990">1990</option><option value="1989">1989</option>
<option value="1988">1988</option><option value="1987">1987</option>
<option value="1986">1986</option><option value="1985">1985</option>
<option value="1984">1984</option><option value="1983">1983</option>
<option value="1982">1982</option><option value="1981">1981</option>
<option value="1980">1980</option><option value="1979">1979</option>
<input type="submit" name="sub" id="sub"/>
</select>
</form>
</Html>

i want to insert this date month year from html form into oracle 10g database where i have a table named "details" and column name "dob" of "date" type...for this i have created a "registration.java" servlet..coding is as follows:

import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.*; 
public class registration extends HttpServlet {
    @Override
    public void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        Connection con=null;
        Statement st=null;
        ResultSet rs=null;
        SimpleDateFormat formatter = new SimpleDateFormat("yyyyMMdd");
try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","ORS","ors");

 // code for inserting date into oracle 10g in the format of oracle


        } catch(ClassNotFoundException c)
        {
            System.out.println(c);
        }
        catch(SQLException se)
        {
            System.out.println(se);
        }
        finally {
            try{
           rs.close();
            st.close();
           con.close();
            }catch(SQLException se)
            {
                System.out.println(se);
            }
            }
            }

Note: i have mentioned here only necessary coding..not mentioned here my full html form and servlet coding.... i don't know what should be the coding for inserting date in oracle's format..if der is ny1 to help me for the code of inserting date..i have tried a lot to find on google..but was not able to get the solution..so finally hv decided to post here...plz help me thnx in advance.....:):)

View Answers

April 6, 2012 at 9:22 AM

to insert the data in oracle you need to follow the jdbc concept. here is the snippet of an example: public class ConnJha {

Connection  con;
Statement   st;
ResultSet rs;
 PreparedStatement pt;

public ConnJha()
{

    connect();
}

public void connect(){

    try{

    String driver = "oracle.jdbc.OracleDriver";
    Class.forName(driver);

    con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:XE","username","password");
    st = con.createStatement();

    String sql1 = "INSERT INTO <table_name>" +
            "VALUES ('value1', 'value2', 'value3', 'value4')";
    st.executeUpdate(sql1);



        }
        catch(Exception e){
            e.printStackTrace();

        }

}

}