daymanage.java~31~

java语言写的

package scoremis;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import scoremis.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @于二坤
 * @version 1.0
 */

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("Dialog", 1, 22));
    jLabel1.setBounds(new Rectangle(109, 13, 151, 36));
    stumis.setFont(new java.awt.Font("Dialog", 0, 12));
    stumis.setBounds(new Rectangle(129, 67, 125, 23));
    inputscore.setFont(new java.awt.Font("Dialog", 0, 12));
    inputscore.setBounds(new Rectangle(253, 67, 85, 25));
    editscore.setFont(new java.awt.Font("Dialog", 0, 12));
    editscore.setBounds(new Rectangle(130, 114, 85, 23));
    addadmin.setFont(new java.awt.Font("Dialog", 0, 12));
    addadmin.setBounds(new Rectangle(129, 160, 85, 23));
    editpassword.setFont(new java.awt.Font("Dialog", 0, 12));
    editpassword.setBounds(new Rectangle(253, 161, 85, 23));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setBounds(new Rectangle(29, 65, 102, 27));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setBounds(new Rectangle(29, 158, 86, 23));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setToolTipText("");
    jLabel3.setText("姓名");
    jLabel3.setBounds(new Rectangle(69, 194, 45, 46));
    aname.setFont(new java.awt.Font("Dialog", 0, 12));
    aname.setBounds(new Rectangle(111, 207, 65, 24));
    addmanager.setBounds(new Rectangle(105, 252, 75, 25));
    addmanager.setFont(new java.awt.Font("Dialog", 0, 12));
    psd.setFont(new java.awt.Font("Dialog", 0, 12));
    psd.setBounds(new Rectangle(238, 208, 68, 23));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setToolTipText("");
    jLabel4.setText("密码");
    jLabel4.setBounds(new Rectangle(204, 211, 36, 15));
    quit.setBounds(new Rectangle(216, 252, 75, 25));
    quit.setFont(new java.awt.Font("Dialog", 0, 12));
    sure.setBounds(new Rectangle(254, 110,75, 25));
    sure.setFont(new java.awt.Font("Dialog", 0, 12));
    //添加各组件
    this.getContentPane().add(stumis);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(inputscore);
    this.getContentPane().add(jLabel5);
    this.getContentPane().add(addadmin);
    this.getContentPane().add(editpassword);
    this.getContentPane().add(quit);
    this.getContentPane().add(jLabel1);
    this.getContentPane().add(editscore);
    this.getContentPane().add(sure);
    this.getContentPane().add(aname);
    this.getContentPane().add(jLabel3);
    this.getContentPane().add(psd);
    this.getContentPane().add(jLabel4);
    this.getContentPane().add(addmanager);
    sure.addActionListener(new Handel());  //给按钮添加监视器
    addadmin.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.getSource()==addadmin){  //添加管理员时姓名和密码框设置为可编辑
        if(addadmin.isSelected()){
          editpassword.setSelected(false);
          addmanager.setText("添加");
          psd.setEditable(true);
          aname.setEditable(true);aname.requestFocus(true);
        }else{
          addadmin.setSelected(false);
          psd.setText("");
          psd.setEditable(false);
          aname.setText("");
          aname.setEditable(false);
      }
    }else if(e.getSource()==editpassword) {   //修改密码
      if(editpassword.isSelected()){
        addmanager.setText("修改");
        aname.setText("");aname.setEditable(false);
        psd.setText("");psd.setEditable(true);psd.requestFocus(true);
      }else{
        psd.setText("");
        psd.setEditable(false);
      }
    }else if(e.getSource()==addmanager){
      if(addadmin.isSelected())  {   //添加管理员
        String xm=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,"管理员添加成功!");
          addadmin.setSelected(false);
          aname.setEnabled(false);aname.setText("");
          psd.setEnabled(false);psd.setText("");
        }else
          JOptionPane.showMessageDialog(null,"管理员添加失败!!");
      }
      else if(editpassword.isSelected()) {   //修改密码
        String jmm=aname.getText();
        String xmm=psd.getText();
        sql="update teacher set psd='"+xmm+"' where name='"+user+"' and psd='"+password+"'";
        int i=db.Update(sql);
        if(i>0){
          JOptionPane.showMessageDialog(null,"修改密码成功!");
          editpassword.setSelected(false);
          aname.setEnabled(false);aname.setText("");
          psd.setEnabled(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+",scoredit="+xg+",stumis="+gl+"";
      int i=db.Update(sql);
      if(i>0)
        JOptionPane.showMessageDialog(null,"设置权限成功!");
      else
        JOptionPane.showMessageDialog(null,"设置失败,请仔细检查!");
     }else if(e.getSource()==quit) {   //处理"退出"事件
        dispose();//setVisible(false);
     }
     }
   }
  JLabel jLabel1=new JLabel("系统日常管理");
  JLabel jLabel2=new JLabel("教师权限设置");
  JCheckBox stumis=new JCheckBox("学生信息管理");
  JCheckBox addadmin=new JCheckBox("添加管理员");
  JCheckBox editpassword=new JCheckBox("修改密码");
  JCheckBox editscore=new JCheckBox("成绩修改");
  JCheckBox inputscore=new JCheckBox("成绩录入");
  JLabel jLabel3=new JLabel("姓名:");
  JTextField aname=new JTextField();
  JLabel jLabel4=new JLabel("密码:");
  JTextField psd=new JTextField();
  JButton addmanager=new JButton("添加");
  JButton quit=new JButton("退出");
  JLabel jLabel5=new JLabel("管理员管理");
  JButton sure=new JButton("应用");
  String user,password;
}