Share on Google+Share on Google+

1 Answer(s)      6 years and 4 months ago
Posted in : Development process

tell me the coding for Dateofbirth in html.when we fill this field in form the data will be store into database is the sql server 2008.i am giving the datatype as date. and also i am try put the datatype as datetime,datetimeoffset but its not working. when i am select the dateofbirth it shows as null.

here is the html code for date of birth:

      <select name="DateOfBirth_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 name="DateOfBirth_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 name="DateOfBirth_Year">
      <option> - Year - </option>
      <option value="2010">2010</option>
      <option value="2009">2009</option>
      <option value="2008">2008</option>
      <option value="2007">2007</option>
      <option value="2006">2006</option>
      <option value="2005">2005</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>
      <option value="1978">1978</option>
      <option value="1977">1977</option>
      <option value="1976">1976</option>
      <option value="1975">1975</option>
      <option value="1974">1974</option>
      <option value="1973">1973</option>
      <option value="1972">1972</option>
      <option value="1971">1971</option>
      <option value="1970">1970</option>
      <option value="1969">1969</option>
      <option value="1968">1968</option>
      <option value="1967">1967</option>
      <option value="1966">1966</option>
      <option value="1965">1965</option>
      <option value="1964">1964</option>
      <option value="1963">1963</option>
      <option value="1962">1962</option>
      <option value="1961">1961</option>
      <option value="1960">1960</option>
      <option value="1959">1959</option>
      <option value="1958">1958</option>
      <option value="1957">1957</option>
      <option value="1956">1956</option>
      <option value="1955">1955</option>
      <option value="1954">1954</option>
      <option value="1953">1953</option>
      <option value="1952">1952</option>
      <option value="1951">1951</option>
      <option value="1950">1950</option>
      <option value="1949">1949</option>
      <option value="1948">1948</option>
      <option value="1947">1947</option>
      <option value="1946">1946</option>
      <option value="1945">1945</option>
      <option value="1944">1944</option>
      <option value="1943">1943</option>
      <option value="1942">1942</option>
      <option value="1941">1941</option>
      <option value="1940">1940</option>
      <option value="1939">1939</option>
      <option value="1938">1938</option>
      <option value="1937">1937</option>
      <option value="1936">1936</option>
      <option value="1935">1935</option>
      <option value="1934">1934</option>
      <option value="1933">1933</option>
      <option value="1932">1932</option>
      <option value="1931">1931</option>
      <option value="1930">1930</option>
      <option value="1929">1929</option>
      <option value="1928">1928</option>
      <option value="1927">1927</option>
      <option value="1926">1926</option>
      <option value="1925">1925</option>
      <option value="1924">1924</option>
      <option value="1923">1923</option>
      <option value="1922">1922</option>
      <option value="1921">1921</option>
      <option value="1920">1920</option>
      <option value="1919">1919</option>
      <option value="1918">1918</option>
      <option value="1917">1917</option>
      <option value="1916">1916</option>
      <option value="1915">1915</option>
      <option value="1914">1914</option>
      <option value="1913">1913</option>
      <option value="1912">1912</option>
      <option value="1911">1911</option>
      <option value="1910">1910</option>
      <option value="1909">1909</option>
      <option value="1908">1908</option>
      <option value="1907">1907</option>
      <option value="1906">1906</option>
      <option value="1905">1905</option>
      <option value="1904">1904</option>
      <option value="1903">1903</option>
      <option value="1902">1902</option>
      <option value="1901">1901</option>
      <option value="1900">1900</option>
View Answers

May 12, 2011 at 5:03 PM


function addOption(selectbox,text,value )
var optn = document.createElement("OPTION");
optn.text = text;
optn.value = value;

