import javax.servlet.*;
import javax.servlet.http.*;
import
java.io.*;
import java.util.*;
import java.sql.*;
public class jb48_ora extends HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)throws
ServletException,IOException
{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title> get data </title></head>");
out.println("<body>");
String st1 =request.getParameter("matcode");
out.println(st1);
String st2
=request.getParameter("costcentre");
out.println(st2);
String st3
=request.getParameter("fromdate");
out.println(st3);
String st4
=request.getParameter("todate");
out.println(st4);
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
try
{
con=DriverManager.getConnection("jdbc:odbc:imms","imms","notvalid");
Statement stmt =con.createStatement();
String query ="SELECT in_reqnno, in_reqndt, in_issno, in_issdt, ii_matcode, ii_issued_qty FROM is_note, is_note_item where in_costcentre = '"+st2+"' and ii_matcode = '"+st1+"' and (in_issdt between '"+st3+"' and '"+st4+"') and ii_issno = in_issno ";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
String s1 =rs.getString("in_reqnno");
String s2 =rs.getString("in_reqndt");
String s3 =rs.getString("in_issno");
String s4 =rs.getString("in_issdt");
String s5 =rs.getString("ii_matcode");
String s6 =rs.getString("ii_issued_qty");
out.println("<p>");
out.println("<BOLD>");
out.println("REQ_NO");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s1+"'>");
out.println("<BOLD>");
out.println("REQ_DATE");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s2+"'>");
out.println("<BOLD>");
out.println("ISS_NO");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s3+"'>");
out.println("<BOLD>");
out.println("ISS_DATE");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s4+"'>");
out.println("<BOLD>");
out.println("MATCODE");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s5+"'>");
out.println("<BOLD>");
out.println("ISS_QTY");
out.println("</BOLD>");
out.println("<INPUT TYPE ='text'
value='"+s6+"'>");
out.println("</p>");
}
rs.close();
}
catch(SQLException sqle)
{
out.println("out of
loop");
System.err.println(sqle.getMessage());
}
out.close();
}
}