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

wageTxt.setText(\ wTypeTxt.setText(\ conn=null; connT=null; }

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

sql=\

}

}catch(Exception a){}

conn=new sqlconn(); try{

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

JOptionPane jop=new JOptionPane();

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

}

rs=null; return ;

catch(Exception exc){}

try{

sql=\

name='\

+ageTxt.getText()+\

getSelectedItem()

+\

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

JOptionPane jop=new JOptionPane();

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

catch(Exception se){} idTxt.setText(\ nameTxt.setText(\ sexTxt.setText(\ ageTxt.setText(\ postTxt.setText(\ dtmtTxt.setText(\ wageTxt.setText(\ wTypeTxt.setText(\ conn=null; }

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

JOptionPane jopask=new JOptionPane();

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

try{

conn=new sqlconn();

sql=\

conn.dbMod(sql);

conn.dbClose(rs);

JOptionPane jop=new JOptionPane();

jop.showMessageDialog(null,\删除成功!\提示信息\ sql=\ connT=new sqlconn(); connT.dbMod(sql); connT.dbClose(rs); }

catch(Exception se){}

conn=null; connT=null;

idChoice.remove(idChoice.getSelectedIndex()); idTxt.setText(\

nameTxt.setText(\ sexTxt.setText(\ ageTxt.setText(\ postTxt.setText(\

wageTxt.setText(\

} }

public void itemStateChanged(ItemEvent ie){ String sqlTemp;

ResultSet rsTemp=null;

idTxt.setText(idChoice.getSelectedItem());

sqlTemp=\try{

sqlconn sConn=new sqlconn(); rsTemp=sConn.getRs(sqlTemp); if(rsTemp.next()){

idTxt.setText(rsTemp.getString(\nameTxt.setText(rsTemp.getString(\sexTxt.setText(rsTemp.getString(\ageTxt.setText(rsTemp.getString(\postTxt.setText(rsTemp.getString(\wageTxt.setText(rsTemp.getString(\dtmtChoice.select(rsTemp.getString(\wTypeChoice.select(rsTemp.getString(\sConn.dbClose(rsTemp); sConn=null; rsTemp=null;