sportorproxy.java

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

package proxyLayer;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JOptionPane;
import dbAccessLayer.*;
import modules.*;
import modules.SysUser;

public class SportorProxy {
	private AccessTableData userDataset = new AccessTableData();
	public Vector getAllSportUsers(){
		Vector userList = new Vector();
		ResultSet userSet = userDataset.DMLOperation("SELECT * FROM Sportor");
		try
		{
			while( userSet.next() ){
				SportsMan user = new SportsMan();
				user.setSportorId( userSet.getString("SPORTORID") );
				user.setName( userSet.getString("NAME"));
				user.setGender( userSet.getString("GENDER"));
				user.setWeight( userSet.getFloat("WEIGHT") );
				user.setHeight( userSet.getFloat("HEIGHT") );
				user.setAge( userSet.getInt("AGE"));
				user.setGrade( userSet.getInt("GRADE"));
				user.setVoid( userSet.getString("VOID"));
				userList.add(user);
			}			
		}
		catch(SQLException sqlEx){
			JOptionPane.showMessageDialog(null,"鏁版嵁杞