employeemanage.java

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

//成员基本信息管理类




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

public class Employeemanage extends JInternalFrame{
	JInternalFrame jif;
    public Employeemanage() {
    	jif=this;
        initComponents();
    }

    private void initComponents() {

    	setTitle("家庭成员基本信息");

    	String politicsVisage[]={"党员","群众"};
    	String Estate[]={"在职","停薪留职","离职"};
    	String Sex[]={"男","女"};
    	String Marriage[]={"未婚","已婚","离婚"};
    	Font f = new Font("新宋体", 0, 14);

        lb1 = new JLabel("成员基本信息管理");
        lb2 = new JLabel("身份证号:");
        lb3 = new JLabel("政治面貌:");
        lb4 = new JLabel("婚姻状态:");
        lb5 = new JLabel("性别:");
        lb6 = new JLabel("状态:");
        lb7 = new JLabel("职务:");
        lb8 = new JLabel("备注:");
        lb9 = new JLabel("所在公司:");
        lb10 = new JLabel("工作时间:");
        lb11 = new JLabel("毕业时间:");
        lb12 = new JLabel("出生日期:");
        lb13 = new JLabel("学历:");
        lb14 = new JLabel("姓名:");
        txt_number = new JTextField();
        txt_name = new JTextField();
        sex_cb = new JComboBox(Sex);
        theadship = new JTextField();
        tschoolage= new JTextField();
        tdepartment = new JTextField();
        txt_borndate = new JTextField();
        marriage_cb = new JComboBox(Marriage);
        politicsVisage_cb = new JComboBox(politicsVisage);
        estate_cb = new JComboBox(Estate);
        txt_enterdate = new JTextField();
        txt_InDueFormDate = new JTextField();
        remark_ta = new JTextArea();
        save_bt = new JButton("保存");
        rm_bt = new JButton(">>");
        lm_bt = new JButton("<<");
        right_bt = new JButton(">|");
        left_bt = new JButton("|<");
        exit_bt = new JButton("退出");
        append_bt = new JButton("添加");
        delet_bt= new JButton("删除");
        amend_bt = new JButton("修改");
      
        getContentPane().setLayout(null);

        setFont(new Font("黑体", 1, 24));
        lb1.setBackground(new Color(33, 44, 55));
        lb1.setFont(new Font("新宋体", 1, 24));
        lb1.setForeground(new Color(33, 44, 255));
        getContentPane().add(lb1);
        lb1.setBounds(140, 10, 210, 40);


        lb2.setFont(f);

        getContentPane().add(lb2);
        lb2.setBounds(20, 80, 60, 20);

        lb3.setFont(f);

        getContentPane().add(lb3);
        lb3.setBounds(10, 240, 80, 20);

        lb4.setFont(f);

        getContentPane().add(lb4);
        lb4.setBounds(10, 190, 80, 20);

        lb5.setFont(f);

        getContentPane().add(lb5);
        lb5.setBounds(360, 140, 60, 20);

        lb6.setFont(f);

        getContentPane().add(lb6);
        lb6.setBounds(200, 290, 60, 20);

        lb7.setFont(f);

        getContentPane().add(lb7);
        lb7.setBounds(200, 190, 60, 20);

        lb8.setFont(f);

        getContentPane().add(lb8);
        lb8.setBounds(350, 240, 60, 20);

        lb9.setFont(f);

        getContentPane().add(lb9);
        lb9.setBounds(200, 140, 60, 20);

        lb10.setFont(f);

        getContentPane().add(lb10);
        lb10.setBounds(350, 190, 70, 20);

        lb11.setFont(f);

        getContentPane().add(lb11);
        lb11.setBounds(10, 290, 110, 20);

        lb12.setFont(f);

        getContentPane().add(lb12);
        lb12.setBounds(10, 140, 80, 20);

        lb13.setFont(f);

        getContentPane().add(lb13);
        lb13.setBounds(200, 240, 60, 20);

        lb14.setFont(f);

        getContentPane().add(lb14);
        lb14.setBounds(190, 80, 60, 20);

        getContentPane().add(txt_number);
        txt_number.setBounds(80, 80, 80, 21);

        getContentPane().add(txt_name);
        txt_name.setBounds(250, 80, 80, 20);

        getContentPane().add(sex_cb);
        sex_cb.setFont(f);
        sex_cb.setSelectedIndex(1);
        sex_cb.setBounds(430, 140, 90, 23);

        getContentPane().add(txt_borndate);
        txt_borndate.setBounds(80, 140, 100, 20);  //出生日期

        getContentPane().add(marriage_cb);
        marriage_cb.setFont(f);
        marriage_cb.setBounds(80, 190, 100, 23);

        getContentPane().add(politicsVisage_cb);
        politicsVisage_cb.setFont(f);
        politicsVisage_cb.setBounds(80, 240, 100, 23);//政治面貌

        getContentPane().add(estate_cb);
        estate_cb.setFont(f);
        estate_cb.setBounds(250, 290, 90, 23); //工作状态

        getContentPane().add(tdepartment);
        tdepartment.setFont(f);
        tdepartment.setBounds(250, 140, 90, 20); //公司

        getContentPane().add(theadship);
        theadship.setFont(f);
        theadship.setBounds(250, 190, 90, 20);  //职务

        getContentPane().add(tschoolage);
        tschoolage.setFont(f);
        tschoolage.setBounds(250, 240, 90, 20); //学历

        getContentPane().add(txt_enterdate);
        txt_enterdate.setBounds(100, 290, 90, 20); //工作时间

        getContentPane().add(txt_InDueFormDate);
        txt_InDueFormDate.setBounds(430, 190, 100, 20); //毕业时间

        getContentPane().add(remark_ta);         //备注
        remark_ta.setBounds(350, 260, 190, 53);

        save_bt.setFont(f);

        getContentPane().add(save_bt);
        save_bt.setBounds(20, 390, 70, 25);
        save_bt.setEnabled(false);

        rm_bt.setFont(f);

        getContentPane().add(rm_bt);
        rm_bt.setBounds(260, 350, 70, 25);

        lm_bt.setFont(f);

        getContentPane().add(lm_bt);
        lm_bt.setBounds(150, 350, 70, 25);

        right_bt.setFont(f);

        getContentPane().add(right_bt);
        right_bt.setBounds(370, 350, 70, 25);

        left_bt.setFont(f);
        getContentPane().add(left_bt);
        left_bt.setBounds(50, 350, 70, 25);

        exit_bt.setFont(f);

        getContentPane().add(exit_bt);
        exit_bt.setBounds(410, 390, 70,25);

        append_bt.setFont(f);

        getContentPane().add(append_bt);
        append_bt.setBounds(110, 390, 70, 25);

        delet_bt.setFont(f);

        getContentPane().add(delet_bt);
        delet_bt.setBounds(310, 390, 70, 25);

        amend_bt.setFont(f);
        getContentPane().add(amend_bt);
        amend_bt.setBounds(210, 390, 70, 25);
       

        Database.joinDB();

//初始化窗体数据
        String csql="select * from UserInfo";
        try{
            if(Database.query(csql)){
            	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 e){System.out.println(e);};




         //上一条按钮事件
         rm_bt.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){
            	try{
            		if(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 erm){
            		System.out.println(erm);
            		}
            	}
         	});

         //下一条按钮事件
         lm_bt.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e){
            	try{
            		if(Database.rs.previous()){
		            	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);
		            		}