frame4.java

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

           {
               String success="成功删除";
               jTextField1.setText("");
               jTextField2.setText("");
               jTextField3.setText("");
               defaultTableModel1.setRowCount(0);
               message(success);
           }
           else
           {
                   String fail="失败";
                   message(fail);
           }
        }
        catch(Exception sqlex)
           {
             System.out.println("unable run ***");
             sqlex.printStackTrace();
           }


    }

    public void jButton3_actionPerformed(ActionEvent e)
    {
        try{
         boolean test = true;
         String kong1="";
         Statement statement = connect.createStatement(ResultSet.
                 TYPE_SCROLL_INSENSITIVE,
                 ResultSet.CONCUR_UPDATABLE);
         char[] a=jTextField6.getText().toCharArray();          //将字符串转换成字符数组
         int y;
         y=((int)a[1]-48)+((int)a[0]-48)*10;
         String query = "insert into gclass values ('" + jTextField4.getText() +
                        "', '" +
                        jTextField5.getText() + "', " +y
                       +
                        ")";

         String query1 = " select Sname,class,period from student,sclass where  Nclass='" +
                          jTextField4.getText() +
                        "'  and SN='" + jTextField5.getText() + "'";

         String query2 = "select SN from gclass where Nclass='" +
                         jTextField4.getText() + "'";
         ResultSet rs2 = statement.executeQuery(query2);
         if (rs2.next()) {
             while (rs2.next()) {
                 String StudentNumber = rs2.getString("SN");
                 if (StudentNumber.equalsIgnoreCase(jTextField5.getText())) {
                     String fail = "插入信息已有，请核实后再进行操作";
                     message(fail);
                     rs2.close();
                     statement.close();
                     test = false;
                     break;
                 }
             }
         }
         if(kong1.equalsIgnoreCase(jTextField4.getText()) )
           {
              String empty="不能为空";
              message(empty);
              test=false;
          }

         if (test)
         {
             rs2 = statement.executeQuery(query1);
             ResultSetMetaData rsmd1 = rs2.getMetaData();
             defaultTableModel2.setColumnCount(0);
             defaultTableModel2.setRowCount(0);
             for (int i = 1; i <= rsmd1.getColumnCount(); i++) {
                 defaultTableModel2.addColumn(rsmd1.getColumnName(i));
             }
             int i = 0;
             while (rs2.next()) {
                 defaultTableModel2.setNumRows(i + 1);
                 for (int j = 0; j < rsmd1.getColumnCount(); j++) {
                     defaultTableModel2.setValueAt(rs2.getString(j + 1), i,
                             j);
                 }
                 i++;
             }
             rs2.close();
             jTable3.setModel((TableModel) defaultTableModel2);

             int result1 = statement.executeUpdate(query);
             if (result1 == 1) {
                 String success = "插入成功";
                 message(success);
                 statement.close();
             }
         }
      }
        catch(Exception sqlex)
          {
           System.out.println("unable run ***");
           sqlex.printStackTrace();
         }

    }

    public void jButton4_actionPerformed(ActionEvent e) {
        try
  {
      Statement statement = connect.createStatement(ResultSet.
              TYPE_SCROLL_INSENSITIVE,
              ResultSet.CONCUR_UPDATABLE);
      String query="delete from gclass where Nclass='"+jTextField4.getText()+"' and SN='"+
                   jTextField5.getText()+"' and result='"+jTextField6.getText()+"'";
     int result = statement.executeUpdate(query);
     if(result==1)
     {
         String success="成功删除";
         jTextField4.setText("");
         jTextField5.setText("");
         jTextField6.setText("");
         defaultTableModel2.setRowCount(0);
         message(success);
     }
     else
     {
             String fail="失败";
             message(fail);
     }
  }
  catch(Exception sqlex)
     {
       System.out.println("unable run ***");
       sqlex.printStackTrace();
     }

    }

    public void jButton5_actionPerformed(ActionEvent e) {
        try{
       boolean test = true;
       String kong1="";
      Statement statement = connect.createStatement(ResultSet.
              TYPE_SCROLL_INSENSITIVE,
              ResultSet.CONCUR_UPDATABLE);
      String query = "insert into sclass values ('" + jTextField7.getText() +
                     "', '" +
                     jTextField8.getText() + "', '" +
                     jTextField9.getText() + "'" +
                     ")";
      String query1 =  " select * from sclass where Nclass='" +
                         jTextField7.getText() +"'";

      //String query2 = "select *from sclass where Nclass='" +jTextField7.getText() + "'";

      ResultSet rs1 = statement.executeQuery(query1);
      if (rs1.next()) {
          while (rs1.next()) {
              String ClassNumber = rs1.getString("Nclass");
              if (ClassNumber.equalsIgnoreCase(jTextField7.getText()))
              {
                  String fail = "插入信息已有，请核实后再进行操作";
                  message(fail);
                  rs1.close();
                  statement.close();
                  test = false;
                  break;
              }
          }
      }
      if(kong1.equalsIgnoreCase(jTextField7.getText()) )
      {
          String empty="不能为空";
          message(empty);
          test=false;

      }
      if (test)
      {
          rs1 = statement.executeQuery(query1);
          ResultSetMetaData rsmd1 = rs1.getMetaData();
          defaultTableModel3.setColumnCount(0);
          defaultTableModel3.setRowCount(0);
          for (int i = 1; i <= rsmd1.getColumnCount(); i++) {
              defaultTableModel3.addColumn(rsmd1.getColumnName(i));
          }
          int i = 0;
          while (rs1.next()) {
              defaultTableModel3.setNumRows(i + 1);
              for (int j = 0; j < rsmd1.getColumnCount(); j++) {
                  defaultTableModel3.setValueAt(rs1.getString(j + 1), i,
                          j);
              }
              i++;
          }
          rs1.close();
          jTable2.setModel((TableModel) defaultTableModel3);

          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 jButton6_actionPerformed(ActionEvent e) {
        try
            {
              Statement statement = connect.createStatement(ResultSet.
                                    TYPE_SCROLL_INSENSITIVE,
                                     ResultSet.CONCUR_UPDATABLE);
              String query="delete from sclass where Nclass='"+jTextField7.getText()+"' and  class='"+
              jTextField8.getText()+"' and period='"+jTextField9.getText()+"'";
              int result = statement.executeUpdate(query);
              if(result==1)
                 {
                    String success="成功删除";
                    jTextField7.setText("");
                    jTextField8.setText("");
                    jTextField9.setText("");
                    defaultTableModel3.setRowCount(0);
                    message(success);
                }
            else
              {
                   String fail="失败";
                   message(fail);
              }
          }
        catch(Exception sqlex)
        {
            System.out.println("unable run ***");
            sqlex.printStackTrace();
        }


    }

}


class Frame4_jButton6_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton6_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton5_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton5_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton5_actionPerformed(e);
    }
}


class Frame4_jButton4_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton4_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton3_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton3_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton7_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton7_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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


class Frame4_jButton1_actionAdapter implements ActionListener {
    private Frame4 adaptee;
    Frame4_jButton1_actionAdapter(Frame4 adaptee) {
        this.adaptee = adaptee;
    }

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