biao7.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 biao7
    extends ReadFile {
  public String[][] data = new String[30][7];
  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 biao7() {
    for(int i=0; i< data.length; i++){
       for(int j=0; j< data[i].length; j++){
         data[i][j] = "";
       }
     }
   }


  public biao7(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=0;i<data.length;i++){
      for(int j=0; j < data[i].length; j++){
        result += "data["+i+"]["+j+"]"+data[i][j]+"\n";
      }
    }
    return

        data[8][5]+"\t"+
        data[9][5]+"\t"+
        data[10][5]+"\t"+
        data[11][5]+"\t"+
        data[12][5]+"\t"+
        data[13][5]+"\t"+
        data[14][5]+"\t"+
        data[15][5]+"\t"+
        data[16][5]+"\t"+
        data[17][5]+"\t"+
        data[18][5]+"\t"
;
  }
  public static void main(String[] args) {
    biao7 biao7 = new biao7();
//    biao6.setSheet("H:\\数据备份\\全省汇总表格\\各县区表格\\安庆市\\枞阳县\\乡（镇）、建制村基本情况汇总表.XLS","Sheet1");
//    biao6.read();
    System.out.println(biao7.getContent("H:\\数据备份\\全省汇总表格\\各县区表格","安庆市","枞阳县"));
  }
}