frame2.java

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

        String sex;
        boolean flag=true;
        if(jRadioButton2.isSelected())
        {
             flag= false;
             sex="女";
        }
        else
            { flag=true;
                 sex="男";}
        ////////////////////////////////
        String query="insert into student values ('"+jTextField2.getText() + "', '" +
                                                    jTextField1.getText() + "', '" +
                                                    sex + "', '" +
                                                    jTextField7.getText() + "', '" +
                                                    jTextField3.getText() + "', '" +
                                                    jTextField4.getText() + "', '" +
                                                    jTextField6.getText() + "'" +
                                                   ")";
         if(jTextField2!=null)
         {
             String query1 = "select * from student where " + "SN" + "='" +
                             jTextField2.getText() + "'";
             ResultSet rs1 = statement.executeQuery(query1);
             if (rs1.next())
             {
                 String fai = "学号已存在，请更换学号";
                 message(fai);
                 test=false;
                 statement.close();
             }
             if(kong1.equalsIgnoreCase(jTextField7.getText()) )
                  {
                     String empty="不能为空";
                     message(empty);
                     test=false;

                  }
               if(test)
             {
                int result = statement.executeUpdate(query);
                if(result==1)
                 {
                   String success="插入成功";
                   message(success);
                 }
                else
                 {
                   String fail="插入失败";
                   jTextField1.setText("");
                   jTextField2.setText("");
                   jTextField3.setText("");
                   jTextField4.setText("");
                   jTextField5.setText("");
                   jTextField6.setText("");
                   jTextField7.setText("");
                   jRadioButton1.setSelected(true);
                   jRadioButton2.setSelected(false);
                    message(fail);
                   }
          statement.close();
          }
       }
    }

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


    }

    public void jRadioButton1_actionPerformed(ActionEvent e) {
          jRadioButton1.setSelected(true);
          jRadioButton2.setSelected(false);
    }

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

    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 student where SN= '"+ssn+"'";
      if(kong1.equalsIgnoreCase(jTextField7.getText()) )
         {
            String empty="不能为空";
            message(empty);
            test=false;
           }
         if(test)
         {
              statement.executeUpdate( query1 );
              String query="insert into student values ('"+jTextField2.getText() + "', '" +
                                                    jTextField1.getText() + "', '" +
                                                    sex + "', '" +
                                                    jTextField7.getText() + "', '" +
                                                    jTextField3.getText() + "', '" +
                                                    jTextField4.getText() + "', '" +
                                                    jTextField6.getText() + "'" +")";

              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 jButton3_actionPerformed(ActionEvent e) {
        try
        {
         Statement statement = connect.createStatement(ResultSet.
                    TYPE_SCROLL_INSENSITIVE,
                    ResultSet.CONCUR_UPDATABLE);
         String query1="delete from student where SN= '"+jTextField2.getText()+"'";
         String query2="delete from gclass where SN='"+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("");
               jRadioButton1.setSelected(true);
               jRadioButton2.setSelected(false);
               defaultTableModel1.setRowCount(0);
               message(success);
            }
             statement.close();
      }
     catch(Exception sqlex)
      {
       System.out.println("unable run ***");
       sqlex.printStackTrace();
      }

    }

}


class Frame2_jButton3_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton3_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton4_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton4_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jRadioButton2_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jRadioButton2_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jRadioButton1_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jRadioButton1_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton1_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton1_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton5_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton5_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame2_jButton2_actionAdapter implements ActionListener {
    private Frame2 adaptee;
    Frame2_jButton2_actionAdapter(Frame2 adaptee) {
        this.adaptee = adaptee;
    }

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