<%@ page import="java.sql.*;" %>
<%
   String s1=request.getParameter("from");
   String s2=request.getParameter("to");
   String s3=request.getParameter("date");
   String s4=request.getParameter("tno");
   String s5=request.getParameter("pname");

   try
    {
     Class.forName("oracle.jdbc.OracleDriver");
     Connection con = DriverManager.getConnection("jdbc:oracle:thin:10.45.8.23:1523:oraclit", "scott","Tiger1234");
     Statement st = con.createStatement();
     st.executeUpdate("create table bal20(form varchar(20),to varchar(20),date Date,tno int,pname varchar(20))");
     st.executeUpdate("insert into bal20 values('"+s1+"','"+s2+"','"+s3+"','"+s4+"',''"+s5+"')");
     con.close();
   }
  catch(Exception e)
   {
     out.Writeln(e);
   }

%>