cardaction.java

MCV框架下的Action代码, 并使用了Hibernate持久化技术等

// Class Source File : CardAction.java

package com.shinecode.struts.action;

import com.shinecode.Card;
import com.shinecode.handle.MSFmessage;
import com.shinecode.handle.CardHandleDAO;
import com.shinecode.handle.RegionHandleDAO;
import com.shinecode.other.PageBean;
import com.shinecode.struts.form.CardForm;
import java.lang.reflect.InvocationTargetException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.http.*;
import org.apache.commons.beanutils.BeanUtils;
import org.apache.struts.action.*;
import org.apache.struts.actions.DispatchAction;
import net.sf.hibernate.HibernateException;

import net.sf.hibernate.Transaction;
import net.sf.hibernate.Session;
import java.sql.*;
import com.shinecode.dao._RootDAO;
import com.shinecode.util.DButil;

// Referenced classes of package com.shinecode.struts.action:
//            BaseAction

public class CardAction extends DispatchAction
    implements BaseAction
{

    public CardAction()
    {
    }

    public ActionForward save(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
		String ctype = "";
		if(request.getParameter("ctype") == null || request.getParameter("ctype").equals(""))
			ctype = null;
		else
			ctype = request.getParameter("ctype");

		CardForm cardForm = (CardForm)form;
		Card card = new Card();
		if(!(ctype == null || ctype.equals(""))) cardForm.setCtype(ctype);

		Transaction tx = null;
		Session s = null;
		try
		{
			_RootDAO.initialize();
			s = _RootDAO.createSession();
			if(!s.isConnected()) s.reconnect();
			tx = s.beginTransaction();

			Connection conn=s.connection();
			String strproc = "{call spGetNextID(?) }";
			CallableStatement cstmt = conn.prepareCall(strproc);
			cstmt.setString(1,"");
			cstmt.registerOutParameter(1, Types.VARCHAR);
			cstmt.executeUpdate();
			String strID = cstmt.getString(1);

			cardForm.setCId(strID);
			//cardForm.setCId(DButil.GetCardNextID());
			BeanUtils.copyProperties(card, cardForm);
			CardHandleDAO cardHandleDAO = new CardHandleDAO();
			cardHandleDAO.save(card);
			tx.commit();
		}
		catch(IllegalAccessException e1)
		{
			e1.printStackTrace();
			if(tx != null) try{tx.rollback();}catch(HibernateException hexp){hexp.printStackTrace();}
		}
		catch(InvocationTargetException e2)
		{
			e2.printStackTrace();
			if(tx != null) try{tx.rollback();}catch(HibernateException hexp){hexp.printStackTrace();}
		}
		catch(HibernateException he)
		{
			he.printStackTrace();
			if(tx != null) try{tx.rollback();}catch(HibernateException hexp){hexp.printStackTrace();}
			System.out.println("------------HibernateException: CardAction.save-----------------");
		}
		catch(Exception e)
		{
			e.printStackTrace();
			if(tx != null) try{tx.rollback();}catch(HibernateException hexp){hexp.printStackTrace();}
			System.out.println("-----------------Exception: CardAction.save---------------------");
		}
		finally
		{
			if(s != null) try{s.close();}catch(HibernateException hexp){hexp.printStackTrace();}
		}
		HttpSession session = request.getSession();
		session.setAttribute("cType", ctype);
		return mapping.findForward("cardsaveok");
	}

	/*
	public ActionForward save(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
	{
		String ctype = "";
		if(request.getParameter("ctype") == null || request.getParameter("ctype").equals(""))
			ctype = null;
		else
			ctype = request.getParameter("ctype");

		CardForm cardForm = (CardForm)form;
		Card card = new Card();
		if(!(ctype == null || ctype.equals("")))
		{
			cardForm.setCId(DButil.GetCardNextID());
			cardForm.setCtype(ctype);
		}

		try
		{
			BeanUtils.copyProperties(card, cardForm);
 			CardHandleDAO cardHandleDAO = new CardHandleDAO();
			cardHandleDAO.save(card);
		}
		catch(IllegalAccessException e1)
		{
			e1.printStackTrace();
		}
		catch(InvocationTargetException e1)
		{
			e1.printStackTrace();
		}
		HttpSession session = request.getSession();
		session.setAttribute("cType", ctype);
		return mapping.findForward("cardsaveok");
	} 
	*/

    public ActionForward select(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
        CardHandleDAO cardHandleDAO = new CardHandleDAO();
        HttpSession session = request.getSession();
        int pageSize = 10;
        int curPage;
        if(request.getParameter("cur_page") == null || request.getParameter("cur_page").equals("0"))
            curPage = 1;
        else
            curPage = Integer.parseInt(request.getParameter("cur_page"));

		String cardtype = "card";
		String ctype = "";
		if(session.getAttribute("cType") == null || session.getAttribute("cType").equals("")){
			if(request.getParameter("ctype") == null || request.getParameter("ctype").equals("")){
				ctype = null;
			}else{
				ctype = request.getParameter("ctype");
			}
		}else{
			ctype = (String)session.getAttribute("cType");
		}

		System.out.println("====================CardAction: ctype="+ctype);
		List list1 = null;
        try
        {
            if(session.getAttribute("curPage") != null)
            {
                curPage = Integer.parseInt((String)session.getAttribute("curPage"));
                session.removeAttribute("curPage");
            }
            if(ctype == null || ctype.equals(""))
            {
            	cardtype = "card";
            	list1 = (ArrayList)cardHandleDAO.selectCard();
            	session.removeAttribute("cType");
            }else{
            	cardtype = "card" + ctype;
            	list1 = (ArrayList)cardHandleDAO.selectCardBytype(ctype);
            	session.setAttribute("cType",ctype);
            }
            System.out.println("-----------cardtype="+cardtype);
            PageBean pageList = new PageBean(list1, curPage, pageSize);
            List cardlists = (List)pageList.getData();
            int pageCount = pageList.getPageCount();
            request.removeAttribute("cardlists");
            request.setAttribute("cardlists", cardlists);
            request.setAttribute("pageCount", String.valueOf(pageCount));
            request.setAttribute("curPage", String.valueOf(curPage));

            if(list1.size() <= 0)
            {
                request.setAttribute("errormsg", MSFmessage.getMessage(2001));
                return mapping.findForward("failure");
            }

            RegionHandleDAO regionHandleDAO2 = new RegionHandleDAO();
            List regionlists = (ArrayList)regionHandleDAO2.selectRegion();
            request.removeAttribute("regionlists");
            request.setAttribute("regionlists", regionlists);
        }
        catch(HibernateException e2)
        {
            e2.printStackTrace();
        }
        //return mapping.findForward("card");
        return mapping.findForward(cardtype);
    }

    public ActionForward selectbyid(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
        String cid = request.getParameter("cid");
        CardHandleDAO cardHandleDAO = new CardHandleDAO();
        Card card = cardHandleDAO.selectbyid(cid);
        request.setAttribute("card", card);
        return mapping.findForward("cardupdate");
    }

    public ActionForward delete(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
        CardHandleDAO cardHandleDAO = new CardHandleDAO();
        int curPage = Integer.parseInt(request.getParameter("cur_page"));
        String cid = request.getParameter("cid");

		String ctype = "";
		if(request.getParameter("ctype") == null || request.getParameter("ctype").equals(""))
			ctype = null;
		else
			ctype = request.getParameter("ctype");

        try
        {
            String i = cardHandleDAO.delete(cid);
            if(i.equals("0"))
            {
                request.setAttribute("errormsg", MSFmessage.getMessage(4001));
                return mapping.findForward("failure");
            }
        }
        catch(NumberFormatException e)
        {
            e.printStackTrace();
        }
        HttpSession session = request.getSession();
        session.setAttribute("curPage", String.valueOf(curPage));
        session.setAttribute("cType", ctype);
        return mapping.findForward("carddeleteok");
    }

    public ActionForward selectLast(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
        CardHandleDAO cardHandleDAO = new CardHandleDAO();
        int pageSize = 10;
        int curPage;
        if(request.getParameter("cur_page") == null)
            curPage = 1;
        else
            curPage = Integer.parseInt(request.getParameter("cur_page"));

		HttpSession session = request.getSession();
		String ctype = "";
		String cardtype = "card";
		if(session.getAttribute("cType") == null || session.getAttribute("cType").equals(""))
			ctype = null;
		else
			ctype = (String)session.getAttribute("cType");

		System.out.println("==================cType="+ctype);

		List list1 = null;
        try
        {
            if(ctype == null || ctype.equals(""))
            {
            	cardtype = "card";
            	list1 = (ArrayList)cardHandleDAO.selectCard();
            	session.removeAttribute("cType");
            }else{
            	cardtype = "card" + ctype;
            	list1 = (ArrayList)cardHandleDAO.selectCardBytype(ctype); //"B");
            	session.setAttribute("cType",ctype);
            }
            PageBean pageList_ = new PageBean(list1, curPage, pageSize);
            int pageCount = pageList_.getPageCount();
            PageBean pageList = new PageBean(list1, pageCount, pageSize);
            List cardlists = (List)pageList.getData();
            if(list1 == null)
            {
                request.setAttribute("errormsg", MSFmessage.getMessage(2001));
                return mapping.findForward("failure");
            }
            request.removeAttribute("cardlists");
            request.setAttribute("cardlists", cardlists);
            request.setAttribute("pageCount", String.valueOf(pageCount));
            request.setAttribute("curPage", String.valueOf(pageCount));

            RegionHandleDAO regionHandleDAO2 = new RegionHandleDAO();
            List regionlists = (ArrayList)regionHandleDAO2.selectRegion();
            request.removeAttribute("regionlists");
            request.setAttribute("regionlists", regionlists);
        }
        catch(HibernateException e2)
        {
            e2.printStackTrace();
        }
        //return mapping.findForward("card");
        return mapping.findForward(cardtype);
    }

    public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response)
    {
        String cid = request.getParameter("CId");
        System.out.println("---------------------CardAction: Card.update---------------------");
        String cName2 = request.getParameter("CName2");
        String longitude2 = request.getParameter("Longitude2");
        String latitude2 = request.getParameter("Latitude2");
        String err2 = request.getParameter("Err2");
        String place2 = request.getParameter("Place2");
        //System.out.println("--"+cid+"\t"+cName2+"\t"+longitude2+"\t"+latitude2+"\t"+err2+"\t"+place2);
        CardHandleDAO cardHandleDAO2 = new CardHandleDAO();
        Card card = cardHandleDAO2.selectbyid(cid);
        card.setCName(cName2);
        card.setLongitude(new Float(longitude2));
        card.setLatitude(new Float(latitude2));
        card.setErr(new Integer(err2));
        card.setPlace(place2);
        CardHandleDAO cardHandleDAO = new CardHandleDAO();
        cardHandleDAO.update(card);
        return null;
    }
}