employeemanage.java

本人用java编写的家庭财务管理软件

		            
		            	theadship.setText(Database.rs.getString("E_Headship"));
		            	txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
		            	if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
		            		politicsVisage_cb.setSelectedIndex(0);
		            		}
		            	else{
		            		politicsVisage_cb.setSelectedIndex(1);
		            		}

		            	tschoolage.setText(Database.rs.getString("E_SchoolAge"));
		            	txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
		            	if(Database.rs.getString("E_Estate").equals("在职")){
		            		estate_cb.setSelectedIndex(0);
		            		}
		            	else if(Database.rs.getString("E_Estate").equals("停薪留职")){
		            		estate_cb.setSelectedIndex(1);
		            		}
		            	else{
		            		estate_cb.setSelectedIndex(2);
		            		}
		            	remark_ta.setText(Database.rs.getString("E_Remark"));
            			}
            		}
            	catch(Exception erm){
            		System.out.println(erm);
            		}
            	}
         	});

         //最前一条按钮事件
         left_bt.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){
            	try{
            		if(Database.rs.first()){
		            	txt_number.setText("" + Database.rs.getInt("E_Number"));
		            	txt_name.setText(Database.rs.getString("E_Name"));
		            	if(Database.rs.getString("E_Sex").equals("男")){
		            		sex_cb.setSelectedIndex(0);
		            		}
		            	else{
		            		sex_cb.setSelectedIndex(1);
		            		}
		            
		            	txt_borndate.setText(Database.rs.getString("E_BornDate"));
		            	tdepartment.setText(Database.rs.getString("E_Department"));

		           	if(Database.rs.getString("E_Marriage").equals("未婚")){
		            		marriage_cb.setSelectedIndex(0);
		            		}
		            	else if(Database.rs.getString("E_Marriage").equals("已婚")){
		            		marriage_cb.setSelectedIndex(1);
		            		}
		            	else{
		            		marriage_cb.setSelectedIndex(2);
		            		}
		           
		            	theadship.setText(Database.rs.getString("E_Headship"));
		            	txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
		            	if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
		            		politicsVisage_cb.setSelectedIndex(0);
		            		}
		            	else{
		            		politicsVisage_cb.setSelectedIndex(1);
		            		}

		            	tschoolage.setText(Database.rs.getString("E_SchoolAge"));
		            	txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
		            	if(Database.rs.getString("E_Estate").equals("在职")){
		            		estate_cb.setSelectedIndex(0);
		            		}
		            	else if(Database.rs.getString("E_Estate").equals("停薪留职")){
		            		estate_cb.setSelectedIndex(1);
		            		}
		            	else{
		            		estate_cb.setSelectedIndex(2);
		            		}
		            	remark_ta.setText(Database.rs.getString("E_Remark"));
            			}
            		}
            	catch(Exception erm){
            		System.out.println(erm);
            		}
            	}
         	});

         right_bt.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){
            	try{
            		if(Database.rs.last()){
		            	txt_number.setText("" + Database.rs.getInt("E_Number"));
		            	txt_name.setText(Database.rs.getString("E_Name"));
		            	if(Database.rs.getString("E_Sex").equals("男")){
		            		sex_cb.setSelectedIndex(0);
		            		}
		            	else{
		            		sex_cb.setSelectedIndex(1);
		            		}
		            	
		            	txt_borndate.setText(Database.rs.getString("E_BornDate"));
		            	tdepartment.setText(Database.rs.getString("E_Department"));

		           	if(Database.rs.getString("E_Marriage").equals("未婚")){
		            		marriage_cb.setSelectedIndex(0);
		            		}
		            	else if(Database.rs.getString("E_Marriage").equals("已婚")){
		            		marriage_cb.setSelectedIndex(1);
		            		}
		            	else{
		            		marriage_cb.setSelectedIndex(2);
		            		}
		          
		            	theadship.setText(Database.rs.getString("E_Headship"));
		            	txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
		            	if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
		            		politicsVisage_cb.setSelectedIndex(0);
		            		}
		            	else{
		            		politicsVisage_cb.setSelectedIndex(1);
		            		}

		            	tschoolage.setText(Database.rs.getString("E_SchoolAge"));
		            	txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
		            	if(Database.rs.getString("E_Estate").equals("在职")){
		            		estate_cb.setSelectedIndex(0);
		            		}
		            	else if(Database.rs.getString("E_Estate").equals("停薪留职")){
		            		estate_cb.setSelectedIndex(1);
		            		}
		            	else{
		            		estate_cb.setSelectedIndex(2);
		            		}
		            	remark_ta.setText(Database.rs.getString("E_Remark"));
            			}
            		}
            	catch(Exception erm){
            		System.out.println(erm);
            		}
            	}
         	});



