c042a697d82f001d15b3d293b7672d16

客户关系管理系统主要管理新老客户的一些信息并可以发现潜在客户

/**
 * 
 */
package edu.qdxy.jsp.action;

import java.util.List;

import edu.qdxy.jsp.dao.JdbcUtils;
import edu.qdxy.jsp.dao.StorageDAO;
import edu.qdxy.jsp.model.Storage;

/**
 * @author user
 *
 */
public class StorageAction extends BaseAction {
	private StorageDAO dao = new StorageDAO();
	private Storage storage;
	
	public void setStorage(Storage storage){
		this.storage = storage;
	}
	
	/**
	 * 
	 */
	public void edit(){
		try{
			if( storage.getId()!=null ){
				storage = dao.findById(storage.getId());
				request.setAttribute("storage", storage);
			}else{
				request.setAttribute("storage", storage);
			}
			JdbcUtils.commitTransaction();			//事务提交
		}catch(Exception e){
			e.printStackTrace();
			JdbcUtils.rollbackTransaction();		//事务回滚
			saveError("检索数据失败！");
		}finally{
//			JdbcUtils.closeCurrentConnection();		//关闭连接
		}
	}

    /**
     * 
     */
    public void save(){
        try{
            if( storage.getId()==null ){
                dao.create(storage);
                saveMessage("创建'"+storage.getProduct()+"'成功！");
            }else{
                dao.update(storage);
                saveMessage("更新'"+storage.getProduct()+"'成功");
            }
            
            JdbcUtils.commitTransaction();              //提交事务
        }catch( Exception e ){
            e.printStackTrace();
            JdbcUtils.rollbackTransaction();            //事务回滚
            saveError("保存'"+storage.getProduct()+"'失败");
        }finally{
//            JdbcUtils.closeCurrentConnection();         //关闭Connection
        }
    }

    /**
     *
     */
    public void delete(){
        try{
            if( storage.getId()!=null ){
                dao.delete(storage.getId());
                saveMessage("删除成功！");
            }
            JdbcUtils.commitTransaction();              //提交事务
        }catch( Exception e ){
            e.printStackTrace();
            JdbcUtils.rollbackTransaction();            //事务回滚
            saveError("删除'"+storage.getProduct()+"'失败");
        }finally{
//            JdbcUtils.closeCurrentConnection();         //关闭Connection
        }
    }

    /**
     * 
     */
    public List<Storage> findAll(){
        List<Storage> list = null;
        try{ 
            list = dao.findAll();
            request.setAttribute("storages", list);
            JdbcUtils.commitTransaction();              //提交事务
        }catch( Exception e ){
            e.printStackTrace();
            JdbcUtils.rollbackTransaction();            //事务回滚
            saveError("检索'"+storage.getProduct()+"'失败");
        }finally{
            JdbcUtils.closeCurrentConnection();         //关闭Connection
        }
        return list;
    }

    /**
     * 
     */
    public List<Storage> list(){
        List<Storage> list = null;
        try{ 
            list = dao.list(storage);
            request.setAttribute("storages", list);
            JdbcUtils.commitTransaction();              //提交事务
        }catch( Exception e ){
            e.printStackTrace();
            JdbcUtils.rollbackTransaction();            //事务回滚
            saveError("检索'"+storage.getProduct()+"'失败");
        }finally{
            JdbcUtils.closeCurrentConnection();         //关闭Connection
        }
        return list;
    }
}