selectpanel.java~54~

银行管理系统,根据实习的要求以及参考现实中的银行数据库系统

package bank;

import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.*;
import javax.swing.JTable;
import javax.swing.*;
import java.util.*;
import java.awt.Font;
import javax.swing.border.TitledBorder;
import java.awt.*;
import javax.swing.table.*;

//模糊查询。。。。。
public class SelectPanel extends JPanel  {
  public SelectPanel() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
    this.setLayout(xYLayout1);
    xYLayout1.setWidth(479);
    xYLayout1.setHeight(342);
    jButton1.setText("确定");
    jButton1.addActionListener(new SelectPanel_jButton1_actionAdapter(this));
    jButton2.setText("重置");
    String a [] ={"wo","ni"};
    jScrollPane1.setColumnHeader(null);
    jScrollPane1.getViewport().setBackground(UIManager.getColor(
        "FormattedTextField.selectionForeground"));
    jScrollPane1.setBorder(null);
    jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 14));
    jLabel1.setText("查询内容：");
    jScrollPane1.setBounds(new Rectangle(10, 10, 755, 240));
    this.add(jTextField1, new XYConstraints(90, 14, 183, 35));
    this.add(jButton2, new XYConstraints(370, 17, 67, 29));
    this.add(jButton1, new XYConstraints(291, 17, 67, 29));
    jScrollPane1.getViewport().add(jTable1);
    this.add(jLabel1, new XYConstraints(5, 14, 79, 34));
    this.add(jScrollPane1, new XYConstraints(23, 62, 410, 179));
    jTable1.setModel(dtm);
    dtm.addColumn("客户号");
    dtm.addColumn("客户名");
    dtm.addColumn("客户所在城市");
    dtm.addColumn("客户等级");
    this.setVisible(true);

  }

  int columnCount=4;
  XYLayout xYLayout1 = new XYLayout();
  JTextField jTextField1 = new JTextField();
  DefaultTableModel dtm=new DefaultTableModel();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  private Connection con;
   JTable jTable1 = new JTable();
  TitledBorder titledBorder1 = new TitledBorder("");
  JScrollPane jScrollPane1 = new JScrollPane();
  JLabel jLabel1 = new JLabel();
  Statement stmt;
   ResultSet rs;
  public void jButton1_actionPerformed(ActionEvent e) {
    try
        {

          con=bankconnect.getconn();
          stmt=con.createStatement();
           String[] s = new String[columnCount];
         ResultSet rs=stmt.executeQuery("select * from customer where customer_name like"+"'%"+jTextField1.getText().trim()+"%'");
          if(!rs.next()){ JOptionPane.showMessageDialog( null,"对不起，没有找到你要的信息！！！");return ;}
         if(rs.next())
        {
           for (int i = 1; i < columnCount; i++) {
             s[i - 1] = rs.getString(i);
           }
           dtm.addRow(s);
         }
        // jTable1.updateUI();
         //  rs.close();
          // con.close();

        }
       catch(SQLException ex)
       {
         ex.printStackTrace();
       }

  }

  ///////////////////////////////////
 /* private Vector getNextRow( ResultSet rs,
  ResultSetMetaData rsmd )
  throws SQLException
  {
  Vector currentRow = new Vector();
  for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
  currentRow.addElement( rs.getString( i ) );
//返回一条记录
  return currentRow;
  }
*/
}

class SelectPanel_jButton1_actionAdapter
    implements ActionListener {
  private SelectPanel adaptee;
  SelectPanel_jButton1_actionAdapter(SelectPanel adaptee) {
    this.adaptee = adaptee;
  }

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