cardservlet.java

oa办公管理系统。一些小型的企业办公管理用的系统。一个月废寝忘食的结果。

package com.soft.card.control;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.soft.card.dao.CardDAO;
import com.soft.deptmgr.dao.DeptInfoDAO;

public class CardServlet extends HttpServlet {

	public CardServlet() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

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

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String methodcode=request.getParameter("methodcode");
		System.out.println(methodcode);
	
		if(methodcode.equals("add"))
		{
			CardDAO cd=new CardDAO();
  	  String cardName=request.getParameter("textfield");
  	  cardName=new  String(cardName.getBytes( "ISO8859_1"), "utf-8");
  	  int cardHolder=Integer.parseInt(request.getParameter("select"));
      String companyName=request.getParameter("textfield2");
      companyName=new String(companyName.getBytes( "ISO8859_1"), "utf-8");
  	  String name=request.getParameter("textfield27");
  	  name=new String(name.getBytes( "ISO8859_1"), "utf-8");
      String customerOccupatation=request.getParameter("textfield22");
      customerOccupatation=new String(customerOccupatation.getBytes( "ISO8859_1"), "utf-8");
  	  String customerAddress=request.getParameter("address");
  	   customerAddress=new String(customerAddress.getBytes( "ISO8859_1"), "utf-8");
  	  String customerPostalCode=request.getParameter("textfield25");
  	  
  	  String customerOfficePhone=request.getParameter("textfield23");
  	  String customerMobilePhone=request.getParameter("textfield24");
  	  String customerEmail=request.getParameter("textfield26");
  	  int i=cd.addCard(cardName, cardHolder, companyName, name, customerOccupatation, customerAddress, customerPostalCode, customerOfficePhone, customerMobilePhone, customerEmail);
  	 
  	  if(i>0)
  	  {
  		request.getSession().setAttribute("flag", "succ");
  		request.getRequestDispatcher("new_user_card.jsp").forward(request,response);
  	
  	  }
  	  else
  	  {
  		request.getSession().setAttribute("flag", "fail");
  		request.getRequestDispatcher("new_user_card.jsp").forward(request,response);
  	  }
		}
		else if(methodcode.equals("search"))
		{
			
			int page=1;
			int p=1;
			int pagecount=1;
			try{
				
				pagecount=Integer.parseInt(request.getAttribute("pagecount").toString());
			}
			catch(Exception e1){}
		    try{
			 String strPage=request.getParameter("curpage");
			 p=Integer.parseInt(strPage);
		
			System.out.println("当前："+p);
			}catch(Exception e){
				e.printStackTrace();
			}
	
		  if(p>1)
		  page=p;
		
			
	        System.out.println("要转到的页面"+page);
	     
			   CardDAO dif=new CardDAO();
			 
				dif.setCurPage(page);
				
				
				List lt = dif.getAllCard();
				
				System.out.println("总页数"+dif.getPageCount());
				System.out.println("总记录数"+dif.getRowsCount());
				System.out.println("每页显示记录数："+dif.getPageSize());
				System.out.println("当前页记录数："+dif.getPageRowsCount());
				if(lt.size()>0)
			    {
					request.setAttribute("list",lt);
			
				
				  request.setAttribute("curpage",page);
				  request.setAttribute("pagecount",dif.getPageCount());
				  request.setAttribute("rowscount",dif.getPageRowsCount());
				  request.getRequestDispatcher("shared_card.jsp").forward(request,response);
			     

				}
			
				else request.getRequestDispatcher("shared_card.jsp").forward(request,response);
		}
		
		else if(methodcode.equals("delete"))
		{
			int rowscount=Integer.parseInt(request.getParameter("rowscount"));
			int page=Integer.parseInt(request.getParameter("curpage"));
			int id=Integer.parseInt((String)request.getParameter("cardid"));
			if(rowscount==1)
				page=page-1;
			CardDAO cd=new CardDAO();
			cd.setCurPage(page);
			int i= cd.deleteCard(id);
			List lt=cd.getAllCard();
			
			request.setAttribute("list",lt);
			request.setAttribute("curpage", page);
			request.setAttribute("pagecount",cd.getPageCount());
			if(i>0)
			{
				request.getSession().setAttribute("flag", "succ");
				request.getRequestDispatcher("CardServlet?methodcode=search").forward(request,response);
				
			}
			else
			{
				request.getSession().setAttribute("flag", "fail");
		  		request.getRequestDispatcher("CardServlet?methodcode=search").forward(request,response);
			}
		}
			
		
	}

	
	public void init() throws ServletException {
		
	}

}