(完整版)工资管理系统(论文范文_JSP_JAVA_毕业设计)

除。如图5.5所示。

图5.5删除用户信息

用户管理信息的功能实现的核心代码如下：

public userInfo(){ super(\系统用户管理\ setResizable(false);

this.setLocationRelativeTo(this.getParent());设置显示的位置 setLayout(null);

public void initChoice() { try{

conn=new sqlconn();连接数据库

sql=\语句

rs=conn.getRs(sql); while(rs.next()){

userChoice.addItem(rs.getString(\

}

conn.dbClose(rs); conn=null; }

catch(Exception e){} }

public void actionPerformed(ActionEvent ee){

if(ee.getActionCommand().equals(\退出\

dispose();

if(ee.getActionCommand().equals(\增加\

sql=\ from users where name='\

conn=new sqlconn(); try{

rs=conn.getRs(sql); if(rs.next()){

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\该用户已经存在!\警告\ conn.dbClose(rs); conn=null; rs=null; } else{ try{

sql=\

into

values('\

conn=new sqlconn(); conn.dbMod(sql); conn.dbClose(rs);

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\添加成功!\提示信息\ }

catch(Exception se){}

userChoice.addItem(nameTxt.getText());

users

nameTxt.setText(\ pwdTxt.setText(\ conn=null; }

if(ee.getActionCommand().equals(\修改\

}

}catch(Exception a){}

sql=\ conn=new sqlconn(); try{

rs=conn.getRs(sql); if(!(rs.next())){

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\用户不存在,修改失败!\警告\ conn.dbClose(rs); sql=\ conn=null; }

catch(Exception exc){} }

rs=null; return ;

try{

sql=%users set

password='\

conn=new sqlconn(); conn.dbMod(sql); conn.dbClose(rs);

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\修改成功!\提示信息\ }

catch(Exception se){} nameTxt.setText(\ pwdTxt.setText(\ conn=null; }

if(ee.getActionCommand().equals(\删除\

JOptionPane jopask=new JOptionPane();

\

if(jopask.showConfirmDialog(null,\你确定要删除此记录吗?\请确认

sql=\

conn=new sqlconn(); try{

rs=conn.getRs(sql); if(!(rs.next())){

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\用户不存在,删除失败!\警告\