addservlet.java

student managment systemstudent managment systemstudent managment systemstudent managment systemstud

package servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import common.DataBaseConnection;
import common.NumFormat;

public class AddServlet extends HttpServlet
{  
	public void init(ServletConfig config) throws ServletException
    {super.init(config);
    }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		try{
   			Connection con=DataBaseConnection.getConnection();
   			PreparedStatement prst=con.prepareStatement("insert into score values(?,?,?,?,?)");
	        prst.setString(1,NumFormat.transInsert(request.getParameter("sno")));
	        prst.setString(2,NumFormat.transInsert(request.getParameter("name")));
	        prst.setFloat(3,Float.parseFloat(request.getParameter("math")));
	        prst.setFloat(4,Float.parseFloat(request.getParameter("physical")));
	        prst.setFloat(5,Float.parseFloat(request.getParameter("english")));
	        prst.executeUpdate();	
		    con.close();
   		}catch(SQLException e){
   			e.printStackTrace();
   		}
        RequestDispatcher dispatcher= request.getRequestDispatcher("/success.jsp");
        dispatcher.forward(request, response);         
    } 
   public  void  doGet(HttpServletRequest request,HttpServletResponse response) 
                        throws ServletException,IOException
    {   
   		doPost(request,response);
    }
}