I am creating a website using jsp and servlets that is used to view houses from a database. I want to be able to edit the information of each house. showAll.jsp shows all the houses and beside that is a link to an edit page. The edit page needs to display all the house information from the database in the textboxes. Please help me to display the information in the textboxes. Below is edit.jsp:
<%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE html> <html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Edit Property</title>
</head>
<body>
<h1><img src="images/logo.gif" width="100" height="100" /> LIT Realty <img src="images/logo.gif" width="100" height="100" /></h1>
<br>
<form id="editProperty" name="editProperty" method="get" action="EditPropertyServlet">
<p><em>Please edit any properties details</em></p>
Enter Street: <input type="text" name="street" />
<br><br>
Enter city: <input type="text" name="city" />
<br><br>
Enter Listing Number: <input type="text" name="listingNum" />
<br><br>
Enter Style Id: <input type="text" name="styleId" />
<br><br>
Enter Type Id: <input type="text" name="typeId" />
<br><br>
Enter number of bedrooms: <input type="text" name="bedrooms" />
<br><br>
Enter number of bathrooms: <input type="text" name="bathrooms" />
<br><br>
Enter square feet: <input type="text" name="squarefeet" />
<br><br>
Enter description: <input type="text" name="description" />
<br><br>
Enter lot size: <input type="text" name="lotsize" />
<br><br>
Enter garage size: <input type="text" name="garagesize" />
<br><br>
Enter garage Id <input type="text" name="garageId" />
<br><br>
Enter your agent id: <input type="text" name="agentId" />
<br><br>
Select photo: <input type="text" name="photo" />
<br><br>
Enter price: <input type="text" name="price" />
<br><br>
<input type="submit" value="Edit Property" name="editProperty" />
</form>
</body> </html>
and edit.servlet:
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException{
response.setContentType("text/html");
PrintWriter pw = response.getWriter();
try
{
int id = Integer.parseInt(request.getParameter("id"));
String street = request.getParameter("street");
String city = request.getParameter("city");
int listingNum = Integer.parseInt(request.getParameter("listingNum"));
int styleId = Integer.parseInt(request.getParameter("styleId"));
int typeId = Integer.parseInt(request.getParameter("typeId"));
int bedrooms = Integer.parseInt(request.getParameter("bedrooms"));
int bathrooms = Integer.parseInt(request.getParameter("bathrooms"));
int squarefeet = Integer.parseInt(request.getParameter("squarefeet"));
String description = request.getParameter("description");
String lotsize = request.getParameter("lotsize");
int garagesize = Integer.parseInt(request.getParameter("garagesize"));
int garageId = Integer.parseInt(request.getParameter("garageId"));
int agentId = Integer.parseInt(request.getParameter("agentId"));
String photo = request.getParameter("photo");
double price = Double.parseDouble(request.getParameter("price"));
Connection conn = PropertyDB.doConnection();
PreparedStatement editpst = conn.prepareStatement("SELECT * from properties WHERE id =" + id); //need to get id from Show.jsp
editpst.setString(1,street);
editpst.setString(2,city);
editpst.setInt(3,listingNum);
editpst.setInt(4,styleId);
editpst.setInt(5,typeId);
editpst.setInt(6,bedrooms);
editpst.setInt(7,bathrooms);
editpst.setInt(8,squarefeet);
editpst.setString(9,description);
editpst.setString(10,lotsize);
editpst.setInt(11,garagesize);
editpst.setInt(12,garageId);
editpst.setInt(13,agentId);
editpst.setString(14,photo);
editpst.setDouble(15,price);
int i = editpst.executeUpdate();
if(i!=0)
{
pw.println("<br>Property has been updated");
}
else
{
pw.println("Failed to update the data");
}
}
catch (Exception e){
pw.println(e.getMessage());
}
}
}