frame13.java~62~

大二做的实训. 纯Java程序

package bookmanagesystem;

import javax.swing.table.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JTable;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
//import com.borland.dbswing.JdbTable;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.DebugGraphics;
import javax.swing.Box;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */

public class Frame13 extends JFrame  {
    Icon icon;
    public Frame13() {
        try {
            setBounds(300, 250, 600, 370);
            a = new Object[10][9];
            Object name[] = {"编号", "名称", "出版社", "作者", "地址", "日期", "价格", "评论",
                            "总数"};
            jTable1 = new JTable(a, name);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(0, 66, 92));
        this.setResizable(false);
        this.setTitle("书籍信息查询");
        this.setVisible(true);
        jLabel1.setForeground(Color.white);
        jLabel1.setText("书  名");
        jLabel1.setBounds(new Rectangle(276, 9, 43, 23));
        jLabel3.setForeground(Color.white);
        jLabel3.setText("作  者");
        jLabel3.setBounds(new Rectangle(276, 41, 43, 23));
        jTextField1.setBounds(new Rectangle(330, 9, 227, 22));
        jTextField3.setBounds(new Rectangle(330, 77, 227, 22));
        jTextField2.setBounds(new Rectangle(330, 42, 227, 22));
        jButton3.setBounds(new Rectangle(496, 121, 61, 23));
        jButton3.setText("退出");
        jButton3.addActionListener(new Frame13_jButton3_actionAdapter(this));
        jButton2.setBounds(new Rectangle(141, 76, 95, 23));
        jButton2.setForeground(Color.red);
        jButton2.setText("自定义查询");
        jButton2.addActionListener(new Frame13_jButton2_actionAdapter(this));
        jButton1.setBounds(new Rectangle(415, 121, 61, 23));
        jButton1.setText("查询");
        jButton1.addActionListener(new Frame13_jButton1_actionAdapter(this));
        jPanel1.setBounds(new Rectangle(6, 148, 584, 187));
        jPanel1.setLayout(borderLayout1);
        jButton4.setBounds(new Rectangle(330, 121, 65, 23));
        jButton4.setText("重置");
        jButton4.addActionListener(new Frame13_jButton4_actionAdapter(this));
        jLabel5.setText("jLabel5");
        jLabel5.setBounds(new Rectangle(102, 145, 42, 15));
        jTextPane1.setText("jTextPane1");
        jLabel4.setForeground(Color.white);
        jLabel4.setText("查询结果如下：");
        jLabel4.setBounds(new Rectangle(6, 122, 146, 22));
        icon=new ImageIcon("a456.jpg");
        jLabel6.setForeground(Color.white);
        jLabel6.setText("（如：出版日期、价格等）请单击");
        jLabel6.setBounds(new Rectangle(26, 48, 187, 25));
        jLabel7.setForeground(Color.white);
        jLabel7.setText("    如果想通过其他方式进行书籍查询");
        jLabel7.setBounds(new Rectangle(39, 22, 215, 25));
        jLabel2.setForeground(Color.white);
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jLabel7);
        jPanel1.add(new JScrollPane(jTable1), BorderLayout.CENTER);
        jPanel1.add(jTable2, java.awt.BorderLayout.NORTH);
        jPanel1.add(jTable3, java.awt.BorderLayout.SOUTH);
        jPanel1.add(jTable4, java.awt.BorderLayout.EAST);
        jPanel1.add(jTable6, java.awt.BorderLayout.WEST);
        jLabel2.setText("出版社");
        jLabel2.setBounds(new Rectangle(276, 76, 43, 23));

