//家庭成員收入查詢類(lèi)





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

public class EPIQ extends JInternalFrame{

	JLabel lb1=new JLabel("成員收入查詢");
   	JLabel lb2=new JLabel("身份證號(hào):");
   	JLabel lb3=new JLabel("成員姓名：");
   	JTextField txt1=new JTextField(10);
   	JTextField txt2=new JTextField(10);
   	JButton btn1=new JButton("查詢");

   	JTable table;
	DefaultTableModel dtm;
	String columns[] = {"身份證號(hào)","成員姓名：","獎(jiǎng)金收入","工資收入","發(fā)金時(shí)間","備注"};
	public EPIQ(){
		setTitle("成員收入信息查詢");

		dtm = new DefaultTableModel();
		table = new JTable(dtm);
		JScrollPane sl = new JScrollPane(table);
		
		dtm.setColumnCount(6);
		dtm.setColumnIdentifiers(columns);
	
		getContentPane().setLayout(null);
		lb1.setBounds(200,10,300,30);
		lb1.setFont(new Font("宋體",Font.BOLD,24));
		getContentPane().add(lb1);

		Font f=new Font("宋體",Font.PLAIN,12);
		lb2.setBounds(10,60,80,25);
		lb2.setFont(f);
		getContentPane().add(lb2);
		txt1.setBounds(80,60,80,23);
		txt1.setFont(f);
		getContentPane().add(txt1);
		lb3.setBounds(10,90,80,25);
		lb3.setFont(f);
   	    getContentPane().add(lb3);
   	    txt2.setBounds(80,90,80,23);
   	    txt2.setFont(f);
   	    getContentPane().add(txt2);
   	    btn1.setBounds(90,130,60,25);
   	    btn1.setFont(f);
   	    getContentPane().add(btn1);

   	    //設(shè)置邊框
		txt1.setBorder(BorderFactory.createLineBorder(Color.black));
   	    txt2.setBorder(BorderFactory.createLineBorder(Color.black));
   	    btn1.setBorder(BorderFactory.createRaisedBevelBorder());
		sl.setBorder(BorderFactory.createLineBorder(Color.black));

	
		Database.joinDB();

//初始化表數(shù)據(jù)
		String scEPIQ="select * from Shouru";

		if(Database.query(scEPIQ)){
        			System.out.println(scEPIQ);
        			try{
        				while(Database.rs.next()){
        					String number = ("" + Database.rs.getInt("EP_Number"));
        					String name = Database.rs.getString("EP_Name");
        					System.out.println(name);
        					String date = Database.rs.getString("EP_Date");
        					System.out.println(date);
        					String address = Database.rs.getString("EP_Address");
        					System.out.println(address);
        					String causation = Database.rs.getString("EP_Causation");
        					System.out.println(causation);
        					String remark = Database.rs.getString("EP_Remark");
        					System.out.println(remark);


        					Vector v = new Vector();
        					v.add(number);
        					v.add(name);
        					v.add(date);
        					v.add(address);
        					v.add(causation);
        					v.add(remark);

        					dtm.addRow(v); 
       					}
        				}
        		   	catch(Exception eEPIQ){}

        			}



//為查詢按鈕加事件
        btn1.addActionListener(new ActionListener(){
        	public void actionPerformed(ActionEvent e){
        		System.out.println("查詢按鈕事件執(zhí)行");
        		String sEPIQ;
        		int rc=dtm.getRowCount();
        	
        	    	for(int i=0;i<rc;i++){
        						dtm.removeRow(0);
        						}

        		if(txt1.getText().equals("")&&txt2.getText().equals("")){
        			sEPIQ="select * from Shouru";

        			}
        		else if(txt2.getText().equals("")){
        			sEPIQ="select * from Shouru where EP_Number = '" + txt1.getText() +"'";
        			}
        		else{
        			sEPIQ="select * from Shouru where EP_Number = '" + txt1.getText() +"' or EP_Name like '%"+ txt2.getText() +"%'";
        			}
        		System.out.println(sEPIQ);
 

        		if(Database.query(sEPIQ)){
        			System.out.println(sEPIQ);
        			try{
        				while(Database.rs.next()){
        					String number = ("" + Database.rs.getInt("EP_Number"));
        					String name = Database.rs.getString("EP_Name");
        					System.out.println(name);
        					String date = Database.rs.getString("EP_Date");
        					System.out.println(date);
        					String address = Database.rs.getString("EP_Address");
        					System.out.println(address);
        					String causation = Database.rs.getString("EP_Causation");
        					System.out.println(causation);
        					String remark = Database.rs.getString("EP_Remark");
        					System.out.println(remark);


        					Vector v = new Vector();
        					v.add(number);
        					v.add(name);
        					v.add(date);
        					v.add(address);
        					v.add(causation);
        					v.add(remark);

        					dtm.addRow(v);   
       					}
        				}
        		   	catch(Exception eEPIQ){}

        			}
       		}
        	});
		sl.setBounds(180,60,425,290);
		getContentPane().add(sl);

		setSize(688,470);
		this.setClosable(true);
	
		setVisible(true);
		}
	}