managementtest.java

java开发的桌面系统

    			rs4 = db.getResult(sPost);//返回resultset类型
    			lst4 = db.convert(rs4);//返回list类型
    			obj4 = db.queryOne(sPost,lst4);//返回object  类型
    			tfpost.setText(obj4.toString());//把结果转换成字符串输出到文本框
    			
    			String sWorktime= "select 员工工龄 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs5 = db.getResult(sWorktime);//返回resultset类型
    			lst5 = db.convert(rs5);//返回list类型
    			obj5 = db.queryOne(sWorktime,lst5);//返回object  类型
    			tfeWorktime.setText(obj5.toString());//把结果转换成字符串输出到文本框
    			
    			
    			
    			String sCardID= "select 银行卡号 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs6 = db.getResult(sCardID);//返回resultset类型
    			lst6 = db.convert(rs6);//返回list类型
    			obj6 = db.queryOne(sCardID,lst6);//返回object  类型
    			tfcardID.setText(obj6.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String sOnDays= "select 上班天数 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs7 = db.getResult(sOnDays);//返回resultset类型
    			lst7 = db.convert(rs7);//返回list类型
    			obj7 = db.queryOne(sOnDays,lst7);//返回object  类型
    			tfonDays.setText(obj7.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String sSickDays= "select 病假天数 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs8 = db.getResult(sSickDays);//返回resultset类型
    			lst8 = db.convert(rs8);//返回list类型
    			obj8 = db.queryOne(sSickDays,lst8);//返回object  类型
    			tfsickDays.setText(obj8.toString());//把结果转换成字符串输出到文本框
    			
    			
	       	
    			
    			String sRestDays= "select 休假天数 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs9 = db.getResult(sRestDays);//返回resultset类型
    			lst9 = db.convert(rs9);//返回list类型
    			obj9 = db.queryOne(sRestDays,lst9);//返回object  类型
    			tfrestDays.setText(obj9.toString());//把结果转换成字符串输出到文本框
    			
    			////////////////////////////////****************
    			
    			String s1 = "select 奖金 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs10 = db.getResult(s1);//返回resultset类型
    			lst10 = db.convert(rs10);//返回list类型
    			obj10 = db.queryOne(s1,lst10);//返回object  类型
    			tfaward.setText(obj10.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s2 = "select 应发工资 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs11 = db.getResult(s2);//返回resultset类型
    			lst11 = db.convert(rs11);//返回list类型
    			obj11 = db.queryOne(s2,lst11);//返回object  类型
    			tfsalary.setText(obj11.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s3 = "select 个人所得税 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs12 = db.getResult(s3);//返回resultset类型
    			lst12 = db.convert(rs12);//返回list类型
    			obj12 = db.queryOne(s3,lst12);//返回object  类型
    			tfpensTax.setText(obj12.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s4 = "select 国家税 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs13 = db.getResult(s4);//返回resultset类型
    			lst13 = db.convert(rs13);//返回list类型
    			obj13 = db.queryOne(s4,lst13);//返回object  类型
    			tfstaTax.setText(obj13.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s5 = "select 医疗保险 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs14 = db.getResult(s5);//返回resultset类型
    			lst14 = db.convert(rs14);//返回list类型
    			obj14 = db.queryOne(s5,lst14);//返回object  类型
    			tfmedInsure.setText(obj14.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s6 = "select 退休保险 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs15 = db.getResult(s6);//返回resultset类型
    			lst15 = db.convert(rs15);//返回list类型
    			obj15 = db.queryOne(s6,lst15);//返回object  类型
    			tfretInsure.setText(obj15.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s7 = "select 实际工资 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs16 = db.getResult(s7);//返回resultset类型
    			lst16 = db.convert(rs16);//返回list类型
    			obj16 = db.queryOne(s7,lst16);//返回object  类型
    			tfactiSalary.setText(obj9.toString());//把结果转换成字符串输出到文本框
    			
    			
    			String s8 = "select 扣除总数 from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs17 = db.getResult(s8);//返回resultset类型
    			lst17 = db.convert(rs17);//返回list类型
    			obj17 = db.queryOne(s8,lst17);//返回object  类型
    			tfsubSly.setText(obj17.toString());//把结果转换成字符串输出到文本框
    			
    		}
    		else if(e.getActionCommand().equals("取消")){
    			tfeNo.setText("");
    			tfeName.setText("");
    			tfonDays.setText("");
    			tfsickDays.setText("");
    			tfrestDays.setText("");
    			tfpost.setText("");
    			tfeSex.setText("");
    			tfeAge.setText("");
    			tfeWorktime.setText("");
    			
    			tfaward.setText("");
    			tfsalary.setText("");
				tfpensTax.setText("");
				tfstaTax.setText("");
				tfmedInsure.setText("");
				tfretInsure.setText("");
				tfactiSalary.setText("");
				tfsubSly.setText("");
    			
    		}
    	}
    }
    //////////////////////////////////结束
    
    private class ClickMagDemo implements ActionListener{
    	public void actionPerformed(ActionEvent e){
    		if(e.getActionCommand().equals("确定")){
    			 String stAwd = tfaward.getText();//奖金
    			 String stSly = tfsalary.getText();//工资;
    			 String stmedInsure = tfmedInsure.getText();//医疗保险
    			 String stretInsure = tfretInsure.getText();//退休保险
    			 
    			 
    			 double dAwd = Double.parseDouble(stAwd);//奖金
    			 double dSly = Double.parseDouble(stSly);//工资 
    			 double dmedInsure = Double.parseDouble(stmedInsure);//医疗保险的值
    			 double drretInsure = Double.parseDouble(stretInsure);//退休保险的值
    			 
    			 
    			 //收入 income
				//应纳税所得额 ytax
				//个人所得税 grtax
				double ytax= dSly;
				double grtax = 0.0;
				
				
				if(ytax <= 500)
				{
				 grtax = ytax * (5.0/100.0);
				 ytax = grtax;
				}
				else if(500 < ytax && ytax <= 2000)
				{
				 grtax = ytax * (15.0/100.0) - 25;
				 ytax = grtax;
				}
				else if(2000 < ytax && ytax <= 5000)
				{
				 grtax = ytax * (20.0/100.0) - 125;
				 ytax = grtax;
				}
				else if(5000 < ytax && ytax <= 10000)
				{
				 ytax = grtax;
				 grtax = ytax * (25.0/100.0) - 375;
				}
				
				
				//个人所得税和国家所得税，一下情况认为是相等的
				Double dgrtax = new Double(grtax);
				tfpensTax.setText(dgrtax.toString());
				tfstaTax.setText(dgrtax.toString());
				
				
				//扣除的金额
				double dsubSly = ytax + grtax + dmedInsure + drretInsure;
				Double dsubSlyfz = new Double(dsubSly);
				tfsubSly.setText(dsubSlyfz.toString());
				
				//实际工资的值计算和显示
				double dactiSalary = dSly + dAwd - dsubSly;
				Double dactiSalaryfz = new Double(dactiSalary);
				tfactiSalary.setText(dactiSalaryfz.toString());
				
    		}
    	
    	
    	else if(e.getActionCommand().equals("显示全部信息")){
    		if(saiTest == null){
    			saiTest = new ShowAllInfo();
    		}
    		else
    		saiTest.setVisible(true);
    	}
    	
    	/*else if(e.getActionCommand().equals("更新")){
    		
    		String upde = "update 职工信息 set 员工编号 ='" + tfeNo.getText()"'," +
    		"员工姓名 = '" + tfeName.getText()"',"+
    		"上班天数= '" + tfonDays.getText()"',"+
    		"病假天数= '" +　tfsickDays.getText()"'"+
    		"休假天数= '" + frestDays.getText"',"+
    		"员工职务= '" +tfpost.getText()"',"+
    		"员工性别= '"+tfeSex.getText()"',"+
    		"员工年龄= '"+tfeAge.getText()"',"+
    		"员工工龄= '"+tfeWorktime.getText()"',"+
    		"员工卡号= '"+tfcardID.getText()"'";
			
			rsupe = db.getResult(upde);		

			String updm = "update 职工信息 set 奖金 ='"+tfaward.getText()"',"+
    				"应发工资 = '"+tfsalary.getText()"',"+
    				"个人所得税= '"+tfpensTax.getText()"',"+
    				"国家税= '"+tfstaTax.getText()"',"+
					"医疗保险= '"+tfmedInsure.getText"',"+
					"退休保险= '"+tfretInsure.getText()"',"+
					"实际工资= '"+tfactiSalary.getText()"',"+
					"扣除总数= '"+tfeAge.getText()"'";
			rsupm = db.getResult(updm);	
    		 
    		
    	}
    	else if(e.getActionCommand().equals("插入")){
    		
    		String ins = "insert into 职工信息 valuse(" +  tfeNo.getText()"'," + tfeName.getText()"',"+
						tfonDays.getText()"',"+tfsickDays.getText()"',"+
						tfrestDays.getText()"',"+tfpost.getText()"',"+
						tfeSex.getText()"',"+tfeAge.getText()"',"+
						tfeWorktime.getText()"',"+tfcardID.getText()"')"
    		
    		rsinse = db.getResult(updm);
    	}*/
    	else if(e.getActionCommand().equals("删除")){
    		
    		String dele = "delete from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    		String delm = "delete from 工资管理 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    		
    		rsdele = db.getResult(dele);
    		rsdelm = db.getResult(delm);
    			
    		
    	}
    	
    	}
    }
	
	
	
	public static void main(String[] args){
		new ManagementTest();
		
	}
}