Untitled

<html>
<head>
    <title>TODO supply a title</title>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta name="viewport" content="width=device-width">
</head>
<body>
   <form action="Search">
 Enter your Name: <input type="text" name="name"/><br/>
<input type="submit" value="search"/>
</form>
</body>
</html>

import java.io.*;
 import java.sql.*;
 import javax.servlet.ServletException;
 import javax.servlet.http.*;
 public class Search extends HttpServlet {
   public void doGet(HttpServletRequest request, HttpServletResponse
  response)
                 throws ServletException, IOException {
          response.setContentType("text/html");
          PrintWriter out = response.getWriter();
          String name=request.getParameter("name");
          try{
                 Class.forName("com.mysql.jdbc.Driver");
        Connection
   con=DriverManager.getConnection("jdbc:mysql://localhost/coffeedb", "root","");

                 PreparedStatement ps=con.prepareStatement("select * from coffee where name = ?");
                 ps.setString(1,name);
                 out.print("<table width=25% border=1>");
                 out.print("<center><h1>Result:</h1></center>");
                 ResultSet rs=ps.executeQuery();
                 /* Printing column names */
                 ResultSetMetaData rsmd=rs.getMetaData();
                 while(rs.next())
                    {
                 out.print("<tr>");
                 out.print("<td>"+rsmd.getColumnName(1)+"</td>");
                    out.print("<td>"+rs.getString(1)+"</td></tr>");
                    out.print("<tr><td>"+rsmd.getColumnName(2)+"</td>");
                    out.print("<td>"+rs.getString(2)+"</td></tr>");
                    out.print("<tr><td>"+rsmd.getColumnName(3)+"</td>");
                    out.print("<td>"+rs.getString(3)+"</td></tr>");
                    out.print("<tr><td>"+rsmd.getColumnName(4)+"</td>");
                    out.print("<td>"+rs.getString(4)+"</td></tr>");
                 }
                 out.print("</table>");

          }catch (Exception e2)
            {
                e2.printStackTrace();
            }

          finally{out.close();
            }
   }

 }