entering servlet form values into database
how can i get servlet form data into database?. please modify my code and send it.
I m sending with my requirements
..................................
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
String Name = request.getParameter("name");
String Age = request.getParameter("age");
String Gender = request.getParameter("gender");
String Origin= request.getParameter("origin");
String Destination = request.getParameter("destination");
boolean resStatus=false;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException ex)
{
ex.printStackTrace();
}
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
try
{
con=DriverManager.getConnection("jdbc:oracle:thin: @localhost:1521:XE","system","malli");
stmt=con.createStatement();
String sql="insert into RESERVATION_DETAILS values('+Name+','+Age+',+Gender+','+Origin+','+Des tination+')";
rs=stmt.executeQuery(sql);
resStatus=rs.next();
}
catch(SQLException ex)
{
ex.printStackTrace();
}
finally
{
try
{
if(rs!=null)
{
rs.close();
rs=null;
}
}
catch(SQLException ex)
{
ex.printStackTrace();
}
try
{
if(stmt!=null)
{
stmt.close();
stmt=null;
}
}
catch(SQLException ex)
{
ex.printStackTrace();
}
try
{
if(con!=null)
{
con.close();
con=null;
}
}
catch(SQLException ex)
{
ex.printStackTrace();
}
PrintWriter out=response.getWriter();
if(resStatus)
{
out.println("reservation success");
}
else
{
out.println("registration fail");
}
out.println("<a href='http://localhost:7070/proj_dev_resv/LoginServlet?username=malli&password=123'>back</a>");
}
