xiaolong889916的专栏

使用runtime， 实现java客户端多次调用linux命令或者shell脚本，并返回对应结果或信息

java用ssh2远程登录到服务器的jar包

import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.util.ArrayList; import java.util.List; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; public class test { private Workbook workbook = null; /** * 读取excel资源路径 * @param excelFile * @throws FileNotFoundException * @throws IOException */ public test (File excelFile){ try { workbook = new XSSFWorkbook(new FileInputStream(excelFile)); } catch (Exception ex) { try { workbook = new HSSFWorkbook(new FileInputStream(excelFile)); } catch (FileNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } /** * 获得单元个中的内容 * @param cell * @return */ protected Object getCellString(Cell cell ){ Object result=null; if(cell!=null){ int cellType=cell.getCellType(); switch(cellType){ case HSSFCell.CELL_TYPE_STRING: result=cell.getRichStringCellValue().getString(); break; case HSSFCell.CELL_TYPE_NUMERIC: result=cell.getNumericCellValue(); break; case HSSFCell.CELL_TYPE_FORMULA: result=cell.getNumericCellValue(); break; case HSSFCell.CELL_TYPE_ERROR: result=null; break; case HSSFCell.CELL_TYPE_BOOLEAN: result=cell.getBooleanCellValue(); break; case HSSFCell.CELL_TYPE_BLANK: result=null; break; } } return result; } /** * * @param sheetNo * @return */ public List<List>getDataSheet(int sheetNo){ List<List> result=new ArrayList(); try { //获取制定的表 Sheet sheet=workbook.getSheetAt(sheetNo); //获取数据总行数 int rowCount=sheet.getLastRowNum(); if(rowCount<1){ return result; } //逐行读取数据 for(int line=0;line<rowCount;line++){ Row row=sheet.getRow(line); if(row!=null){ List<Object> rowData=new ArrayList<Object>(); //获取本行单元个的个数 int columnCount=row.getLastCellNum(); for(short col=0;col<columnCount;col++){ Cell cel=row.getCell(col); //获取指定单元格数据 Object cell=this.getCellString(cel); rowData.add(cell); } result.add(rowData); } } } catch (RuntimeException e) { e.printStackTrace(); System.out.print("逐行读取数据错误！"); } return result; } public Workbook getWorkbook() { return workbook; } public void setWorkbook(Workbook workbook) { this.workbook = workbook; } public static void main(String[] args){ try { File file=new File("E:\\11.xlsx"); test parser=new test(file); List<List> datas=parser.getDataSheet(0); for(int i=0;i<datas.size();i++){ List row=datas.get(i); for(short n=0;n<row.size();n++){ Object value=row.get(n); String data=String.valueOf(value); System.out.print(data+"\t"); } System.out.println(); } } catch (RuntimeException e) { // TODO Auto-generated catch block e.printStackTrace(); } // } }