moneytypejpanel.java

培训时做的学生管理系统.基于J2SE平台开发

package cn.com.studentsystem.debt;

import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.table.DefaultTableModel;

import cn.com.studentsystem.classnews.SelectTopic;
import cn.com.util.DBConnection;

public class MoneyTypeJPanel extends JPanel {
	
	JComboBox money_type ;
	JLabel moneytype_label;
	 JButton select_button;
	 JButton refresh_button ;
	 JButton cancel_button;
	 Vector vector = new Vector();
	
	public MoneyTypeJPanel(){
		init();
	}
	
	public void init(){
		moneytype_label = new JLabel("  请选择货币类型           ");
		money_type = new JComboBox();
		money_type.addItem("RMB￥");
		money_type.addItem("HK$");
		money_type.addItem("美元$");
		money_type.addItem("台币");
		select_button = new JButton("查询");
		refresh_button = new JButton("刷新");
		cancel_button = new JButton("取消");
		
		FlowLayout flow = new FlowLayout(FlowLayout.CENTER,20,20);
		this.setLayout(flow);
		this.add(moneytype_label);
		this.add(money_type);
		this.add(select_button);
		this.add(refresh_button);
		this.add(cancel_button);
		
		class MoneyTypeAction implements ActionListener{

			public void actionPerformed(ActionEvent arg0) {
				
				if(arg0.getActionCommand().equals("查询")){
					DefaultTableModel model = (DefaultTableModel)Debt.jtable.getModel();
	    			int now_row = model.getRowCount();
	    			for(int i=now_row-1;i>=0;i--){
						model.removeRow(i);	
	    			}
	                
				    Connection con = DBConnection.getConnectionOracle();
							
					try {
							
						PreparedStatement ps = con.prepareStatement("select itemnumber,datetime,moneytype,actionway,iomoney,ioperson,ioreason from debt where moneytype = ? order by itemnumber");
						ps.setString(1, money_type.getSelectedItem().toString());
						ResultSet rs = ps.executeQuery();
							    
					    while(rs.next()){
											    		 
					    	int no = rs.getInt(1);
							String date = rs.getString(2);
						    String moneytype = rs.getString(3);
						    String ioway = rs.getString(4);
						    String iomoney = rs.getString(5);
						    String ioperson = rs.getString(6);
						    String ioreason = rs.getString(7);
					        DebtVo vo = new DebtVo(no,date,moneytype,ioway,iomoney,ioperson,ioreason);
						    vector.add(vo);
							 }
					
						Iterator ite = vector.iterator();
							    
						while(ite.hasNext()){
						DebtVo nv = (DebtVo)ite.next();
						Object[] obj = {nv.getItemnumber(),nv.getDatetime(),nv.getMoneytype(),nv.getActionway(),
								nv.getIomoney(),nv.getIoperson(),nv.getIoreason()};
						Debt.table_model.addRow(obj);
							    	 
							 }
						SelectDebt.jf.dispose();
							     
					
				    } catch (SQLException e) {
					    e.printStackTrace();
				    }
					
				}else if(arg0.getActionCommand().equals("刷新")){
					DefaultTableModel model = (DefaultTableModel)Debt.jtable.getModel();
	    			int now_row = model.getRowCount();
	    			for(int i=now_row-1;i>=0;i--){
						model.removeRow(i);	
	    			}
	                
				    Connection con = DBConnection.getConnectionOracle();
							
					try {
							
						PreparedStatement ps = con.prepareStatement("select itemnumber,datetime,moneytype,actionway,iomoney,ioperson,ioreason from debt order by itemnumber");
						ResultSet rs = ps.executeQuery();
							    
					    while(rs.next()){
											    		 
					    	int no = rs.getInt(1);
							String date = rs.getString(2);
						    String moneytype = rs.getString(3);
						    String ioway = rs.getString(4);
						    String iomoney = rs.getString(5);
						    String ioperson = rs.getString(6);
						    String ioreason = rs.getString(7);
					   
						    DebtVo vo = new DebtVo(no,date,moneytype,ioway,iomoney,ioperson,ioreason);
						    vector.add(vo);
							 }
					
						Iterator ite = vector.iterator();
							    
						while(ite.hasNext()){
						DebtVo nv = (DebtVo)ite.next();
						Object[] obj = {nv.getItemnumber(),nv.getDatetime(),nv.getMoneytype(),nv.getActionway(),
								nv.getIomoney(),nv.getIoperson(),nv.getIoreason()};
						Debt.table_model.addRow(obj);
							    	 
							 }
						SelectDebt.jf.dispose();
							     
					
				    } catch (SQLException e) {
					    e.printStackTrace();
				    }
					
				  }else if(arg0.getActionCommand().equals("取消")){
					  SelectTopic.jf.dispose(); 
				}
				
			}
			
		}
		  
		
		MoneyTypeAction moneytype_action = new MoneyTypeAction();
		select_button.addActionListener(moneytype_action);
		refresh_button.addActionListener(moneytype_action);
		cancel_button.addActionListener(moneytype_action);
		
	}

}