user.java

工资管理系统的软件.是同许设计的 是一个比较完整的工资管理系统

import java.awt.*;
import java.util.*;
import java.awt.event.*;
import java.awt.Window;
import java.sql.*;
import javax.swing.*;
class user extends Frame implements ActionListener ,ItemListener
{  private condb con=null;
   private ResultSet rs=null;
   private String sql=null;
   private Button btnadd=new Button("增加");
   private Button btndel=new Button("删除");
   private Button btnmod=new Button("修改");
   private Button btnexit=new Button("退出");
   private Label lbname=new Label("用   户");
   private Label lbpwd=new Label("密   码");
   private Label lbuserchoice=new Label("用户列表");
   private TextField txtname=new TextField();
   private TextField txtpwd=new TextField();
   private Choice userchoice=new Choice();
   public user()
    { super("系统用户管理");
      setSize(410,250);
      this.setLocationRelativeTo(this.getParent());
      setResizable(false);
      setBackground(Color.LIGHT_GRAY);
      setLayout(null);
      lbname.setSize(50,20);
      lbpwd.setSize(50,20);
      lbuserchoice.setSize(50,20);
      txtname.setSize(170,20);
      txtpwd.setSize(170,20);
      userchoice.setSize(170,20);
      btnadd.setSize(50,20);
      btndel.setSize(50,20);
      btnmod.setSize(50,20);
      btnexit.setSize(50,20);
      lbname.setLocation(80,50);
      txtname.setLocation(160,50);
     lbpwd.setLocation(80,100);
     txtpwd.setLocation(160,100);
     userchoice.setLocation(160,150);
     btnadd.setLocation(60,200);
     btndel.setLocation(140,200);
     btnmod.setLocation(220,200);
     btnexit.setLocation(300,200);
    add(lbname);
    add(txtname);
    add(lbpwd);
    add(txtpwd);
    add(lbuserchoice);
    add(userchoice);
    add(btnadd);
    add(btndel);
    add(btnmod);
    add(btnexit);
    btnadd.addActionListener(this);
    btndel.addActionListener(this);
    btnmod.addActionListener(this);
    btnexit.addActionListener(this);
   
    setVisible(true);
    initchoice();
    userchoice.addItemListener(this);
    addWindowListener(new WindowAdapter()
                      { public void windowClosing(WindowEvent e)
                         {dispose();}
                       }
                      );  
   }
  public void initchoice()
  { try {  con=new condb();
           sql="select 用户名 from  数据库用户";
    rs=con.getrs(con.con,sql);
    while(rs.next())
         { userchoice.addItem(rs.getString("用户名"));
         }
           con.dbclose(con.con,rs);
           con=null;
          }
    catch(Exception e){}
  }
public void actionPerformed(ActionEvent ee)
  {  if(ee.getActionCommand().equals("退出"))
         dispose();
     if(ee.getActionCommand().equals("增加"))
      { sql="select *  from 数据库用户 where 用户名='"+txtname.getText()+"'";
        con=new condb();
        try{  rs=con.getrs(con.con,sql);
              if(rs.next())
              { JOptionPane jop=new JOptionPane();
                jop.showConfirmDialog(null,"该用户已经存在!","警告",-1);
                con.dbclose(con.con,rs);
                con=null;
                rs=null;
              
               }
             else   { sql="insert into 数据库用户 values('"+txtname.getText()+
                      "','"+txtpwd.getText()+"')";
                     con=new condb();
                       try{  con.moddb(con.con,sql);
                           con.con.close();
                          }
                       catch(SQLException se){}
                 userchoice.addItem(txtname.getText());
                 txtname.setText("");
                 txtpwd.setText("");
           
              con=null;      }
     }catch(Exception a){}
      
   }
  if(ee.getActionCommand().equals("修改"))
     { sql="update 数据库用户 set 密码='"+txtpwd.getText()
                         +"'where 用户名='"+txtname.getText()+"'";
       con=new condb();
       try{   con.moddb(con.con,sql);
              con.con.close();
           }
       catch(SQLException se){}
       txtname.setText("");
       txtpwd.setText("");
       con=null;
     }
if(ee.getActionCommand().equals("删除"))
  { JOptionPane jopask=new JOptionPane();
     if(jopask.showConfirmDialog(null,"你要删除?","请确认",2)==0)
       { con=new condb();
           sql="delete from 数据库用户 where 用户名='"+txtname.getText()+"'";
     try{ con.moddb(con.con,sql);
          con.con.close();
         }
      catch(SQLException se){}
     con=null;
     userchoice.remove(userchoice.getSelectedIndex());
     txtname.setText("");
     txtpwd.setText("");
    }
}
}

public void itemStateChanged(ItemEvent ie)
       {txtname.setText(userchoice.getSelectedItem());}
     
 

}