//为添加保存按钮加事件
    append_bt.addActionListener(new ActionListener(){
       public void actionPerformed(ActionEvent e){
       	        save_bt.setEnabled(true);
                txt_number.setText("");
              
            	txt_name.setText("");
            	sex_cb.setSelectedIndex(0);
            	txt_borndate.setText("");
            	tdepartment.setText("");
            	marriage_cb.setSelectedIndex(0);
            	theadship.setText("");
            	txt_InDueFormDate.setText("");
            	politicsVisage_cb.setSelectedIndex(0);
            	tschoolage.setText("");
            	txt_enterdate.setText("");
            	estate_cb.setSelectedIndex(0);
            	remark_ta.setText("");
     		}
     	});

     	save_bt.addActionListener(new ActionListener(){
     		public void actionPerformed(ActionEvent e){
     			if(txt_name.getText().equals("")||txt_borndate.getText().equals("")||tdepartment.getText().equals("")
     			    ||theadship.getText().equals("")||txt_InDueFormDate.getText().equals("")||tschoolage.getText().equals("")
                    ||txt_enterdate.getText().equals("")){
                    	new JOptionPane().showMessageDialog(null,"除备注外，其余数据均不能为空！");
                    	}
                else{
                	String number=txt_number.getText();
                	String name=txt_name.getText();
                	String borndate=txt_borndate.getText();
                	String department=tdepartment.getText();
                	String headship=theadship.getText();
                	String indueformdate=txt_InDueFormDate.getText();
                	String schoolage=tschoolage.getText();
                	String enterdate=txt_enterdate.getText();
                	String remark=remark_ta.getText();

                	String sex=("" + sex_cb.getSelectedItem());
                	String marriage=(""+marriage_cb.getSelectedItem());
                	String estate=("" + estate_cb.getSelectedItem());
                	String politicsVisage=("" + politicsVisage_cb.getSelectedItem());

                	String sInsert="insert UserInfo values( '"+ number +"',  '"+ name +"','"+ sex +"','"+  borndate+"',"+
                	               "'"+ marriage +"','"+ politicsVisage +"','"+ schoolage +"','"+ enterdate +"','"+ indueformdate +"',"+
                	               "'"+ department +"','"+ headship +"','"+  estate +"','"+ remark +"')";
                

                	try{
                		if(Database.executeSQL(sInsert)){
                			txt_number.setEditable(true);
                			save_bt.setEnabled(false);
                			new JOptionPane().showMessageDialog(null,"添加数据成功！");

                			Database.joinDB();
                			String sql="select * from UserInfo";
                			Database.query(sql);
                			Database.rs.last();
                			txt_number.setText("" + Database.rs.getInt("E_Number"));
                			}
                		}
                	catch(Exception einsert){
                		System.out.println(einsert);
                		}
                	}
     			}
     		});


