search.java

ACCP 软件工程java 教程学生用书

package diary;

import java.awt.BorderLayout;
import javax.swing.JFrame;

import javax.swing.JDialog;
import javax.swing.JPanel;
import javax.swing.table.*;
import java.awt.*;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JTable;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

public class Search extends JDialog {
    JPanel panel1 = new JPanel();
    JTextField txtSearch = new JTextField();
    JButton btnSearch = new JButton();
    JComboBox cboFieldName = new JComboBox();
    JTable tblResults = new JTable();
    String fieldName;
    String[] fields = {"FirstName", "LastName", "Address", "Phone", "Mobile", "Email"};
    Connection con;
    Statement st;
    ResultSet rs;
    JTableHeader jTableHeader1 = tblResults.getTableHeader();

    public Search(JFrame owner, String title, boolean modal, Connection c, Statement s, ResultSet r) {
        super(owner, title, modal);
        System.out.println("in");
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            con = c;
            st = s;
            rs = r;
            for ( int i=0; i<fields.length; i++) {
                cboFieldName.addItem(fields[i]);
            }
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /*public Search() {
 //       this(new Frame(), "Search", false );
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }*/

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        this.getContentPane().setLayout(null);
        btnSearch.setBounds(new Rectangle(288, 21, 76, 20));
        btnSearch.setToolTipText("");
        btnSearch.setText("Search");
        btnSearch.addActionListener(new Search_btnSearch_actionAdapter(this));
        cboFieldName.setBounds(new Rectangle(164, 22, 113, 21));

        cboFieldName.addActionListener(new Search_cboFieldName_actionAdapter(this));
        btnSearch.addActionListener(new Search_btnSearch_actionAdapter(this));
        this.getContentPane().add(panel1, null);
        this.getContentPane().add(jTableHeader1);
        panel1.add(txtSearch);
        panel1.add(cboFieldName);
        panel1.add(btnSearch);

        txtSearch.setText("Type Keyword to Search");
        txtSearch.setBounds(new Rectangle(23, 22, 128, 21));
        panel1.setBounds(new Rectangle(0, 0, 400, 300));
        tblResults.setBounds(new Rectangle(22, 71, 241, 88));
        panel1.add(tblResults);

    }

    public void btnSearch_actionPerformed(ActionEvent e) {
        try {
            String sql = "Select * from Contacts";
            st = con.createStatement(
                    ResultSet.TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_UPDATABLE);
            rs = st.executeQuery(sql);
            TableModel obj = tblResults.getModel();
            System.out.println(sql);
            Object[][]  data = new Object[5][6];
            int i=0;
            while (rs.next()) {
                System.out.println(rs.getString(1));
                data[i][0] = rs.getString(1);
                data[i][1] = rs.getString(2);
                data[i][2] = rs.getString(3);
                data[i][3] = rs.getString(4);
                data[i][4] = rs.getString(5);
                data[i][5] = rs.getString(6);
                i++;



                    /*tblResults.setValueAt(rs.getString(2), i,
                                          1);
                    tblResults.setValueAt(rs.getString(3), i,
                                          2);
                    //    tblResults.setValueAt(DiaryFrame.rsContacts.getLong(4), i, 3);
                    //   tblResults.setValueAt(DiaryFrame.rsContacts.getLong(5), i, 4);
                    tblResults.setValueAt(rs.getString(6), i,
                                          5);*/

            }

            tblResults = null;
            tblResults = new JTable(data, fields );
//            tblResults = new JTable(data, fields );
//            JTableHeader jTableHeader1 = tblResults.getTableHeader();
//            tblResults.setBounds(new Rectangle(22, 71, 241, 88));
  //          panel1.add(tblResults);



        } catch (Exception sqlException) {

        }
    }

    public void cboFieldName_actionPerformed(ActionEvent e) {
        //fieldname = cboFieldName.getSelectedItem().toString();
    }
}


class Search_cboFieldName_actionAdapter implements ActionListener {
    private Search adaptee;
    Search_cboFieldName_actionAdapter(Search adaptee) {
        this.adaptee = adaptee;
    }

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


class Search_btnSearch_actionAdapter implements ActionListener {
    private Search adaptee;
    Search_btnSearch_actionAdapter(Search adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btnSearch_actionPerformed(e);
    }
}