daymanage.java

Student management system

package scoremis;
import java.awt.*;
import java.swing.*;
import java.awt.event.*;
public class DayManage extends JFrame
{
  public DayManage(String uname,String psd)    //设置有参构造函数
   {
     try
      {
        user=uname;
        password=psd;
        jbInit(); 
       }
     catch(Exception exception)
      { 
        exception.printStackTrace();
       }
   }
   private void jbInit() throws Exception                //设置各个组件的位置及字体
    {
     getContentPane().setLayout(null);
     jLabel1.setFont(new java.awt.font("宋体",Font.PLAIN,20));
     jLabel1.setBounds(new Rectangle(120,15,289,36));
     stumis.setBounds(new Rectangle(199,69,125,23));
     inputscore.setBounds(new Rectangle(321,69,85,25));
     editscore.setBounds(new Rectangle(323,118,85,23));
     addamin.setBounds(new Rectangle(199,162,85,23));
     editpassword.setBounds(new Rectangle(323,163,85,23));
     jLabel2.setBounds(new Rectangle(99,67,102,27));
     jLabel5.setBounds(new Rectangle(99,160,86,23));
     jLabel3.setBounds(new Rectangle(99,192,45,46));
     aname.setBound(new Rectangle(141,205,65,24));
     addmanager.setBound(new Rectangle(331,204,60,25));
     psd.setBounds(new Rectangle(251,206,68,23));
     jLabel4.setBounds(new Rectangle(214,210,42,15));
     quit.setBounds(new Rectangle(286,254,83,25));
      sure.setBounds(new Rectangle(142,254,83,25));
      this.getContentPane().add(jLabel1);      //利用getContentPane()方法来向窗体中添加各个组件
      this.getContentPane().add(jLabel2);
      this.getContentPane().add(stumis);
      this.getContentPane().add(inputscore);
      this.getContentPane().add(editscore);
      this.getContentPane().add(jLabel5);
      this.getContentPane().add(addadmin);
      this.getContentPane().add(editpassword);
      this.getContentPane().add(jLabel3);
      this.getContentPane().add(aname);
      this.getContentPane().add(jLabel4);
      this.getContentPane().add(psd);
      this.getContentPane().add(addmanager);
      this.getContentPane().add(sure);
      this.getContentPane().add(quit);
      sure.addActionListener(new Handel());     //分别为按钮应用，退出，添加；复选框：添加管理员，修改密码添加监视器
      addamin.addActionListener(new Handel());
      editpassword.addActionListener(new Handel());
      addmanager.addActionListener(new Handel());
      quit.addActionListener(new Handel());
      aname.setEditable(false);
      psd.setEditable(false);
    }
 
 class Handel implements ActionListener      //用于处理各个监视器事件
  { 
    public void actionPerformed(ActionEvent e)
      {
        dbconn db=new dbconn();    //重新建立连接
        String sql="";
        if(e.getSouucr()==addamin  //如果复选钮“添加管理员”获得焦点的处理事件
          {
          if(addamin.isSelected())
             {
               addmanager.setText("添加");
               psd.setEditable(true);
               aname.setEditable(true);
             }
          else
             {
               psd.setText("");
               aname.setEditable(false);
               aname.setText("");
               psd.setEditable(false);
             }  
          }
        else if(e.getSource()==editpassword) //如果复选钮“修改密码”获得焦点的处理事件
         {
           if(editpassword.isSelected())
             {
               addmanager.setText("修改");
               psd.setEditable(true);
               aname.setEditable(false);
             }
            else
             {
               psd.setText("");
               psd.setEditable(false);
             }
          } 
        else if(e.getSource()==addmanager)   //如果添加按钮获得焦点的处理事件 
         {
           if(addamin.isSelected())
             {
               String sm=aname.getText();
               String mm=psd.getText();
               sql="insert into teacher(ID,name,psd,isAdmin) values('admin"+ xm +"','"+ xm +"','"+ mm +"',true)";
               int i=db.Update(sql);
               if(i>0)
                {
                 JOptionPane.showMessageDialog(null,"管理员添加成功");
                 addamin.setSelected(false);
                 }
               else
                 JOptionPane.showMessageDialog(null,"管理员添加失败");
 
             }
            else if(editpassword.isSelected())//修改密码
             {
               String jmm=aname.getText();
               String xmm=psd.getText();
               sql="Update teacher set psd='"+xm+"' where name='" + user + "' and psd='" + password + "'";
                 int i=db.Update(sql)
                if(i>0)
                { 
                  JOptionPane.showMessageDialog(null,"修改密码成功！");
                  editpassword.setSelected(false);
                }
               else
                  JOptionPane.showMessageDialog(null,"修改失败，请检查原因");
             }
          } 
        else if(e.getSource()==sure)//“应用”按钮获得焦点的 处理事件
         {
            boolean lr=inputscore.isSelected();
            boolean xg=editscore.isSelected();
            boolean gl=stumis.isSelected();
            boolean mm=editpassword.isSelected();
            sql="update quanxian set scoreinput=" + lr +" , scoreedit=" + xg + " ,stumis=" +gl;
            int i=db.Update(sql);
            if(i>0)
              JOptionPane.showMessageDialog(null,"设置权限成功");
            else 
              JOptionPane.showMessageDialog(null,"设置失败！");
         }
        else if(e.getSource()==quit)//退出按钮的 处理事件
          {
           setVisible(false);
          }
       }
   }
   JLabel jLabel1=new JLabel("系统日常管理");   //设置各个组件的初始值
   JLabel JLabel2=new JLabel("教师权限管理");
   JCheckBox stumis=new JCheckBox("学生信息管理");
   JCheckBox addamin=new JCheckBox("添加管理员");
   JCheckBox inputscore=new JCheckBox("成绩录入");
   JCheckBox editscore=new JCheckBox("成绩修改");
   JLabel jLabel3=new JLabel("姓名");
   JTextField aname=new JTextField();
   JLabel jLabel4=new JLabel("密码");
   JTextField psd=new JTextField();
   JCheckBox editpassword=new JCheckBox("修改密码");
   JButton addmanager=new JButton("添加");
   JButton quit=new JButton("退出");
   JLabel jLabel5=new JLabel("管理员管理");
   JButton sure=new JButton("应用");
   String user,password;
 }