Edit.html
<html>
<head>
<title>TODO supply a title</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width">
</head>
<body bgcolor="pink">
<center>
<font color="blue" size="5">
<h2> Sookshmas Edit form</h2>
</font>
<form action="edit" method="POST">
Student Id:<input type="text" name="id"/>
<input type="submit" value="EDIT" />
</form>
</center>
</body>
</html>
Servlet: edit.java
package handler;
import DAO.student;
import DAO.user;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
@WebServlet(name = "edit", urlPatterns = {"/edit"})
public class edit extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
HttpSession session = request.getSession();
try (PrintWriter out = response.getWriter()) {
String id = request.getParameter("id");
user u = new user(session);
student s = u.getid(id);
if (s == null) {
out.println("<html>");
out.println("<body>");
out.println("<br>");
out.println("<font color='red' size='6'>");
out.println("student Not Existed");
out.println("</font>");
out.println("<br>");
out.println("<h3> <a href='edit.html'>back</a></h3>");
out.println("</body></html)");
} else {
out.println("<html>");
out.println("<body bgcolor='pink'>");
out.println("<br>");
out.println("<center>");
out.println("<font color='red' size='6'>");
out.println("Student Edit Form");
out.println("</font>");
out.println("<form action='update' method='GET'>");
out.println("<table>");
out.println("<tr><td>student id</td> <td>" + id + "</td></tr>");
out.println("<input type='hidden' name='id' value='" + id + "'/> ");
out.println("<tr><td>name</td> <td><input type='text' name='name' value='" + s.getName() + "' </td></tr>");
out.println("<tr><td>Phone Number</td><td><input type='text' name='pno' value='" + s.getphone() + "'</td> </tr>");
out.println(" <tr><td> <input type='submit' name='submit' value='Update'/></td></tr>");
out.println("</table></form></center></body></html>");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
Classname: user.java
package DAO;
import java.sql.*;
import javax.servlet.http.HttpSession;
public class user {
Connection con;
Statement st;
ResultSet rs = null;
String status = "";
HttpSession se;
student s;
public user(HttpSession session) {
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sookshmas", "root", "root");
se = session;
} catch (Exception e) {
e.printStackTrace();
}
}
public student getid(String id) {
try {
st = con.createStatement();
rs = st.executeQuery("select * from sookshmas where slno= '" + id + "'");
boolean b = rs.next();
if (b == true) {
s = new student();
s.setId(rs.getString(1));
s.setName(rs.getString(2));
s.setphone(rs.getString(3));
} else {
s = null;
}
} catch (Exception e) {
e.printStackTrace();
}
return s;
}
public String update(int id, String name, String pno) {
// System.out.println(id + name + pno);
try {
st = con.createStatement();
st.executeUpdate("update sookshmas set name='" + name + "',phone='" + pno + "' where slno='" + id + "' ");
status = "success";
} catch (Exception e) {
status = "failure";
e.printStackTrace();
}
return status;
}
}
Classname: student.java
package DAO;
public class student {
String id;
String name;
String phonenumber;
public String getId() {
return id;
}
public String getName() {
return name;
}
public String getphone() {
return phonenumber;
}
public void setId(String id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
public void setphone(String phonenumber) {
this.phonenumber = phonenumber;
}
}
Servlet name: update.java
package handler;
import DAO.user;
import com.sun.jmx.snmp.BerDecoder;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(name = "update", urlPatterns = {"/update"})
public class update extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
if (request.getParameter("submit") != null) {
int id = Integer.parseInt(request.getParameter("id"));
String name = request.getParameter("name");
String pno = request.getParameter("pno");
System.out.println(id + name + pno);
user u = new user();
String status = u.update(id, name, pno);
out.println("<html>");
out.println("<body>");
out.println("<br>");
out.println("<br>");
out.println("<h2>");
if (status.equals("success")) {
out.println("<body bgcolor='pink'>");
out.println("<br>");
out.println("<center>");
out.println("<font color='red' size='6'>");
out.println(" Record Updated successfully");
out.println("</font>");
out.println("<br>");
out.println("</center></body>");
// out.println("student updated successfully <br>");
} else {
out.println("student updation failure <br>");
}
out.println("<html>");
out.println("<body>");
out.println("<br>");
out.println("<center>");
out.println("<h3> <a href='edit.html'>BACK</a></h3>");
out.println("</center></body></html)");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
