Java 实现导入excel

GetConnection getcontent = new GetConnection();
Connection conn = null;
try {
InputStream is = new FileInputStream(“f:/shop20180808.xls”);
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(is);

		HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(0);  
		
		conn = getcontent.getConnection();
		for (int rowNum = 1; rowNum <= hssfSheet.getLastRowNum(); rowNum++) {  
			HSSFRow hssfRow = hssfSheet.getRow(rowNum);   
			  
			String onename = hssfRow.getCell(0).getStringCellValue();  
			//String.valueOf(hssfRow.getCell(1).getNumericCellValue())
			String onenumber =hssfRow.getCell(1).getStringCellValue();  
			String twoname = hssfRow.getCell(2).getStringCellValue();  
			String twonumber = hssfRow.getCell(3).getStringCellValue();  
			String threename = hssfRow.getCell(4).getStringCellValue();  
			String threenumber = hssfRow.getCell(5).getStringCellValue();  
			String bz = hssfRow.getCell(6).getStringCellValue(); 
			String sql="insert into wz_goodclassexcel(onename,onenumber,twoname,twonumber,threename,threenumber,bz) values('"+onename+"','"+onenumber+"','"+twoname+"','"+twonumber+"','"+threename+"','"+threenumber+"','"+bz+"')";
		
			Statement st=conn.createStatement();
			st.executeUpdate(sql);	
			st.close();			    
		} 
		
	} catch (FileNotFoundException e) {  
		// TODO Auto-generated catch block  
		e.printStackTrace();  
	} catch (IOException e) {  
		// TODO Auto-generated catch block  
		e.printStackTrace();  
	} catch (SQLException e) {
		
		e.printStackTrace();
	} finally {
		try {
			conn.close();
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
	}