modifyvetafterservlet.java~40~

宠物医院

package servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.PreparedStatement;
import bean.JDBCBean;
import java.sql.ResultSet;
import java.sql.Connection;

public class ModifyVetAfterServlet
    extends HttpServlet {
  public ModifyVetAfterServlet() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private static final String CONTENT_TYPE = "text/html; charset=GBK";
  int spesID; //得到专业编号
  int vetidINT;
  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    JDBCBean jdbc=new JDBCBean();
    Connection con=jdbc.getCon();
    PreparedStatement pstm=null;
    ResultSet rs=null;
    String sql;
    int vetId=0;
    String vetNumber=request.getParameter("vetNumber");   //修改医师编号
    String vetname=request.getParameter("vetname");
    String spesname=request.getParameter("specname");
    try
    {
      sql="select id from specialties where name=?";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,spesname);
      rs=pstm.executeQuery();
      if(rs.next())
      {
        spesID=rs.getInt(1);  //专业编号
      }
      pstm.close();

      sql="select id from vets where name=? and number=? ";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,vetname);
      pstm.setString(2,vetNumber);
      rs=pstm.executeQuery();
      if(rs.next())
      {
        vetId=rs.getInt(1);
      }
      pstm.close();
      rs.close();
      sql="update vets set name=? where number=?  "+
          "update vet_specialties set specialty_id=?  where vet_id=? ";
      pstm=con.prepareStatement(sql);
      pstm.setString(1,vetname);
      pstm.setString(2,vetNumber);
      pstm.setInt(3,spesID);
      pstm.setInt(4,vetId);
      pstm.executeUpdate();
      pstm.close();

      javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("modifyVetOK.jsp?modifyAfterNumber="+vetNumber);
      dis.forward(request,response);

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



  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }

  private void jbInit() throws Exception {
  }
}