managementtest.java

java开发的桌面系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.ImageIcon;
import java.sql.*;
import java.util.List;
import java.util.Map;
import java.util.HashMap;
import java.util.ArrayList;
import java.util.Iterator;



class ManagementTest extends Frame{
	Panel pin,pincon,pinconinner,pinconmid,pinconbton,p;
	Label award,payMeth,salary,pensTax,staTax,medInsure,retInsure,actiSalary,
			subSly,null1,null2,null3,null4;
	TextField tfaward,tfsalary,tfpensTax,tfstaTax,tfmedInsure,
       			tfretInsure,tfactiSalary,tfhidpay,tfsubSly;
    Button sure2,cancel2,sure3,showAll,delete,insert;
    Label lbwrt;
    CheckboxGroup payM;
    Checkbox bankCard,cash,check;
    ScrollPane sp ;
    ResultSet rs,rsupe,rsupm,rsdele,rsdelm,rsinse;
    ShowAllInfo saiTest = null;
    DBManager db;
    ResultSet rs1,rs2,rs3,rs4,rs5,rs6,rs7,rs8,rs9,rs10,rs11,rs12,rs13,rs14,rs15,rs16,rs17;
	List lst1,lst2,lst3,lst4,lst5,lst6,lst7,lst8,lst9,lst,lst10,lst11,lst12,lst13,lst14,lst15,lst16,lst17;
	Object obj1,obj2,obj3,obj4,obj5,obj6,obj7,obj8,obj9,obj,obj10,obj11,obj12,obj13,obj14,obj15,obj16,obj17;
    
    ///////////////////////////////
    Panel pinf,pinfcon;
	Label eNo,eName,onDays,sickDays,restDays,post,eSex,eAge,eWorktime,cardID;
	TextField tfeNo,tfeName,tfonDays,tfsickDays,tfrestDays,tfpost,
			tfeSex,tfeAge,tfeWorktime,tfcardID;
	Button sure1,cancel1;
	
	/////////////////////////////
	
	public ManagementTest(){
		
		super("管理员信息");
		this.init();
		}
		
