QuestionAsk Questions?
Derrick Tan
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?
View Answers
July 9, 2012 at 3:38 PM
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>
February 7, 2013 at 9:00 AM
mysql-connector-java-5.1.20-bin
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
