com.heitaox.sql.executor.source.file

类 ExcelUtil

java.lang.Object

com.heitaox.sql.executor.source.file.ExcelUtil

public class ExcelUtil
extends Object

构造器概要

构造器

构造器和说明
ExcelUtil()

方法概要

限定符和类型	方法和说明
static int	appendValue2003(List<Map<String,Object>> valueList, String filePath, String tableName)
static int	appendValue2007(List<Map<String,Object>> valueList, String filePath, String tableName)
static int	appendValueCsv(List<List<Object>> lines, String filePath)
static int	deleteValue2003(List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)
static int	deleteValue2007(List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)
static int	deleteValueCsv(List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)
static String	getSuffix(String filePath)
static List<Map<String,String>>	readExcel(String filePath) 读取excel
static String	readExcelHead(String filePath)
static int	updateValue2003(Map<String,Object> updateItems, List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)
static int	updateValue2007(Map<String,Object> updateItems, List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)
static int	updateValueCsv(Map<String,Object> updateItems, List<PredicateEntity<Object>> predicateEntities, String filePath, String tableName)

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

构造器详细资料

ExcelUtil

public ExcelUtil()

方法详细资料

readExcelHead

public static String readExcelHead(String filePath)
                            throws IOException

抛出:

IOException

readExcel

public static List<Map<String,String>> readExcel(String filePath)
                                          throws IOException

读取excel

参数:

filePath - filePath

返回:

List

抛出:

IOException - IOException

getSuffix

public static String getSuffix(String filePath)

updateValue2003

public static int updateValue2003(Map<String,Object> updateItems,
                                  List<PredicateEntity<Object>> predicateEntities,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

deleteValue2007

public static int deleteValue2007(List<PredicateEntity<Object>> predicateEntities,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

deleteValue2003

public static int deleteValue2003(List<PredicateEntity<Object>> predicateEntities,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

updateValue2007

public static int updateValue2007(Map<String,Object> updateItems,
                                  List<PredicateEntity<Object>> predicateEntities,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

appendValue2007

public static int appendValue2007(List<Map<String,Object>> valueList,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

appendValue2003

public static int appendValue2003(List<Map<String,Object>> valueList,
                                  String filePath,
                                  String tableName)
                           throws IOException

抛出:

IOException

appendValueCsv

public static int appendValueCsv(List<List<Object>> lines,
                                 String filePath)
                          throws IOException

抛出:

IOException

updateValueCsv

public static int updateValueCsv(Map<String,Object> updateItems,
                                 List<PredicateEntity<Object>> predicateEntities,
                                 String filePath,
                                 String tableName)
                          throws IOException

抛出:

IOException

deleteValueCsv

public static int deleteValueCsv(List<PredicateEntity<Object>> predicateEntities,
                                 String filePath,
                                 String tableName)
                          throws IOException

抛出:

IOException