vetnewservlet.java

宠物医院

package servlet;

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

public class vetNewServlet
    extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";
  JDBCBean jdbc=new JDBCBean();
  Connection con=jdbc.getCon();
  //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;
    Vector vc=new Vector();
    String sql;
    Statement s=null;
    boolean isInEmpTable=false;
    VetDTO vet=new VetDTO();
    EmpDTO emp=new EmpDTO();

    String vetname=request.getParameter("vetname");
    String specname=request.getParameter("specname");
    String empname=request.getParameter("emp");
    String password=request.getParameter("password");
    String propem=request.getParameter("popedom");
    String telephone=request.getParameter("telephone");
    String address=request.getParameter("address");
    String resume=request.getParameter("resume");
    int propemInt=Integer.parseInt(propem);
    boolean insertEmp=false;
    boolean insertVet=false;

    vet.setVetName(vetname);
    vet.setSpecName(specname);
    vet.setTelephone(telephone);
    vet.setAddress(address);
    vet.setResume(resume);

    HttpSession session=request.getSession();
    session.setAttribute("vetName",vet.getVetName());  //将医师姓名加入到会话中

    emp.setEmp_name(empname);
    emp.setEmp_psw(password);
    emp.setPopedom(propemInt);
    isInEmpTable=emp.isInEmp();

    if(isInEmpTable==false)
       {

         insertVet=vet.insertVet();  //先插入医师信息
         try
         {
           sql="select id from vets where name=? and telephone=? and address=? and resume=?";
           pstm=con.prepareStatement(sql);
           pstm.setString(1,vetname);
           pstm.setString(2,telephone);
           pstm.setString(3,address);
           pstm.setString(4,resume);
           rs=pstm.executeQuery();
           while(rs.next())
           {
             emp.setVet_id(rs.getInt(1));
           }
         }
         catch(Exception e)
         {
           e.printStackTrace();
         }
         insertEmp=emp.insertEmp();
         if(insertVet==true&&insertEmp==true)
         {
           javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("VetNewOK.jsp");
           dis.forward(request,response);
         }
         else
         {
           out.println("很抱歉,"+vetname+"医师信息添加失败!");
           javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("vetNew.jsp");
           dis.include(request,response);

         }
       }
       else
       {
          out.println("很抱歉,已有同名的用户登录信息!");
         javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("vetNew.jsp");
         dis.include(request,response);


       }

  }

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

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