ydq.java

学生信息管理系统

   text3=new TextField(10);
   text4=new TextField(10);
   text5=new TextField(10);
   text6=new TextField(10);
   text7=new TextField(10);
   text8=new TextField(10);
   Panel p1=new Panel();
   Panel p2=new Panel();
   Panel p3=new Panel();
   Panel p4=new Panel();
   Panel p5=new Panel();
   Panel p6=new Panel();
   Panel p7=new Panel();
   Panel p8=new Panel();
   Panel p9=new Panel();
   Panel p10=new Panel();
   Panel p11=new Panel();
   Panel p12=new Panel();
   Panel p13=new Panel();
   p13.add(button1,"West");
   p13.add(button2,"Center");
   p1.add(label1,"West");
   p1.add(text1,"Center");
   p2.add(label2,"West");
   p2.add(text2,"Center");
   p3.add(label3,"West");
   p3.add(text3,"Center");
   p4.add(label4,"West");
   p4.add(text4,"Center");
   p5.add(label5,"West");
   p5.add(text5,"Center");
   p6.add(label6,"West");
   p6.add(text6,"Center");
   p7.add(label7,"West");
   p7.add(text7,"Center");
   p8.add(label8,"West");
   p8.add(text8,"Center");
   p9.add(p1,"North");
   p9.add(p2,"Center");
   p9.add(p3,"South");
   p10.add(p4,"North");
   p10.add(p5,"Center");
   p10.add(p6,"South");
   p11.add(p7,"North");
   p11.add(p8,"Center");
   p11.add(p13,"South");
   p12.add(p9,"North");
   p12.add(p10,"Center");
   p12.add(p11,"South");
   add(p12);
   addWindowListener (new WindowAdapter()
       {public void windowClosing(WindowEvent e)
          {dispose();}
       }
    );
   button1.addActionListener(this);
   button2.addActionListener(this); 
 }
 public void actionPerformed(ActionEvent e)
 {if(e.getSource()==button1)
   { try
     {chaxun();
     }
     catch(SQLException k1) {}
   }
   else if(e.getSource()==button2)
   { try
      {
      genggai();
      }
      catch(SQLException ee9) {}
   }
  }
  public void chaxun() throws SQLException
  {
      try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";
      rs=sql.executeQuery("select * from gerenxinxi where 用户名="+s1);
      while(rs.next())
      {String q1=rs.getString("姓名");
       String q2=rs.getString("性别");
       String q3=rs.getString("出生日期");
       String q4=rs.getString("家庭住址");
       String q5=rs.getString("院系");
       String q6=rs.getString("班级");
       String q7=rs.getString("爱好");
       text2.setText(q1);
       text3.setText(q2);
       text4.setText(q3.substring(0,10));
       text5.setText(q4);
       text6.setText(q5);
       text7.setText(q6);
       text8.setText(q7);
       ll1=q1;
       ll2=q2;
       ll3=q3.substring(0,15);
       ll4=q4;
       ll5=q5;
       ll6=q6;
       ll7=q7;
       con.close();
       return;
      }
      JOptionPane.showMessageDialog(this,"没有该用户","提示",JOptionPane.WARNING_MESSAGE);
  }
  public void genggai() throws SQLException
  { try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";
      String q1="'"+text2.getText()+"'";
      String q2="'"+text3.getText()+"'";
      String q3="'"+text4.getText()+"'";
      String q4="'"+text5.getText()+"'";
      String q5="'"+text6.getText()+"'"; 
      String q6="'"+text7.getText()+"'";
      String q7="'"+text8.getText()+"'";
      sql.executeUpdate("update gerenxinxi set 姓名 ="+q1+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 性别 ="+q2+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 出生日期 ="+q3+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 家庭住址 ="+q4+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 院系 ="+q5+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 班级 ="+q6+" where 用户名="+s1);
      sql.executeUpdate("update gerenxinxi set 爱好="+q7+" where 用户名="+s1);
      JOptionPane.showMessageDialog(this,"更改成功","提示",JOptionPane.WARNING_MESSAGE);
      
  }   
    
}
 class kecheng extends Frame implements ActionListener
 { Label label1,label2,label3,label4,label5;
   TextField text1,text2,text3,text4,text5;
   Button button1,button2,button3,button4;
   Connection con=null;
   Statement sql=null;
   ResultSet rs=null;
   kecheng()
   {super("基本课程信息");
    setSize(300,300);
    setBounds(200,200,600,300);
    setVisible(false);
    setBackground(color2);
    label1=new Label("课程号");
    label2=new Label("课程名");
    label3=new Label("教师"); 
    label4=new Label("学时");
    label5=new Label("上课地点");
    text1=new TextField(10);
    text2=new TextField(10);
    text3=new TextField(10);
    text4=new TextField(10);
    text5=new TextField(10);
    button1=new Button("查询");
    button2=new Button("修改");
    button3=new Button("删除");
    button4=new Button("添加");
    button1.addActionListener(this);
    button2.addActionListener(this);
    button3.addActionListener(this);
    button4.addActionListener(this);
    Panel p1=new Panel();
    Panel p2=new Panel();
    Panel p3=new Panel();
    Panel p4=new Panel();
    Panel p5=new Panel();
    Panel p6=new Panel();
    Panel p7=new Panel();
    Panel p8=new Panel();
    Panel p9=new Panel();
    p1.add(label1,"West");
    p1.add(text1,"Center");
    p2.add(label2,"West");
    p2.add(text2,"Center");
    p3.add(label3,"West");
    p3.add(text3,"Center");
    p4.add(label4,"West");
    p4.add(text4,"Center");
    p5.add(label5,"West");
    p5.add(text5,"Center");
    p6.add(button1,"West");
    p6.add(button2,"Center");
    p6.add(button3,"East");
    p6.add(button4,"South");
    p7.add(p1,"North");
    p7.add(p2,"Center");
    p7.add(p3,"South");
    p8.add(p4,"North");
    p8.add(p5,"Center");
    p8.add(p6,"South");
    p9.add(p7,"North");
    p9.add(p8,"South");
    add(p9);         
    addWindowListener (new WindowAdapter()
       {public void windowClosing(WindowEvent e)
          {dispose();}
       }
    );
   }
   public void actionPerformed(ActionEvent e)
   { if(e.getSource()==button1)
     { try
       {chaxun();
       }
     catch(SQLException k1) {}
     }
    else if(e.getSource()==button2)
    { try
      {
      genggai();
      }
      catch(SQLException ee9) {}
    }
    else if(e.getSource()==button3)
    { try
      {
      shanchu();
      }
      catch(SQLException ee9) {}
    }
    else if(e.getSource()==button4)
    { try
      {
      tianjia();
      }
      catch(SQLException ee9) {}
    }
   }
   public void chaxun() throws SQLException
   { try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";
      rs=sql.executeQuery("select * from kecheng where 课程号="+s1);
      while(rs.next())
      {String q1=rs.getString("课程名");
       String q2=rs.getString("教师");
       String q3=rs.getString("学时");
       String q4=rs.getString("上课地点");
       text2.setText(q1);
       text3.setText(q2);
       text4.setText(q3);
       text5.setText(q4);
       return;
       }
       JOptionPane.showMessageDialog(this,"没有该课程的信息，请确认课程号是否正确","提示",JOptionPane.WARNING_MESSAGE);
       
   }
   public void genggai() throws SQLException
   {try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";
      String s2="'"+text2.getText().trim()+"'";
      String s3="'"+text3.getText().trim()+"'";
      String s4="'"+text4.getText().trim()+"'";
      String s5="'"+text5.getText().trim()+"'";
      if(text1.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"课程号不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text2.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"课程名不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text3.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"教师不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text4.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"学时不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text1.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"上课地点不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      } 
      sql.executeUpdate("update kecheng set 课程名  ="+s2+" where 课程号="+s1);
      sql.executeUpdate("update kecheng set 教师    ="+s3+" where 课程号="+s1);
      sql.executeUpdate("update kecheng set 学时    ="+s4+" where 课程号="+s1);
      sql.executeUpdate("update kecheng set 上课地点 ="+s5+" where 课程号="+s1);
      JOptionPane.showMessageDialog(this,"修改成功","提示",JOptionPane.WARNING_MESSAGE);
      con.close();
   } 
   public void shanchu() throws SQLException
   {  try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";   
      rs=sql.executeQuery("select * from kecheng where 课程号="+s1);
      while(rs.next())
      { sql.executeUpdate("delete from kecheng where 课程号="+s1);
        text1.setText("");
        text2.setText("");
        text3.setText("");
        text4.setText("");
        text5.setText("");
        JOptionPane.showMessageDialog(this,"删除成功","提示",JOptionPane.WARNING_MESSAGE);
        con.close();
        return;
      }
      JOptionPane.showMessageDialog(this,"数据库中没有该课程号相关的信息","警告",JOptionPane.WARNING_MESSAGE);
      con.close(); 
   }
   public void tianjia() throws SQLException
   { try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
      catch(ClassNotFoundException e2) {}
      con=DriverManager.getConnection("jdbc:odbc:qqq","","");
      sql=con.createStatement();
      String s1="'"+text1.getText().trim()+"'";
      String s2="'"+text2.getText().trim()+"'";
      String s3="'"+text3.getText().trim()+"'";
      String s4="'"+text4.getText().trim()+"'";
      String s5="'"+text5.getText().trim()+"'";
      rs=sql.executeQuery("select * from kecheng where 课程号="+s1);
      while(rs.next())
      {JOptionPane.showMessageDialog(this,"数据库中已有该课程号的课程信息，请更换课程号","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      if(text1.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"课程号不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text2.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"课程名不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text3.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"教师不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text4.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"学时不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
      else if(text1.getText().equals(""))
      {JOptionPane.showMessageDialog(this,"上课地点不能为空","提示",JOptionPane.WARNING_MESSAGE);
       return;
      }
     sql.executeUpdate("insert into kecheng values("+s1+","+s2+","+s3+","+s4+","+s5+")");  
     JOptionPane.showMessageDialog(this,"添加成功","提示",JOptionPane.WARNING_MESSAGE);
     con.close();
   }   
 }
 
 class chengji extends Frame implements ActionListener,ItemListener
 {
     Label label1,label2,label3,label4;
     TextField text1,text2,text3;
     Choice choice;
     Button button1,button2,button3,button4;
     Connection con=null;
     Statement sql=null;
     ResultSet rs=null;
     chengji()
    {super("成绩信息管理页面");
     setBackground(color2);
     setSize(400,400);
     setBounds(200,200,600,300);
     setVisible(false);
     label1=new Label("用户名");
     label2=new Label("课程名");
     label3=new Label("课程号");
     label4=new Label("成绩");
     choice=new Choice();
     text1=new TextField(10);
     text2=new TextField(10);
     text3=new TextField(10);
     button1=new Button("查询成绩");
     button2=new Button("添加此成绩记录");
     button3=new Button("修改此成绩记录");
     button4=new Button("删除此成绩记录");
     button1.addActionListener(this);
     button2.addActionListener(this);
     button3.addActionListener(this);
     button4.addActionListener(this);
     choice.addItemListener(this);
     Panel p1=new Panel();
     Panel p2=new Panel();
     Panel p3=new Panel();
     Panel p4=new Panel();
     Panel p5=new Panel();
     Panel p6=new Panel();
     Panel p7=new Panel();
     Panel p8=new Panel();
     p1.add(label1,"West");
     p1.add(text1,"Center");
     p2.add(label2,"We