import java.io.*;
import javax.servlet.http.*;
import java.sql.*;
public class Update extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
String url=" ";
Connection cont;
try
{
url="jdbc:odbc:AddressBook1";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cont=DriverManager.getConnection(url);
Statement statement=cont.createStatement();
String query="SELECT * FROM addresses WHERE ID= '"+ request.getParameter ("number") + "'";
ResultSet rs=statement.executeQuery(query);
while(rs.next())
{
String recnum=rs.getString(1);
if(recnum.equals(request.getParameter("number")))
{
pw.println("
Number:" +recnum+"
");pw.println("
Name:" +rs.getString(2)+"
");pw.println("
E-mail:" +rs.getString(4)+"
");pw.println("
Phone:"+rs.getString(5)+"
");}
else
{
pw.println("No record found");
}
}
statement.close();
}
catch(Exception e)
{
pw.println(e.toString());
}
}
}
No comments:
Post a Comment