readqianlian.java

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

/*
 * 创建日期 Sep 2, 2006
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.aetherial.gis.baobu.TotalQiaoLiang;

import java.io.File;
import java.io.IOException;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class readqianlian {
public   String inputPath;
public int gdq;
public int gxq;
public int gzq;
public int daqiao;
public int zhongqiao;
public int xiaoqiao;
public int b8daqiao;
public int b8zhongqiao;
public int b8xiaoqiao;
readqianlian(){
	this.daqiao=0;
	this.xiaoqiao=0;
	this.zhongqiao=0;
	this.b8daqiao=0;
	this.b8xiaoqiao=0;
	this.b8zhongqiao=0;
	gdq=0;
	gxq=0;
	gzq=0;
}
private void nbaoqiaoliangtoji(String qiao){
	if(qiao.trim().equals("小桥"))
		  this.gxq++;
	  else
		  if(qiao.trim().equals("中桥"))
	  		this.gzq++;
		  else
			  if(qiao.trim().equals("大桥"))
				  this.gdq++;
}
private void GPSqiaoliangtoji(String qiao){
	if(qiao.trim().equals("小桥"))
		  this.xiaoqiao++;
	  else
		  if(qiao.trim().equals("中桥"))
	  		this.zhongqiao++;
		  else
			  if(qiao.trim().equals("大桥"))
				  this.daqiao++;
}
/**
 * @throws BiffException
 * @throws IOException
 */
private void Readbao2() throws BiffException, IOException{
	
	File f=new File(inputPath);
	String qiao="";
     jxl.Workbook rwb = Workbook.getWorkbook(f);
    Sheet rs = rwb.getSheet("桥梁");
      for(int i=2;i<rs.getRows();i++)
      { 
    	  qiao=rs.getCell(8,i).getContents();
    	  if(qiao.trim().equals("")) break;
    	  if(rs.getCell(0,i).getContents().equals("年报"))
    		  this.nbaoqiaoliangtoji(qiao);
    	  else
    		  if(rs.getCell(0,i).getContents().equals("GPS测量"))
    			  this.GPSqiaoliangtoji(qiao);	  		
      	}
    
//      System.out.println("2_桥梁比较表.xls");
//      System.out.println("年报");
//      System.out.println("大桥"+"\t"+"中桥"+"\t"+"小桥");
//      System.out.println(this.gdq+"\t"+this.gzq+"\t"+this.gxq);
//      System.out.println("GPS");
//      System.out.println("大桥"+"\t"+"中桥"+"\t"+"小桥");
//      System.out.println(daqiao+"\t"+zhongqiao+"\t"+xiaoqiao);
//    
    	  rwb.close();
}
private void readbao8() throws BiffException, IOException{
	File f=new File(inputPath);
//	System.out.println(f.getName());
	String qiao="";
     jxl.Workbook rwb = Workbook.getWorkbook(f);
    Sheet rs = rwb.getSheet("桥梁");
      for(int i=2;i<rs.getRows();i++)
      {
    	  qiao=rs.getCell(8,i).getContents();
    	  if(qiao.trim().equals("")) break;
    	  if(qiao.trim().equals("小桥"))
    		  this.b8xiaoqiao++;
    	  else
    		  if(qiao.trim().equals("中桥"))
    	  		this.b8zhongqiao++;
    		  else
    			  if(qiao.trim().equals("大桥"))
    				  this.b8daqiao++;
      	}
//     
//      System.out.println("大桥"+"\t"+"中桥"+"\t"+"小桥");
//      System.out.println(b8daqiao+"\t"+b8zhongqiao+"\t"+b8xiaoqiao);
//   
    	  rwb.close();
}
public void Readqiaolianshuxi() throws Exception  //构建Workbook对象, 只读Workbook对象
{
			if(this.inputPath.trim().endsWith("2_桥梁比较表.xls"))
				this.Readbao2();
			else
				if(this.inputPath.trim().endsWith("8_桥梁信息汇总表（各地市、县填写）.xls"))
					this.readbao8();
   }
public void setInputPath(String inputPath) {
    this.inputPath = inputPath;
  }


public int getB8daqiao() {
	return b8daqiao;
}
public void setB8daqiao(int b8daqiao) {
	this.b8daqiao = b8daqiao;
}
public int getB8xiaoqiao() {
	return b8xiaoqiao;
}
public void setB8xiaoqiao(int b8xiaoqiao) {
	this.b8xiaoqiao = b8xiaoqiao;
}
public int getB8zhongqiao() {
	return b8zhongqiao;
}
public void setB8zhongqiao(int b8zhongqiao) {
	this.b8zhongqiao = b8zhongqiao;
}
public int getDaqiao() {
	return daqiao;
}
public void setDaqiao(int daqiao) {
	this.daqiao = daqiao;
}
public int getGdq() {
	return gdq;
}
public void setGdq(int gdq) {
	this.gdq = gdq;
}
public int getGxq() {
	return gxq;
}
public void setGxq(int gxq) {
	this.gxq = gxq;
}
public int getGzq() {
	return gzq;
}
public void setGzq(int gzq) {
	this.gzq = gzq;
}
public int getXiaoqiao() {
	return xiaoqiao;
}
public void setXiaoqiao(int xiaoqiao) {
	this.xiaoqiao = xiaoqiao;
}
public int getZhongqiao() {
	return zhongqiao;
}
public void setZhongqiao(int zhongqiao) {
	this.zhongqiao = zhongqiao;
}
public String getInputPath() {
	return inputPath;
}
public static void main(String args[]) throws Exception {
	readqianlian readcut = new readqianlian();
    readcut.setInputPath("E:\\核对工作\\数据\\操作数据\\滁州市\\凤阳县\\年报核对表\\2_桥梁比较表.xls");
    readcut.Readqiaolianshuxi();
}
}