//家庭成員收入管理類import java.awt.*;import javax.swing.*;import java.awt.event.*;import java.sql.*;public class EncouragementPunish extends JInternalFrame {    public EncouragementPunish() {         Database.joinDB();    	setTitle("成員收入管理!");    	Font f = new Font("新宋體", 0, 14);        lb1 = new JLabel("成員收入信息");        lb2 = new JLabel("身份證號:");        lb3 = new JLabel("工資收入");        lb4 = new JLabel("獎金收入");        lb5 = new JLabel("發(fā)金時間:");        lb6 = new JLabel("備注:");        lb7 = new JLabel("成員姓名:");        tnumber = new JTextField();        tname = new JTextField();        tremarks = new JTextArea();        tadress = new JTextField();        treason = new JTextField();        ttime = new JTextField();        btright = new JButton("<<");        btleft = new JButton(">>");        btdelet = new JButton("刪除");        btamend = new JButton("修改");        btsave = new JButton("保存");        btadd = new JButton("添加");        getContentPane().setLayout(null);        lb1.setBackground(new java.awt.Color(204, 204, 204));        lb1.setFont(new java.awt.Font("新宋體", 1, 18));        lb1.setForeground(new java.awt.Color(33, 44, 255));        getContentPane().add(lb1);        lb1.setBounds(220, 10, 190, 30);        lb2.setFont(f);        getContentPane().add(lb2);        lb2.setBounds(120, 60, 70, 20);        lb7.setFont(f);        getContentPane().add(lb7);        lb7.setBounds(300, 60, 70, 20);        getContentPane().add(tname);        tname.setBounds(370,60,90,20);        lb3.setFont(f);        getContentPane().add(lb3);        lb3.setBounds(120, 100, 70, 20);        lb4.setFont(f);        getContentPane().add(lb4);        lb4.setBounds(120, 140, 70, 20);        lb5.setFont(f);        getContentPane().add(lb5);        lb5.setBounds(120, 180, 70, 20);        lb6.setFont(f);        getContentPane().add(lb6);        lb6.setBounds(380, 100, 70, 20);        getContentPane().add(tnumber);        tnumber.setBounds(190, 60, 90, 20);        getContentPane().add(tremarks);        tremarks.setBounds(380, 130, 130, 70);        getContentPane().add(tadress);        tadress.setBounds(190, 100, 150, 20);        getContentPane().add(treason);        ttime.setBounds(190, 140, 150, 20);        getContentPane().add(ttime);        treason.setBounds(190, 180, 150, 21);        btright.setFont(f);        getContentPane().add(btright);        btright.setBounds(400, 230, 50, 20);        btleft.setFont(f);        getContentPane().add(btleft);        btleft.setBounds(400, 250, 50, 20);        btdelet.setFont(f);        getContentPane().add(btdelet);        btdelet.setBounds(320, 240, 70, 25);        btamend.setFont(f);        getContentPane().add(btamend);        btamend.setBounds(240, 240, 70, 25);        btsave.setFont(f);        getContentPane().add(btsave);        btsave.setBounds(80, 240, 70, 25);        btadd.setFont(f);        getContentPane().add(btadd);        btadd.setBounds(160, 240, 70, 25);        String sqlc="select * from Shouru";        try{        if(Database.query(sqlc)){        	Database.rs.next();            tnumber.setText(""+Database.rs.getInt("EP_Number"));            tname.setText(Database.rs.getString("EP_Name"));            ttime.setText(Database.rs.getString("EP_Date"));            tadress.setText(Database.rs.getString("EP_Address"));            treason.setText(Database.rs.getString("EP_Causation"));            tremarks.setText(Database.rs.getString("EP_Remark"));        	}          }         catch(Exception e){         	System.out.println(e);         	}//為左右按鈕加事件     btright.addActionListener(new ActionListener(){     	public void actionPerformed(ActionEvent e){     		try{     		if(Database.rs.previous()){     	    tnumber.setEditable(true);            tnumber.setText(""+Database.rs.getInt("EP_Number"));            tname.setText(Database.rs.getString("EP_Name"));            ttime.setText(Database.rs.getString("EP_Date"));            tadress.setText(Database.rs.getString("EP_Address"));            treason.setText(Database.rs.getString("EP_Causation"));            tremarks.setText(Database.rs.getString("EP_Remark"));     			}     		  }     		 catch(Exception el){     		 	System.out.println(el);     		 	}     		}     	});     btleft.addActionListener(new ActionListener(){     	public void actionPerformed(ActionEvent e){     		try{     		if(Database.rs.next()){     		tnumber.setEditable(true);            tnumber.setText(""+Database.rs.getInt("EP_Number"));            tname.setText(Database.rs.getString("EP_Name"));            ttime.setText(Database.rs.getString("EP_Date"));            tadress.setText(Database.rs.getString("EP_Address"));            treason.setText(Database.rs.getString("EP_Causation"));            tremarks.setText(Database.rs.getString("EP_Remark"));     			}     		 }     		 catch(Exception er){     		 	System.out.println(er);     		 	}     		}     	});//添加添加按扭事件        btadd.addActionListener(new ActionListener(){        	public void actionPerformed(ActionEvent e){        		tnumber.setText("");        	        		btsave.setEnabled(true);        		tname.setText("");        		ttime.setText("");        		treason.setText("");        		tadress.setText("");        		tremarks.setText("");        	}        });//添加保存按扭事件        btsave.addActionListener(new ActionListener(){        	public void actionPerformed(ActionEvent e){        	 if(tname.getText().equals("") || ttime.getText().equals("") || tadress.getText().equals("") || treason.getText().equals("")){        	    new JOptionPane().showMessageDialog(null,"成員姓名,工資收入,獎金收入,發(fā)金時間!填寫不能為空！");        	   }        	else{            String number=tnumber.getText();        	String name=tname.getText();        	String time=ttime.getText();        	String reason=treason.getText();        	String address=tadress.getText();        	String remarks=tremarks.getText();        	String sInsert="insert Shouru values ('"+number+"', '"+name+"','"+time+"','"+ address +"','"+remarks+"','"+reason+"')";        	System.out.println(sInsert);        	try{        	if(Database.executeSQL(sInsert)){        	tnumber.setEditable(true);        	btsave.setEnabled(false);        	new JOptionPane().showMessageDialog(null,"成功添加數(shù)據(jù)！");        	String sql="select * from Shouru ";        	Database.joinDB();        	Database.query(sql);        	Database.rs.last();        	tnumber.setText(""+Database.rs.getInt("EP_Number"));            }             }catch(Exception el){             	new JOptionPane().showMessageDialog(null,"添加數(shù)據(jù)不成功！");             }         }       	}        });//添加修改和刪除事件按扭   	btdelet.addActionListener(new ActionListener(){   		public void actionPerformed(ActionEvent e){   			try{   				String sql="delete from Shouru where EP_Number ='"+ tnumber.getText()+"'";   				System.out.println(sql);   				if(Database.executeSQL(sql)){   					new JOptionPane().showMessageDialog(null,"數(shù)據(jù)刪除成功！");   					Database.joinDB();   	  				String sqll="select * from Shouru";   	  				Database.query(sqll);   	  				Database.rs.last();                    tnumber.setText(""+Database.rs.getInt("EP_Number"));                    tname.setText(Database.rs.getString("EP_Name"));                    ttime.setText(Database.rs.getString("EP_Date"));                    tadress.setText(Database.rs.getString("EP_Address"));                    treason.setText(Database.rs.getString("EP_Causation"));                    tremarks.setText(Database.rs.getString("EP_Remark"));   					}   				}   			catch(Exception el){}   			}   		});   	btamend.addActionListener(new ActionListener(){   		public void actionPerformed(ActionEvent e){   			try{   				String supdate="update Shouru set EP_Name='"+ tname.getText()+ "',EP_Date='"+ ttime.getText() +"',EP_Address='"+tadress.getText()+"',EP_Causation='"+treason.getText()+"',EP_Remark='"+tremarks.getText()+"'where EP_Number='"+tnumber.getText()+"'";   				if(Database.executeSQL(supdate)){   					new JOptionPane().showMessageDialog(null,"數(shù)據(jù)修改成功！");   					Database.joinDB();   	  				String sqll="select * from Shouru";   	  				Database.query(sqll);   	  				Database.rs.last();                    tnumber.setText(""+Database.rs.getInt("EP_Number"));                    tname.setText(Database.rs.getString("EP_Name"));                    ttime.setText(Database.rs.getString("EP_Date"));                    tadress.setText(Database.rs.getString("EP_Address"));                    treason.setText(Database.rs.getString("EP_Causation"));                    tremarks.setText(Database.rs.getString("EP_Remark"));   					}   				}   				catch(Exception es){new JOptionPane().showMessageDialog(null,"修改數(shù)據(jù)不成功！");}   			}   		});              setBounds(0, 0, 688, 470);        this.setClosable(true);        setVisible(true);    }     JButton btadd;     JButton btamend;     JButton btdelet;     JButton btleft;     JButton btright;     JButton btsave;     JLabel lb1;     JLabel lb2;     JLabel lb3;     JLabel lb4;     JLabel lb5;     JLabel lb6;     JLabel lb7;     JTextField tadress;     JTextField tname;     JTextField tnumber;     JTextField treason;     JTextArea tremarks;     JTextField ttime;}