数据库工资管理系统课程设计(12)

con.moddb(con.con, sql);

sql = "delete from 考勤表 where 职工号

='"+numco.getSelectedItem()+"'";

con.moddb(con.con, sql);

sql = "delete from 工资表 where 职工号

='"+numco.getSelectedItem()+"'";

con.moddb(con.con, sql); System.out.println("aaa"); initnumcho();

System.out.println("bbb");

JOptionPane jop = new JOptionPane();

jop.showMessageDialog(null, " 职工删除成功!", "更新成功

", -1);

}

System.out.println("ccc"); //con.dbclose(con.con, null); System.out.println("ddd");

con = null; rs = null;

} catch (Exception et) {

System.out.println("aaaa"); et.printStackTrace();

3.职工信息查询

sql = "select * from 员工基本信息 where 员工基本信息.职工号='" + numchoice.getSelectedItem()+ "'";

try {

rs = con.getrs(con.con, sql); if (rs.next()) {

nametext.setText(rs.getString("姓名"));