tableting.java

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

package net.aetherial.gis.table;

import java.io.FileInputStream;
import java.io.File;
import net.aetherial.gis.surface.CreateFile;
import net.aetherial.gis.surface.ItemValue;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2004</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TableTing {
  private String head = "";
  private String top = "";
  private String end = "";
  //最大20行
  //开始的表格
  private String datarow1 = "";
  private String datarow2 = "";
  private String nullrow1 = "";
  private String nullrow2 = "";


  /**
   * 陶主任后来让改的表格
   */
  private String xiangrow = "";
  private String datarow = "";
  private String excelString ="";
  private boolean lastRow = false;
  public final int rowNum = 20;
  private int rowCount =1;
  public TableTing(String biaoge) {
    if (biaoge.equals("老表格")) {
      this.getFileString();
    }else if(biaoge.equals("统计表格")){
      this.getFileString_tongji();
    }

  }

  private void methodSetHead(){
    this.excelString = this.head;
  }

  private void methodMovenext(){
    if(this.rowCount%20 == 0){
      this.methodSetLastRow(true);
    }else{
      this.methodSetLastRow(false);
    }
    if(!this.lastRow){
      this.excelString = this.excelString + this.datarow1;
    }else{
      this.excelString = this.excelString + this.datarow2;
    }
    this.rowCount ++;
  }

  private void methodMovenextNull(){
    if(this.rowCount%20 == 0){
      this.methodSetLastRow(true);
    }else{
      this.methodSetLastRow(false);
    }
    if(!this.lastRow){
      this.excelString = this.excelString + this.nullrow1;
    }else{
      this.excelString = this.excelString + this.nullrow2;
    }
    this.rowCount ++;
  }

  private void methodSetTop(){
    this.excelString = this.excelString + this.top;
  }

  private void methodSetEnd(){
    this.excelString = this.excelString + this.end;
  }
  private void methodSetLastRow(boolean last){
    this.lastRow = last;
  }
  //top  Excel的抬头部分
  /**
   *  #hrkj_new_danwei# 填报单位
   * #hrkj_new_2# 填报日期：
   * #hrkj_new_1# 乡镇
   *
   */
  public String getTDanWei(String string,String danwei){
     return string.replaceAll("#hrkj1#",danwei);
   }
   public String getTDanWeiNew(String string,String danwei){
     return string.replaceAll("#hrkj_new_danwei#",danwei);
   }

   public String getTShi(String string,String shi){
     return string.replaceAll("#hrkj2#",shi);
   }
   public String getTXian(String string,String xian){
     return string.replaceAll("#hrkj3#",xian);
   }
   public String getTXiang(String string,String xiang){
     return string.replaceAll("#hrkj4#",xiang);
   }
   public String getTDate(String string,String date){
     return string.replaceAll("#hrkj5#",date);
   }
   public String getTDateNew(String string,String date){
     return string.replaceAll("#hrkj_new_2#",date);
   }
   public String getTXiangzhen(String string,String xiangzhen){
     return string.replaceAll("#hrkj_new_1#",xiangzhen);
   }


   public String getT_licheng(String string,String licheng){
     return string.replaceAll("#hrkj8_licheng#",licheng);
   }

   public String getTYe(String string,String ye){
     return string.replaceAll("#hrkj6#",ye);
   }
   public String getTYeCount(String string,String yeCount){
     return string.replaceAll("#hrkj7_YeCount#",yeCount);
  }
  //数据行
  public String getD1_1RoadName(String string,String roadName){

      return string.replaceAll("#hrkj1#", roadName);
  }
  public String getD1_2XZCName(String string,String xzcName){

      return string.replaceAll("#hrkj2#", xzcName);
  }
  public String getD1_3R1Name(String string,String name){

      return string.replaceAll("#hrkj3#", name);
  }
  public String getD1_4R1X(String string,String X){

      return string.replaceAll("#hrkj4#", X);
  }
  public String getD1_5R1Y(String string,String Y){

      return string.replaceAll("#hrkj5#", Y);
  }
  public String getD1_6R2Name(String string,String name){

      return string.replaceAll("#hrkj6#", name);
  }
  public String getD1_7R2X(String string,String X){

      return string.replaceAll("#hrkj7#", X);
  }
  public String getD1_8R2Y(String string,String Y){

      return string.replaceAll("#hrkj8#", Y);
  }
  public String getD1_9R3Name(String string,String name){

      return string.replaceAll("#hrkj9#", name);
  }
  public String getD1_10R3X(String string,String X){

      return string.replaceAll("#hrkj10#", X);
  }
  public String getD1_11R3Y(String string,String Y){

      return string.replaceAll("#hrkj11#", Y);
  }
  public String getD1_12R4Name(String string,String name){

      return string.replaceAll("#hrkj12#", name);
  }
  public String getD1_13R4X(String string,String X){

      return string.replaceAll("#hrkj13#", X);
  }
  public String getD1_14R4Y(String string,String Y){

      return string.replaceAll("#hrkj14#", Y);
  }
  public String getD1_15R5Name(String string,String name){


      return string.replaceAll("#hrkj15#", name);
  }
  public String getD1_16R5X(String string,String X){


      return string.replaceAll("#hrkj16#", X);
  }
  public String getD1_17R5Y(String string,String Y){

      return string.replaceAll("#hrkj17#", Y);
  }
  public String getD1_18_licheng(String string,String now){

      return string.replaceAll("#hrkj18#", now);
  }
  public String getD1_19_luji(String string,String now){

      return string.replaceAll("#hrkj19#", now);
  }
  public String getD1_20_lumian(String string,String now){

      return string.replaceAll("#hrkj20#", now);
  }
  public String getD1_21_type(String string,String now){

      return string.replaceAll("#hrkj21#", now);
  }
  public String getD1_22_licheng(String string,String plan){


      return string.replaceAll("#hrkj22#", plan);
  }
  public String getD1_23_luji(String string,String plan){

      return string.replaceAll("#hrkj23#", plan);
  }
  public String getD1_24_lumian(String string,String plan){

      return string.replaceAll("#hrkj24#", plan);

  }
  public String getD1_25_type(String string,String plan){

      return string.replaceAll("#hrkj25#", plan);

  }
  public String getD1_26_invest(String string,String plan){

      return string.replaceAll("#hrkj26#", plan);
  }
  public String getD1_27_start(String string,String plan){

      return string.replaceAll("#hrkj27#", plan);

  }
  public String getD1_28_complete(String string,String plan){


      return string.replaceAll("#hrkj28#", plan);
  }
  public String getD1_29_name(String string,String ganxian){

      return string.replaceAll("#hrkj29#", ganxian);
  }
  public String getD1_30_dis(String string,String ganxian){

      return string.replaceAll("#hrkj30#", ganxian);
  }
  public String getD1_31_renkou(String string,String renkou){

      return string.replaceAll("#hrkj31#", renkou);
  }
  public String getD1_32_shouru(String string,String shouru){

      return string.replaceAll("#hrkj32#", shouru);
  }
  public String getD1_33_jingji(String string,String jingji){

      return string.replaceAll("#hrkj33#", jingji);
  }
  public String getD1_34_beizhu(String string,String beizhu){

      return string.replaceAll("#hrkj34#", beizhu);
  }
  public String getD1_35_buzhu(String string,String buzhu){

      return string.replaceAll("#hrkj_new_1#", buzhu);
  }
  public String getD1_36_xiangzhen(String string,String xiangzhen){

      return string.replaceAll("#hrkj_new_2#", xiangzhen);
  }


  //



  private String readFile(String fileName) {
    String content = "";
    File f = new File(fileName);
    try {
      FileInputStream in = new FileInputStream(f);
      int l =Integer.parseInt(f.length()+"");
      byte[] b = new byte[l];
      if(l>0){
        while (true) {
          if ( in.read(b) == -1) {
            break;
          }
          content = content + (new String(b, "UTF-8"));
        }
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return content;
  }
  private void getFileString(){
    this.head = this.readFile("file\\table\\1head.txt");
    this.top = this.readFile("file\\table\\2top.txt");
    this.datarow1 = this.readFile("file\\table\\31datarow.txt");
    this.datarow2 = this.readFile("file\\table\\32datarow.txt");
    this.nullrow1 = this.readFile("file\\table\\41nullRow.txt");
    this.nullrow2 = this.readFile("file\\table\\42nullRow.txt");
    this.end = this.readFile("file\\table\\5bottom.txt");
  }
  private void getFileString_tongji(){
      this.head = this.readFile("file\\table_tongji\\1head.txt");
      this.top = this.readFile("file\\table_tongji\\2top.txt");
      this.xiangrow = this.readFile("file\\table_tongji\\3xiang.txt");
      this.datarow = this.readFile("file\\table_tongji\\4datarow.txt");
      this.end = this.readFile("file\\table_tongji\\5bottom.txt");
  }

  public void CreateFile(String filePath){
    File f = new File(filePath);
    CreateFile cfWpt = new CreateFile(f);
    cfWpt.setEncode("utf-8");
    cfWpt.memoryToFile(this.excelString);
  }
  public static void main(String test[]){
    TableTing tt = new TableTing("老表格");
    tt.methodSetHead();
    tt.methodSetTop();
    for(int i =0;i<18;i++){
      tt.methodMovenext();
      tt.methodMovenextNull();
    }
    tt.methodMovenext();
    tt.methodSetLastRow(true);
    tt.methodMovenext();
    //tt.methodSetEnd();
    tt.methodSetTop();
    for(int i =0;i<18;i++){
      tt.methodMovenext();
      tt.methodMovenextNull();
    }
    tt.methodMovenext();
    tt.methodSetLastRow(true);
    tt.methodMovenext();
    tt.methodSetEnd();

    tt.CreateFile("C:\\test.xml");
  }

  public String getETop() {
    return top;
  }

  public String getEXiangZhen() {
    return xiangrow;
  }

  public String getENullrow2() {
    return nullrow2;
  }

  public String getENullrow1() {
    return nullrow1;
  }

  public String getEHead() {
    return head;
  }

  public String getEEnd() {
    return end;
  }

  public String getEDataRow() {
    return this.datarow;
  }

  public String getEDatarow2() {
    return datarow2;
  }

  public String getEDatarow1() {
    return datarow1;
  }
  //数据行，有底纹
  //空数据行，没有底纹
  //空数据行，有底纹
}