testpoi.java

java生成图形验证码源代码

package com.poi;


import java.io.FileInputStream;
import java.io.InputStream;
import java.io.RandomAccessFile;
import java.text.SimpleDateFormat;
import java.util.Date;

/*import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
*/
public class TestPOI {/*
    public static void main(String[] args) {
    	//File file=new File("E:\\12580文档\\酒店查询需求\\5月29日全国酒店名单.xls");
    	//BufferedReader br = new BufferedReader(new FileReader(file));
    	try {
    //	InputStream xmls=new FileInputStream("E:\\12580文档\\酒店查询\\5月29日全国酒店名单.xls");测试EXCEL.xls
    		InputStream xmls=new FileInputStream("D:\\测试EXCEL.xls");
    	HSSFWorkbook wb = new HSSFWorkbook(xmls);
    	HSSFSheet sheet = wb.getSheetAt(0);       // 第一个工作表
    	HSSFRow row  =null;
    	HSSFCell cell=null;
    	int rowCount = sheet.getPhysicalNumberOfRows();
    	int colCount = sheet.getRow(0).getPhysicalNumberOfCells();
        System.out.println(" rowCount :"+rowCount+" colCount :"+colCount);
         RandomAccessFile rf = new  RandomAccessFile("E:\\12580文档\\酒店查询\\"+getSystemDate()+".log","rw");
		  rf.seek(rf.length());
		  StringBuffer buf=null;
		  String temp=null;
		  byte[] byt = null;
    	for(int i=0;i<rowCount;i++) {
    	  row     = sheet.getRow(i);        // 第三行
      	System.out.print(i+"|");
      	buf=new StringBuffer();
      	buf.append("");
    	  for(int j=0;j<colCount;j++) {
    		  System.out.println(row);
    	  cell   = row.getCell((short)j);  // 第四个单元格
    	  System.out.println(cell);
    	//System.out.print(cell.getStringCellValue()+" ");

    	if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
    		temp=cell.getStringCellValue().replaceAll("\n", "");
    		buf.append(temp+"|");
    		System.out.print( temp+"|");
    	} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
    		  temp=cell.getNumericCellValue()+"";
    		buf.append(temp+"|");
    		System.out.print(temp+"|");
    	} else   {
    		buf.append("|");
    		System.out.print("|");
    	}
    	  }
    	  buf.append("\n");
    	  byt=buf.toString().getBytes();
    	 // rf.write(byt);
    	  System.out.println("");
    	}
    	//if(rf!=null)rf.close();
    	}catch(Exception e) {
    		e.printStackTrace();
    	} 
    }
    
    public static String getSystemDate() {
		SimpleDateFormat s = new SimpleDateFormat("yyyyMMdd");
		return s.format(new Date());
	}
*/}