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

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("姓名"));

}

xbtext.setText(rs.getString("性别")); bmtext.setText(rs.getString("部门名")); gwtext.setText(rs.getString("岗位")); csnytext.setText(rs.getString("出生年月")); hyzktext.setText(rs.getString("婚姻状况")); lxdhtext.setText(rs.getString("联系电话")); zztext.setText(rs.getString("住址"));

con.dbclose(con.con, rs); con = null; rs = null;

}catch (SQLException e1) { }

e1.printStackTrace();

4.修改职工信息

if (ae.getActionCommand().equals("确定")) {

try {

sql = "update 员工基本信息 set 姓名='"+nametext.getText()+"',

性别='"+xbtext.getText()+"',部门名='"+bmchoice.getSelectedItem()+"',岗位='"+gwchoice.getSelectedItem()+"',出生年月='"+csnytext.getText()+"',婚姻状况='"+hyzktext.getText()+"',

联

系

电

话

='"+lxdhtext.getText()+"',

住

址

='"+zztext.getText()+"' WHERE 职工号='"+numchoice.getSelectedItem()+"'"; -1);

} catch (Exception ue) { }

con.dbclose(con.con, rs); nametext.setText("");

ue.printStackTrace();

con.moddb(con.con, sql);

jop.showMessageDialog(null, " 职工修改成功!", "更新成功",

}

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()+"'";

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

String aa=rs.getString("岗位"); rs=null; sql=null;

sql="select * from 工资类别 WHERE 岗位='"+aa+"'"; rs=con.getrs(con.con, sql); rs.next();

jbgz=rs.getFloat("基础工资"); jbfy=rs.getFloat("加班费"); qqfy=rs.getFloat("缺勤费"); gz=jbgz+jbfy*jbss-qqfy*qqts; System.out.println(gz);

sql="insert into 工资表(职工号,工资,工资日期) values('"+numchoice.getSelectedItem()+"','"+gz+"','" +kqrqtext.getText()+"')"; con.moddb(con.con, sql);

} try {

// // // // //

con.dbclose(con.con,null);

} catch (Exception ue) { }

ue.printStackTrace();

con.dbclose(con.con, rs); jbsstext.setText(""); qqtstext.setText(""); kqrqtext.setText(""); con = null;

}

}

rs = null;

catch (SQLException et) { }

et.printStackTrace();

6.职工工资查询

if(e.getActionCommand().equals("查询")) { con=new condb();

sql="select 工资表.职工号,员工基本信息.姓名,工资表.工资,工资表.工资日期 from 员工基本信息,工资表 WHERE 员工基本信息.职工号=工资表.职工号 AND 职工号='" + numchoice.getSelectedItem()+ "' ORDER BY 工资表.工资日期 DESC ";

rs=con.getrs(con.con, sql); try {

while(rs.next()) { }

try {

gzcx.appendText(rs.getString("职工号")); gzcx.appendText(rs.getString("姓名")); gzcx.appendText(rs.getString("工资")); gzcx.appendText("\t");

gzcx.appendText(rs.getString("工资日期")); gzcx.appendText("\n");

} catch (SQLException e1) { }

// TODO Auto-generated catch block e1.printStackTrace();

} catch (SQLException e1) {

}

// TODO Auto-generated catch block e1.printStackTrace();

con.dbclose(con.con,rs); con=null; rs = null; } 7.部门工资查询

if(e.getActionCommand().equals("平均工资"))

{

int count=0; float gzh=0; con=new condb();

sql="select * from 工资表,员工基本信息 WHERE 部门名='" +

bmchoice.getSelectedItem()+ "' AND 员工基本信息.职工号=工资表.职工号 ";

rs=con.getrs(con.con, sql); try{

while(rs.next()) { }

gzh=gzh+rs.getFloat("工资"); count++;

}catch (SQLException e2){ }

String a=new String("该部门平均工资为"); float b=gzh/count; a+=b;

jop.showMessageDialog(null,a, "错误", -1);

e2.printStackTrace();

if (e.getActionCommand().equals("查询")) {

gzcx.setText("&quo …… 此处隐藏：3095字，全部文档内容请下载后查看。喜欢就下载吧 ……