frame14.java~119~

大二做的实训. 纯Java程序

class Frame14_jComboBox1_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox1_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jComboBox1_mouseMoved(e);
    }
}


class Frame14_jTextField4_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jTextField4_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jTextField4_mouseMoved(e);
    }
}


class Frame14_jComboBox6_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox6_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(java.awt.event.MouseEvent e) {
        adaptee.jComboBox6_mouseExited(e);
    }
}


class Frame14_jComboBox5_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox5_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jComboBox5_mouseMoved(e);
    }
}


class Frame14_jComboBox5_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox5_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(java.awt.event.MouseEvent e) {
        adaptee.jComboBox5_mouseExited(e);
    }
}


class Frame14_jComboBox6_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox6_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jComboBox6_mouseMoved(e);
    }
}


class Frame14_jComboBox4_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox4_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(java.awt.event.MouseEvent e) {
        adaptee.jComboBox4_mouseExited(e);
    }
}


class Frame14_jComboBox4_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jComboBox4_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jComboBox4_mouseMoved(e);
    }
}


class Frame14_jTextField2_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jTextField2_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jTextField2_mouseMoved(e);
    }
}


class Frame14_jTextField6_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jTextField6_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jTextField6_mouseMoved(e);
    }
}


class Frame14_jTextField2_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jTextField2_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(java.awt.event.MouseEvent e) {
        adaptee.jTextField2_mouseExited(e);
    }
}


class Frame14_jTextField6_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jTextField6_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseExited(java.awt.event.MouseEvent e) {
        adaptee.jTextField6_mouseExited(e);
    }
}


class Frame14_jButton1_actionAdapter implements ActionListener {
    private Frame14 adaptee;
    Frame14_jButton1_actionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame14_jButton1_mouseMotionAdapter extends java.awt.event.
        MouseMotionAdapter {
    private Frame14 adaptee;
    Frame14_jButton1_mouseMotionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseMoved(java.awt.event.MouseEvent e) {
        adaptee.jButton1_mouseMoved(e);
    }
}


class Frame14_jButton1_mouseAdapter extends java.awt.event.MouseAdapter {
    private Frame14 adaptee;
    Frame14_jButton1_mouseAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame14_jButton2_actionAdapter implements ActionListener {
    private Frame14 adaptee;
    Frame14_jButton2_actionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame14_jButton3_actionAdapter implements ActionListener {
    private Frame14 adaptee;
    Frame14_jButton3_actionAdapter(Frame14 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}
class MyDialog extends Dialog
{
    JPanel jPanel1 = new JPanel();
    JTable jTable1;
       Object a[][];
       JLabel jLabel1 = new JLabel();
       String str1,str2,str3,str4,str5,str6,str7,str8,str9;

    MyDialog(Frame f,String s,boolean b)
    {
        super(f,s,b);
        jPanel1.setLayout(new BorderLayout());
        try {
            setBounds(100, 100, 570, 259);
            a = new Object[13][9];
            Object name[] = {"编号", "名称", "出版社", "作者", "地址", "日期", "价格", "评论",
                            "总数"};
            jTable1 = new JTable(a, name);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
        addWindowListener(new WindowAdapter()
        {
            public void windowClosing(WindowEvent eeee)
        {setVisible(false);}
        }
                );
    }
    private void jbInit() throws Exception {
        add(jPanel1);
        jPanel1.add(jTable1, BorderLayout.CENTER);
        jPanel1.setBounds(new Rectangle(19, 29, 528, 188));
        this.setResizable(false);
        jPanel1.add(new JScrollPane(jTable1), BorderLayout.CENTER);
   }
   public void setStr(String s1,String s2,String s3,String s4,String s5,String s6,String s7,String s8,String s9)
   {
       str1=s1;
       str2=s2;
       str3=s3;
       str4=s4;
       str5=s5;
       str6=s6;
       str7=s7;
       str8=s8;
       str9=s9;
        DataBaseManager dbm = new DataBaseManager();
        ResultSet rs;
        String str_1="",str_2="",str_3="",str_4="",str_5="",str_6="";
        if(str5.equals(""))
        {  str_5="SELECT * FROM books";
        }
else
{
    str_5="SELECT * FROM books WHERE PressDate="+"'"+str5+"'";
}
if(str6.equals(""))
      {str_6=str_5;}
      else
      {
          str_6="SELECT * FROM ("+str_5+") AS TEMP WHERE Price="+"'"+str6+"'";
}
if(str1.equals(""))
      {str_1=str_6;}
      else
      {
          if(str7.equals("前方匹配"))
          {  str_1="SELECT * FROM ("+str_6+") AS TEMP WHERE BookName LIKE"+"'"+str1+"%'";}
          else
          {  str_1="SELECT * FROM ("+str_6+") AS TEMP WHERE BookName LIKE"+"'%"+str1+"%'";}

}
if(str2.equals(""))
             {str_2=str_1;}
             else
             {
                 str_2="SELECT * FROM ("+str_1+") AS TEMP WHERE Author="+"'"+str2+"'";
}
if(str3.equals(""))
            {str_3=str_2;}
            else
            {
                if(str8.equals("前方匹配"))
                { str_3="SELECT * FROM ("+str_2+") AS TEMP WHERE Press LIKE"+"'"+str3+"%'";}
                else
                { str_3="SELECT * FROM ("+str_2+") AS TEMP WHERE Press LIKE"+"'%"+str3+"%'";}

}
if(str4.equals(""))
             {str_4=str_3;}
             else
             {
                 if(str9.equals("前方匹配"))
                 {str_4="SELECT * FROM ("+str_3+") AS TEMP WHERE Address LIKE"+"'"+str4+"%'";}
                 else
                 {str_4="SELECT * FROM ("+str_3+") AS TEMP WHERE Address LIKE"+"'%"+str4+"%'";}

             }
try
{
    int m=0;
    rs=dbm.getResult(str_4);
    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);
                validate();
            }
            m++;
    }
    validate();
    setVisible(true);
}
catch(SQLException eee)
{System.out.print(eee);}
dbm.closeConnection();
   }
}