HELLO! I wanna create a jsp page which able to let me get its name, phone and other info by asking the user to key in their email address from mysql database by using servlet and jsp too. Can anyone let me know any of its tutorial link?
Here is an application that ask the user to enter email-id. According to that data will get retrieved from database.
1)search.jsp:
<html> <head> </head> <body> <br><br><br><br><br><br> <form method="post" name="frm" action="..//search"> <table border="0" width="300" align="center" bgcolor="#CDFFFF"> <tr><td colspan=2 style="font-size:12pt;color:#00000;" align="center"> <h3>Search Form</h3></td></tr> <tr><td ><b>Enter Email</b></td> <td>: <input type="text" name="email" id="email"> </td></tr> <tr><td colspan=2 align="center"> <input type="submit" name="submit" value="Search"></td></tr> </table> </form> </body> </html>
2)Search.java:
import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import javax.sql.*; import java.sql.*; import java.util.*; public class Search extends HttpServlet{ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{ response.setContentType("text/html"); PrintWriter out = response.getWriter(); System.out.println("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String dbName = "register"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "root"; Statement st; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url+dbName,userName,password); System.out.println("Connected to the database"); String email = request.getParameter("email"); String query = "select * from item where email='"+email+"'"; st = conn.createStatement(); ResultSet rs = st.executeQuery(query); out.println("<table border='1'> while(rs.next()){ out.println("<tr><td>First Name</td><td><td><input type='text' value="+rs.getString(1)+"></td></tr>"); out.println("<tr><td>Last Name</td><td><td><input type='text' value="+rs.getString(2)+"></td></tr>"); out.println("<tr><td>Address</td><td><td><input type='text' value="+rs.getString(3)+"></td></tr>"); out.println("<tr><td>Contact No</td><td><td><input type='text' value="+rs.getString(4)+"></td></tr>"); } out.println("</table>"); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { e.printStackTrace(); } } }
3)web.xml:
<servlet-name>Search</servlet-name> <servlet-class>Search</servlet-class> </servlet> <servlet-mapping> <servlet-name>Search</servlet-name> <url-pattern>/search</url-pattern> </servlet-mapping>
mysql-connector-java-5.1.20-bin