        TableModel dataModel = new AbstractTableModel() {
            public int getColumnCount() {
                return 10;
            }

            public int getRowCount() {
                return 10;
            }

            public Object getValueAt(int row, int col) {
                return new Integer(row * col);
            }
        };
        JTable table = new JTable(dataModel);
        JScrollPane scrollpane = new JScrollPane(table);

    }

    JTable jTable1;
    Object a[][];
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField1 = new JTextField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JPanel jPanel1 = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    JButton jButton4 = new JButton();
    JLabel jLabel5 = new JLabel();
    JTextPane jTextPane1 = new JTextPane();
    JFileChooser jFileChooser1 = new JFileChooser();
    PopupMenu popupMenu1 = new PopupMenu();
    MenuBar menuBar1 = new MenuBar();
    JTable jTable2 = new JTable();
    JTable jTable3 = new JTable();
    JTable jTable4 = new JTable();
    JTable jTable5 = new JTable();
    JTable jTable6 = new JTable();
    JLabel jLabel4 = new JLabel();
    private Object a123;
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    public void jButton3_actionPerformed(ActionEvent e) {
        dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        Frame14 fr14 = new Frame14();
        setVisible(false);
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        String str1,str2,str3;
        String str8="";
        DataBaseManager dbm = new DataBaseManager();
        ResultSet rs;
        if (jTextField1.getText().equals("")&& jTextField2.getText().equals("")&&
            jTextField3.getText().equals("")) {
            str8 = "SELECT * FROM books";
        }
        if (jTextField1.getText().equals("")&& jTextField2.getText().equals("")&&
            jTextField3.getText().equals("")==false) {
           str3= jTextField3.getText();
            str8 =  "SELECT * FROM books WHERE Press ="+"'"+str3+"'";
        }
        if (jTextField1.getText().equals("")==false&&
            jTextField2.getText().equals("")&& jTextField3.getText().equals("")) {
            str1= jTextField1.getText();
            str8=  "SELECT * FROM books WHERE BookName ="+"'"+str1+"'";
        }
        if (jTextField1.getText().equals("")&& jTextField2.getText().equals("")==false&&
            jTextField3.getText().equals("")) {
            str2= jTextField2.getText();
            str8=  "SELECT * FROM books WHERE Author ="+"'"+str2+"'";
        }
       if (jTextField1.getText().equals("")==false&&
            jTextField2.getText().equals("")&& jTextField3.getText().equals("")==false) {
                    str1= jTextField1.getText();
                    str3= jTextField3.getText();
                    str8=  "SELECT * FROM books WHERE BookName ="+"'"+str1+"'"+"AND Press ="+"'"+str3+"'";
        }
        if (jTextField1.getText().equals("")==false&&
            jTextField2.getText().equals("")==false&&
            jTextField3.getText().equals("")) {
            str1= jTextField1.getText();
            str2= jTextField2.getText();
            str8=  "SELECT * FROM books WHERE BookName ="+"'"+str1+"'"+"AND Author ="+"'"+str2+"'";
        }
        if (jTextField1.getText().equals("")&& jTextField2.getText().equals("")==false&&
            jTextField3.getText().equals("")==false) {
            str2= jTextField2.getText();
            str3= jTextField3.getText();
            str8=  "SELECT * FROM books WHERE Author ="+"'"+str2+"'"+"AND Press ="+"'"+str3+"'";
        }
        if (jTextField1.getText().equals("")==false&&
            jTextField2.getText().equals("")==false&&
            jTextField3.getText().equals("")==false) {
            str1= jTextField1.getText();
            str2= jTextField2.getText();
            str3= jTextField3.getText();
            str8= "SELECT * FROM books WHERE BookName ="+"'"+str1+"'"+"AND Author ="+"'"+str2+"'"+"AND Press ="+"'"+str3+"'";
        }
        try
        {
            int m=0;
            rs=dbm.getResult(str8);
            while(rs.next())
            {
                Object name1[]=new Object[9];
                for(int i=1;i<=9;i++)
                {name1[i-1]=rs.getString(i);}
                    for(int j=0;j<9;j++)
                    {
                        jTable1.setValueAt(name1[j], m, j);
                    }
                    m++;
            }
        }
        catch(SQLException eee)
        {System.out.print(eee);}
        dbm.closeConnection();

    }

    public void jButton4_actionPerformed(ActionEvent e) {
        jTextField2.setText(null);
        jTextField3.setText(null);
        jTextField1.setText(null);
    }
}


class Frame13_jButton4_actionAdapter implements ActionListener {
    private Frame13 adaptee;
    Frame13_jButton4_actionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame13_jButton2_actionAdapter implements ActionListener {
    private Frame13 adaptee;
    Frame13_jButton2_actionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame13_jButton1_actionAdapter implements ActionListener {
    private Frame13 adaptee;
    Frame13_jButton1_actionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame13_jButton3_actionAdapter implements ActionListener {
    private Frame13 adaptee;
    Frame13_jButton3_actionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}
class Imagecanvas extends Canvas//画图片
{
        Toolkit tool;
        Image image;
        Imagecanvas()
        {
                setSize(493,369);
                tool=getToolkit();
                image=tool.getImage("1136382960_3.jpg");
        }
        public void paint(Graphics g)
        {
                g.drawImage(image,0,0,image.getWidth(this),image.getHeight(this),this);
        }
        public Image getImage()
        {
                        return image;
        }
}