//成員基本信息管理類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);		            		}