//为修改删除按钮添加事件
     amend_bt.addActionListener(new ActionListener(){
     	public void actionPerformed(ActionEvent e){
     		String number=txt_number.getText();
           	String name=txt_name.getText();
        	String borndate=txt_borndate.getText();
        	String department=tdepartment.getText();
        	String headship=theadship.getText();
        	String indueformdate=txt_InDueFormDate.getText();
        	String schoolage=tschoolage.getText();
        	String enterdate=txt_enterdate.getText();
        	String remark=remark_ta.getText();

        	String sex=("" + sex_cb.getSelectedItem());
        	String marriage=(""+marriage_cb.getSelectedItem());
        	String estate=("" + estate_cb.getSelectedItem());
        	String politicsVisage=("" + politicsVisage_cb.getSelectedItem());

     		String supdate="update UserInfo set E_Number ='"+ number +"',  E_Name ='"+ name +"',E_Sex='"+ sex +"'," +
     		               "E_BornDate='"+ borndate +"',E_Marriage='"+ marriage +"',E_PoliticsVisage='"+ politicsVisage +"'," +
     		               "E_SchoolAge='"+ schoolage+"',E_EnterDate='"+ enterdate +"',E_InDueFormDate='"+ indueformdate +"',"+
     		               "E_Department='"+ department +"',E_Headship='"+ headship +"',E_Estate='"+ estate +"'," +
     		               "E_Remark='"+ remark +"' where E_Number='"+ txt_number.getText() +"'";

     		System.out.println(supdate);
     		try{
     	     	if(Database.executeSQL(supdate)){
   					new JOptionPane().showMessageDialog(null,"数据修改成功！");
                      
   					Database.joinDB();
   	  				String sqll="select * from UserInfo";
  	  				Database.query(sqll);
   				    }
     			}
     		catch(Exception eupdate){}
     		}
     	});

     delet_bt.addActionListener(new ActionListener(){
     	public void actionPerformed(ActionEvent e){
     		String sdelete = "delete from UserInfo where E_Number ='"+ txt_number.getText()+"'";
     		try{
     			if(Database.executeSQL(sdelete)){
     				new JOptionPane().showMessageDialog(null,"数据删除成功！");

	     		    String sql="select * from UserInfo";
	     		    Database.query(sql);
	     		    Database.rs.next();


	            	txt_number.setText("" + Database.rs.getInt("E_Number"));
	            	txt_name.setText(Database.rs.getString("E_Name"));
	            	if(Database.rs.getString("E_Sex").equals("男")){
	            		sex_cb.setSelectedIndex(0);
	            		}
	            	else{
	            		sex_cb.setSelectedIndex(1);
	            		}
	            	
	            	txt_borndate.setText(Database.rs.getString("E_BornDate"));
	            	tdepartment.setText(Database.rs.getString("E_Department"));

	           	if(Database.rs.getString("E_Marriage").equals("未婚")){
	            		marriage_cb.setSelectedIndex(0);
	            		}
	            	else if(Database.rs.getString("E_Marriage").equals("已婚")){
	            		marriage_cb.setSelectedIndex(1);
	            		}
	            	else{
	            		marriage_cb.setSelectedIndex(2);
	            		}
	            	
	            	theadship.setText(Database.rs.getString("E_Headship"));
	            	txt_InDueFormDate.setText(Database.rs.getString("E_InDueFormDate"));
	            	if(Database.rs.getString("E_PoliticsVisage").equals("党员")){
	            		politicsVisage_cb.setSelectedIndex(0);
	            		}
	            	else{
	            		politicsVisage_cb.setSelectedIndex(1);
	            		}

	            	tschoolage.setText(Database.rs.getString("E_SchoolAge"));
	            	txt_enterdate.setText(Database.rs.getString("E_EnterDate"));
	            	if(Database.rs.getString("E_Estate").equals("在职")){
	            		estate_cb.setSelectedIndex(0);
	            		}
	            	else if(Database.rs.getString("E_Estate").equals("停薪留职")){
	            		estate_cb.setSelectedIndex(1);
	            		}
	            	else{
	            		estate_cb.setSelectedIndex(2);
	            		}
	            	remark_ta.setText(Database.rs.getString("E_Remark"));
	     				}
     			}
     		catch(Exception er){
     			System.out.println(er);
     			}
     		}
     	});

     exit_bt.addActionListener(new ActionListener(){
     	public void actionPerformed(ActionEvent e){
     		jif.setVisible(false);
     		}
     	});


        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        setBounds(0, 0, 688, 470);
        this.setClosable(true);
        this.setMaximizable(true);
        setVisible(true);
    }


    private JButton save_bt;
    private JButton rm_bt;
    private JButton lm_bt;
    private JButton right_bt;
    private JButton left_bt;
    private JButton exit_bt;
    private JButton append_bt;
    private JButton delet_bt;
    private JButton amend_bt;
    private JComboBox sex_cb;
    private JComboBox marriage_cb;
    private JComboBox politicsVisage_cb;
    private JComboBox estate_cb;
    private JFrame jFrame1;
    private JLabel lb1;
    private JLabel lb10;
    private JLabel lb11;
    private JLabel lb12;
    private JLabel lb13;
    private JLabel lb14;
    private JLabel lb2;
    private JLabel lb3;
    private JLabel lb4;
    private JLabel lb5;
    private JLabel lb6;
    private JLabel lb7;
    private JLabel lb8;
    private JLabel lb9;
    private JList headship_ls;
    private JList schoolage_ls;
    private JList department_ls;
    private JTextArea remark_ta;
    private JTextField txt_number;
    private JTextField txt_name;
    private JTextField txt_borndate;
    private JTextField txt_enterdate;
    private JTextField txt_InDueFormDate;
    private JTextField theadship;
    private JTextField tschoolage;
    private JTextField tdepartment;


}