append.java

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

import javax.lang.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import   java.util.Date;  
import java.util.GregorianCalendar;
public class append implements ActionListener{
	private Frame append;
	private Label number,name,sex,age,birthday;
	private Label data,local,level,charecter;
	private Label beizhu,yonhuname,address,telphone;
	private TextField inputnum,inputname,inputage,inputbirthday;
	private TextField inputdata,inputlevel,inputyonhuname,inputaddress,inputtelphone;
	private TextArea inputcharecter,inputbeizhu;
	private Choice insex,inlocal;
	private Button queding,check;
	public append(){
		init();
	}
	private void init(){
		append=new Frame("添加");
		append.setLayout(null);
		append.setVisible(true);
		append.setSize(600,710);
		append.setBackground(Color.gray);
		number=new Label("员工编号:");
		number.setSize(80,20);
		number.setLocation(50, 50);
		append.add(number);
		
		inputnum=new TextField(10);
		inputnum.setBounds(150, 50, 120, 20);
		append.add(inputnum);
		
		check=new Button("验证该号是否已经存在");
		check.setBounds(300, 50, 150, 20);
		check.addActionListener(this);
		append.add(check);
		
		name=new Label("姓名:");
		name.setSize(80, 20);
		name.setLocation(50,80);
		append.add(name);
		
		inputname=new TextField(10);
		inputname.setBounds(150, 80, 120, 20);
		append.add(inputname);
		
		sex=new Label("性别:");
		sex.setSize(80, 20);
		sex.setLocation(50,110);
		append.add(sex);
		
        insex=new Choice();  
        insex.addItem("fmale");
        insex.addItem("male");
        insex.setBounds(150, 110, 120, 20);
		append.add(insex);
		
		age=new Label("年龄:");
		age.setSize(80, 20);
		age.setLocation(50,140);
		append.add(age);
		
		inputage=new TextField(10);
		inputage.setBounds(150, 140, 120, 20);
		append.add(inputage);
		
		birthday=new Label("出生日期:");
		birthday.setSize(80, 20);
		birthday.setLocation(50,170);
		append.add(birthday);
		
		inputbirthday=new TextField(10);
		inputbirthday.setBounds(150, 170, 120, 20);
		append.add(inputbirthday);
		
		data=new Label("何时进入分:");
		data.setSize(80, 20);
		data.setLocation(50,200);
		append.add(data);
		
		inputdata=new TextField(10);
		inputdata.setBounds(150, 200, 140, 20);
		append.add(inputdata);
		
		local=new Label("职务:");
		local.setSize(80, 20);
		local.setLocation(50,230);
		append.add(local);
		
		inlocal=new Choice();
		inlocal.addItem("主管");
		inlocal.addItem("经理");
		inlocal.addItem("普通职员");
		inlocal.addItem("总经理");
		inlocal.setBounds(150, 230, 140, 20);
		//inlocal.setLocation(100, 230);
		append.add(inlocal);
		
		level=new Label("薪水:");
		level.setSize(80, 20);
		level.setLocation(50,260);
		append.add(level);
		
		inputlevel=new TextField(10);
		inputlevel.setBounds(150, 260, 140, 20);
		append.add(inputlevel);
		
		yonhuname=new Label("用户名:");
		yonhuname.setSize(80, 20);
		yonhuname.setLocation(50,300);
		append.add(yonhuname);
		
		inputyonhuname=new TextField(10);
		inputyonhuname.setBounds(150, 300, 140, 20);
		append.add(inputyonhuname);
		
		address=new Label("地址");
		address.setSize(80, 20);
		address.setLocation(50,330);
		append.add(address);
		
		inputaddress=new TextField(10);
		inputaddress.setBounds(150, 330, 140, 20);
		append.add(inputaddress);
		
		telphone=new Label("联系电话");
		telphone.setSize(80, 20);
		telphone.setLocation(50,360);
		append.add(telphone);
		
		inputtelphone=new TextField(10);
		inputtelphone.setBounds(150, 360, 140, 20);
		append.add(inputtelphone);
		
		charecter=new Label("个人特点:");
		charecter.setSize(100, 20);
		charecter.setLocation(50,390);
		append.add(charecter);
		
		inputcharecter=new TextArea();
		inputcharecter.setBounds(150, 420, 300, 100);
		append.add(inputcharecter);
		
		beizhu=new Label("备注:");
		beizhu.setSize(100, 20);
		beizhu.setLocation(50,530);
		append.add(beizhu);
		
		inputbeizhu=new TextArea();
		inputbeizhu.setBounds(150, 560, 300, 100);
		append.add(inputbeizhu);
		
		
		queding=new Button("确定");
		queding.setSize(100, 20);
		queding.setLocation(230,680);
		queding.addActionListener(this);
		append.add(queding);				
		append.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				new 管理员查询();
				append.setVisible(false);
			}			
		});		
	}
	public static void main(String args[]){
		append t=new append();
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==queding){
			boolean b=true;
			try{
				 b=checknum();
			}catch(SQLException ee)
			{
				ee.printStackTrace();
			}			
			 if(b==false)
			 {
				 String message="该编号已经存在";
				 JOptionPane.showMessageDialog(append, message);
				 inputnum.setText("");
			 }else{
			try{
				Liststudent();
			}catch(SQLException ee)
			{
				ee.printStackTrace();
			}
		}
		}
			 else if(e.getSource()==check){
			try{
				 checknum();
			}catch(SQLException ee)
			{
				ee.printStackTrace();
			}
		}
		
	}
	public boolean  checknum()throws SQLException {
		String number;
		number=inputnum.getText();
		try{
			Class.forName("sun.jdbc.odbc.jdbcodbcDriver");
		}
		  catch(ClassNotFoundException e) 
		  {			  
		  }
		  Connection con=DriverManager.getConnection("jdbc:odbc:wgzl");
		  Statement sql=con.createStatement(); //创建Statement对象
		  String sqly="select * from xinxi where 员工编号= '"+number+"'";
		  ResultSet rs=sql.executeQuery(sqly);
		  if(rs.next()){
			  
			  String message="该编号已经存在";
			  JOptionPane.showMessageDialog(append, message);
			  inputnum.setText("");
			  return false;
		  }else {
			  String message="您可以使用该编号";
			  JOptionPane.showMessageDialog(append, message);
			  return true;
		  }		
	}
	public void Liststudent() throws SQLException {//针对数据库的操作{
		Calendar   cal   =   new   GregorianCalendar();  
		int   year   =   cal.get(Calendar.YEAR);                           //   2002   
        int   month   =   cal.get(Calendar.MONTH);
        String yar=Float.toString(year);
        String mth=Float.toString(month);
        float award=2000.0f;
        float kaoqi=0;
        String jilu="无";
		 // SimpleDateFormat   format=new   SimpleDateFormat("yyyy-MM-dd"); 
		 String num,name,sex;
		 int age;
		 float level;
		 String  birthday,local,yonhuname,data,character,beizhu;
		 String ads,tel;
		 String defaut="123456";
		 float leibie=2;
		 num=inputnum.getText();
		 name=inputname.getText();
		 sex=insex.getSelectedItem();
		 age=Integer.parseInt(inputage.getText());
		 ads=inputaddress.getText();
		 tel=inputtelphone.getText();
		birthday=inputbirthday.getText();
		 data=inputdata.getText();
		 local=inlocal.getSelectedItem();
		 level=Float.parseFloat(inputlevel.getText());
		 yonhuname=inputyonhuname.getText();
		 character=inputcharecter.getText();
		 beizhu=inputbeizhu.getText();
		 
		try{
			Class.forName("sun.jdbc.odbc.jdbcodbcDriver");
		}catch(ClassNotFoundException e) 
		  {}
		  Connection con=DriverManager.getConnection("jdbc:odbc:wgzl");
		  Statement sql=con.createStatement(); //创建Statement对象
		  String sqly="insert into xinxi values('"+num+"','"+name+"','"+sex+"',"+age+",'"+birthday+"','"+data+"','"+local+"',"+level+",'"+character+"','"+beizhu+"','"+yonhuname+"','"+ads+"','"+tel+"')";
		  String sqll="insert into 登录验证 values('"+yonhuname+"','"+defaut+"',"+leibie+")";
		  String sqly2="insert into 工资表 values('"+num+"','"+name+"','"+yar+"','"+mth+"',"+level+","+award+","+kaoqi+",'"+jilu+"',"+level+")";
	      sql.executeUpdate(sqly);
	      sql.executeUpdate(sqll);
	      sql.executeUpdate(sqly2);
		  
	} 
	
	
 }