biao10.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

package net.aetherial.gis.jiaotongbu.biaoGeHuiZong;

import jxl.*;
import net.aetherial.gis.our.duibi.readXLS.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class biao10
    extends ReadFile {
  public String[][] data = new String[30][8];
  static String fileName = "农村公路隧道、渡口、涵洞汇总表.XLS";
  public void read() {
    for (int i = 0; i < data.length; i++) {
      moveNext();

      for (int j = 0; j < data[i].length; j++) {
        if (rowData != null) {
          data[i][j] = rowData[j].getContents().trim();
        }
      }
    }

  }

  public biao10() {
    for(int i=0; i< data.length; i++){
       for(int j=0; j< data[i].length; j++){
         data[i][j] = "";
       }
     }
   }


  public biao10(Sheet sheet) {
    super(sheet);
  }

  public void setSheet(String fileName, String sheetName) {
    super.setSheet(fileName, sheetName);
//    setSourceFile(fileName);
  }
  public String getContent(String base, String shi, String xian){

    try{
      java.io.FileInputStream fi = new java.io.FileInputStream(new java.io.File(base+"\\"+shi+"\\"+xian+"\\"+fileName));
    }catch(Exception e){
      return "";
    }
    setSheet(base+"\\"+shi+"\\"+xian+"\\"+fileName,"Sheet1");

    read();
    return toString();

  }
  public String toString(){
    String result = "";
    for(int i=9;i<20;i++){
      for(int j=3; j < 8; j++){
        result += data[i][j]+"\t";
      }
    }
    return result
;
  }
  public static void main(String[] args) {
    biao10 biao10 = new biao10();
//    biao6.setSheet("H:\\数据备份\\全省汇总表格\\各县区表格\\安庆市\\枞阳县\\乡（镇）、建制村基本情况汇总表.XLS","Sheet1");
//    biao6.read();
    System.out.println(biao10.getContent("H:\\数据备份\\全省汇总表格\\各县区表格","安庆市","枞阳县"));
  }
}