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


  public biao6(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[10][3]+"\t"+
        data[11][3]+"\t"+
        data[12][3]+"\t"+
        data[13][3]+"\t"+
        data[14][3]+"\t"+
        data[15][3]+"\t"+
        data[16][3]+"\t"+
        ""+"\t"+
        data[18][3]+"\t"+
        data[19][3]+"\t"+
        data[20][3]+"\t"+
        data[21][3]+"\t"+
        data[22][3]+"\t"+
        data[23][3]+"\t"+
        data[10][6]+"\t"+
        data[11][6]+"\t"+
        data[12][6]+"\t"+
        data[13][6]+"\t"+
        data[14][6]+"\t"+
        data[15][6]+"\t"+
        data[16][6]+"\t"+
        data[17][6]+"\t"+
        data[18][6]+"\t"+
        data[19][6]+"\t"+
        data[20][6]+"\t"+
        data[21][6]+"\t"+
        data[22][6]+"\t"+
        data[23][6]+"\t"

;
  }
  public static void main(String[] args) {
    biao6 biao6 = new biao6();
//    biao6.setSheet("H:\\数据备份\\全省汇总表格\\各县区表格\\安庆市\\枞阳县\\乡（镇）、建制村基本情况汇总表.XLS","Sheet1");
//    biao6.read();
    System.out.println(biao6.getContent("H:\\数据备份\\全省汇总表格\\各县区表格","安庆市","枞阳县"));
  }
}