frame1.java~21~

数据库管理系统平台

                     defaultTableModel1.setNumRows(i+1);
                     for (int j=0;j<rsmd1.getColumnCount();j++)
                         {
                             defaultTableModel1.setValueAt(rs1.getString(j+1),i,j);
                         }
                     i++;
             }
            rs1.close();
            jTable1.setModel((TableModel)defaultTableModel1);
            statement.close();
        }
         catch(Exception sqlex)
        {
            System.out.println("不能运行");
            sqlex.printStackTrace();
        }

    }

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

       String query="insert into teacher values ('"+jTextField1.getText() + "', '" +
                                                   jTextField2.getText() + "', '" +
                                                   jTextField3.getText() + "', '" +
                                                   jTextField4.getText() + "')";
        if(jTextField2!=null)
        {
            boolean test=true;
            String query1 = "select * from teacher where " + "tssn" + "='" +
                            jTextField2.getText() + "'";
            ResultSet rs1 = statement.executeQuery(query1);
            if (rs1.next())
            {
                String fai = "教师号已存在，请更换教师号";
                message(fai);
                statement.close();
            }
            if(empty.equals(jTextField4.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 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&&result1==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();
    }


    }
}


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);
    }
}