visitservlet.java

宠物诊所的JAVA-WEB实现

package com.hellofdeath.visit;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;

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.tool.DBUtils;
import java.sql.*;

public class VisitServlet extends HttpServlet {
	
	private static final long serialVersionUID = 6845788247762538965L;

	public void init() throws ServletException {
	}

	public VisitServlet() {
		super();
	}

	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 {
		response.setContentType("text/html;charset=GBK");
		request.setCharacterEncoding("GBK");
		out = response.getWriter();
		session = request.getSession();
		vec_browse = new Vector<PetVisitDao>();
		action = request.getParameter("action");//获取动作信息
		
		if (action.equals("阅览病历")) {
			this.visitBrowse(request, response);
		} else if (action.equals("添加病历")) {
			this.visitAddPage(request, response);
		} else if (action.equals("添加")) {
			this.visitAdd(request, response);
		}
		out.flush();
		out.close();
	}

	public void visitBrowse(HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		strSql = "select * from visits where pet_id="
				+ Integer.parseInt(request.getParameter("id"));
		System.out.println(strSql);
		rs = dbu.getResultSet(strSql);
		try {
			while (rs.next()) {
				visitBrowse = new PetVisitDao();
				visitBrowse.setVisitDate(rs.getString("visit_date"));
				visitBrowse.setDescription(rs.getString("description"));
				vec_browse.add(visitBrowse);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		session.setAttribute("visitBrowse", vec_browse);
		//转到浏览病历的页面
		response.sendRedirect("/PetClinic/visit/petVisitHistory.jsp");
	}

	public void visitAddPage(HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		//转到添加病历的页面
		response.sendRedirect("/PetClinic/visit/petVisitAdd.jsp");
	}

	public void visitAdd(HttpServletRequest request,
			HttpServletResponse response) throws IOException {
		//添加病历
		String strSql = "insert into visits(pet_id,visit_date,description) values("
				+ Integer.parseInt(request.getParameter("id"))
				+ ",'"+ request.getParameter("date")
				+ "','"+ request.getParameter("description")
				+"')";
		if(dbu.insert(strSql)){
			response.sendRedirect("/PetClinic/success.jsp");
		}
	}

	private HttpSession session = null;
	private ResultSet rs = null;
	private Vector<PetVisitDao> vec_browse;
	private PetVisitDao visitBrowse;
	private String strSql = null;
	private DBUtils dbu = new DBUtils();
	private String action = null;
	private PrintWriter out;
}