petservlet.java

宠物诊所的JAVA-WEB实现

package com.hellofdeath.pet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;


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 com.hellofdeath.owner.PetownerDao;
import com.hellofdeath.tool.DBUtils;


public class PetServlet extends HttpServlet {

	private static final long serialVersionUID = -8653381118836032582L;
	public void init() throws ServletException {
	}
	
	public void destroy() {
		super.destroy(); 
	}

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

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		pet_vd = new Vector<PetDao>();
		owner_vd=new Vector<PetownerDao>();
		session=request.getSession();
		response.setContentType("text/html;charset=GBK");
		request.setCharacterEncoding("GBK");
		out = response.getWriter();
		String action=request.getParameter("action");
		System.out.print("已经进入SERVELT,动作是:"+action);
		if(action.equals("查  询")){
			this.petSearch(request,response);
		}
		if(action.equals("添加")){
			this.petAdd(request,response);
		}
		if(action.equals("修改")){
			this.petUpdate(request,response);
		}
		out.flush();
		out.close();
	}
	//宠物的相关查询操作
	public void petSearch(HttpServletRequest request, HttpServletResponse response) 
					throws ServletException, IOException{
		petName = request.getParameter("petName");// 获取宠物的名字
		petOwner = request.getParameter("petOwnerName");// 获取主人的名称
		System.out.println("主人和宠物的名字:");
		System.out.println(petName);
		System.out.println(petOwner);
		System.out.println("");
		if (petName ==null && petOwner!=null) {// 判断宠物和主人的输入 是否有为空的情况
			this.querypetOwner();
		} else if (petName!=null && petOwner==null) {
			this.querypetName();
		} else if (petName!= null && petOwner!=null) {
			this.queryBoth();
		}

		if (!existed) {
			out.println("<p align=center>抱歉,您要求的查询没有得到结果.请单击" +
							"<a href=\"/PetClinic/vet/vetSearch.jsp\">返回</a>继续查询");
		} else {
			//将宠物的信息存储到request的pet属性中
			//将宠物主人的信息存储到request的owner属性中
			//并转发到显示页面
			session.setAttribute("pet", pet_vd);
			session.setAttribute("owner",owner_vd);
			response.sendRedirect("/PetClinic/pet/petSearch_name.jsp");
		}
	}

	public void querypetName() { // 只输入了宠物的名字
		strSql="select a.id as 'pet_id',a.name as 'pet_name',a.birth_date,a.type_id,a.owner_id," +
				"b.id as 'owner_id',b.name as 'owner_name',address,city,telephone,c.name as 'type_name'"
				+" from pets a,owners b,types c where a.owner_id=b.id and a.type_id=c.id"
				+" and a.name like '%"+petName+"%'";
		this.addVector();
	}

	public void querypetOwner() {// 只输入了医师的名字
		strSql="select a.id as 'pet_id',a.name as 'pet_name',a.birth_date,a.type_id,a.owner_id,"
				+"b.id as 'owner_id',b.name as 'owner_name',address,city,telephone,c.name as 'type_name'"
				+" from pets a,owners b,types c where a.owner_id=b.id and a.type_id=c.id "
				+" and b.name like '%"+petOwner+"%'";
		this.addVector();
	}

	public void queryBoth() {// 输入医师和宠物的名字
		strSql="select a.id as 'pet_id',a.name as 'pet_name',a.birth_date,a.type_id,a.owner_id,"
				+"b.id as 'owner_id',b.name as 'owner_name',address,city,telephone,c.name as 'type_name'"
				+" from pets a,owners b,types c where a.owner_id=b.id and a.type_id=c.id" 
				+" and a.name like '%"+petName+"%' and b.name like '%"+petOwner+"%'";
		this.addVector();
	}

	public void addVector() {// 将信息加入向量容器
		rs = dbu.getResultSet(strSql);
		try {
			while (rs.next()) {
				existed = true;
				//存储宠物的信息
				pet = new PetDao();
				pet.setPetBirthDate(rs.getString("birth_date"));
				pet.setPetId(rs.getInt("pet_id"));
				pet.setPetName(rs.getString("pet_name"));
				pet.setPetOwnerId(rs.getInt("owner_id"));
				pet.setPetOwnerName(rs.getString("owner_name"));
				pet.setPetTypeId(rs.getInt("type_id"));
				pet.setPetTypeName(rs.getString("type_name"));
				pet_vd.addElement(pet);
				//存储用户的信息
				owner=new PetownerDao();
				owner.setPetOwnerAddress("address");
				owner.setPetOwnerCity("city");
				owner.setPetOwnerId(rs.getInt("owner_id"));
				owner.setPetOwnerName(rs.getString("owner_name"));
				owner.setPetOwnerTelNo("telephone1");
				owner_vd.addElement(owner);
			}
		} catch (SQLException e) {
			System.out.println(e.getMessage());
			existed = false;
		}
		dbu.close();// 关闭数据库的连接
	}

	//宠物的相关添加操作
	public void petAdd(HttpServletRequest request, HttpServletResponse response) throws IOException{
		System.out.print("添加宠物");
		pet=new PetDao();
		pet.setPetBirthDate(request.getParameter("date"));
		pet.setPetName(request.getParameter("petName"));
		pet.setPetOwnerId(Integer.parseInt(request.getParameter("ownerId")));
		pet.setPetTypeId(Integer.parseInt(request.getParameter("typeId")));
		if(dbu.insertPet(pet)){
			response.sendRedirect("/PetClinic/success.jsp");
		}
		dbu.close();
	}
	
	//宠物的相关更新操作
	public void petUpdate(HttpServletRequest request, HttpServletResponse response) throws IOException{
		pet.setPetId(Integer.parseInt(request.getParameter("pet_id")));
		pet.setPetName(request.getParameter("petName"));
		pet.setPetBirthDate(request.getParameter("birth_date"));
		pet.setPetOwnerName(request.getParameter("ownerName"));
		pet.setPetOwnerId(Integer.parseInt(request.getParameter("owner_id")));
		pet.setPetTypeId(Integer.parseInt(request.getParameter("type_id")));
		pet.setPetTypeName(request.getParameter("typeName"));
		if(dbu.updatePet(pet)){
			response.sendRedirect("/PetClinic/success.jsp");
		}
		dbu.close();
	}
	
	private boolean existed = false;
	private Vector<PetDao> pet_vd;
	private Vector<PetownerDao> owner_vd;
	private String petName = new String("");
	private String petOwner = new String("");
	private PrintWriter out ;
	private String strSql = null;
	private PetDao pet;
	private HttpSession session=null;
	private PetownerDao owner;
	private DBUtils dbu = new DBUtils();
	private ResultSet rs = null;
}