itemattendproxy.java

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

package proxyLayer;

import java.sql.*;
import java.util.Vector;
import javax.swing.*;
import modules.*;
import dbAccessLayer.AccessTableData;

public class ItemAttendProxy {
	private AccessTableData sportItemDataset = new AccessTableData();
	
	public void closeDbConnection() throws SQLException{
		sportItemDataset.closeAll();
	}
	
	public ItemAttend getSportItemById(String itemId,String sportorId){
		ItemAttend result = new ItemAttend(); 
		String sqlQuery = "SELECT * FROM ItemAttend WHERE  ITEMID='" + itemId + "' AND SPORTORID = '" + sportorId + "'";
		ResultSet itemSet = sportItemDataset.DMLOperation(sqlQuery);
		try
		{
			if( itemSet.next() ){
				result.setItemId( itemSet.getString("ITEMID") );
				result.setSportorId( itemSet.getString("SPORTORID"));
				result.setScore( itemSet.getString("SCORE"));
				result.setVoid( itemSet.getString("VOID"));
			}			
		}
		catch(SQLException sqlEx){
			JOptionPane.showMessageDialog(null,"鏁版嵁杞