POI를 사용한 엑셀파일 로딩 및 DB저장

목차

없음

본문내용

package techDsc;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import techDsc.charset.CharSetConvert;
import techDsc.dao.ConnectionManager;
public class HSSFTest
{
public static ConnectionManager connManager;
public static void main(String[] argv) throws FileNotFoundException, IOException, SQLException
{
String sql = "";
PreparedStatement insertPstmt = null;
HSSFTest hssf = new HSSFTest();

키워드

POI,   EXCEL,   DB