QuestionAsk Questions?
shivangi gupta
storing date from html form to oracle 10g using servlet
1 Answer(s) a year and 2 months ago
Posted in : JSP-Servlet
1 Answer(s) a year and 2 months ago
Posted in : JSP-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();
}
}
}
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
