polydateread.java~81~

主要为一个空间信息管理系统

package edu.whu.poly;
import edu.whu.database.ConnectionPooling;
import java.sql.ResultSet;
import java.sql.Connection;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class polyDateRead
{
  Connection conn;
  public polyDateRead(String homeDirectory)
  {
    ConnectionPooling.setHomeDirectory(homeDirectory);
    conn=ConnectionPooling.getConnection();
  }
  public polyStruct[] ReadFromDatabase()
  {
    polyStruct[] polyDate=null;
    polyStruct polyTempDate;
    int[] x=null;
    int[] y=null;
    String projectName;
    int polyNumber=0;
    int pointNumber=0;
    int CountNumber=0;
    String sqlcmd_c = "SELECT COUNT(*) FROM wugang_project_pos group by W_PROJECT_NAME";
    String sqlcmd = "SELECT * FROM wugang_project_pos group by W_PROJECT_NAME";
    try
    {
      ResultSet rs_c = conn.createStatement().executeQuery(sqlcmd_c);
      ResultSet rs = conn.createStatement().executeQuery(sqlcmd);
      while(rs_c.next())
      {
        CountNumber++;
      }
      System.out.println(CountNumber);
      polyDate = new polyStruct[CountNumber];
      int RolNumber=0;
      int i=0;
      while(rs.next())
      {
        projectName=rs.getString("W_PROJECT_NAME");
        String sqlcmd2_c="SELECT COUNT(*) FROM wugang_project_pos where W_PROJECT_NAME ='"+projectName+"'";
        String sqlcmd2="SELECT * FROM wugang_project_pos where W_PROJECT_NAME ='"+projectName+"'";
        ResultSet rs2_c=conn.createStatement().executeQuery(sqlcmd2_c);
        ResultSet rs2=conn.createStatement().executeQuery(sqlcmd2);
        int RolNumber2=0;
        int j=0;
        if(rs2_c.next())
        {
          pointNumber=rs2_c.getInt(1);
          System.out.println("pointNumber="+pointNumber);
          polyTempDate=new polyStruct(pointNumber);
        }
        else
        {
          polyTempDate=null;
        }
        while(rs2.next())
        {

          x = new int[pointNumber];
          y = new int[pointNumber];
          polyTempDate.polyX[j]=Integer.parseInt(rs2.getString("W_PROJECT_POS_X"));
          polyTempDate.polyY[j]=Integer.parseInt(rs2.getString("W_PROJECT_POS_Y"));
          System.out.println(polyTempDate.polyX[j]+" x"+j);
          System.out.println(polyTempDate.polyY[j]+" y"+j);
          j++;
        }
        polyTempDate.projectName=projectName;
        polyDate[i]=polyTempDate;
        i++;
        rs2.close();
      }
      //System.out.println(polyDate.length);

      for(int k=0;k<polyDate.length;k++)
      {

        if(polyDate[k]!=null)
        {
          System.out.println(polyDate[k].projectName);
          for(int l=0;l<polyDate[k].getX().length;l++)
          {
            System.out.println(polyDate[k].getX()[l]);
            System.out.println("length="+polyDate[k].getX().length);
          }
          for(int u=0;u<polyDate[k].getY().length;u++)
          {
            System.out.println(polyDate[k].getY()[u]);
          }

        }
      }
      test_paint p=new test_paint(polyDate);
      rs.close();
    }
    catch (Exception e1)
    {
      e1.printStackTrace();
    }

    return polyDate;
  }
  public static void main(String[] args)
  {
    String path="F:\\wu\\project\\sjhProject";
    polyDateRead polyDateRead1 = new polyDateRead(path);
    polyDateRead1.ReadFromDatabase();
  }

}