读取excel中数据存到oracle中

注意点:1.代码复制很多爆红,相关jar包没导入

            2.此方法适用高版本的excel(.xlsx结尾),低版本的换成HSSFWorkbook即可

public class UpdateDBByExcel {

	public static void main(String[] args) {
		PreparedStatement pre =null;
		Connection con = null;
		File file = new File("C:\\Users\\wjw\\Desktop\\aaa.xlsx");
		try {
			Class.forName("oracle.jdbc.OracleDriver");
			con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "system", "Wangwen8");
			pre= con.prepareStatement("insert into PERSON_TEST t(t.name,t.pid) values(?,?)");
			
			XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(file));
			XSSFSheet sheet = workbook.getSheetAt(0);
			//获取sheet中最后一行行号      行从0开始,列从1
			int rowNum = sheet.getLastRowNum();
			for (int i = 0; i <= rowNum; i++) {
				XSSFRow