frame1.java

数据库管理系统平台

   }
}
   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 teacher where tssn= '"+jTextField1.getText()+"'";
        String query2="delete from tsubject where tssn='"+jTextField1.getText()+"'";
        int result = statement.executeUpdate(query1);
        int result1=statement.executeUpdate(query2);
                  if(result==1)
                   {
                     String success="删除成功";
                      jTextField1.setText("");
                      jTextField2.setText("");
                      jTextField3.setText("");
                      jTextField4.setText("");
                      defaultTableModel1.setRowCount(0);
                      message(success);
                   }
                    statement.close();
        }

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

    }

    public void jButton4_actionPerformed(ActionEvent e) {
                    jTextField1.setText("");
                    jTextField2.setText("");
                    jTextField3.setText("");
                    jTextField4.setText("");

    }

    public void jButton5_actionPerformed(ActionEvent e) {
        try
  {
      Statement statement =connect.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE,
                              ResultSet.CONCUR_UPDATABLE);
       String query1="select * from student where ssn="+"'"+jTextField5.getText()+"'";
       String query2="select * from subject where ssn='"
                     +jTextField5.getText()+"'";

       ResultSet rs1 = statement.executeQuery( query1 );
       if(rs1.next())
       {
               jTextField6.setText( rs1.getString( "name" ) );
               jTextField7.setText( rs1.getString( "sex" ) );
               jTextField8.setText( rs1.getString( "sroom" ) );


       }
       else
       {
          String find="查无此人";
          message(find);
       }
       rs1=statement.executeQuery(query2);
       ResultSetMetaData rsmd1=rs1.getMetaData();
       defaultTableModel2.setColumnCount(0);
       defaultTableModel2.setRowCount(0);
       for(int i=1;i<=rsmd1.getColumnCount();i++)
        {
              defaultTableModel2.addColumn(rsmd1.getColumnName(i));
        }
       int i=0;
       while(rs1.next())
         {
               defaultTableModel2.setNumRows(i+1);
               for (int j=0;j<rsmd1.getColumnCount();j++)
                   {
                       defaultTableModel2.setValueAt(rs1.getString(j+1),i,j);
                   }
               i++;
       }
      rs1.close();
      jTable2.setModel((TableModel)defaultTableModel2);
      statement.close();
  }
  catch(Exception sqlex)
  {
      System.out.println("unable run ***");
      sqlex.printStackTrace();
  }

    }

    public void jButton6_actionPerformed(ActionEvent e) {
        try {
String empty="";
Statement statement = connect.createStatement(ResultSet.
        TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_UPDATABLE);

String query="insert into student values ('"+jTextField5.getText() + "', '" +
                                            jTextField6.getText() + "', '" +
                                            jTextField7.getText() + "', '" +
                                            jTextField8.getText() + "')";
 if(jTextField5!=null)
 {
     boolean test=true;
     String query1 = "select * from student where " + "ssn" + "='" +
                     jTextField5.getText() + "'";
     ResultSet rs1 = statement.executeQuery(query1);
     if (rs1.next())
     {
         String fai = "学号已存在，请更换学号";
         message(fai);
         statement.close();
     }
     if(empty.equals(jTextField5.getText()) )
        {
           String Empty="不能为空";
           message(Empty);
           test=false;
         }
       if(test)
        {
        int result = statement.executeUpdate(query);
        if(result==1)
         {
           String success="插入成功，如果要插入课程信息，请在<课程变动>插入";
           message(success);
         }
        else
         {
            String fail="插入失败";
            message(fail);
           }
        statement.close();
        }
      }
   }
      catch(Exception sqlex)
       {
            System.out.println("unable run ***");
            sqlex.printStackTrace();
        }

    }

    public void jButton7_actionPerformed(ActionEvent e) {
        try{
       Statement statement = connect.createStatement(ResultSet.
       TYPE_SCROLL_INSENSITIVE,
       ResultSet.CONCUR_UPDATABLE);
       String query1="delete from student where ssn= '"+jTextField5.getText()+"'";
       String query2="delete from subject where ssn='"+jTextField5.getText()+"'";
       int result = statement.executeUpdate(query1);
       int result1=statement.executeUpdate(query2);
                 if(result==1&&result1==1)
                  {
                     String success="删除成功";
                     jTextField5.setText("");
                     jTextField6.setText("");
                     jTextField7.setText("");
                     jTextField8.setText("");
                     defaultTableModel2.setRowCount(0);
                     message(success);
                  }
                   statement.close();
       }

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


    }

    public void jButton8_actionPerformed(ActionEvent e) {
        jTextField5.setText("");
        jTextField6.setText("");
        jTextField7.setText("");
        jTextField8.setText("");

    }

    public void jButton9_actionPerformed(ActionEvent e) {
        try{
            Statement statement = connect.createStatement(ResultSet.
        TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_UPDATABLE);

            String query = "insert into subject values(" +
                           jTextField9.getText() + "', '" +
                           jTextField10.getText() + "', '" +
                           jTextField11.getText() + "')"; ;
            int result = statement.executeUpdate(query);
        if(result==1)
          {

          String success="插入成功";
           message(success);
          }
        }
        catch(Exception sqlex)
         {
            System.out.println("unable run ***");
            sqlex.printStackTrace();
         }

    }

    public void jButton10_actionPerformed(ActionEvent e) {
         jTextField9.setText("");
         jTextField10.setText("");
         jTextField11.setText("");

    }

    public void jButton11_actionPerformed(ActionEvent e) {
        try{
    Statement statement = connect.createStatement(ResultSet.
TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

    String query = "insert into tsubject values(" +
                   jTextField12.getText() + "', '" +
                   jTextField13.getText() + "')"; ;
    int result = statement.executeUpdate(query);
if(result==1)
  {

  String success="插入成功";
   message(success);
  }
}
catch(Exception sqlex)
 {
    System.out.println("unable run ***");
    sqlex.printStackTrace();
 }

    }

    public void jButton12_actionPerformed(ActionEvent e) {
         jTextField12.setText("");
         jTextField13.setText("");
    }
}


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

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


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

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


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

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


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

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


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

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


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

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


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

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton6_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_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_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);
    }
}


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_jMenuFileExit_ActionAdapter implements ActionListener {
    Frame1 adaptee;

    Frame1_jMenuFileExit_ActionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuFileExit_actionPerformed(actionEvent);
    }
}


class Frame1_jMenuHelpAbout_ActionAdapter implements ActionListener {
    Frame1 adaptee;

    Frame1_jMenuHelpAbout_ActionAdapter(Frame1 adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent actionEvent) {
        adaptee.jMenuHelpAbout_actionPerformed(actionEvent);
    }
}