this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel3, null);
    jTable1.setRowSelectionAllowed(true);

  }

  void del_actionPerformed(ActionEvent e)
  {
    Vector data = dm.getDataVector();
    Enumeration datatemp = data.elements();
    Vector row;
    String headdata;
    String projectname;
    int i = 0;
    int j;
    for (j = data.size() - 1; j >= 0; j--)
    {
      row = (Vector) data.elementAt(j);
      Enumeration rowhead = row.elements();
      if (rowhead.hasMoreElements())
      {
        headdata = rowhead.nextElement().toString();
        if (headdata.equalsIgnoreCase("true"))
        {
          projectname = rowhead.nextElement().toString();
          polyRecord record = new polyRecord("./");
          record.polyRecord_deleteFromprojectName("shanghai", projectname);
          System.out.println(row.toString());
          dm.removeRow(j);
        }
      }

    }

  }

  void modify_actionPerformed(ActionEvent e)
  {
    modify1 = 1;
    Vector data = dm.getDataVector();
    Vector row;
    String projectname;
    int j = jTable1.getSelectedRows()[0];
    if (jTable1.getSelectedRows().length == 1)
    {
      row = (Vector) data.elementAt(j);
      Enumeration rowhead = row.elements();
      if (rowhead.hasMoreElements())
      {
        rowhead.nextElement();
        projectname = rowhead.nextElement().toString();
        polyRecord record = new polyRecord("./");
        polyStruct[] Pdata = record.polyRecord_ReadFromSql(" WHERE NAME='" +
            projectname + "'", "shanghai");
        number.setText(Pdata[0].getProjectNumber() + "");
        number.setEnabled(false);
        name.setText(Pdata[0].getProjectName());
        date.setDate(Pdata[0].getDate());
        coordinate.setText(Pdata[0].getCoordinate());
        man.setText(Pdata[0].getProjectMan());
        position1.setText(Pdata[0].getFilePath1());
        position2.setText(Pdata[0].getFilePath2());
        position3.setText(Pdata[0].getFilePath3());
        eposition.setText(Pdata[0].getEposition());
        posnumber.setText(Pdata[0].getX().length + "");
        Tdata = Pdata[0];
      }
    }

  }

  void jButton2_actionPerformed(ActionEvent e)
  {
    this.hide();
  }

  public void refresh_database(String tablename)
  {
    String[] columnNames1 =
        {
        "", "工程名", "工程開始時間", "工程責任人", "工程坐標系統"
    };
    Object[][] data1 = new Object[0][5];
    DefaultTableModel dm1 = new DefaultTableModel(data1, columnNames1)
    {
      public Class getColumnClass(int column)
      {
        return getValueAt(0, column).getClass();
      }
    };
    boolean flag = false;
    String sqlcmd = "";
    String ItemData1 = null;
    String ItemData2 = null;
    String fromDate = null;
    String toDate = null;
    String coordinate;
    try
    {
      polyProcess p1 = new polyProcess();
      polyRecord record = new polyRecord("./");
      polyStruct[] Pdata = record.polyRecord_ReadProper(sqlcmd, tablename);
      if (Pdata.length > 0)
      {
        for (int j = 0; j < Pdata.length; j++)
        {
          if (Pdata[j].getPropertyArray() != null)
          {
            dm1.addRow(Pdata[j].getAbstractPropertyArray());
          }
        }
      }
    }
    catch (Exception e1)
    {
      e1.printStackTrace();

    }
    dm=dm1;
    jTable1.setModel(dm);
    TableColumn column = jTable1.getColumnModel().getColumn(0);
    TableColumn column1 = jTable1.getColumnModel().getColumn(1);
    TableColumn column2 = jTable1.getColumnModel().getColumn(2);
    TableColumn column3 = jTable1.getColumnModel().getColumn(3);
    TableColumn column4 = jTable1.getColumnModel().getColumn(4);
    column.setPreferredWidth(10);
    column1.setPreferredWidth(200);
    column2.setPreferredWidth(130);
    column3.setPreferredWidth(130);
    column4.setPreferredWidth(130);
    //jTable1.repaint();
  }

  void down_actionPerformed(ActionEvent e)
  {
    int datanumber;
    try
    {
      datanumber = Integer.parseInt(posnumber.getText());
      D_DataInputTable DataInputTable_D;
      if ( (Tdata != null) && (datanumber == Tdata.getX().length))
      {
        DataInputTable_D = new D_DataInputTable(this, "3", true, "3",
                                                datanumber, Tdata.getX(),
                                                Tdata.getY());
      }
      else
      {
        DataInputTable_D = new D_DataInputTable(this, "3", true, "3",
                                                datanumber);
      }
      DataInputTable_D.setSize(160, 200);
      //Validate frames that have preset sizes
      //Pack frames that have useful preferred size info, e.g. from their layout
      //Center the window
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      Dimension frameSize = DataInputTable_D.getSize();
      if (frameSize.height > screenSize.height)
      {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width)
      {
        frameSize.width = screenSize.width;
      }

      //DataInputTable_D.setLocation( (screenSize.width - frameSize.width) / 2,
      //                      (screenSize.height - frameSize.height) / 2);
      DataInputTable_D.setLocation( (screenSize.width -
                                     (int) down.getAlignmentX()) / 2 - 210,
                                   (screenSize.height -
                                    (int) down.getAlignmentY()) / 2 + 120);
      DataInputTable_D.setVisible(true);
      DataInputTable_D1 = DataInputTable_D;
    }
    catch (Exception e1)
    {
      e1.printStackTrace();
    }
  }

  void reset_actionPerformed(ActionEvent e)
  {
    number.setText("");
    number.setEnabled(true);
    name.setText("");
    date.setDate(null);
    coordinate.setText("");
    man.setText("");
    position1.setText("");
    position2.setText("");
    position3.setText("");
    eposition.setText("");
    posnumber.setText("");

  }

  void add_actionPerformed(ActionEvent e)
  {
    Vector row;
    Vector posData;
    int datanumber = 0;
    int i = 0;
    int flag = 0;
    int flag1 = 0;

    try
    {
      polyRecord record = new polyRecord("./");
      polyStruct Pdata = new polyStruct(Integer.parseInt(posnumber.getText()));
      Pdata.setProjectNumber(Integer.parseInt(number.getText()));
      datanumber = Integer.parseInt(posnumber.getText());
      int[] x = new int[datanumber];
      int[] y = new int[datanumber];
      Pdata.setProjectName(name.getText());
      Pdata.setDate(date.getDate());
      Pdata.setCoordinate(coordinate.getText());
      Pdata.setProjectMan(man.getText());
      Pdata.setFilePath1(position1.getText());
      Pdata.setFilePath2(position2.getText());
      Pdata.setFilePath3(position3.getText());
      Pdata.setEposition(eposition.getText());
         if (DataInputTable_D1 == null)
        {
          Pdata.setX(Tdata.getX());
          Pdata.setY(Tdata.getY());
        }
        else
        {
          posData = DataInputTable_D1.getVectorData();
          Enumeration rowhead = posData.elements();
          while (rowhead.hasMoreElements())
          {
            row = (Vector) rowhead.nextElement();
            if (row.elementAt(0) != null)
            {
              System.out.println(row.elementAt(0).toString());
              x[i] = Integer.parseInt(row.elementAt(0).toString());
              System.out.println("x=" + x[i]);
              flag++;
            }
            if (row.elementAt(1) != null)
            {
              y[i] = Integer.parseInt(row.elementAt(1).toString());
              System.out.println("y=" + y[i]);
              flag1++;
            }
            i++;
          }

          if ( (x.length == flag) && (y.length == flag1))
          {
            Pdata.setX(x);
            Pdata.setY(y);
          }
          else
          {
            Pdata.setX(Tdata.getX());
            Pdata.setY(Tdata.getY());
          }
        }
        record.polyRecord_UpdateFromProjectNumber(Pdata, "shanghai");
        refresh_database("shanghai");


    }
    catch (Exception e1)
    {
      e1.printStackTrace();
    }
    modify1 = 0;

  }

}

class D_Create1_del_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_del_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.del_actionPerformed(e);
  }
}

class D_Create1_modify_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_modify_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.modify_actionPerformed(e);
  }
}

class D_Create1_jButton2_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_jButton2_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.jButton2_actionPerformed(e);
  }
}

class D_Create1_down_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_down_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.down_actionPerformed(e);
  }
}

class D_Create1_reset_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_reset_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.reset_actionPerformed(e);
  }
}

class D_Create1_add_actionAdapter
    implements java.awt.event.ActionListener
{
  D_Create1 adaptee;

  D_Create1_add_actionAdapter(D_Create1 adaptee)
  {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e)
  {
    adaptee.add_actionPerformed(e);
  }
}