frame15.java~25~

大二做的实训. 纯Java程序

package bookmanagesystem;

import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Dimension;
/*import com.borland.dbswing.JdbTable;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbStatusLabel;
import com.borland.dbswing.JdbLabel;
import com.borland.dbswing.JdbList;
import com.borland.dbswing.JdbComboBox;
import com.borland.dbswing.JdbTree;*/
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.Font;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame15 extends JFrame {
    public Frame15() {
        try {
            setBounds(300,250,503,320);
            a=new Object[10][7];
           Object name[]={"编号","姓名","书名","归还日期","借出日期","评论","是否归还"};
            jTable1=new JTable(a,name);

            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jLabel1.setForeground(Color.white);
        jLabel1.setText("借阅者:");
        jLabel1.setBounds(new Rectangle(101, 20, 42, 20));
        jButton1.setBounds(new Rectangle(241, 49, 81, 23));
        jButton1.setText("查询");
        jButton1.addActionListener(new Frame15_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(334, 49, 81, 23));
        jButton2.setText("退出");
        jButton2.addActionListener(new Frame15_jButton2_actionAdapter(this));
        this.getContentPane().setBackground(new Color(0, 66, 92));
        this.setResizable(false);
        this.setTitle("借阅信息查询");
        this.setVisible(true);
        jPanel1.setBounds(new Rectangle(5, 102, 487, 186));
        jPanel1.setLayout(borderLayout1);
        jButton3.setBounds(new Rectangle(144, 49, 81, 23));
        jButton3.setText("重置");
        jButton3.addActionListener(new Frame15_jButton3_actionAdapter(this));
        jTextField2.setBounds(new Rectangle(287, 20, 127, 20));
        jTextField1.setBounds(new Rectangle(145, 20, 87, 20));
        jLabel3.setForeground(Color.white);
        jLabel3.setText("查询结果如下：");
        jLabel3.setBounds(new Rectangle(6, 77, 104, 20));
        jLabel2.setForeground(Color.white);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        jPanel1.add(new JScrollPane(jTable1),BorderLayout.CENTER);
        jLabel2.setText("书名:");
        jLabel2.setBounds(new Rectangle(256, 20, 32, 20));
    }
    JTable jTable1;
    Object a[][];
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JPanel jPanel1 = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    JButton jButton3 = new JButton();
    JLabel jLabel3 = new JLabel();
    public void jButton2_actionPerformed(ActionEvent e) {
dispose();
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        jTextField1.setText(null);
        jTextField2.setText(null);
        for(int m=0;m<10;m++)
       {
           for(int n=0;n<7;n++)
           {
               jTable1.setValueAt("",m,n);
               jTable1.repaint();
           }
       }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String str1, str2;
        String str8="";
       DataBaseManager dbm = new DataBaseManager();
       ResultSet rs;
        if (jTextField1.getText().equals("")&&jTextField2.getText().equals("")) {
            str8 = "SELECT * FROM bookBrowse";
        }
        if (jTextField1.getText().equals("")==false&&jTextField2.getText().equals("")==false) {
                    str1=jTextField1.getText();
                    str2=jTextField2.getText();
                    str8= "SELECT * FROM bookBrowse WHERE StudentName ="+"'"+str1+"'"+"AND BookName ="+"'"+str2+"'";
        }
        if (jTextField1.getText().equals("")==false&&jTextField2.getText().equals("")) {
            str1=jTextField1.getText();
            str8=  "SELECT * FROM bookBrowse WHERE StudentName ="+"'"+str1+"'";
        }
        if (jTextField1.getText().equals("")&&jTextField2.getText().equals("")==false) {
            str2=jTextField2.getText();
            str8=  "SELECT * FROM bookBrowse WHERE BookName ="+"'"+str2+"'";
        }

       try
       {
           int m=0;
           rs=dbm.getResult(str8);
           while(rs.next())
           {
               Object name1[]=new Object[7];
               for(int i=1;i<=7;i++)
               {name1[i-1]=rs.getString(i);}
                   for(int j=0;j<7;j++)
                   {
                       jTable1.setValueAt(name1[j], m, j);
                   }
                   m++;
           }
       }
       catch(SQLException eee)
       {System.out.print(eee);}
       dbm.closeConnection();
    }
}


class Frame15_jButton1_actionAdapter implements ActionListener {
    private Frame15 adaptee;
    Frame15_jButton1_actionAdapter(Frame15 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame15_jButton3_actionAdapter implements ActionListener {
    private Frame15 adaptee;
    Frame15_jButton3_actionAdapter(Frame15 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame15_jButton2_actionAdapter implements ActionListener {
    private Frame15 adaptee;
    Frame15_jButton2_actionAdapter(Frame15 adaptee) {
        this.adaptee = adaptee;
    }

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