sportitemproxy.java

《Java课程设计案例精编（第二版）》-黄晓东-源代码-4450

package proxyLayer;
import java.sql.*;
import java.util.*;
import javax.swing.*;

import dbAccessLayer.*;
import modules.*;
public class SportItemProxy {
	private AccessTableData sportItemDataset = new AccessTableData();
	public Vector getAllSportsItem(){
		Vector vecItemList = new Vector();
		ResultSet itemSet = sportItemDataset.DMLOperation("SELECT * FROM SportItems");
		try
		{
			while( itemSet.next() ){
				SportItem sportItem = new SportItem();
				sportItem.setItemId( itemSet.getString("ITEMID") );
				sportItem.setItemName( itemSet.getString("ITEMNAME"));
				sportItem.setItemType( itemSet.getString("ITEMTYPE"));
				sportItem.setVoid( itemSet.getString("VOID"));
				vecItemList.add(sportItem);
			}			
		}
		catch(SQLException sqlEx){
			JOptionPane.showMessageDialog(null,"鏁版嵁杞