import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*

public class Search extends HttpServlet
{

 public void doGet(HttpServletRequest request, HttpServletResponse response)
 throws ServletException, IOException
{


    response.setContentType("text/html");

    PrintWriter printWriter = response.getWriter();
    String query = request.getParameter("query");
    try {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:db1","system","root");
    PreparedStatement preparedStatement =connection.prepareStatement(query);
    printWriter.print("<table width=25% border=1>");
    printWriter.print("<center><h1>Result:</h1></center>");



     ResultSet resultSet = preparedStatement.executeQuery();

     ResultSetMetaData resultsetmetadata = resultSet.getMetaData();
     while(resultSet.next())
     {
        printWriter.print("<tr>");
        printWriter.print("<td>"+resultsetmetadata.getColumnName(1)+</td>");
        printWriter.print("<td>"+resultSet.getInt(1)+"</td></tr>");
        printWriter.print("<td>"+resultsetmetadata.getColumnName(2)+"<td>");
        printWriter.print("<td>"+resultSet.getString(2)+"</td></tr>");
        printWriter.print("<td>"+resultsetmetadata.getColumnName(3)+</td>");
        printWriter.print("<td>"+resultSet.getString(3)+"</td></tr>");
        printWriter.print("<td>"+resultsetmetadata.getColumnName(4)+"<td>");
        printWriter.print("<td>"+resultSet.getString(4)+"</td></tr>");
        printWriter.print("<td>"+resultsetmetadata.getColumnName(5)+"<td>");
        printWriter.print("<td>"+resultSet.getInt(5)+"</td></tr>");

    }
    printWriter.print("</table>");
   }catch(Exception e){e.getMessage();}