		public void init(){
			
		
			
		////////////////////
		pinf = new Panel();
    	pinfcon = new Panel();
    	sp = new ScrollPane();
    	
    	pinf.setLayout(new BorderLayout(5,5));
    	pinfcon.setLayout(new GridLayout(6,4,5,5));
    	
    	//面板pinfcon上的标签
    	eNo = new Label("员工编号");
    	eName = new Label("员工姓名");
    	eSex = new Label("员工性别");
    	eAge = new Label("员工年龄");
    	post = new Label("员工职务");
    	eWorktime = new Label("员工工龄");
    	cardID = new Label("员工卡号");
    	onDays = new Label("上班天数");
    	restDays = new Label("休假天数");
    	sickDays = new Label("病假天数");
    	sure1 = new Button("确定");
    	cancel1 = new Button("取消");
    	
    	//面板1上的文本框
    	tfeNo = new TextField(20);
    	tfeName = new TextField(20);
    	tfeSex = new TextField(20);
    	tfeAge = new TextField(20);
    	tfpost = new TextField(20);
    	tfeWorktime = new TextField(20);
    	tfcardID = new TextField(20);
    	tfonDays = new TextField(20);
    	tfsickDays = new TextField(20);
    	tfrestDays = new TextField(20);
    	
    	
    	
    	
    	//把组建添加到显示面板中,该面板的作用是输入员工的编号,在各个文本框中输出相应的信息
    	pinfcon.add(eNo);pinfcon.add(tfeNo);pinfcon.add(sure1);pinfcon.add(cancel1);
    	pinfcon.add(eName);pinfcon.add(tfeName);pinfcon.add(eSex);pinfcon.add(tfeSex);
    	pinfcon.add(eAge);pinfcon.add(tfeAge);pinfcon.add(post);pinfcon.add(tfpost);
    	pinfcon.add(eWorktime);pinfcon.add(tfeWorktime);pinfcon.add(cardID);pinfcon.add(tfcardID);
    	pinfcon.add(onDays);pinfcon.add(tfonDays);
    	pinfcon.add(sickDays);pinfcon.add(tfsickDays);pinfcon.add(restDays);pinfcon.add(tfrestDays);
    	
    	pinf.add(pinfcon,BorderLayout.CENTER);
    	
    	//给职工信息上的按钮添加触发
    	sure1.addActionListener(new ClickEmpDemo());
    	cancel1.addActionListener(new ClickEmpDemo());
    	
    	
    	
    	/////////////////////////////////////
		
		p = new Panel();
		pin = new Panel();
		pincon = new Panel();
    	pinconinner = new Panel();
    	pinconmid = new Panel();
    	pinconbton = new Panel();
    	
    	p.setLayout(new BorderLayout(5,5));
    	pin.setLayout(new BorderLayout(5,5));
    	pincon.setLayout(new BorderLayout(5,5));
    	pinconinner.setLayout(new GridLayout(5,4,15,15));
    	pinconmid.setLayout(new GridLayout(1,4));
    	pinconbton.setLayout(new GridLayout(1,4,5,5));
    	
    	lbwrt = new Label("管理员输入信息");
    	
    	//面板pinmid的构造和内容显示
    	payM = new CheckboxGroup();//制作一个单选按钮,选择付款方式
   	    bankCard = new Checkbox("银行卡",payM,false);
    	cash = new Checkbox("现金支付",payM,false);
    	check = new Checkbox("支票支付",payM,false);
    	
    	//以下都是在pinconinner面板上的标签
    	award = new Label("奖金（必填）");
    	salary = new Label("应发工资（必填）");
    	pensTax = new Label("个人所得税");
    	staTax = new Label("国家税"); 
    	medInsure = new Label("医疗保险（必填）");
    	retInsure = new Label("退休保险（必填）");
    	subSly = new Label("扣除总数");
    	null1 = new Label("");
    	null2 = new Label("");
    	actiSalary = new Label("实际工资");
    	
    	payMeth = new Label("付款方式");
    	
    	sure2 = new Button("确定");
    	cancel2 = new Button("取消");
    	
    	sure3 = new Button("更新");
    	insert = new Button("插入");
    	delete = new Button("删除");
    	//null3 = new Label("");
    	showAll = new Button("显示全部信息");
    	//null4 = new Label("");
    	
    	//一下是在面板pinconinner上的数据框
    	
    	tfaward = new TextField(20);
    	tfsalary = new TextField(20);
    	tfpensTax = new TextField(20);
    	tfstaTax = new TextField(20);
    	tfmedInsure = new TextField(20);
    	tfretInsure = new TextField(20);
    	tfsubSly = new TextField(20);
    	tfactiSalary = new TextField(20);
    	
    	//向面板pinconinner中添加组件
		pinconinner.add(award);pinconinner.add(tfaward);pinconinner.add(salary);pinconinner.add(tfsalary);
		pinconinner.add(pensTax);pinconinner.add(tfpensTax);pinconinner.add(staTax);pinconinner.add(tfstaTax);
		pinconinner.add(medInsure);pinconinner.add(tfmedInsure);pinconinner.add(retInsure);pinconinner.add(tfretInsure);
    	pinconinner.add(subSly);pinconinner.add(tfsubSly);pinconinner.add(null1);pinconinner.add(null2);
    	pinconinner.add(sure2);pinconinner.add(cancel2);
    	pinconinner.add(actiSalary);pinconinner.add(tfactiSalary);
    	
    	//在面板pin中设置监听器
    	sure2.addActionListener(new ClickMagDemo());
    	cancel2.addActionListener(new ClickMagDemo());
    	sure3.addActionListener(new ClickMagDemo());
    	insert.addActionListener(new ClickMagDemo());
    	delete.addActionListener(new ClickMagDemo());
    	showAll.addActionListener(new ClickMagDemo());
    	
    	
    	
    	//添加按钮在pinconbton中
    	pinconbton.add(sure3);pinconbton.add(insert);pinconbton.add(delete);pinconbton.add(showAll);
    	
    	
    	
    	//把选择付款方式的单选框添加在pinconmid面板的中间
    	pinconmid.add(payMeth);
    	pinconmid.add(bankCard);
    	pinconmid.add(cash);
    	pinconmid.add(check);
    	//pinconmid.add(lbhidpay);
    	//pinconmid.add(tfhidpay);
    	
    	//向pincon中添加组件
    	pincon.add(pinconinner,BorderLayout.NORTH);
    	pincon.add(pinconmid,BorderLayout.CENTER);
    	pincon.add(pinconbton,BorderLayout.SOUTH);
    	
    	pin.add(pincon,BorderLayout.CENTER);
    	pin.add(lbwrt,BorderLayout.NORTH);
    	
    	p.add(pinf,BorderLayout.NORTH);
    	p.add(pin,BorderLayout.CENTER);
    	
		
		this.addWindowListener(new WindowAdapter(){
    		public void windowClosing(WindowEvent e){
    			dispose();
    		}
    	});
    	
    	p.setBackground(Color.pink);
    	sp.add(p);
    	this.setLocation(80,80);
    	this.add(sp);
    	sp.setSize(750,450);
    	this.setResizable(false);
    	this.pack();
    	this.setVisible(true);
		
	}
	
	/////////////////////////////////////////////////////职工信息面板上的触发事件
	private class ClickEmpDemo implements ActionListener{
    	public void actionPerformed(ActionEvent e){
    		if(e.getActionCommand().equals("确定")){
    			db = new DBManager();
    			
    			
    			String sql = "select 员工姓名 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
				rs1 = db.getResult(sql);//返回结果集
				lst1 = db.convert(rs1);//把结果集转换成list类型的
				obj1 = db.queryOne(sql,lst1);//单个查询，
				String x1 = obj1.toString();
				tfeName.setText(x1);
    			
    			
    			String sSex = "select 员工性别 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			
    			rs2 = db.getResult(sSex);//返回resultset类型
    			lst2 = db.convert(rs2);//返回list类型
    			obj2 = db.queryOne(sSex,lst2);//返回object  类型
    			String x2 = obj2.toString();
    			tfeSex.setText(x2);//把结果转换成字符串输出到文本框
    			
    	
    			String sAge = "select 员工年龄 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			rs3 = db.getResult(sAge);//返回resultset类型
    			lst3 = db.convert(rs3);//返回list类型
    			obj3 = db.queryOne(sAge,lst3);//返回object  类型
    			tfeAge.setText(obj3.toString());//把结果转换成字符串输出到文本框
    			
    			
    			
    			String sPost = "select 员工职务 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";