frame13.java~68~

大二做的实训. 纯Java程序

            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);
    }

    public void jLabel8_mouseClicked(MouseEvent e) {
        jLabel8.setIcon(new ImageIcon("help2.jpg"));
                MyDialog2 md2 = new MyDialog2(this,"欢迎使用帮助",true);
        md2.setVisible(true);
    }

    public void jLabel8_mouseMoved(MouseEvent e) {
        jLabel8.setIcon(new ImageIcon(""));
    }

    public void jLabel8_mousePressed(MouseEvent e) {
        jLabel8.setIcon(new ImageIcon(""));
    }

    public void jLabel8_mouseExited(MouseEvent e) {
        jLabel8.setIcon(new ImageIcon("help2.jpg"));
    }

    public void jButton1_mouseMoved(MouseEvent e) {
        if(jTextField1.getText().equals(""))
                        {
                            if(jTextField2.getText().equals(""))
                            {
                                if(jTextField3.getText().equals(""))
                            {
                                jLabel9.setText("输入项均为空，则查询所有书籍信息");
                            }

                            }
        }
    }

    public void jButton1_mouseExited(MouseEvent e) {
        jLabel9.setText("");
    }
}


class Frame13_jLabel8_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame13 adaptee;
    Frame13_jLabel8_mouseMotionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jLabel8_mouseMoved(e);
    }
}


class Frame13_jLabel8_mouseAdapter extends MouseAdapter {
    private Frame13 adaptee;
    Frame13_jLabel8_mouseAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jLabel8_mouseClicked(e);
    }

    public void mousePressed(MouseEvent e) {
        adaptee.jLabel8_mousePressed(e);
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jLabel8_mouseExited(e);
    }
}


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_jButton1_mouseAdapter extends MouseAdapter {
    private Frame13 adaptee;
    Frame13_jButton1_mouseAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(MouseEvent e) {
        adaptee.jButton1_mouseExited(e);
    }
}


class Frame13_jButton1_mouseMotionAdapter extends MouseMotionAdapter {
    private Frame13 adaptee;
    Frame13_jButton1_mouseMotionAdapter(Frame13 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(MouseEvent e) {
        adaptee.jButton1_mouseMoved(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;
        }
}
    class MyDialog2 extends Dialog
     {
         JLabel jLabel100;
         MyDialog2(Frame f,String s,boolean b)
         {
             super(f,s,b);
             setBounds(100,100,300,200);
             setBackground(new Color(0, 66, 92));
             setResizable(false);
             jLabel100=new JLabel();
             jLabel100.setBounds(100,100,300,200);
             jLabel100.setIcon(new ImageIcon("help3.jpg"));
             add(jLabel100);
             validate();
             addWindowListener(new WindowAdapter()
             {
                 public void windowClosing(WindowEvent eeee)
             {setVisible(false);}
             }
                 );
         }

     }