}
xbtext.setText(""); csnytext.setText(""); hyzktext.setText(""); lxdhtext.setText(""); zztext.setText(""); con = null; rs = null;
nametx.setText("");
//
5.考勤录入
if (e.getActionCommand().equals("确定")) {
sql = "select * from 考勤表 where 职工号='"+
numchoice.getSelectedItem()+ "' AND 考勤日期='" +kqrqtext.getText()+"'";
try {
rs = con.getrs(con.con, sql); if (rs.next()) {
jop.showMessageDialog(null, "该名职工该考勤日期已记录",
"错误", -1); 期
} else {
sql = "insert into 考勤表(职工号,加班时间,缺勤天数,考勤日
)
values('"+
numchoice.getSelectedItem()+"','"+jbsstext.getText()+"','"+qqtstext.getText()+"','"+kqrqtext.getText()+"')";
con.moddb(con.con, sql); jbss=new Float(jbsstext.getText()); qqts=new Float(qqtstext.getText());
sql="select 岗位 from 员工基本信息 WHERE 职工号='"+numchoice.getSelectedItem()+"'";