diaryaction.java

spring+struts+hibernate做的银行系统

/*
 * Created on 2006-4-19
 *
 * 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.blank.form.DiaryForm;

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.DiaryBean;
import cn.com.tym.table.bean.RegisterBean;
import cn.com.tym.util.tablebean.UtilDiary;


/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class DiaryAction extends DispatchAction{
	
	public ActionForward add(ActionMapping mapping, 
			 ActionForm form,
			 HttpServletRequest request, 
			 HttpServletResponse response){
 
	 
		if (EmployeeLogin.isLogin(request) == 0) {
			return mapping.findForward("logines");
		}
	 
 
			DiaryForm frm=(DiaryForm)form;
  
			 
			String id=((RegisterBean)request.getSession().getAttribute("user")).getRid();	
	    	String PageForward="error";
	   
			  DB db=null; 
			  UtilDiary util=new UtilDiary();
			 
		        try{
				 	ConnPool pool=new ConnPool();
			        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
			        db = new DB(dataSource); 
			        if(util.insert(frm,id,db)){
			    
			        	PageForward="diaryList";
			        } 
		        } 
		        catch(Exception e){ 
		        	e.printStackTrace();
		        	
		        }
		        finally{
		        	db.close();
		        }    
		     
		 return mapping.findForward(PageForward);
	}
	
	
	//ɾ��
/**	
	public ActionForward deleteDiary(ActionMapping mapping, 
			 ActionForm form,
			 HttpServletRequest request, 
			 HttpServletResponse response){
	 

		if (EmployeeLogin.isLogin(request) == 0) {
			return mapping.findForward("login");
		}
	
 
			String diaryId=request.getParameter("articleId");//�õ��ռDZ��ID
		 
	    	String PageForward="errors";

			  DB db=null; 
			  UtilDiary util=new UtilDiary();
		 
		        try{
				 	ConnPool pool=new ConnPool();
			        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
			        db = new DB(dataSource); 
			        if(util.delete(diaryId,db)){
			        	//�ɹ�
			        	PageForward="diaryList";  //�ٵ��Ǹ�ɾ���Ժ���б�ҳ��
			        } 
		        } 
		        catch(Exception e){ 
		        	e.printStackTrace();
		        	//����ͳһ���ش���ҳ�� 
		        }
		        finally{
		        	db.close();
		        }    
		     
		 return mapping.findForward(PageForward);
	}
	*/
	
	//�޸�ҳ��
	/**
	public ActionForward makeDiary(ActionMapping mapping, 
			 ActionForm form,
			 HttpServletRequest request, 
			 HttpServletResponse response){
	 

		String articleId=request.getParameter("articleId");
		 
		String PageForward="errors"; 
		ArrayList arraylist=new ArrayList();	
		UtilDiary util=new UtilDiary();
		DB db=null;
		try{
		ConnPool pool=new ConnPool();
		DataSource dataSource=pool.Tomcat_JDBC_DataSource();
		db = new DB(dataSource);

		DiaryBean bean=util.seeLock(articleId,db); ;
		request.setAttribute(Constants.DIARYONE,bean);
		 
		PageForward="makeDiaryPage";
		}
		catch(Exception e){
		e.printStackTrace();
//		����ͳһ���ش���ҳ��

		}
		finally{
		db.close();
		db=null;
		}
		return mapping.findForward(PageForward);

	}
 
	public ActionForward diaryPage(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 PageForward="errors"; 
	    ArrayList arraylist=new ArrayList();	
	    
	    UtilDiary util=new UtilDiary();
  
	   
	   DB db=null;
	   try{
		 	ConnPool pool=new ConnPool();
	        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
	        db = new DB(dataSource);
	    
	     
     
	        arraylist=util.diaryAll(request,id,db);
	        request.setAttribute(Constants.DIARYLIST,arraylist);
 
	       	PageForward="viewDiary";

	       }  
	   catch(Exception e){ 
        	e.printStackTrace(); 
        }
        finally{
        	db.close();
        }    
     
 return mapping.findForward(PageForward);
}
	
 */


//��һ���ռDZ��ͳ���һ��
public ActionForward Chice(ActionMapping mapping, 
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) throws Exception {
//TODO Auto-generated method stub

String articleId=request.getParameter("articleId");
 
String PageForward="errors"; 
ArrayList arraylist=new ArrayList();	
UtilDiary util=new UtilDiary();
DB db=null;
try{
ConnPool pool=new ConnPool();
DataSource dataSource=pool.Tomcat_JDBC_DataSource();
db = new DB(dataSource);

DiaryBean bean=util.seeLock(articleId,db); ;
request.setAttribute(Constants.DIARYONE,bean);
 
PageForward="DiaryOnesss";
}
catch(Exception e){
e.printStackTrace();
//����ͳһ���ش���ҳ��

}
finally{
db.close();
db=null;
}
return mapping.findForward(PageForward);

}

  	//�修改日记
public ActionForward submitMake(ActionMapping mapping, 
		 ActionForm form,
		 HttpServletRequest request, 
		 HttpServletResponse response){


	if (EmployeeLogin.isLogin(request) == 0) {
		return mapping.findForward("logines");
	}
	 System.out.println("#####YYYYYYYYYYYYYYYYYYYYYYYYY");
		DiaryForm frm=(DiaryForm)form;
		String id=((RegisterBean)request.getSession().getAttribute("user")).getRid();	
		String PageForward="error";
 
		  DB db=null; 
		  UtilDiary util=new UtilDiary();
 
	        try{
			 	ConnPool pool=new ConnPool();
		        DataSource dataSource=pool.Tomcat_JDBC_DataSource();
		        
		        System.out.println("dd="+frm.getDiaryId()+frm.getDiaryTime()+frm.getLock()+frm.getContent()+frm.getMainTitle());
		        db = new DB(dataSource); 
		        if(util.ismake(frm,db)){  
		        	PageForward="diaryList";
		        } 
	        } 
	        catch(Exception e){ 
	        	e.printStackTrace(); 
	         
	        }
	        finally{
	        	db.close();
	        	db=null;
	        }    
	     
	 return mapping.findForward(PageForward);
}
}