seven.ExcelFactory Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of ExcelReads Show documentation
A ExcelReads Utils By Seven
There is a newer version: 1.0.4
package seven;

import seven.callBack.PackageDataInterface;
import seven.savewapper.SaveExcel;
import seven.savewapper.wapperRef.sysWppers.ResExportDBMap;
import seven.savewapper.wapperRef.sysWppers.ResExportDBObj;
import seven.savewapper.wapperRef.sysWppers.ResExportMap;
import seven.savewapper.wapperRef.sysWppers.ResExportObj;
import seven.wapperInt.Wrapper;
import seven.wapperInt.wapperRef.WrapperObj;

import java.sql.ResultSet;
import java.util.List;
import java.util.Map;


//=======================================================
//		          .----.
//		       _.'__    `.
//		   .--(^)(^^)---/#\
//		 .' @          /###\
//		 :         ,   #####
//		  `-..__.-' _.-\###/
//		        `;_:    `"'
//		      .'"""""`.
//		     /,  ya ,\\
//		    //狗神保佑  \\
//		    `-._______.-'
//		    ___`. | .'___
//		   (______|______)
//=======================================================
/**
 * @author Seven
 * date 2016年6月4日-下午4:08:19
 */
@SuppressWarnings("all")
public class ExcelFactory {

    private ExcelFactory() {
    }

    /**
     * 读取Excel
     * @param FilePath 路径
     * @param r        包装类
     * @return Wrapper
     * @throws Exception
     */
    public static  Wrapper getBeans(String FilePath, WrapperObj r) throws Exception {
        return r.init(FilePath);
    }

    /**
     * 保存Excel
     *
     * @param bean
     * @param FilePath
     * @return SaveExcel
     * @throws Exception
     */
    public static   SaveExcel saveExcel(List bean, String FilePath) throws Exception {
        if (bean.size() < 1) {
            throw new Exception("请传入数据");
        }
        if (bean.get(0) instanceof Map) {
            return (SaveExcel) new ResExportMap((List)bean, FilePath);
        }
        return new ResExportObj(bean, FilePath);
    }

    /**
     * 保存Excel
     *
     * @param bean
     * @return SaveExcel
     * @throws Exception
     */
    public static SaveExcel saveExcel(List bean) throws Exception {
        if (bean.size() < 1) {
            throw new Exception("请传入数据");
        }
        if (bean.get(0) instanceof Map) {
            return new ResExportMap((List) bean);
        }
        return new ResExportObj((List) bean);
    }


    /**
     * 保存Excel
     *
     * @param resultSet
     * @param FilePath
     * @return SaveExcel
     * @throws Exception
     */
    public static SaveExcel saveExcel(ResultSet resultSet, String FilePath) throws Exception {
        return new ResExportDBMap(resultSet, FilePath);
    }

    /**
     * 保存Excel
     *
     * @param resultSet
     * @param FilePath
     * @param packageDataInterface
     * @return SaveExcel
     * @throws Exception
     */
    public static SaveExcel saveExcel(ResultSet resultSet, String FilePath, PackageDataInterface packageDataInterface) throws Exception {
        return new ResExportDBObj(resultSet, FilePath, packageDataInterface);
    }

    /**
     * 保存Excel
     *
     * @param resultSet
     * @param type
     * @return SaveExcel
     * @throws Exception
     */
    public static SaveExcel saveExcel(ResultSet resultSet, Class type) throws Exception {
        return new ResExportDBObj(resultSet, type);
    }


    /**
     * 保存Excel
     *
     * @param resultSet
     * @return SaveExcel
     * @throws Exception
     */
    public static SaveExcel saveExcel(ResultSet resultSet) throws Exception {
        return new ResExportDBMap(resultSet);
    }
}