frame1.java

java开发的一个基于mysql的小数据库系统

             {
                 String query1 = "select * from teacher where " + "ssn" + "='" +
                                 jTextField2.getText() + "'";
                 ResultSet rs1 = statement.executeQuery(query1);
                 if (rs1.next())
                 {
                     String fai = "教师号已存在，请更换教师号";
                     message(fai);
                     test=false;
                     statement.close();
                 }
                 if(kong1.equalsIgnoreCase(jTextField4.getText()) )           //如果插入为空值探出对话框
                    {
                       String empty="不能为空";
                       message(empty);
                       test=false;
                     }
                   if(test)
                    {
                    int result = statement.executeUpdate(query);
                    if(result==1)
                     {
                       zero();
                       String success="插入成功，如果要插入课程信息，请在<课程变动>插入";
                       message(success);
                     }
                    else
                     {
                        String fail="插入失败";
                        zero();
                        message(fail);
                       }
              statement.close();
              }
        }
    }
        catch(Exception sqlex)
        {
            System.out.println("unable run ***");
            sqlex.printStackTrace();
        }

    }
    void zero()                                  //清空显示的信息
    {
                       jTextField1.setText("");
                       jTextField2.setText("");
                       jTextField3.setText("");
                       jTextField4.setText("");
                       jTextField5.setText("");
                       jTextField6.setText("");
                       jTextField7.setText("");
                       jTextField8.setText("");
                       jRadioButton1.setSelected(true);
                       jRadioButton2.setSelected(false);

    }
    void message(String t)
     {
       JOptionPane.showMessageDialog(null,t);
     }

//jButton4的响应事件是修改
    public void jButton4_actionPerformed(ActionEvent e) {
        try {
         boolean test=true;
         String kong1="";
         Statement statement = connect.createStatement(ResultSet.
                 TYPE_SCROLL_INSENSITIVE,
                 ResultSet.CONCUR_UPDATABLE);

        boolean flag;
        String sex;
        if(jRadioButton2.isSelected())
        {
        flag= false;
        sex="女";
        }
        else
        {
          flag=true;
          sex="男";
        }
       String ssn      = jTextField2.getText() ;
       String query1="delete from teacher where ssn= '"+ssn+"'";
       statement.executeUpdate( query1 );
       String query="insert into teacher values ('"+jTextField1.getText() + "', '" +
                                                        jTextField2.getText() + "', '" +
                                                        jTextField6.getText() + "', '" +
                                                        jTextField3.getText() + "', '" +
                                                        jTextField8.getText() + "', '" +
                                                        sex + "', '" +
                                                        jTextField5.getText() + "', '" +
                                                        jTextField7.getText() + "')";
      if(kong1.equalsIgnoreCase(jTextField4.getText()) )
           {
                  String empty="不能为空";
                  message(empty);
                  test=false;
          }
       if(test)
       {
        int result = statement.executeUpdate(query);
         if(result==1)
            {
                 String success="修改成功";
                 message(success);
            }
         statement.close();


          }
       }
       catch(Exception sqlex)
       {
           System.out.println("unable run ***");
           sqlex.printStackTrace();
       }


    }

    public void jTextField4_actionPerformed(ActionEvent e) {



    }
//删除
    public void jButton5_actionPerformed(ActionEvent e) {
        try
        {
        Statement statement = connect.createStatement(ResultSet.
         TYPE_SCROLL_INSENSITIVE,
         ResultSet.CONCUR_UPDATABLE);
         String query1="delete from teacher where ssn= '"+jTextField2.getText()+"'";
         String query2="delete from tclass where ssn='"+jTextField2.getText()+"'";
         int result = statement.executeUpdate(query1);
         int result1=statement.executeUpdate(query2);
                   if(result==1)
                    {
                      String success="删除成功";
                      /* jTextField1.setText("");
                       jTextField2.setText("");
                       jTextField3.setText("");
                       jTextField4.setText("");
                       jTextField5.setText("");
                       jTextField6.setText("");
                       jTextField7.setText("");
                       jTextField8.setText("");
                       jRadioButton1.setSelected(true);
                       jRadioButton2.setSelected(false);*/
                       defaultTableModel1.setRowCount(0);
                       zero();
                       message(success);
                    }
                     statement.close();
         }
       catch(Exception sqlex)
      {
          System.out.println("unable run ***");
          sqlex.printStackTrace();
      }

    }
 //但旋钮的设置选一个另一个值自动设为false
    public void jRadioButton1_actionPerformed(ActionEvent e) {
         //jRadioButton1.isSelected();
         jRadioButton1.setSelected(true);
         jRadioButton2.setSelected(false);

    }

    public void jRadioButton2_actionPerformed(ActionEvent e) {
        //jRadioButton2.isSelected();
        jRadioButton2.setSelected(true);
        jRadioButton1.setSelected(false);
    }
}


class Frame1_jRadioButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jRadioButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jRadioButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jRadioButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton5_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton5_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton5_actionPerformed(e);
    }
}


class Frame1_jTextField4_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jTextField4_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton4_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton4_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame1_jButton1_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton1_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

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

class Frame1_jButton3_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton3_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton3_actionPerformed(e);
    }
}
class Frame1_jButton2_actionAdapter implements ActionListener {
    private Frame1 adaptee;
    Frame1_jButton2_actionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton2_actionPerformed(e);
    }
}