employeedemo.java

java开发的桌面系统

/**
 * @(#)EmployeeDemo.java
 *
 *
 * @author 
 * @version 1.00 2008/7/9
 */

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




public class EmployeeDemo extends Frame{
	Panel pinf,pinfcon;
	Label eNo,eName,onDays,sickDays,restDays,post,lbinf,eSex,eAge,eWorktime,cardID;
	TextField tfeNo,tfeName,tfonDays,tfsickDays,tfrestDays,tfpost,
			tfeSex,tfeAge,tfeWorktime,tfcardID;
	Button sure1,cancel1;
	ScrollPane sp =null;
	ResultSet rs1,rs2,rs3,rs4,rs5,rs6,rs7,rs8,rs9,rs;
	List lst1,lst2,lst3,lst4,lst5,lst6,lst7,lst8,lst9,lst;
	Object obj1,obj2,obj3,obj4,obj5,obj6,obj7,obj8,obj9,obj;
	DBManager db;
        
    /**
     * Creates a new instance of <code>EmployeeDemo</code>.
     */
    public EmployeeDemo() {
    	super("职工信息");
    	this.init();
    }
    public void init(){
    
//    	Panel p2 = new MyPanel(this);
    	pinf = new Panel();
    	pinfcon = new Panel();
    	sp = new ScrollPane();
    	
    	pinf.setLayout(new BorderLayout(5,5));
    	pinfcon.setLayout(new GridLayout(6,4,5,5));
    	
    	lbinf = new Label("输入用户信息");
    	
    	//面板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);
    	
    	//把显示标签lbinf和pincon分别添加到pinf的北边
    	pinf.add(lbinf,BorderLayout.NORTH);
    	pinf.add(pinfcon,BorderLayout.CENTER);
    	
    	this.addWindowListener(new WindowAdapter(){
    		public void windowClosing(WindowEvent e){
    			dispose();
    		}
    	});
    	
    	//给按钮添加事件触发
    	sure1.addActionListener(new OnClickDemo());
    	cancel1.addActionListener(new OnClickDemo());
    	
    	pinf.setBackground(Color.pink);

    	sp.add(pinf);
    	this.setLocation(200,200);
    	this.add(sp);
    	sp.setSize(700,250);
    	this.setResizable(false);
    	this.pack();
    	this.setVisible(true);
    }
    
    private class OnClickDemo implements ActionListener{
    	public void actionPerformed(ActionEvent e){
    		if(e.getActionCommand().equals("确定")){
    			
    			db = new DBManager();
    			
    			String sql = "select 员工姓名 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
				rs = db.getResult(sql);//返回结果集
				lst = db.convert(rs);//把结果集转换成list类型的
				obj = db.queryOne(sql,lst);//单个查询，
				String x1 = obj.toString();
				tfeName.setText(x1);
    			
    			
    			String sSex = "select 员工性别 from 职工信息 where 员工编号 = '" + tfeNo.getText().trim() + "'";
    			
    			rs = db.getResult(sSex);//返回resultset类型
    			lst = db.convert(rs);//返回list类型
    			obj = db.queryOne(sSex,lst);//返回object  类型
    			String x2 = obj.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() + "'";
    			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());//把结果转换成字符串输出到文本框
    			
    			
	       
    			
    		}
    		else if(e.getActionCommand().equals("取消")){
    			
    			tfeNo.setText("");
    			
    		}
    	}
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        new EmployeeDemo();
    }
}