管理员查询.java

用纯java代码写的简单粗糙的“人事管理系统”

import javax.lang.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*; 

public class 管理员查询 implements ActionListener{
	 Frame 管理员查询;
	private MenuBar search;
	private Menu subsearch,appendmenu,deletemenu,updatemenu,levelmenu;
	private MenuItem numsearch;
	private MenuItem numdelete;
	private MenuItem numupdate;
	private MenuItem numappend;
	private MenuItem 工资录入;
	private Panel menupanel;
	private Panel buttonpanel,outputpanel,panel;
	private Label Labelsearch,output;
	private TextField inputtext;
	private Button queding;
	private TextArea outputarea;
	private Choice input;
	
	public 管理员查询()
	{
		init();
	}
	private void init(){		
		menupanel=new Panel();	
		panel=new Panel();
		menupanel.setLayout(new FlowLayout());
		search=new MenuBar();		
		subsearch=new Menu("查询");
		search.add(subsearch);
		numsearch=new MenuItem("按工号查询");
		subsearch.add(numsearch);
		numsearch.addActionListener(this);	
		buttonpanel=new Panel();
		Labelsearch=new Label("请选择查询条件");
		input=new Choice();		
		input.add("员工编号");
		input.add("姓名");
		input.add("年龄");
		input.add("职务");
		inputtext=new TextField();
		inputtext.setColumns(10);
		queding=new Button("确定");
		queding.addActionListener(this);
		buttonpanel.add(Labelsearch);
		buttonpanel.add(input);	
		buttonpanel.add(inputtext);
		buttonpanel.add(queding);
		outputpanel=new Panel();
		output=new Label("查询结果");
		outputarea=new TextArea();
		outputarea.setEditable(false);
		outputarea.setRows(80);
		outputpanel.add(output);
		outputpanel.add(outputarea);
		/*queding.setVisible(false);
		outputpanel.setVisible(false);
	    buttonpanel.setVisible(false);*/		
		panel.add(menupanel);
		panel.add(buttonpanel);
		
		appendmenu=new Menu("添加");
		search.add(appendmenu);
		numappend=new MenuItem("工号");
		numappend.addActionListener(this);	
		appendmenu.add(numappend);
		
		deletemenu=new Menu("删除");
		search.add(deletemenu);
		numdelete=new MenuItem("工号");
		numdelete.addActionListener(this);
		deletemenu.add(numdelete);
						
		updatemenu=new Menu("更新");
		search.add(updatemenu);
		numupdate=new MenuItem("工号");
		numupdate.addActionListener(this);
		updatemenu.add(numupdate);
		
		levelmenu=new Menu("工资管理");
		search.add(levelmenu);
		工资录入=new MenuItem("工资录入");
		工资录入.addActionListener(this);
		levelmenu.add(工资录入);
		
		管理员查询=new Frame("管理员界面");
		管理员查询.setLayout(new BorderLayout());
		管理员查询.setMenuBar(search);
		管理员查询.add("North",panel);
		管理员查询.add("Center",outputpanel);
		管理员查询.setVisible(true);
		管理员查询.setSize(500,350);
		//manage.setBackground(Color.cyan);
		管理员查询.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				System.exit(0);
			}			
		});
	}
	public static void main(String args[]) throws SQLException{
		管理员查询 t=new 管理员查询();
	}
	public void actionPerformed(ActionEvent e) {
		
		if(e.getSource()==numsearch)
		{
			queding.setVisible(true);
			outputpanel.setVisible(true);
		    buttonpanel.setVisible(true);		
		}
		else if(e.getSource()==numupdate)
		{
			管理员查询.setVisible(false);
			new 管理员更新();
			
			
		}else if(e.getSource()==numdelete){
			new delete();
			
		}else if(e.getSource()==numappend){
			new append();
		}else if(e.getSource()==工资录入){
			new 工资录入();
		}
		else if(e.getSource()==queding){
			outputarea.setText("");
			try{
			Liststudent();
		}catch(SQLException ee)
		{
			ee.printStackTrace();
		}
		
	}
	}
	public void Liststudent() throws SQLException {//针对数据库的操作{
		 String num,name,sex;
		 float age;
		 String birthday,data,local,ads,tel;
		 float level;
		 String character,beizhu;
		 String sqly;
		try{
			Class.forName("sun.jdbc.odbc.jdbcodbcDriver");
		}
		  catch(ClassNotFoundException e) { }
		  Connection con=DriverManager.getConnection("jdbc:odbc:wgzl");
		  Statement sql=con.createStatement(); //创建Statement对象
		  int c=input.getSelectedIndex();
		  sqly="select * from xinxi where 员工编号= '"+inputtext.getText().trim()+"'";
		  if(c==0){
		  sqly="select * from xinxi where 员工编号= '"+inputtext.getText().trim()+"'";
		  }else if(c==1){
			  sqly="select * from xinxi where 姓名= '"+inputtext.getText().trim()+"'";
		  }else if(c==2){
			  sqly="select * from xinxi where 年龄>= '"+inputtext.getText().trim()+"'";
		  }else if(c==3){
			  sqly="select * from xinxi where 职务= '"+inputtext.getText().trim()+"'";
		  }
		  ResultSet rs=sql.executeQuery(sqly);
		  outputarea.append("员工编号 "+"姓名 "+"性别 "+"年龄 "+"出生日期 "
				  +"何时进入分司 "+"职务 "+"薪水 "+"个人特点 "+"备注 "+'\n');
		  while(rs.next()){ //输出被查询的情况
			  num=rs.getString(1);
			  name=rs.getString(2);
			  sex=rs.getString(3);
			  age=rs.getFloat(4);
			  birthday=rs.getString(5);
			  data=rs.getString(6);
			  local=rs.getString(7);			  
			  level=rs.getFloat(8);
			  character=rs.getString(9);
			  beizhu=rs.getString(10);
			  ads=rs.getString(11);
			  tel=rs.getString(12);
			  //if(num.trim().equals(input.getText().trim())){
			  outputarea.append('\n'+num+" "+name+" "+sex+" "+age+" "+birthday+" "+
					  data+" "+local+" "+level+" "+character+" "+beizhu+" "+ads+" "+tel+'\n');
			 // }
		    }
		  } 
		 }