/**
* execl数据格式的转换
*
* @param cell
* @return
*/
public String publicExcel(Cell cell) {
String value = null;
switch (cell.getCellType()) {
case Cell.CELL_TYPE_NUMERIC:
value = "" + cell.getNumericCellValue();
break;
case Cell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BLANK:
;
break;
default:
}
return value;
}
/***
*
* 取得Workbook对象(xls和xlsx对象不同,不过都是Workbook的实现类)
* xls:HSSFWorkbook
* xlsx:XSSFWorkbook
* @param filePath
* @return
* @throws IOException
* @author fangke
*/
private Workbook getWorkbook(String filePath,String fileName) throws IOException {
Workbook workbook = null;
InputStream is = new FileInputStream(filePath);
if (fileName.endsWith("xls")) {
workbook = new HSSFWorkbook(is);
} else if (fileName.endsWith("xlsx")) {
workbook = new XSSFWorkbook(is);
}
return workbook;
}
/**
* 该方法是利用poi对导入的excel,进去解析读取和写入数据库
* @param fileName
* @param filePath
* @throws Exception
* @author fangke
*/
public void importExcel(String fileName, String filePath) throws Exception {
Workbook workbook = getWorkbook(filePath, fileName);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn = DriverManager.getConnection(url, "zj7", "zj7");
conn.setAutoCommit(false);// 取消自动提交
S
* execl数据格式的转换
*
* @param cell
* @return
*/
public String publicExcel(Cell cell) {
String value = null;
switch (cell.getCellType()) {
case Cell.CELL_TYPE_NUMERIC:
value = "" + cell.getNumericCellValue();
break;
case Cell.CELL_TYPE_STRING:
value = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_BLANK:
;
break;
default:
}
return value;
}
/***
*
* 取得Workbook对象(xls和xlsx对象不同,不过都是Workbook的实现类)
* xls:HSSFWorkbook
* xlsx:XSSFWorkbook
* @param filePath
* @return
* @throws IOException
* @author fangke
*/
private Workbook getWorkbook(String filePath,String fileName) throws IOException {
Workbook workbook = null;
InputStream is = new FileInputStream(filePath);
if (fileName.endsWith("xls")) {
workbook = new HSSFWorkbook(is);
} else if (fileName.endsWith("xlsx")) {
workbook = new XSSFWorkbook(is);
}
return workbook;
}
/**
* 该方法是利用poi对导入的excel,进去解析读取和写入数据库
* @param fileName
* @param filePath
* @throws Exception
* @author fangke
*/
public void importExcel(String fileName, String filePath) throws Exception {
Workbook workbook = getWorkbook(filePath, fileName);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
Connection conn = DriverManager.getConnection(url, "zj7", "zj7");
conn.setAutoCommit(false);// 取消自动提交
S