jsp新代码第125课

new125.java

package pack02;

import java.io.Console;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class new125  //update
 */
@WebServlet(name = "new125",urlPatterns = "/page02/pack02.new125")
public class new125 extends HttpServlet 
{
	private static final long serialVersionUID = 1L;
       
 
    public new125() 
    {
        super();
         
    }

 
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		 request.setCharacterEncoding("utf-8");
		 int id = Integer.parseInt(request.getParameter("id"));
		 String name = request.getParameter("name");
		 String sex = request.getParameter("sex");
		 int age = Integer.parseInt(request.getParameter("age"));
		 float weight = Float.parseFloat(request.getParameter("weight"));
		 float height = Float.parseFloat(request.getParameter("height"));
		 
		 StringBuilder sql1 = new StringBuilder();
		 sql1.append("update students_info set ");
		 sql1.append("name='" + name +"',");
		 sql1.append("sex='" + sex + "',");
		 sql1.append("age=" + age + ",");
		 sql1.append("weight=" + weight + ",");
		 sql1.append("height=" + height);
		 sql1.append(" where id=" + id);
		 String sql = sql1.toString();
		 System.out.println(sql);
		 new116 run = new new116();
		 int n = run.updateSQL(sql);
		 if (n >= 1)
		 {
			 request.getRequestDispatcher("new113.jsp").forward(request, response);
		 }
		 else 
		 {
			 request.getRequestDispatcher("new114.jsp").forward(request, response);
		 }
	}

 
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		 
		doGet(request, response);
	}

}