d_search.java~26~

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

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.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class D_Search extends JDialog
{
  JPanel panel1 = new JPanel();
  JLabel L_X1 = new JLabel();
  JTextField jTextField9 = new JTextField();
  JLabel L_Y5 = new JLabel();
  JButton B_Search1 = new JButton();
  JTextField jTextField10 = new JTextField();
  JTextField jTextField11 = new JTextField();
  JLabel L_Y6 = new JLabel();
  JLabel L_X5 = new JLabel();
  JLabel L_Y7 = new JLabel();
  JLabel L_X6 = new JLabel();
  JTextField jTextField12 = new JTextField();
  JButton B_Cancel1 = new JButton();
  JLabel L_Y8 = new JLabel();
  JLabel L_X7 = new JLabel();
  JTextField jTextField13 = new JTextField();
  JTextField jTextField14 = new JTextField();
  JTextField jTextField15 = new JTextField();
  JTextField jTextField16 = new JTextField();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  TitledBorder titledBorder3;
  TitledBorder titledBorder4;

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

  public D_Search()
  {
    this(null, "", false);
  }
  private void jbInit() throws Exception
  {
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    panel1.setLayout(null);
    L_X1.setBounds(new Rectangle(57, 31, 18, 29));
    L_X1.setText("X1");
    jTextField9.setText("");
    jTextField9.setBounds(new Rectangle(79, 143, 57, 22));
    L_Y5.setText("Y1");
    L_Y5.setBounds(new Rectangle(55, 61, 17, 29));
    B_Search1.setText("search");
    B_Search1.addActionListener(new D_Search_B_Search1_actionAdapter(this));
    B_Search1.setBounds(new Rectangle(57, 207, 73, 25));
    jTextField10.setBounds(new Rectangle(266, 113, 57, 22));
    jTextField10.setText("");
    jTextField11.setText("");
    jTextField11.setBounds(new Rectangle(266, 30, 57, 22));
    L_Y6.setText("Y2");
    L_Y6.setBounds(new Rectangle(245, 57, 18, 29));
    L_X5.setBounds(new Rectangle(57, 110, 18, 29));
    L_X5.setText("X3");
    L_Y7.setText("Y4");
    L_Y7.setBounds(new Rectangle(246, 137, 18, 29));
    L_X6.setText("X4");
    L_X6.setBounds(new Rectangle(247, 107, 18, 29));
    jTextField12.setBounds(new Rectangle(79, 63, 57, 22));
    jTextField12.setText("");
    B_Cancel1.setBounds(new Rectangle(250, 206, 73, 25));
    B_Cancel1.setText("cancel");
    B_Cancel1.addActionListener(new D_Search_B_Cancel1_actionAdapter(this));
    L_Y8.setBounds(new Rectangle(56, 141, 18, 29));
    L_Y8.setText("Y3");
    L_X7.setText("X2");
    L_X7.setBounds(new Rectangle(247, 27, 18, 29));
    jTextField13.setBounds(new Rectangle(266, 141, 57, 22));
    jTextField13.setText("");
    jTextField14.setBounds(new Rectangle(80, 33, 57, 22));
    jTextField14.setText("");
    jTextField15.setText("");
    jTextField15.setBounds(new Rectangle(79, 110, 57, 22));
    jTextField16.setText("");
    jTextField16.setBounds(new Rectangle(266, 58, 57, 22));
    this.getContentPane().setLayout(null);
    panel1.setBorder(titledBorder3);
    panel1.setBounds(new Rectangle(2, 6, 395, 191));
    this.setJMenuBar(null);
    this.setModal(true);
    this.setTitle("搜索工程");
    panel1.add(jTextField9, null);
    panel1.add(jTextField12, null);
    panel1.add(L_X5, null);
    panel1.add(jTextField11, null);
    panel1.add(jTextField14, null);
    panel1.add(L_X7, null);
    panel1.add(L_Y5, null);
    panel1.add(L_Y8, null);
    panel1.add(L_X1, null);
    panel1.add(jTextField15, null);
    panel1.add(L_Y6, null);
    panel1.add(jTextField16, null);
    panel1.add(jTextField10, null);
    panel1.add(L_X6, null);
    panel1.add(L_Y7, null);
    panel1.add(jTextField13, null);
    this.getContentPane().add(B_Search1, null);
    this.getContentPane().add(B_Cancel1, null);
    this.getContentPane().add(panel1, null);
  }

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

  void B_Search1_actionPerformed(ActionEvent e)
  {

    ConnectionPooling.setHomeDirectory("F:\\wu\\project\\sjhProject");
    String sqlcmd = "SELECT * FROM wugang_project_pos";
    try
    {
      ResultSet rs = ConnectionPooling.getConnection().createStatement().executeQuery(sqlcmd);
      int RolNumber=0;
      while (rs.next())
      {
        System.out.println(rs.getString("W_PROJECT_NAME"));


      }
      rs.close();
    }
    catch (Exception e1)
    {
      e1.printStackTrace();
    }

  }
}

class D_Search_B_Cancel1_actionAdapter implements java.awt.event.ActionListener
{
  D_Search adaptee;

  D_Search_B_Cancel1_actionAdapter(D_Search adaptee)
  {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e)
  {
    adaptee.B_Cancel1_actionPerformed(e);
  }
}

class D_Search_B_Search1_actionAdapter implements java.awt.event.ActionListener
{
  D_Search adaptee;

  D_Search_B_Search1_actionAdapter(D_Search adaptee)
  {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e)
  {
    adaptee.B_Search1_actionPerformed(e);
  }
}