<!--insert.jsp-->
<!--add a new row to the table named register -->


<%@ page import="java.sql.*" %>
<%
   String user = (String)session.getAttribute("user");
   String passwd = (String)session.getAttribute("passwd");

   Connection conn = null;
   try
   {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

      conn = DriverManager.getConnection("jdbc:odbc:orcl",user,passwd);

      String name, rdate, phone, fees;

      name = request.getParameter("name");
      phone = request.getParameter("phone");
      rdate = request.getParameter("rdate");
      fees = request.getParameter("fees");
 	// prepare to insert row
      String insertString = "INSERT INTO REGISTER(NAME,PHONE,RDATE,FEES) "
                         + " VALUES (?, ?, ?, ?)";
      PreparedStatement stmt = conn.prepareStatement(insertString);

      stmt.setString (1, name); 
      stmt.setString (2, phone);
      stmt.setString (3, rdate);
      stmt.setString (4, fees);
      try {
	    stmt.executeUpdate();
            out.println("row inserted.");	       
         } 
      catch (SQLException ex) 
      {
       	 out.println("Could not insert Values.");
      }
      stmt.close();
      conn.close();
 
   }  // end try
   catch(Exception e)
   {
	out.println("Could not insert Values.");
   }

%>