protected synchronized Supplier find(int productID) throws SQLException 
	{
		Supplier supplier = null;
		Connection connection = null;
		PreparedStatement  prepStmt = null;

		try
		{
			connection = DB.getConnection();
			connection.setAutoCommit(true);

			prepStmt = connection.prepareStatement("SELECT * FROM Supplier WHERE SupplierID = ?;");
			prepStmt.setInt(1, productID);
			prepStmt.setMaxRows(1); 

			ResultSet rs = prepStmt.executeQuery();

			while (rs.next())
			{
				supplier = new Supplier(rs.getInt("SupplierID"));
				supplier.SupplierName 		= rs.getString("SupplierName");
			}
			rs.close();
			prepStmt.close();
			DB.closeConnection();
			return supplier;
		}
		catch (Exception e) 
		{
	    	throw e;
		}
	}