Program 3
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package controller;
import dao.StudentDAO;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import model.Student;
public class DisplayUpdate extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
/* TODO output your page here. You may use following sample code. */
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet DisplayUpdate</title>");
out.println("</head>");
out.println("<body>");
int rn;
rn=Integer.parseInt(request.getParameter("txtRno"));
StudentDAO sd=new StudentDAO();
Student S;
S=sd.searchByRno(rn);
if(S==null)
out.println("<font color=red size=7>Record not found</font>");
else
{
out.println("<center>");
out.println("<form method=post action=UpdateData>");
out.println("<table border=1>");
out.println("<tr>");
out.println("<th>Roll No</th>");
out.println("<th>Name</th>");
out.println("<th>Physics</th>");
out.println("<th>Chemistry</th>");
out.println("<th>Maths</th>");
out.println("</tr>");
out.println("<tr>");
out.println("<td>"+S.getRno()+"</td>");
HttpSession session=request.getSession(true);
session.setAttribute("rollno", S.getRno());
out.println("<td><input type=text name=txtName value="+S.getName()+"></td>");
out.println("<td><input type=text name=txtPhy value="+S.getPhy()+"></td>");
out.println("<td><input type=text name=txtChem value="+S.getChem()+"></td>");
out.println("<td><input type=text name=txtMath value="+S.getMath()+"></td>");
out.println("<td><input type=submit value=Update></td>");
out.println("</tr>");
out.println("</table>");
out.println("</form>");
out.println("</center>");
}
out.println("</body>");
out.println("</html>");
}
catch(Exception e)
{
out.println(e);
}
}
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
Program 4
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package controller;
import dao.StudentDAO;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import model.Student;
/**
*
* @author admin
*/
public class UpdateData extends HttpServlet {
/**
* Processes requests for both HTTP <code>GET</code> and <code>POST</code>
* methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
try (PrintWriter out = response.getWriter()) {
/* TODO output your page here. You may use following sample code. */
out.println("<!DOCTYPE html>");
out.println("<html>");
out.println("<head>");
out.println("<title>Servlet UpdateData</title>");
out.println("</head>");
out.println("<body>");
int rno,phy,chem,math;
String name;
HttpSession session=request.getSession();
rno=Integer.parseInt(session.getAttribute("rollno").toString());
name=request.getParameter("txtName");
phy=Integer.parseInt(request.getParameter("txtPhy"));
chem=Integer.parseInt(request.getParameter("txtChem"));
math=Integer.parseInt(request.getParameter("txtMath"));
//out.println(rno + " "+name + " "+ phy + " " + chem+" "+math);
Student S=new Student();
S.setRno(rno);
S.setName(name);
S.setPhy(phy);
S.setChem(chem);
S.setMath(math);
StudentDAO sd=new StudentDAO();
if(sd.updateStudent(S))
out.println("<font color=green size=7>record updated.........</font>");
out.println("</body>");
out.println("</html>");
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}