function setValues(){
for (var i=1; i <=31;++i){
addOption(document.form.DateOfBirth_Day, i, i);
var month = new Array("January","February","March","April","May","June",

for (var i=0; i < month.length;++i){
addOption(document.form.DateOfBirth_Month, month[i], month[i]);
for (var i=2011; i >=1900;i--){
addOption(document.form.DateOfBirth_Year, i, i);
<form name="form" method="post" action="http://localhost:8080/examples/jsp/insertdate.jsp">
<body onload="setValues();">
<select name="DateOfBirth_Day" >
        <option> - Day - </option>
    <select name="DateOfBirth_Month">
      <option> - Month - </option>
    <select name="DateOfBirth_Year">
      <option> - Year - </option>

<input type="submit"  value="Insert Date">


<[email protected] import="java.sql.*"%>
<[email protected] import="java.util.*"%>
<[email protected] import="java.text.*"%>

String mon=request.getParameter("DateOfBirth_Month");
java.util.Date date = new SimpleDateFormat("MMM", Locale.ENGLISH).parse(mon);    
Calendar cal = Calendar.getInstance();
int month = cal.get(Calendar.MONTH); 
int day=Integer.parseInt(request.getParameter("DateOfBirth_Day"));
int year=Integer.parseInt(request.getParameter("DateOfBirth_Year"));
Calendar calendar=Calendar.getInstance();
           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(calendar.getTime().getTime());
    pstmt.setDate(1, sqlDate);
    out.println("Date is successfully inserted");
        catch(Exception e){


Related Tutorials/Questions & Answers:
HTML  What is Semantic HTML? What are the reasons for validating a HTML
HTML  What is Semantic HTML? What are the reasons for validating a HTML
HTML  What is SPAN in HTML
HTML  What is HTML? What is a Hypertext link
HTML  What is HTML? What is a Hypertext link
Html  What is HTML? What is a Hypertext link
HTML  What is BODY in HTML document
html  diffrence between html and xml
html  How to add the calendar in html code
add a header in the html page  what we can do to add a header in the html page
HTML  How do we specify page breaks in HTML
HTML  What is a tag? How can we use MARQUEE in HTML
html  how to convert html page into jsp page
html  i want a registration page in html with good background
HTML  how can we give the unlimited size in the html
html  what we can do to add a header in the html page
html  what we can do to add a header in the html page
HTML  Hi, What is the full form of HTML? Thanks   Hi, The HTML stands for HyperText Markup Language. HTML is used to create webpage for world wide web. Web pages are accessed by web browsers and then shown
html  sir i am new to eclipse and i am created a html program and also tomcat is running successfully in side the eclipse.but now how i deploy that html program in the eclipse
html  Can we Access database through html page and how,if not then why
HTML  How do we create a link? What are the three types of form tags in HTML
html  how we can give the form actions in html after register button in the login page
Adding Header in HTML  what we can do to add a header in the html page
html  For what is used HTML?   Using HTML we can create a Web Page which can be viewed through a Web Browser over Internet. HTML describes... or the End Tag is defined as </> . The whole HTML document is enclosed
Html  in the web page if judge select the age and category then automatically under that conditions the details will be display in the form of grid give me that code in html and java
html   write a html program to print "HELLO WORD"in red coaler font size 12 and italic stile   Here is a html code that display the message "Hello World" in red font with size 12 and in italics. <html> <
Html  i am select the dateofbirth through the html browser.but it can not save into the sql server 2008 database.any special code required to store the date in database by using java servlets
HTML  I have created an info.html file for the applet.The class file is located in a directory different from the HTML file.The info.html file I have created is below. <HTML> <HEAD> <BODY> <APPLET Code
HTML  in html how can we can upload the file <tr> <td><strong>Video of the work:</strong> <td><b>... the file give me the code for this in html and java
HTML  how can we design the gird form view in html i want the following fields in the grid form The fields are Name of the candidate,Title... me the coding for this in html
html  Create a web page with the following using HTML i) To embed an image map in a web page ii) To fix the hot spots iii) Show all the related information when the hot spots are clicked.please reply me sir