d_search5.java

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

package edu.whu.gui;

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.border.*;
import edu.whu.database.ConnectionPooling;
import java.sql.*;
import edu.whu.poly.*;
import javax.swing.table.*;
import com.sunking.swing.JDatePicker;
import java.util.StringTokenizer;
import java.text.DateFormat;
import java.lang.Object;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class D_Search5 extends JDialog
{
  JPanel panel1 = new JPanel();
  JButton B_Search1 = new JButton();
  JButton B_Cancel1 = new JButton();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  TitledBorder titledBorder3;
  TitledBorder titledBorder4;
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JDatePicker datePickerFrom = new JDatePicker();
  JDatePicker datePickerTo = new JDatePicker();
  JComboBox jComboBox3 = new JComboBox();
  JLabel jLabel4 = new JLabel();
  JTextField name = new JTextField();
  JTextField projectsize = new JTextField();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JComboBox jComboBox1 = new JComboBox();
  JComboBox jComboBox2 = new JComboBox();
  JLabel jLabel7 = new JLabel();
  JTextField man2 = new JTextField();
  JLabel jLabel8 = new JLabel();
  JTextField man3 = new JTextField();
  JLabel jLabel9 = new JLabel();
  JTextField company = new JTextField();
  JLabel jLabel10 = new JLabel();
  JTextField man1 = new JTextField();

  public D_Search5(Frame frame, String title, boolean modal)
  {
    super(frame, title, modal);
    try
    {
      jbInit();
      pack();
    }
    catch (Exception ex)
    {
      ex.printStackTrace();
    }
  }

  public D_Search5()
  {
    this(null, "", false);
  }

  private void jbInit() throws Exception
  {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    panel1.setLayout(null);
    B_Search1.setText("查询 ");
    B_Search1.addActionListener(new D_Search5_B_Search1_actionAdapter(this));
    B_Search1.setBounds(new Rectangle(59, 358, 73, 25));
    B_Cancel1.setBounds(new Rectangle(249, 358, 73, 25));
    B_Cancel1.setText("取消 ");
    B_Cancel1.addActionListener(new D_Search5_B_Cancel1_actionAdapter(this));
    this.getContentPane().setLayout(null);
    panel1.setBorder(titledBorder3);
    panel1.setBounds(new Rectangle(2, 6, 395, 341));
    this.setJMenuBar(null);
    this.setTitle("搜索工程");
    //D_Search5_ReadProject();
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel1.setText("工程名：");
    jLabel1.setBounds(new Rectangle(16, 85, 62, 36));
    jLabel2.setBounds(new Rectangle(16, 293, 110, 36));
    jLabel2.setText("工程创建时间： ");
    jLabel2.setFont(new java.awt.Font("Dialog", 1, 12));
    datePickerFrom.setEditable(false);
    jLabel3.setBounds(new Rectangle(239, 292, 62, 36));
    jLabel3.setText("to：");
    jLabel3.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel3.setPreferredSize(new Dimension(28, 20));
    datePickerFrom.setBounds(new Rectangle(119, 299, 108, 27));
    datePickerTo.setEditable(false);
    datePickerTo.setBounds(new Rectangle(269, 298, 99, 27));
    jLabel4.setBounds(new Rectangle(16, 254, 92, 36));
    jLabel4.setText("工程规模：");
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel4.setRequestFocusEnabled(true);
    //D_Search5_ReadProjectMan();
    name.setText("");
    name.setBounds(new Rectangle(75, 93, 311, 23));
    projectsize.setBounds(new Rectangle(123, 260, 144, 24));
    jLabel5.setBounds(new Rectangle(16, 50, 112, 36));
    jLabel5.setText("工程坐标系统：");
    jLabel5.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel5.setToolTipText("");
    jLabel6.setBounds(new Rectangle(16, 17, 113, 36));
    jLabel6.setText("工程实施地点：");
    jLabel6.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel6.setForeground(Color.black);
    jComboBox1.setBounds(new Rectangle(125, 24, 213, 22));
    jComboBox1.addItemListener(new D_Search5_jComboBox1_itemAdapter(this));
    D_Search5_addProjectTableName();
    jComboBox2.setBounds(new Rectangle(124, 59, 90, 22));
    D_Search5_addProjectCoordinate(jComboBox1.getSelectedItem().toString());
    jLabel7.setRequestFocusEnabled(true);
    jLabel7.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel7.setText("工程终审人：");
    jLabel7.setBounds(new Rectangle(16, 153, 92, 36));
    man2.setBounds(new Rectangle(122, 159, 144, 24));
    jLabel8.setBounds(new Rectangle(16, 184, 92, 36));
    jLabel8.setText("工程审核人：");
    jLabel8.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel8.setRequestFocusEnabled(true);
    man3.setBounds(new Rectangle(122, 190, 144, 24));
    jLabel9.setRequestFocusEnabled(true);
    jLabel9.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel9.setText("生产单位：");
    jLabel9.setBounds(new Rectangle(16, 221, 91, 35));
    company.setBounds(new Rectangle(123, 226, 144, 24));
    jLabel10.setRequestFocusEnabled(true);
    jLabel10.setFont(new java.awt.Font("Dialog", 1, 12));
    jLabel10.setText("工程审核人：");
    jLabel10.setBounds(new Rectangle(16, 122, 92, 36));
    man1.setBounds(new Rectangle(122, 128, 144, 24));
    panel1.add(name, null);
    panel1.add(jLabel1, null);
    panel1.add(jLabel5, null);
    panel1.add(jLabel6, null);
    panel1.add(jComboBox1, null);
    panel1.add(jComboBox2, null);
    panel1.add(jLabel8, null);
    panel1.add(man3, null);
    panel1.add(man2, null);
    panel1.add(jLabel7, null);
    panel1.add(company, null);
    panel1.add(jLabel9, null);
    panel1.add(projectsize, null);
    panel1.add(jLabel4, null);
    panel1.add(man1, null);
    panel1.add(jLabel10, null);
    panel1.add(datePickerFrom);
    panel1.add(jLabel2, null);
    panel1.add(jLabel3, null);
    panel1.add(datePickerTo);
    this.getContentPane().add(panel1, null);
    this.getContentPane().add(B_Search1, null);
    this.getContentPane().add(B_Cancel1, null);
  }
  void D_Search5_addProjectTableName()
  {
    polyRecord record = new polyRecord("./");
    Object[] recordData=record.polyRecord_getTableName();
    for(int i=0;i<recordData.length;i++)
    {
      jComboBox1.addItem(recordData[i].toString());
    }

  }
  void D_Search5_addProjectCoordinate(String tablenamefirst)
  {
    polyRecord record = new polyRecord("./");
    Object[] recordData=record.polyRecord_getCoordinatename(tablenamefirst);
    jComboBox2.removeAllItems();
    jComboBox2.addItem("");
    for(int i=0;i<recordData.length;i++)
    {
      jComboBox2.addItem(recordData[i].toString());
    }

  }

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

  void B_Search1_actionPerformed(ActionEvent e)
  {
    boolean flag=false;
    String sqlcmd=" WHERE";
    String ItemData1=null;
    String ItemData2=null;
    String ItemData3=null;
    String ItemData4=null;
    String ItemData5=null;
    String ItemData6=null;
    String fromDate=null;
    String toDate=null;
    String tablename;
    String coordinate;
    tablename=jComboBox1.getSelectedItem().toString();
    coordinate=jComboBox2.getSelectedItem().toString();
    if(datePickerFrom.getSelectedDate()!=null&&datePickerTo.getSelectedDate()!=null)
    {
      fromDate = DateFormat.getDateTimeInstance(2,
          2).format(datePickerFrom.getSelectedDate());
      toDate = DateFormat.getDateTimeInstance(2,
          2).format(datePickerTo.getSelectedDate());
      sqlcmd=sqlcmd+" TIME > '"+fromDate+"' and TIME <'"+toDate+"'";
    }
    ItemData1=this.name.getText();
    ItemData2=this.man1.getText();
    ItemData3=this.man2.getText();
    ItemData4=this.man3.getText();
    ItemData5=this.company.getText();
    ItemData6=this.projectsize.getText();
    if(ItemData1!=null)
    {
        sqlcmd=sqlcmd+" AND NAME LIKE'%"+ItemData1+"%'";
    }
    if (ItemData2 != null)
    {

        sqlcmd = sqlcmd + " and MAN1 LIKE'%" + ItemData2+"%'";

    }
    if (ItemData3 != null)
    {

      sqlcmd = sqlcmd + " and MAN2 LIKE'%" + ItemData3 + "%'";

    }
    if (ItemData4 != null)
    {

      sqlcmd = sqlcmd + " and MAN3 LIKE'%" + ItemData4 + "%'";

    }
    if (ItemData5 != null)
    {

      sqlcmd = sqlcmd + " and UNIT LIKE'%" + ItemData5 + "%'";

    }
    if (ItemData6 != null)
    {

      sqlcmd = sqlcmd + " and PROJECTSIZE LIKE'%" + ItemData6 + "%'";

    }

    if (coordinate.length() > 0)
    {
       sqlcmd = sqlcmd + " and COORDINATE ='" +coordinate+"'";
    }

    try
    {
      tableProcess tableP = new tableProcess();
      polyProcess p1 = new polyProcess();
      polyRecord record = new polyRecord("./");
      polyStruct[] Pdata = record.polyRecord_ReadProper(sqlcmd,tablename);
      if (Pdata.length > 0)
      {
        tableP.createTableModel();
        for (int j = 0; j < Pdata.length; j++)
        {
          if(Pdata[j].getPropertyArray()!=null)
          {
            tableP.addTableDate(Pdata[j].getPropertyArray());
          }
        }
      }
      tableP.showTable(this);
    }
    catch (Exception e1)
    {
      this.hide();
      errorProcess error = new errorProcess("没有查询到记录!");
      error.errorFrameshow(this);

    }

  }
  void D_Search5_ReadProject()
  {
    String Pname;
    String TS;
    polyRecord record = new polyRecord("./");
    Pname=record.polyRecord_ReadProjectName();
    StringTokenizer Pdata = new StringTokenizer(Pname, ",");
    while(Pdata.hasMoreTokens())
    {
      TS=Pdata.nextToken();
      if(TS!=null)
      {

      }
    }
  }
  void D_Search5_ReadProjectMan()
  {
    String Pname;
    String TS;
    polyRecord record = new polyRecord("./");
    Pname=record.polyRecord_ReadMan();
    StringTokenizer Pdata = new StringTokenizer(Pname, ",");
    while(Pdata.hasMoreTokens())
    {
      TS=Pdata.nextToken();
      if(TS!=null)
      {

      }
    }
  }

  void jComboBox1_itemStateChanged(ItemEvent e)
  {

    D_Search5_addProjectCoordinate(jComboBox1.getSelectedItem().toString());
  }

}

class D_Search5_B_Cancel1_actionAdapter implements java.awt.event.ActionListener
{
  D_Search5 adaptee;

  D_Search5_B_Cancel1_actionAdapter(D_Search5 adaptee)
  {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e)
  {
    adaptee.B_Cancel1_actionPerformed(e);
  }
}

class D_Search5_B_Search1_actionAdapter implements java.awt.event.ActionListener
{
  D_Search5 adaptee;

  D_Search5_B_Search1_actionAdapter(D_Search5 adaptee)
  {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e)
  {
    adaptee.B_Search1_actionPerformed(e);
  }
}

class D_Search5_jComboBox1_itemAdapter implements java.awt.event.ItemListener
{
  D_Search5 adaptee;

  D_Search5_jComboBox1_itemAdapter(D_Search5 adaptee)
  {
    this.adaptee = adaptee;
  }
  public void itemStateChanged(ItemEvent e)
  {
    adaptee.jComboBox1_itemStateChanged(e);
  }
}