encouragementpunish.java

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

//家庭成员收入管理类





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("发金时间:");
        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,"成员姓名,工资收入,奖金收入,发金时间!填写不能为空！");
        	   }
        	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,"成功添加数据！");
        	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,"添加数据不成功！");
             }
         }
       	}
        });
//添加修改和删除事件按扭
   	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,"数据删除成功！");
   					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,"数据修改成功！");
   					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,"修改数据不成功！");}
   			}
   		});



      
        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;


}