favoriteaction.java

spring+struts+hibernate做的银行系统

/*
 * Created on 2006-4-14
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.tym.blank.action;


import java.util.ArrayList;


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;

import cn.com.tym.pub.ConnPool;
import cn.com.tym.pub.Constants;
import cn.com.tym.pub.DB;
import cn.com.tym.pub.EmployeeLogin;

import cn.com.tym.table.bean.FavoriteBean;
import cn.com.tym.table.bean.RegisterBean;

import cn.com.tym.util.tablebean.UtilFavorite;

import cn.com.tym.util.text.ExchangeInput;

/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class FavoriteAction extends DispatchAction{

	  public ActionForward addFavorite(ActionMapping mapping,
  			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response){
	  	
		 
		if (EmployeeLogin.isLogin(request) == 0) {
			return mapping.findForward("login");
		}
 	
		
  		String PageForward="errors";
  		String id=((RegisterBean)request.getSession().getAttribute("user")).getRid();
 
	  	String articleId=request.getParameter("articleId");

	  		UtilFavorite util=new UtilFavorite();
	  	    try{
			 	ConnPool pool=new ConnPool();
		        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
		        DB db = new DB(dataSource);
		    
		        
		        //���ж��Ƿ����ղ�
		        if(util.checkArticleId(articleId,id,db)){
 
				      if(util.insert(articleId,id,db))
				      {
				      	PageForward="favoriteSuccess";
				      } 
		        }  
		        else
		        { 
 
		        
		    	PageForward="favoriteclub";
		        }
	  	    }
	  	    catch(Exception e){
	  	    	 PageForward="fail";
	  	    	e.printStackTrace();
	  	    }
	  	  	return mapping.findForward(PageForward);
	  }	  
	  
	  	//�ҵ��ղ��б�
		public ActionForward  favoriteList(ActionMapping mapping, 
				 ActionForm form,
				 HttpServletRequest request, 
				 HttpServletResponse response){
			   System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$");
			if (EmployeeLogin.isLogin(request) == 0) {
				return mapping.findForward("login");
			} 
			String id=((RegisterBean)request.getSession().getAttribute("user")).getRid();
			String mmId=request.getParameter("mmId");
	      	String PageForward="error";
	        System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$");
	      			DB db=null;
				  UtilFavorite util=new UtilFavorite(); // ҵ���߼� 
				  	
				  FavoriteBean bean=new FavoriteBean(); //ֵ����
 	 
			        try{
					 	ConnPool pool=new ConnPool();
				        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
				        db = new DB(dataSource);
				        
				     ArrayList arraylist=util.getFavoriteList(request,db,ExchangeInput.StringToInt(mmId));
				     System.out.println("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$");
				        request.setAttribute(Constants.SUBJECTLIST,arraylist);   
				        request.setAttribute("mmId",mmId);
				        PageForward="favoritePage"; 
			        } 
			        catch(Exception e){
			        
			        	e.printStackTrace();
			        	 
			        	PageForward="fail";
			        }
			        finally{
			        	db.close();
			        }
			 return mapping.findForward(PageForward);
		}
		
		public ActionForward  delFavorite(ActionMapping mapping, 
				 ActionForm form,
				 HttpServletRequest request, 
				 HttpServletResponse response){

			if (EmployeeLogin.isLogin(request) == 0) {
				return mapping.findForward("login");
			}
	 	
			
			String id=((RegisterBean)request.getSession().getAttribute("user")).getRid();
			 String articleId=request.getParameter("articleId");
			 
	      	String PageForward="error"; 
	      			DB db=null;
				  UtilFavorite util=new UtilFavorite(); // ҵ���߼� 
				  	
				  FavoriteBean bean=new FavoriteBean(); //ֵ����
	 
			        try{
					 	ConnPool pool=new ConnPool();
				        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
				        db = new DB(dataSource);
				        
				      boolean check=util.isDel(articleId,id,db);
				      
				      if(check){ 
				        PageForward="favoriteList"; 
				      }
			        } 
			        catch(Exception e){
			        
			        	e.printStackTrace();
			        	//����ͳһ���ش���ҳ��
			        	PageForward="fail";
			        }
			        finally{
			        	db.close();
			        }
			 return mapping.findForward(PageForward);
		}
}