addstudent.java

来自「是一个学生开发信息管理系统」· Java 代码 · 共 37 行

package com.accp.service;
import javax.servlet.http.*;
import javax.servlet.*;
import java.sql.*;
import com.accp.DB.*;


public class addStudent implements Service{
  public void execute(HttpServletRequest request,HttpServletResponse response,ServletContext context){

    StudentBean stu=new StudentBean();
    stu.setStuid(request.getParameter("id"));
    stu.setAge(Integer.parseInt(request.getParameter("age")));
    stu.setSex(request.getParameter("sex"));
    stu.setPhone(request.getParameter("phone"));
    stu.setName(request.getParameter("name"));
    try{
    ConnectionPool conp=(ConnectionPool)context.getAttribute("Pcon");
    Connection conn=conp.getConnection();
    PreparedStatement stat=conn.prepareStatement("insert into student values(?,?,?,?,?)");
    stat.setInt(1,Integer.parseInt(stu.getStuid()));
    stat.setString(2,stu.getName());
    stat.setInt(3,stu.getAge());
    stat.setString(4,stu.getSex());
    stat.setString(5,stu.getPhone());
    stat.executeUpdate();
    stat.close();

    conp.releaseConnection(conn);

    }catch(Exception e){e.printStackTrace();}
  }


}