form submission

form submission // Jdbc code for storing data into the database entered in the html page . Creation of dynamic web project. package com.app; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Servlet implementation class vikki */ @WebServlet("/vikki") public class vikki extends HttpServlet { private static final long serialVersionUID = 1L; /** * Default constructor. */ public vikki() { // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.getWriter().append("Served at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub PrintWriter out=response.getWriter(); String Sname=request.getParameter("sname"); int Age=Integer.parseInt(request.getParameter("age")); String Qualification=request.getParameter("qualification"); String Branch=request.getParameter("branch"); int Year=Integer.parseInt(request.getParameter("year")); int Percentage=Integer.parseInt(request.getParameter("percentage")); try { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection c=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","1998"); PreparedStatement st=c.prepareStatement("insert into students_data values(?,?,?,?,?,?)"); st.setString(1, Sname); st.setInt(2, Age); st.setString(3, Qualification); st.setString(4, Branch); st.setInt(5, Year); st.setInt(6, Percentage); st.executeUpdate(); System.out.println("success"); }catch(Exception e) { } } }//

html data submission and jdbc code